Help Please! Plb with Odoo update and create database

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Help Please! Plb with Odoo update and create database

1 Reply

5418 Views

database odoo9.0

Steven Li

Hi... i have plb when create database on the latest Odoo 9.0, not exactly sure what happened.

anyone could help see how to fix it? Thanks in advance

Log as following:

2016-01-02 02:58:38,911 12728 INFO None werkzeug: 192.168.0.13 - - [02/Jan/2016 02:58:38] "POST /web/database/drop HTTP/1.1" 303 -

2016-01-02 02:58:38,935 12728 INFO gtxtrading werkzeug: 192.168.0.13 - - [02/Jan/2016 02:58:38] "GET /web/database/manager HTTP/1.1" 200 -

2016-01-02 03:00:28,285 12728 INFO None openerp.service.db: Create database `gtxtrading_test`.

2016-01-02 03:00:31,770 12728 INFO gtxtrading_test openerp.modules.loading: loading 1 modules...

2016-01-02 03:00:31,960 12728 INFO gtxtrading_test openerp.modules.module: module base: creating or updating database tables

2016-01-02 03:00:36,328 12728 INFO gtxtrading_test openerp.models: Computing parent left and right for table ir_ui_menu...

2016-01-02 03:00:55,147 12728 INFO gtxtrading_test openerp.models: Computing parent left and right for table res_partner_category...

2016-01-02 03:01:04,647 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'report_file'

2016-01-02 03:01:04,649 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'crud_model_name'

2016-01-02 03:01:04,650 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'wkf_model_name'

2016-01-02 03:01:04,651 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'global'

2016-01-02 03:01:04,652 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'menus_by_module'

2016-01-02 03:01:06,494 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'views_by_module'

2016-01-02 03:01:06,692 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'reports_by_module'

2016-01-02 03:01:06,904 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'display_name'

2016-01-02 03:01:07,028 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'commercial_partner_id'

2016-01-02 03:01:07,031 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'logo_web'

2016-01-02 03:01:07,050 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'email'

2016-01-02 03:01:07,052 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'phone'

2016-01-02 03:01:07,053 12728 INFO gtxtrading_test openerp.models: storing computed values of fields.function 'share'

2016-01-02 03:01:07,059 12728 INFO gtxtrading_test openerp.models: Storing computed values of res.partner.bank fields sanitized_acc_number

2016-01-02 03:01:07,094 12728 INFO gtxtrading_test openerp.modules.loading: loading base/base_data.xml

2016-01-02 03:01:07,308 12728 WARNING gtxtrading_test openerp.addons.base.res.res_lang: Unable to get information for locale en_AU. Information from the default locale (en_US) have been used.

2016-01-02 03:01:11,093 12728 INFO gtxtrading_test openerp.modules.loading: loading base/res/res_currency_data.xml

2016-01-02 03:01:15,126 12728 INFO gtxtrading_test openerp.modules.loading: loading base/res/res_country_data.xml

2016-01-02 03:01:23,710 12728 INFO gtxtrading_test openerp.modules.loading: loading base/security/base_security.xml

2016-01-02 03:01:24,251 12728 INFO gtxtrading_test openerp.modules.loading: loading base/base_menu.xml

2016-01-02 03:01:24,740 12728 INFO gtxtrading_test openerp.modules.loading: loading base/res/res_config.xml

2016-01-02 03:01:24,849 12728 INFO gtxtrading_test openerp.modules.loading: loading base/res/res.country.state.csv

2016-01-02 03:01:25,424 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_actions.xml

2016-01-02 03:01:26,950 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_config_parameter_view.xml

2016-01-02 03:01:27,201 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_cron_view.xml

2016-01-02 03:01:27,542 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_filters.xml

2016-01-02 03:01:27,866 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_mail_server_view.xml

2016-01-02 03:01:28,151 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_model_view.xml

2016-01-02 03:01:30,065 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_attachment_view.xml

2016-01-02 03:01:30,429 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_rule_view.xml

2016-01-02 03:01:30,828 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_sequence_view.xml

2016-01-02 03:01:31,210 12728 INFO gtxtrading_test openerp.modules.loading: loading base/ir/ir_translation_view.xml

2016-01-02 03:01:31,391 12728 ERROR ? openerp.addons.bus.models.bus: Bus.loop error, sleep and retry

Traceback (most recent call last):

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/bus/models/bus.py", line 168, in run

self.loop()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/bus/models/bus.py", line 163, in loop

event.set()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 367, in __exit__

self.close()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 139, in wrapper

