跳至内容
此问题已终结
errorrestoredbexception12.
3 回复
15497 查看
形象
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
形象
丢弃
相关帖文 回复 查看 活动
TypeError: Cannot read properties of undefined (reading 'writeText') 已解决
error exception
形象
形象
形象
2
2月 24
26431
Odoo server error
error exception
形象
形象
1
8月 23
3148
RPC_ERROR Odoo Server Error
error exception
形象
形象
1
7月 22
3919
defining a custom exception
error exception odoo16features
形象
0
7月 23
156
Odoo 13 raise an error and diplay it in UI 已解决
error exception odooV13
形象
形象
形象
2
4月 24
30403