c2c-oerpscenario team mailing list archive

Thread
Date
[Bug 614468] Re: Migration script fails when create database

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: vadim <614468@xxxxxxxxxxxxxxxxxx>
Date: Fri, 15 Oct 2010 23:00:53 -0000
Reply-to: Bug 614468 <614468@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
As per trunk 2882 this is still present:

[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[01]: CREATE DATABASE
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[02]: Traceback (most recent call last):
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[03]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 99, in __call__
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[04]:     update_module=True)[1]
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[05]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 60, in restart_pool
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[06]:     return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[07]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 39, in get_db_and_pool
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[08]:     addons.load_modules(db, force_demo, status, update_module)
[2010-10-16 02:49:47,289][vadim3] ERROR:web-services:[09]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 809, in load_modules
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[10]:     has_updates = load_module_graph(cr, graph, status, perform_checks=(not update_module), report=report)
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[11]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 696, in load_module_graph
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[12]:     migrations.migrate_module(package, 'pre')
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[13]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 583, in migrate_module
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[14]:     mod.migrate(self.cr, pkg.installed_version)
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[15]:   File "base/migrations/1.2/pre-10-res_address_fuction_change_type.py", line 6, in migrate
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[16]:     change_column_type(cr,'res_partner_address')
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[17]:   File "base/migrations/1.2/pre-10-res_address_fuction_change_type.py", line 9, in change_column_type
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[18]:     cr.execute('SELECT id, name FROM res_partner_function')
[2010-10-16 02:49:47,290][vadim3] ERROR:web-services:[19]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 75, in wrapper
[2010-10-16 02:49:47,291][vadim3] ERROR:web-services:[20]:     return f(self, *args, **kwargs)
[2010-10-16 02:49:47,291][vadim3] ERROR:web-services:[21]:   File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 122, in execute
[2010-10-16 02:49:47,291][vadim3] ERROR:web-services:[22]:     res = self._obj.execute(query, params)
[2010-10-16 02:49:47,291][vadim3] ERROR:web-services:[23]: ProgrammingError: relation "res_partner_function" does not exist
[2010-10-16 02:49:47,291][vadim3] ERROR:web-services:[24]: LINE 1: SELECT id, name FROM res_partner_function
[2010-10-16 02:49:47,291][vadim3] ERROR:web-services:[25]:

-- 
Migration script fails when create database
https://bugs.launchpad.net/bugs/614468
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in OpenObject Server: Fix Released

Bug description:
Trunk.

Create a new database. Result:

[2010-08-06 10:43:53,279] INFO:web-services:CREATE DATABASE: sipesa
[2010-08-06 10:44:08,821] INFO:init:module base: loading objects
[2010-08-06 10:44:08,841] INFO:migration:module base: Running migration [>1.2] ir.property: Rename column value to value_reference
[2010-08-06 10:44:08,845] INFO:migration:module base: Running migration [>1.2] res.partner.address: change type of 'function' field many2one to char
[2010-08-06 10:44:08,845] ERROR:db.cursor:Programming error: relation "res_partner_function" does not exist
LINE 1: SELECT id, name FROM res_partner_function
                             ^
, in query SELECT id, name FROM res_partner_function
[2010-08-06 10:44:08,847] ERROR:web-services:[01]: CREATE DATABASE
[2010-08-06 10:44:08,847] ERROR:web-services:[02]: Traceback (most recent call last):
[2010-08-06 10:44:08,847] ERROR:web-services:[03]:   File "/usr/lib/openerp/server/bin/service/web_services.py", line 102, in __call__
[2010-08-06 10:44:08,847] ERROR:web-services:[04]:     update_module=True)[1]
[2010-08-06 10:44:08,847] ERROR:web-services:[05]:   File "/usr/lib/openerp/server/bin/pooler.py", line 62, in restart_pool
[2010-08-06 10:44:08,847] ERROR:web-services:[06]:     return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
[2010-08-06 10:44:08,848] ERROR:web-services:[07]:   File "/usr/lib/openerp/server/bin/pooler.py", line 39, in get_db_and_pool
[2010-08-06 10:44:08,848] ERROR:web-services:[08]:     addons.load_modules(db, force_demo, status, update_module)
[2010-08-06 10:44:08,848] ERROR:web-services:[09]:   File "/usr/lib/openerp/server/bin/addons/__init__.py", line 794, in load_modules
[2010-08-06 10:44:08,848] ERROR:web-services:[10]:     has_updates = load_module_graph(cr, graph, status, perform_checks=(not update_module), report=report)
[2010-08-06 10:44:08,848] ERROR:web-services:[11]:   File "/usr/lib/openerp/server/bin/addons/__init__.py", line 686, in load_module_graph
[2010-08-06 10:44:08,848] ERROR:web-services:[12]:     migrations.migrate_module(package, 'pre')
[2010-08-06 10:44:08,848] ERROR:web-services:[13]:   File "/usr/lib/openerp/server/bin/addons/__init__.py", line 573, in migrate_module
[2010-08-06 10:44:08,849] ERROR:web-services:[14]:     mod.migrate(self.cr, pkg.installed_version)
[2010-08-06 10:44:08,849] ERROR:web-services:[15]:   File "base/migrations/1.2/pre-10-res_address_fuction_change_type.py", line 6, in migrate
[2010-08-06 10:44:08,849] ERROR:web-services:[16]:     change_column_type(cr,'res_partner_address')
[2010-08-06 10:44:08,849] ERROR:web-services:[17]:   File "base/migrations/1.2/pre-10-res_address_fuction_change_type.py", line 9, in change_column_type
[2010-08-06 10:44:08,849] ERROR:web-services:[18]:     cr.execute('SELECT id, name FROM res_partner_function')
[2010-08-06 10:44:08,849] ERROR:web-services:[19]:   File "/usr/lib/openerp/server/bin/sql_db.py", line 74, in wrapper
[2010-08-06 10:44:08,850] ERROR:web-services:[20]:     return f(self, *args, **kwargs)
[2010-08-06 10:44:08,850] ERROR:web-services:[21]:   File "/usr/lib/openerp/server/bin/sql_db.py", line 123, in execute
[2010-08-06 10:44:08,850] ERROR:web-services:[22]:     res = self._obj.execute(query, params)
[2010-08-06 10:44:08,850] ERROR:web-services:[23]: ProgrammingError: relation "res_partner_function" does not exist
[2010-08-06 10:44:08,850] ERROR:web-services:[24]: LINE 1: SELECT id, name FROM res_partner_function
[2010-08-06 10:44:08,850] ERROR:web-services:[25]:                              ^

Should these migration scripts even be running on database creation?