Internal Server Error odoo 12

[mahmoudhnasr]

date	stream	content
2018-10-10 07:19:40	stdout	psycopg2.OperationalError: could not translate host name "db" to address: Name or service not known - - -
2018-10-10 07:19:40	stdout	conn = _connect(dsn, connection_factory=connection_factory, async=async)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/psycopg2/init.py", line 164, in connect
2018-10-10 07:19:40	stdout	**connection_info)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 608, in borrow
2018-10-10 07:19:40	stdout	return fun(self, *args, **kwargs)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 540, in _locked
2018-10-10 07:19:40	stdout	self._cnx = pool.borrow(dsn)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 171, in init
2018-10-10 07:19:40	stdout	return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 657, in cursor
2018-10-10 07:19:40	stdout	with closing(db.cursor()) as cr:
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 375, in list_dbs
2018-10-10 07:19:40	stdout	dbs = odoo.service.db.list_dbs(force)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1501, in db_list
2018-10-10 07:19:40	stdout	dbs = db_list(True, httprequest)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1534, in db_monodb
2018-10-10 07:19:40	stdout	httprequest.session.db = db_monodb(httprequest)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1373, in setup_db
2018-10-10 07:19:40	stdout	self.setup_db(httprequest)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1450, in dispatch
2018-10-10 07:19:40	stdout	return self.app(environ, start_response)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in call
2018-10-10 07:19:40	stdout	return self.app(environ, start_wrapped)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1290, in call
2018-10-10 07:19:40	stdout	return self.dispatch(environ, start_response)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1317, in call
2018-10-10 07:19:40	stdout	result = odoo.http.root(environ, start_response)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
2018-10-10 07:19:40	stdout	return application_unproxied(environ, start_response)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
2018-10-10 07:19:40	stdout	return self.app(e, s)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 255, in app
2018-10-10 07:19:40	stdout	application_iter = app(environ, start_response)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute
2018-10-10 07:19:40	stdout	execute(self.server.app)
2018-10-10 07:19:40	stdout	File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
2018-10-10 07:19:40	stdout	Traceback (most recent call last):
2018-10-10 07:19:40	stdout	2018-10-10 07:19:40,448 1 �[1;31m�[1;49mERROR�[0m ? werkzeug: Error on request:
2018-10-10 07:19:40	stdout	2018-10-10 07:19:40,440 1 �[1;32m�[1;49mINFO�[0m ? werkzeug: 172.17.0.1 - - [10/Oct/2018 07:19:40] "GET /favicon.ico HTTP/1.1" 500 - 0 0.000 0.228
2018-10-10 07:19:40	stdout	2018-10-10 07:19:40,436 1 �[1;32m�[1;49mINFO�[0m ? odoo.sql_db: Connection to the database failed
2018-10-10 07:19:39	stdout	psycopg2.OperationalError: could not translate host name "db" to address: Name or service not known - - -
2018-10-10 07:19:39	stdout	conn = _connect(dsn, connection_factory=connection_factory, async=async)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/psycopg2/init.py", line 164, in connect
2018-10-10 07:19:39	stdout	**connection_info)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 608, in borrow
2018-10-10 07:19:39	stdout	return fun(self, *args, **kwargs)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 540, in _locked
2018-10-10 07:19:39	stdout	self._cnx = pool.borrow(dsn)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 171, in init
2018-10-10 07:19:39	stdout	return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 657, in cursor
2018-10-10 07:19:39	stdout	with closing(db.cursor()) as cr:
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 375, in list_dbs
2018-10-10 07:19:39	stdout	dbs = odoo.service.db.list_dbs(force)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1501, in db_list
2018-10-10 07:19:39	stdout	dbs = db_list(True, httprequest)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1534, in db_monodb
2018-10-10 07:19:39	stdout	httprequest.session.db = db_monodb(httprequest)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1373, in setup_db
2018-10-10 07:19:39	stdout	self.setup_db(httprequest)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1450, in dispatch
2018-10-10 07:19:39	stdout	return self.app(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in call
2018-10-10 07:19:39	stdout	return self.app(environ, start_wrapped)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1290, in call
2018-10-10 07:19:39	stdout	return self.dispatch(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1317, in call
2018-10-10 07:19:39	stdout	result = odoo.http.root(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
2018-10-10 07:19:39	stdout	return application_unproxied(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
2018-10-10 07:19:39	stdout	return self.app(e, s)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 255, in app
2018-10-10 07:19:39	stdout	application_iter = app(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute
2018-10-10 07:19:39	stdout	execute(self.server.app)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
2018-10-10 07:19:39	stdout	Traceback (most recent call last):
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,873 1 �[1;31m�[1;49mERROR�[0m ? werkzeug: Error on request:
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,865 1 �[1;32m�[1;49mINFO�[0m ? werkzeug: 172.17.0.1 - - [10/Oct/2018 07:19:39] "GET /favicon.ico HTTP/1.1" 500 - 0 0.000 0.074
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,861 1 �[1;32m�[1;49mINFO�[0m ? odoo.sql_db: Connection to the database failed
2018-10-10 07:19:39	stdout	psycopg2.OperationalError: could not translate host name "db" to address: Name or service not known - - -
2018-10-10 07:19:39	stdout	conn = _connect(dsn, connection_factory=connection_factory, async=async)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/psycopg2/init.py", line 164, in connect
2018-10-10 07:19:39	stdout	**connection_info)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 608, in borrow
2018-10-10 07:19:39	stdout	return fun(self, *args, **kwargs)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 540, in _locked
2018-10-10 07:19:39	stdout	self._cnx = pool.borrow(dsn)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 171, in init
2018-10-10 07:19:39	stdout	return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 657, in cursor
2018-10-10 07:19:39	stdout	with closing(db.cursor()) as cr:
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 375, in list_dbs
2018-10-10 07:19:39	stdout	dbs = odoo.service.db.list_dbs(force)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1501, in db_list
2018-10-10 07:19:39	stdout	dbs = db_list(True, httprequest)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1534, in db_monodb
2018-10-10 07:19:39	stdout	httprequest.session.db = db_monodb(httprequest)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1373, in setup_db
2018-10-10 07:19:39	stdout	self.setup_db(httprequest)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1450, in dispatch
2018-10-10 07:19:39	stdout	return self.app(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in call
2018-10-10 07:19:39	stdout	return self.app(environ, start_wrapped)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1290, in call
2018-10-10 07:19:39	stdout	return self.dispatch(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/http.py", line 1317, in call
2018-10-10 07:19:39	stdout	result = odoo.http.root(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
2018-10-10 07:19:39	stdout	return application_unproxied(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
2018-10-10 07:19:39	stdout	return self.app(e, s)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 255, in app
2018-10-10 07:19:39	stdout	application_iter = app(environ, start_response)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute
2018-10-10 07:19:39	stdout	execute(self.server.app)
2018-10-10 07:19:39	stdout	File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
2018-10-10 07:19:39	stdout	Traceback (most recent call last):
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,335 1 �[1;31m�[1;49mERROR�[0m ? werkzeug: Error on request:
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,298 1 �[1;32m�[1;49mINFO�[0m ? werkzeug: 172.17.0.1 - - [10/Oct/2018 07:19:39] "GET /web/database/manager HTTP/1.1" 500 - 0 0.000 0.110
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,294 1 �[1;32m�[1;49mINFO�[0m ? odoo.sql_db: Connection to the database failed
2018-10-10 07:19:39	stdout	2018-10-10 07:19:39,184 1 �[1;32m�[1;49mINFO�[0m ? odoo.http: HTTP Configuring static files
2018-10-10 07:19:33	stdout	2018-10-10 07:19:33,859 1 �[1;32m�[1;49mINFO�[0m ? odoo.service.server: HTTP service (werkzeug) running on odoov6:8069
2018-10-10 07:19:33	stdout	2018-10-10 07:19:33,027 1 �[1;32m�[1;49mINFO�[0m ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2018-10-10 07:19:32	stdout	2018-10-10 07:19:32,362 1 �[1;32m�[1;49mINFO�[0m ? odoo: database: odoo@db:5432
2018-10-10 07:19:32	stdout	2018-10-10 07:19:32,361 1 �[1;32m�[1;49mINFO�[0m ? odoo: addons paths: ['/var/lib/odoo/addons/12.0', '/mnt/extra-addons', '/usr/lib/python3/dist-packages/odoo/addons']
2018-10-10 07:19:32	stdout	2018-10-10 07:19:32,360 1 �[1;32m�[1;49mINFO�[0m ? odoo: Using configuration file at /etc/odoo/odoo.conf
2018-10-10 07:19:32	stdout	2018-10-10 07:19:32,359 1 �[1;32m�[1;49mINFO�[0m ? odoo: Odoo version 12.0-20181008

[d-fence]

Can you give more context ? How did you start the docker containers (db and odoo) ?
It seems that the DB cannot be contacted. Did you start the DB container ?

[mahmoudhnasr]

i have Synology NAS storage

• installed on it Docker
• from docker i searched for odoo and make download
• after download i just run it
  i didn't do anything else
  what should i do
  thanks for your support

[mahmoudhnasr]

any idea

[d-fence]

There is a good tutorial as a starting point here: https://hub.docker.com/_/odoo/
The first line of your logs says that you it cannot reach postgresql.
You probably didn't start a postgresql docker container as stated in the above documentation.

[heangratha]

The same as mine:

version: '2'
services:
web:
image: odoo:12.0
depends_on:
- db
ports:
- "8069:8069"
volumes:
- odoo-web-data:/var/lib/odoo
- ./config:/etc/odoo
- ./addons:/mnt/extra-addons
db:
image: postgres:10
environment:
- POSTGRES_PASSWORD=odoo
- POSTGRES_USER=odoo
- PGDATA=/var/lib/postgresql/data/pgdata
volumes:
- odoo-db-data:/var/lib/postgresql/data/pgdata
volumes:
odoo-web-data:
odoo-db-data:

$ docker-compose up -d
$ docker-compose ps

Name Command State Ports

jcgwserver_db_1 docker-entrypoint.sh postgres Up 5432/tcp
jcgwserver_web_1 /entrypoint.sh odoo Up 0.0.0.0:8069->8069/tcp, 8071/tcp

2018-12-12 01:54:36,463 1 INFO odoo werkzeug: 172.21.0.1 - - [12/Dec/2018 01:54:36] "GET / HTTP/1.1" 500 - 2 0.001 0.005
2018-12-12 01:54:36,466 1 ERROR odoo werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 350, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1318, in call
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in call
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in call
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1471, in dispatch
ir_http = request.registry['ir.http']
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 176, in getitem
return self.models[model_name]
KeyError: 'ir.http' - - -
2018-12-12 01:54:36,628 1 INFO odoo werkzeug: 172.21.0.1 - - [12/Dec/2018 01:54:36] "GET /favicon.ico HTTP/1.1" 500 - 2 0.001 0.005
2018-12-12 01:54:36,630 1 ERROR odoo werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 350, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 128, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1318, in call
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in call
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in call
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1471, in dispatch
ir_http = request.registry['ir.http']
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 176, in getitem
return self.models[model_name]
KeyError: 'ir.http' - - -

2018-12-12 01:55:13,000 1 ERROR odoo odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...
^

2018-12-12 01:55:13,001 1 WARNING ? odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo.
2018-12-12 01:55:15,003 1 ERROR odoo odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...
^

2018-12-12 01:55:15,004 1 WARNING ? odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo.
2018-12-12 01:56:13,064 1 ERROR odoo odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...
^

2018-12-12 01:56:13,065 1 WARNING ? odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo.
2018-12-12 01:56:16,060 1 ERROR odoo odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...
^

2018-12-12 01:56:16,061 1 WARNING ? odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo.
2018-12-12 01:57:13,124 1 ERROR odoo odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...
^

2018-12-12 01:57:13,125 1 WARNING ? odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo.
2018-12-12 01:57:17,123 1 ERROR odoo odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...
^

2018-12-12 01:57:17,123 1 WARNING ? odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo.

[d-fence]

Not really the same issue.
There are examples here: https://hub.docker.com/_/odoo/