Migration script fails when create database

[Martin Collins]

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?

[Jay Vora (Serpent Consulting Services) (jayvora)]

Migrations directory removed.
We will introduce a better way sooner.
Thanks.

[Vadim - Enapps LTD (vadim-enapps)]

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_part...

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hi Vadim,

Do you have base/migrations into your source?

Get an update of the code.

Thanks.