This question has been flagged
3 Replies
12951 Views
errorrestoredbexception12.
Avatar
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

Avatar
Discard
Nalini R. Wale

Hi,

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

Avatar
RDS EPOS SOLUTIONS
Best Answer

  I have the same issue. did you resolve it?

Avatar
Discard
Avatar
M Van Nieuwenhove
Author Best Answer

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
Avatar
Discard