Skip to Content
Menu
This question has been flagged
1 Reply
4135 Views

Hi,

Docker, two contaners : Odoo 8.0  and PostGres (Latest) - Sources : Odoo/Postgres

The config is working "as expected" except when asking to do an archive in zip format .... the pg_dump is ok !

Here is the log ...


2017-03-30 14:14:34,029 1 [1;32m[1;49mINFO[0m None werkzeug: 172.17.0.1 - - [30/Mar/2017 14:14:34] "GET /web/database/backup?token=1490883273969&backup_db=2014-2016&backup_format=zip&backup_pwd=Test2017 HTTP/1.1" 200 -
Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--username=Odoo', '--host=172.17.0.3', '--port=5432', '--file=/tmp/tmplLNhXi/dump.sql', u'2014-2016') error 1
    raise Exception('Postgres subprocess %s error %s' % (args2, rc))
  File "/usr/lib/python2.7/dist-packages/openerp/tools/misc.py", line 133, in exec_pg_command
    openerp.tools.exec_pg_command(*cmd)
  File "/usr/lib/python2.7/dist-packages/openerp/service/db.py", line 196, in dump_db
    dump_stream = openerp.service.db.dump_db(backup_db, None, backup_format)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 745, in backup
Traceback (most recent call last):
2017-03-30 14:14:33,844 1 [1;31m[1;49mERROR[0m None openerp.addons.web.controllers.main: Database.backup
2017-03-30 14:14:33,182 1 [1;32m[1;49mINFO[0m None openerp.service.db: DUMP DB: 2014-2016 format zip
2017-03-30 14:11:37,391 1 [1;32m[1;49mINFO[0m None werkzeug: 172.17.0.1 - - [30/Mar/2017 14:11:37] "GET /web/database/backup?token=1490883096726&backup_db=2014-2016&backup_format=zip&backup_pwd=Test2017 HTTP/1.1" 200 -
Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--username=Odoo', '--host=172.17.0.3', '--port=5432', '--file=/tmp/tmpqHj74f/dump.sql', u'2014-2016') error 1
    raise Exception('Postgres subprocess %s error %s' % (args2, rc))
  File "/usr/lib/python2.7/dist-packages/openerp/tools/misc.py", line 133, in exec_pg_command
    openerp.tools.exec_pg_command(*cmd)
  File "/usr/lib/python2.7/dist-packages/openerp/service/db.py", line 196, in dump_db
    dump_stream = openerp.service.db.dump_db(backup_db, None, backup_format)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 745, in backup
Traceback (most recent call last):
2017-03-30 14:11:37,312 1 [1;31m[1;49mERROR[0m None openerp.addons.web.controllers.main: Database.backup
2017-03-30 14:11:35,949 1 [1;32m[1;49mINFO[0m None openerp.service.db: DUMP DB: 2014-2016 format zip


Any idea ?

Thank,

M

Avatar
Discard
Author Best Answer

Hi,

Apparently, it's due to a mismatch in PG_DUMP versions between client (ODOO) and Postgres (Server).

So, Because I have no idea how to change the client version 'inside' docker container .... I downgrade Postgres from 9.6.2 to 9.4.10.

Any suggestion is welcome !

Marc

Avatar
Discard