Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
errorrestoredbexception12.
3 Odpowiedzi
15534 Widoki
Awatar
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

Awatar
Odrzuć
Nalini R. Wale

Hi,

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

Awatar
RDS EPOS SOLUTIONS
Najlepsza odpowiedź

  I have the same issue. did you resolve it?

Awatar
Odrzuć
Awatar
M Van Nieuwenhove
Autor Najlepsza odpowiedź

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
Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
TypeError: Cannot read properties of undefined (reading 'writeText') Rozwiązane
error exception
Awatar
Awatar
Awatar
2
lut 24
26479
Odoo server error
error exception
Awatar
Awatar
1
sie 23
3169
RPC_ERROR Odoo Server Error
error exception
Awatar
Awatar
1
lip 22
3947
defining a custom exception
error exception odoo16features
Awatar
0
lip 23
156
Odoo 13 raise an error and diplay it in UI Rozwiązane
error exception odooV13
Awatar
Awatar
Awatar
2
kwi 24
30433