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

Context: Synology/Docker - Odoo 12 () - Postres 10.6 Alpine

The backup does not report any problems, but it is impossible to perform a functional/valid restore.

The "web/database/restore" page reports two errors (see screen copy below):
1) Msg Database restore error: Database already exists
2) A warning in front of the DB created indicates "DB may not be Compatible".
With regard to the
1) Impossible the name is unique, no doubt,
2) Backup created by the same ODOO 12 entity,
3) Indeed, it is impossible to enter/open this DB,

Do you have an advice or a lead?

Odoo Trace

Log of the Backup

Logs of restore

1 - Odoo

2 - Postgres

3 - Content of Zip file (backup file)


4 - DB Management Interface

อวตาร
ละทิ้ง
Nalini R. Wale

Hi,

Can you able to connect it through backend? by using \c db name?

อวตาร
RDS EPOS SOLUTIONS
คำตอบที่ดีที่สุด

  I have the same issue. did you resolve it?

อวตาร
ละทิ้ง
อวตาร
M Van Nieuwenhove
ผู้เขียน คำตอบที่ดีที่สุด

Sorry for my late follow-up. At one point, I was able to access a restored db. I therefore continued my tests to provide you with some additional information. My last tests show a situation identical to the one initially indicated. In other words : no errors at the time of backup, three problems at the time of restore: (double db with this name, incompatible format, and impossible access). Here is the last log

2019-05-01 09:16:58,539 1 INFO Test_190501_1112 odoo.modules.loading: loading 1 modules... 

2019-05-01 09:16:58,611 1 INFO Test_190501_1112 odoo.modules.loading: 1 modules loaded in 0.07s, 0 queries 

2019-05-01 09:16:58,835 1 INFO Test_190501_1112 odoo.modules.loading: Modules loaded. 

2019-05-01 09:16:58,841 1 ERROR Test_190501_1112 odoo.sql_db: bad query: b'SELECT count(1) FROM "res_lang" WHERE ("res_lang"."active" = true)'

ERROR: relation "res_lang" does not exist

LINE 1: SELECT count(1) FROM "res_lang" WHERE ("res_lang"."active" =...

                             ^

 

2019-05-01 09:16:58,846 1 WARNING Test_190501_1112 odoo.modules.loading: Transient module states were reset 

2019-05-01 09:16:58,847 1 ERROR Test_190501_1112 odoo.modules.registry: Failed to load registry 

Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 60, in __new__

    return cls.registries[db_name]

  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 69, in wrapper

    return func(self, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/tools/lru.py", line 44, in __getitem__

    a = self.d[obj].me

KeyError: 'Test_190501_1112'


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 86, in new

    odoo.modules.load_modules(registry._db, force_demo, status, update_module)

  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 517, in load_modules

    model._register_hook()

  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/res_lang.py", line 88, in _register_hook

    if not self.search_count([]):

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 1538, in search_count

    res = self.search(args, count=True)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 1561, in search

    res = self._search(args, offset=offset, limit=limit, order=order, count=count)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4089, in _search

    self._cr.execute(query_str, where_clause_params)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper

    return f(self, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute

    res = self._obj.execute(query, params)

psycopg2.ProgrammingError: relation "res_lang" does not exist

LINE 1: SELECT count(1) FROM "res_lang" WHERE ("res_lang"."active" =...

                             ^


2019-05-01 09:16:58,854 1 INFO Test_190501_1112 werkzeug: 172.18.0.1 - - [01/May/2019 09:16:58] "GET /web?db%3DTest_190501_1112 HTTP/1.1" 302 - 10 0.027 0.323

2019-05-01 09:16:59,088 1 INFO ? odoo.sql_db: ConnectionPool(used=0/count=5/max=64): Closed 1 connections to 'user=Odoo host=PSQL1006AL-OD12 sslmode=prefer password=xxx dbname=Test_190501_1112 port=5432' 

2019-05-01 09:16:59,105 1 INFO ? werkzeug: 172.18.0.1 - - [01/May/2019 09:16:59] "GET /web/database/selector HTTP/1.1" 200 - 8 0.022 0.213

2019-05-01 09:17:02,706 1 INFO ? odoo.sql_db: ConnectionPool(used=0/count=5/max=64): Closed 1 connections to 'user=Odoo host=PSQL1006AL-OD12 sslmode=prefer password=xxx dbname=Test_190501_1112 port=5432' 

2019-05-01 09:17:02,738 1 INFO ? werkzeug: 172.18.0.1 - - [01/May/2019 09:17:02] "GET /web/database/manager HTTP/1.1" 200 - 8 0.045 0.493

2019-05-01 09:17:18,478 1 INFO None odoo.sql_db: ConnectionPool(used=0/count=5/max=64): Closed 0 connections  

2019-05-01 09:17:20,558 1 INFO None odoo.service.db: DROP DB: Test_190501_1112 

2019-05-01 09:17:20,566 1 INFO None werkzeug: 172.18.0.1 - - [01/May/2019 09:17:20] "POST /web/database/drop HTTP/1.1" 303 - 4 2.086 0.160

2019-05-01 09:17:20,813 1 INFO ? werkzeug: 172.18.0.1 - - [01/May/2019 09:17:20] "GET /web/database/manager HTTP/1.1" 200 - 6 0.021 0.209

2019-05-01 09:19:11,005 1 INFO CVSIDEe_190314 odoo.addons.base.models.ir_cron: Starting job `Mail: Fetchmail Service`. 

2019-05-01 09:19:11,100 1 INFO CVSIDEe_190314 odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server Odoo Account on CVSIDEe Domain 

2019-05-01 09:19:11,408 1 INFO CVSIDEe_190314 odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server O
อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
TypeError: Cannot read properties of undefined (reading 'writeText') แก้ไขแล้ว
error exception
อวตาร
อวตาร
อวตาร
2
ก.พ. 24
26486
Odoo server error
error exception
อวตาร
อวตาร
1
ส.ค. 23
3174
RPC_ERROR Odoo Server Error
error exception
อวตาร
อวตาร
1
ก.ค. 22
3965
defining a custom exception
error exception odoo16features
อวตาร
0
ก.ค. 23
156
Odoo 13 raise an error and diplay it in UI แก้ไขแล้ว
error exception odooV13
อวตาร
อวตาร
อวตาร
2
เม.ย. 24
30444