odoo开发笔记 -- 还原数据库后,异常:ir_attachment: IOError: [Errno 2] No such file or directory: u'/var/...'

场景描述：

恢复Odoo数据后，抛出错误导致无法进入页面

-- ::,  INFO aeo odoo.addons.base.ir.ir_attachment: _read_file reading /var/lib/odoo/filestore/aeo//576746a590a5ec2384a9428a907bc44e9117ee1e

Traceback (most recent call last):

  File "/usr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_attachment.py", line , in _file_read

    r = open(full_path,'rb').read().encode('base64')

IOError: [Errno ] No such file or directory: u'/var/lib/odoo/filestore/aeo/57/576746a590a5ec2384a9428a907bc44e9117ee1e'

-- ::,  INFO aeo odoo.addons.base.ir.ir_attachment: _read_file reading /var/lib/odoo/filestore/aeo//549f82ae56b7397db7fcd8ca1a179494b0cfda03

Traceback (most recent call last):

  File "/usr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_attachment.py", line , in _file_read

    r = open(full_path,'rb').read().encode('base64')

IOError: [Errno ] No such file or directory: u'/var/lib/odoo/filestore/aeo/54/549f82ae56b7397db7fcd8ca1a179494b0cfda03'

原因分析：

原来的环境，附加等文件存放在本地，还原到新环境后，数据库中记录了相应的附件信息，但实际上本地没有相应文件，导致出现附件找不到的异常。

解决方法：

--- 查找库中遗留的附件记录信息

select id,res_model,res_name,db_datas,file_size from ir_attachment where url LIKE '/web/content/%';

--- 将它们删除

DELETE FROM ir_attachment WHERE url LIKE '/web/content/%';

重启odoo服务，加载一下。

参考：https://jalena.bcsytv.com/archives/2022