Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
restoredbdatabasebackupv14
3 ตอบกลับ
10212 มุมมอง
อวตาร
muhammed noufal

When i try to restore database backup to another server (digital ocean to test server on aws), showing an error like this, i tried to change odoo commit same as the live server in the test server 

Traceback (most recent call last):
File "/odoo14/odoo14-server/odoo/api.py", line 792, in get
field_cache = field_cache[record.env.cache_key(field)]
KeyError: (None,)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/odoo14/odoo14-server/odoo/fields.py", line 972, in __get__
value = env\.cache\.get\(record,\ self\)
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 796,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'res\.users\(20,\)\.image_128'

During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 792,\ in\ get
\ \ \ \ field_cache\ =\ field_cache\[record\.env\.cache_key\(field\)\]
KeyError:\ \(None,\)

During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/odoo14/odoo14\-server/odoo/fields\.py",\ line\ 972,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 796,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'res\.partner\(12809,\)\.image_128'

During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 792,\ in\ get
\ \ \ \ field_cache\ =\ field_cache\[record\.env\.cache_key\(field\)\]
KeyError:\ \(None,\ None\)

During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/odoo14/odoo14\-server/odoo/fields\.py",\ line\ 972,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 796,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'ir\.attachment\(321,\)\.datas'

During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 792,\ in\ get
\ \ \ \ field_cache\ =\ field_cache\[record\.env\.cache_key\(field\)\]
KeyError:\ \(None,\)

During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:

Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/odoo14/odoo14\-server/odoo/fields\.py",\ line\ 972,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/odoo14/odoo14\-server/odoo/api\.py",\ line\ 796,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo.exceptions.CacheMiss: 'ir.attachment(321,).raw'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/odoo14/odoo14-server/odoo/addons/base/models/ir_attachment.py", line 105, in _file_read
with open(full_path, 'rb') as f:
FileNotFoundError: [Errno 2] No such file or directory: '/odoo14/.local/share/Odoo/filestore/APL_2.0/c5/c54d3d5e2b1320083bf5378b7c195b0985fa04c1'

อวตาร
ละทิ้ง
Baiju KS

are you trying with the database dump[pg_dump] file without filestore?

muhammed noufal
ผู้เขียน

trying to restore a backup to test server, which took from frond-end  (web/database/manager)

Baiju KS

In database manager which option you are selecting for "Backup Format"?

muhammed noufal
ผู้เขียน

zip including filestore

Baiju KS

Please mention database size and hold old is the DB?

muhammed noufal
ผู้เขียน

231 MB only

Baiju KS

Please check postgres version in new and older server using these commands:- Server version: pg_config --version and Client version: psql --version

muhammed noufal
ผู้เขียน

Both servers have the same version
# pg_config --version
PostgreSQL 12.9 (Ubuntu 12.9-0ubuntu0.20.04.1)
# psql --version
psql (PostgreSQL) 12.9 (Ubuntu 12.9-0ubuntu0.20.04.1)

อวตาร
jomin joseph
คำตอบที่ดีที่สุด

before restoring a database just create a test database and install all your custom modules in it and once that is done restore your database , this should solve your problem

อวตาร
ละทิ้ง
muhammed noufal
ผู้เขียน

I've installed all the custom modules to the new server, still the issue not resolved .

อวตาร
Simon Lee
คำตอบที่ดีที่สุด

Hi, I have the same problem. I tried to follow your suggestion of creating a test server, "ABC", installed all the modules and custom modules on it and tried to restore to server ABC with http://localhost:8069/web/database/manager, clicking "Restore Database", select the backup .zip file of the old database, and named the restore database also as "ABC" (same name as the test database), but odoo said "ABC" already exists and won't let me restore. Please advise how you do it. Thanks.

Regards,
Simon

อวตาร
ละทิ้ง
Baiju KS

What issue you are facing when you try to restore database backup normally?

Simon Lee

The restoration is successful. After that, when I login, I see the cache error as muhammed noufal described in the eclipse console. I am running odoo in eclipse.

Simon Lee

Hi,

I am using odoo 14 on ubuntu 20.04. I tried to copy a database to a new development machine. In the origin server, I use back up in odoo web/database/manager in .zip format. I then go to the development machine and use odoo web/database/manager to restore the database. The restoration is ok and I am able to start odoo on the development machine. But I get the following error. Can you tell me how to solve this? Thanks.

Regards,
Simon Lee

----------------------------------------------

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/api.py", line 792, in get
field_cache = field_cache[record.env.cache_key(field)]
KeyError: (None,)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/fields.py", line 972, in __get__
value = env.cache.get(record, self)
File "/home/hago_admin/odoo14/odoo/api.py", line 796, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'res.users(2,).image_128'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/api.py", line 792, in get
field_cache = field_cache[record.env.cache_key(field)]
KeyError: (None,)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/fields.py", line 972, in __get__
value = env.cache.get(record, self)
File "/home/hago_admin/odoo14/odoo/api.py", line 796, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'res.partner(3,).image_128'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/api.py", line 792, in get
field_cache = field_cache[record.env.cache_key(field)]
KeyError: (None, None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/fields.py", line 972, in __get__
value = env.cache.get(record, self)
File "/home/hago_admin/odoo14/odoo/api.py", line 796, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'ir.attachment(16,).datas'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/api.py", line 792, in get
field_cache = field_cache[record.env.cache_key(field)]
KeyError: (None,)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/fields.py", line 972, in __get__
value = env.cache.get(record, self)
File "/home/hago_admin/odoo14/odoo/api.py", line 796, in get
raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'ir.attachment(16,).raw'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/hago_admin/odoo14/odoo/addons/base/models/ir_attachment.py", line 105, in _file_read
with open(full_path, 'rb') as f:
FileNotFoundError: [Errno 2] No such file or directory: '/home/hago_admin/.local/share/Odoo/filestore/hago_db_3/c5/c54d3d5e2b1320083bf5378b7c195b0985fa04c1'

Baiju KS

You are choosing "This database was moved" for the database option. And you are not copying filestore to the system. You have to copy the filestore to "/home/hago_admin/.local/share/Odoo"

อวตาร
muhammed noufal
ผู้เขียน คำตอบที่ดีที่สุด

Now it's working,
Increased aws free instance resource - 1 gb ram + 5gb swap
changed limit_time_cpu = 99999 and limit_time_real = 99999
installed all the custom module in a database on the same server,
while restoring - choose This database was moved instead of This database is a copy 

Thanks @Jo , @Baiju KS

อวตาร
ละทิ้ง
Baiju KS

If you choose "This database was moved" option, you won't get filestore. If it's pg_dump file, you can choose this option.

muhammed noufal
ผู้เขียน

@Baiju ks database is a copy also working

Related Posts ตอบกลับ มุมมอง กิจกรรม
Database restoration error
restoredb databasebackup v15
อวตาร
อวตาร
อวตาร
อวตาร
3
ส.ค. 24
4169
Odoo error after restore Database แก้ไขแล้ว
community restoredb v14
อวตาร
1
ธ.ค. 24
3918
Problem- Restore Database on Odoo 8
restore restoredb databasebackup
อวตาร
อวตาร
อวตาร
3
มิ.ย. 16
8243
Database restoration issue when we restored data from odoo.sh
database restoredb databasebackup restoration
อวตาร
0
ก.ค. 23
3322
How to restore 4gb DB to odoo 14 in docker
postgresql restoredb db v14
อวตาร
อวตาร
1
ส.ค. 21
7332