Odoo on docker with error after database restore

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Бухоблік
Склад
PoS
Project
MRP

All apps

All Posts Люди Значки

Мітки (View all)

odoo accounting v14 pos v15

Про цей форум

Допомога

Odoo on docker with error after database restore

1 Відповісти

4043 Переглядів

Yannick Heyne

Could Someone please help.

I am a Traini about Linux / Python etc .. so i have this error

2023-07-21 16:46:23,088 1 INFO ? odoo.service.server: Initiating shutdown 
2023-07-21 16:46:23,088 1 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown. 
2023-07-21 16:46:23,516 1 INFO ? odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 7 connections  
2023-07-21 16:46:32,453 1 INFO ? odoo: Odoo version 16.0-20230720 
2023-07-21 16:46:32,453 1 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf 
2023-07-21 16:46:32,453 1 INFO ? odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/var/lib/odoo/addons/16.0', '/mnt/extra-addons'] 
2023-07-21 16:46:32,453 1 INFO ? odoo: database: odoo@db:5432 
2023-07-21 16:46:32,704 1 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf 
2023-07-21 16:46:33,140 1 INFO ? odoo.service.server: HTTP service (werkzeug) running on 4f3d7a3acb73:8069 
2023-07-21 16:47:09,554 1 ERROR ? odoo.modules.loading: Database FRADataERP not initialized, you can force it with `-i base` 
2023-07-21 16:47:09,555 1 INFO ? odoo.modules.registry: Registry loaded in 0.037s 
2023-07-21 16:47:09,560 1 ERROR FRADataERP odoo.http: Exception during request handling. 
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1584, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1596, in _serve_ir_http
    ir_http = self.registry['ir.http']
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1998, in __call__
    response = request._serve_db()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1588, in _serve_db
    exc.error_response = self.registry['ir.http']._handle_error(exc)
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
2023-07-21 16:47:09,562 1 INFO FRADataERP werkzeug: 192.168.1.135 - - [21/Jul/2023 16:47:09] "POST /web/database/restore HTTP/1.1" 500 - 7 0.011 0.436
2023-07-21 16:47:09,572 1 ERROR FRADataERP odoo.http: Exception during request handling. 
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1584, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1596, in _serve_ir_http
    ir_http = self.registry['ir.http']
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1998, in __call__
    response = request._serve_db()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1588, in _serve_db
    exc.error_response = self.registry['ir.http']._handle_error(exc)
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
2023-07-21 16:47:09,573 1 INFO FRADataERP werkzeug: 192.168.1.135 - - [21/Jul/2023 16:47:09] "POST /web/database/restore HTTP/1.1" 500 - 1 0.001 0.004
2023-07-21 16:47:09,583 1 ERROR FRADataERP odoo.http: Exception during request handling. 
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1584, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1596, in _serve_ir_http
    ir_http = self.registry['ir.http']
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1998, in __call__
    response = request._serve_db()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1588, in _serve_db
    exc.error_response = self.registry['ir.http']._handle_error(exc)
  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 190, in __getitem__
    return self.models[model_name]
KeyError: 'ir.http'
2023-07-21 16:47:09,584 1 INFO FRADataERP werkzeug: 192.168.1.135 - - [21/Jul/2023 16:47:09] "POST /web/database/restore HTTP/1.1" 500 - 1 0.001 0.004
2023-07-21 16:47:33,212 1 ERROR FRADataERP odoo.sql_db: bad query: 
            SELECT latest_version
            FROM ir_module_module
             WHERE name='base'
        
ERROR: relation "ir_module_module" does not exist
LINE 3:             FROM ir_module_module
                         ^
 
2023-07-21 16:47:33,214 1 WARNING FRADataERP odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database FRADataERP. 
2023-07-21 16:47:34,236 1 ERROR FRADataERP odoo.sql_db: bad query: 
            SELECT latest_version
            FROM ir_module_module
             WHERE name='base'
        
ERROR: relation "ir_module_module" does not exist
LINE 3:             FROM ir_module_module
                         ^
 
2023-07-21 16:47:34,237 1 WARNING FRADataERP odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database FRADataERP.

Ali Dandan

hello! did you find a solution or what the cause was? any updates?

Yannick Heyne

Автор

Also has the Database Container the following LOG

2023-07-21 17:09:15.739 UTC [41] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:09:15.739 UTC [41] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:09:17.773 UTC [41] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:09:17.773 UTC [41] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:12:09.569 UTC [30] LOG:  checkpoint starting: time
2023-07-21 17:12:09.873 UTC [30] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.055 s, total=0.304 s; sync files=3, longest=0.055 s, average=0.019 s; distance=0 kB, estimate=0 kB
2023-07-21 17:14:05.606 UTC [73] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:14:05.606 UTC [73] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:14:06.629 UTC [73] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:14:06.629 UTC [73] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:14:38.952 UTC [1] LOG:  received fast shutdown request
2023-07-21 17:14:38.994 UTC [1] LOG:  aborting any active transactions
2023-07-21 17:14:38.994 UTC [68] FATAL:  terminating connection due to administrator command
2023-07-21 17:14:38.994 UTC [69] FATAL:  terminating connection due to administrator command
2023-07-21 17:14:39.000 UTC [1] LOG:  background worker "logical replication launcher" (PID 35) exited with exit code 1
2023-07-21 17:14:39.001 UTC [73] FATAL:  terminating connection due to administrator command
2023-07-21 17:14:39.004 UTC [30] LOG:  shutting down
2023-07-21 17:14:39.007 UTC [77] FATAL:  the database system is shutting down
2023-07-21 17:14:39.012 UTC [78] FATAL:  the database system is shutting down
2023-07-21 17:14:39.117 UTC [30] LOG:  checkpoint starting: shutdown immediate
2023-07-21 17:14:39.438 UTC [30] LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.435 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB
2023-07-21 17:14:39.446 UTC [1] LOG:  database system is shut down
PostgreSQL Database directory appears to contain a database; Skipping initialization
2023-07-21 17:14:44.570 UTC [1] LOG:  starting PostgreSQL 15.3 (Debian 15.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2023-07-21 17:14:44.570 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2023-07-21 17:14:44.570 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2023-07-21 17:14:44.856 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-07-21 17:14:44.919 UTC [29] LOG:  database system was shut down at 2023-07-21 17:14:39 UTC
2023-07-21 17:14:44.998 UTC [1] LOG:  database system is ready to accept connections
2023-07-21 17:15:52.811 UTC [36] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:15:52.811 UTC [36] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:15:53.855 UTC [36] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:15:53.855 UTC [36] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:16:52.833 UTC [36] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:16:52.833 UTC [36] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'
 
2023-07-21 17:16:54.927 UTC [36] ERROR:  relation "ir_module_module" does not exist at character 53
2023-07-21 17:16:54.927 UTC [36] STATEMENT:  
	            SELECT latest_version
	            FROM ir_module_module
	             WHERE name='base'

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Реєстрація

Це запитання позначене

Enjoying the discussion? Don't just read, join in!