return f(self, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 279, in close

return self._close(False)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 309, in _close

self._cnx.rollback()

InterfaceError: connection already closed

2016-01-02 03:01:31,393 12728 INFO gtxtrading_test openerp.sql_db: bad query: UPDATE "ir_ui_view" SET "model_data_id"=NULL WHERE id = 59

2016-01-02 03:01:31,394 12728 ERROR gtxtrading_test openerp.modules.registry: Failed to load registry

Traceback (most recent call last):

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/registry.py", line 385, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/loading.py", line 424, in load_modules

cr.close()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 139, in wrapper

return f(self, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 279, in close

return self._close(False)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 309, in _close

self._cnx.rollback()

InterfaceError: connection already closed

2016-01-02 03:01:31,396 12728 ERROR gtxtrading_test openerp.service.db: CREATE DATABASE failed:

Traceback (most recent call last):

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/db.py", line 49, in _initialize_db

db_name, demo, None, update_module=True)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/registry.py", line 385, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/loading.py", line 424, in load_modules

cr.close()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 139, in wrapper

return f(self, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 279, in close

return self._close(False)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 309, in _close

self._cnx.rollback()

InterfaceError: connection already closed

2016-01-02 03:01:31,457 12728 INFO None openerp.sql_db: Connection to the database failed

2016-01-02 03:01:31,458 12728 ERROR gtxtrading_test openerp.http: FATAL: the database system is in recovery mode

Traceback (most recent call last):

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 114, in dispatch_rpc

result = dispatch(method, params)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/common.py", line 57, in dispatch

return g[exp_method_name](*params)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/common.py", line 29, in exp_authenticate

res_users = openerp.registry(db)['res.users']

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/__init__.py", line 50, in registry

return modules.registry.RegistryManager.get(database_name)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/registry.py", line 354, in get

update_module)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/registry.py", line 371, in new

registry = Registry(db_name)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/registry.py", line 63, in __init__

cr = self.cursor()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/modules/registry.py", line 278, in cursor

return self._db.cursor()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 556, in cursor

return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 162, in __init__

self._cnx = pool.borrow(dsn)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 445, in _locked

return fun(self, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 507, in borrow

result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/lib/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect

conn = _connect(dsn, connection_factory=connection_factory, async=async)

OperationalError: FATAL: the database system is in recovery mode

2016-01-02 03:01:31,461 12728 INFO gtxtrading_test openerp.sql_db: Connection to the database failed

2016-01-02 03:01:31,471 12728 INFO gtxtrading_test werkzeug: 192.168.0.13 - - [02/Jan/2016 03:01:31] "POST /web/database/create HTTP/1.1" 500 -

2016-01-02 03:01:31,493 12728 ERROR gtxtrading_test werkzeug: Error on request:

Traceback (most recent call last):

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/lib/python2.7/site-packages/werkzeug/serving.py", line 177, in run_wsgi

execute(self.server.app)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/lib/python2.7/site-packages/werkzeug/serving.py", line 165, in execute

application_iter = app(environ, start_response)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/server.py", line 245, in app

return self.app(e, s)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/wsgi_server.py", line 184, in application

return application_unproxied(environ, start_response)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/wsgi_server.py", line 170, in application_unproxied

result = handler(environ, start_response)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 1488, in __call__

return self.dispatch(environ, start_response)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 1462, in __call__

return self.app(environ, start_wrapped)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/lib/python2.7/site-packages/werkzeug/wsgi.py", line 588, in __call__

return self.app(environ, start_response)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 1652, in dispatch

result = ir_http._dispatch()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/base/ir/ir_http.py", line 186, in _dispatch

return self._handle_exception(e)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/base/ir/ir_http.py", line 157, in _handle_exception

return request._handle_exception(exception)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 781, in _handle_exception

return super(HttpRequest, self)._handle_exception(exception)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/base/ir/ir_http.py", line 182, in _dispatch

result = request.dispatch()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 840, in dispatch

r = self._call_function(**self.params)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 316, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/model.py", line 118, in wrapper

return f(dbname, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 309, in checked_call

result = self.endpoint(*a, **kw)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 959, in __call__

return self.method(*args, **kw)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 509, in response_wrap

response = f(*args, **kw)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/web/controllers/main.py", line 665, in create

return self._render_template(error=error)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/addons/web/controllers/main.py", line 642, in _render_template

d['databases'] = http.db_list()

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/http.py", line 1669, in db_list

dbs = openerp.service.db.list_dbs(force)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/service/db.py", line 307, in list_dbs

with closing(db.cursor()) as cr:

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 556, in cursor

return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 162, in __init__

self._cnx = pool.borrow(dsn)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 445, in _locked

return fun(self, *args, **kwargs)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/odoo/openerp/sql_db.py", line 507, in borrow

result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)

File "/share/CACHEDEV1_DATA/.qpkg/QOdOO/lib/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect

conn = _connect(dsn, connection_factory=connection_factory, async=async)

OperationalError: FATAL: the database system is in recovery mode

Steven Li

Author

Log from postgresql:

LOG: server process (PID 14779) was terminated by signal 11: Segmentation fault

DETAIL: Failed process was running: autovacuum: ANALYZE public.ir_module_module

LOG: terminating any other active server processes

WARNING: terminating connection because of crash of another server process

DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

HINT: In a moment you should be able to reconnect to the database and repeat your command.

WARNING: terminating connection because of crash of another server process

DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

HINT: In a moment you should be able to reconnect to the database and repeat your command.

WARNING: terminating connection because of crash of another server process

DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

HINT: In a moment you should be able to reconnect to the database and repeat your command.

LOG: all server processes terminated; reinitializing

FATAL: the database system is in recovery mode

LOG: database system was interrupted; last known up at 2016-01-02 20:17:42 GMT-10

FATAL: the database system is in recovery mode

LOG: database system was not properly shut down; automatic recovery in progress

LOG: redo starts at 0/D219824

LOG: record with zero length at 0/D5D0B20

LOG: redo done at 0/D5D0AF8

This question has been flagged