Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Help Please! Plb with Odoo update and create database

By
ausl
on 1/1/16, 10:11 PM 1,500 views

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

0
ausl
On 1/2/16, 5:22 AM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 1/1/16, 10:11 PM
Seen: 1500 times
Last updated: 1/2/16, 5:22 AM