Odoo Help


Sha1 attachment identifiers changed (Odoo 8)

Dante Ursini
on 9/21/17, 1:34 PM 608 views

I did a migration from an ubuntu linux box to an OSX machine. Everything is fine except the filestore attachments. Unfortunately Odoo is trying to get the attachment with a different id on the target server. Is there any magic stuff with sha1 to configure to get the same id on both servers.

2017-09-21 17:30:45,663 2577 INFO odoo odoo.addons.base.ir.ir_attachment: _read_file reading

/var/odoo/filestore/odoo/9a/9a0b7247151a736e8d4ba3cd902b2d64a61a8a35 Traceback (most recent call last):

  File "/opt/odoo/odoo/addons/base/ir/ir_attachment.py", line 98, in _file_read

    r = human_size(os.path.getsize(full_path))

  File "/usr/local/Cellar/python/2.7.13_1/Frameworks/Python.framework/Versions/2.7/lib/python2.7/genericpath.py", line 57, in getsize

    return os.stat(filename).st_size

OSError: [Errno 2] No such file or directory: '/var/odoo/filestore/odoo/9a/9a0b7247151a736e8d4ba3cd902b2d64a61a8a35'

Thanks for your help


Anil R. Kesariya (Jupical Technologies)

--Anil R. Kesariya (Jupical Technologies)--
| 7 6 8
Rajkot, India
--Anil R. Kesariya (Jupical Technologies)--

Odoo Techno Functional Expert

* Engaged with odoo since May - 2012.

* Customise existing module or develop new module base on customer requirement.

* Played key developer role in many past and running projects.

* Expert in requirement gathering of business and transforming requirement into odoo platform.

* Major expertise in core modules, database, report development and theme development.

* Integration expert.

Linkedin  : https://in.linkedin.com/in/anil-kesariya-97b20a66

Anil R. Kesariya (Jupical Technologies)
On 9/22/17, 3:21 AM

Hi Dante,

You need to copy all the attachement files from the linux machine from the location where the attachement are located. and put it in OSX machine in the same path where your system is looking for.

Hope this will help.



Hi Anil,

Thanks for your help but that's what I did. Unfortunately Odoo tries to find the attachment with a different identifier.

Dante Ursini
on 9/22/17, 3:24 AM

Your error says, file are not located here. /var/odoo/filestore/odoo/, Make sure your files are already exists in this place.

Anil R. Kesariya (Jupical Technologies)
on 9/22/17, 3:28 AM

I copied exactly the files at the same location but odoo tried to find another key in the same folder

Dante Ursini
on 9/22/17, 4:38 AM

Is there a way to check the filestore location in the browser app

Dante Ursini
on 9/22/17, 4:42 AM

Make sure that the key which your odoo looking inside OSX, it must be exists in your linux machine from where you copied. otherwise copy the same key folder and again override in your new OSX.

Anil R. Kesariya (Jupical Technologies)
on 9/22/17, 4:48 AM

What I did. Exactly the same folder.

Dante Ursini
on 9/24/17, 6:09 AM

Amil. I found the issue. My target database didn't have the 'postgres' role and 'LARGE OBJECTS' where owner by the postgres user. Thanks for your time

Dante Ursini
on 9/24/17, 3:23 PM

That's great, you found the solution!

Anil R. Kesariya (Jupical Technologies)
on 9/25/17, 1:23 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/21/17, 1:34 PM
Seen: 608 times
Last updated: 4/28/18, 8:35 AM