Odoo : attachment not found error

Odoo 16 + postgresql issue with attachment not found -

If you are an Odoo Developer, often we get an error in Odoo console as below


FileNotFoundError: [Errno 2] No such file or directory: 'odoo/data/filestore/sit-16/27/2781a5a3f35b23fa0b47023790bf3f21d8df9c43'


and this may cause issues at the Odoo UI in web browser.
There is a work around to fix this.

• 1. login as postgresql user
• 2. find and connect to the database you are using
• 3. run the below query to clear cache

to login
psql -U postgres
then
command \l to list databases

then to connect

**\connect database_name;**


delete from ir_attachment where url ilike '/web/as%s';


stop and restart Odoo server few times and it will be fixed !