Перейти к содержимому
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Все посты Люди Значки
Теги (Смотреть все)
odoo accounting v14 pos v15
Об этом форуме
Этот вопрос был отмечен
errorrestoredbexception12.
3 Ответы
15514 Представления
Аватар
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
февр. 24
26455
Odoo server error
error exception
Аватар
Аватар
1
авг. 23
3154
RPC_ERROR Odoo Server Error
error exception
Аватар
Аватар
1
июл. 22
3927
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
30415