OpenERP 5.0.0-rc1 update issues

greno · **Joined:** Sat Aug 18, 2007 7:14 am **Posts:** 746

I'm running trunk code using bzr. Existing code from near end of October running (don't remember revisions). So today I do a bzr pull for server, addons, client, extra-addons. I'm assuming of course that trunk matches rc1. So bzr pull finishes and I start the server with update=all. I get dependency errors:

Here's the startup log:

Code:

[Sat Nov 29 21:22:40 2008] ERROR:init:addon:account:Unmet dependencies: product, process
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:account_analytic_analysis:Unmet dependencies: account, hr_timesheet, hr_timesheet_invoice, project
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:report_analytic_planning:Unmet dependencies: account, hr_timesheet_invoice, project, report_analytic_line
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:account_payment:Unmet dependencies: account
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:hr:Unmet dependencies: process
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:hr_attendance:Unmet dependencies: hr
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:hr_timesheet:Unmet dependencies: account, hr, hr_attendance, process
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:product:Unmet dependencies: process
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:board_project:Unmet dependencies: project, report_timesheet, report_analytic_planning, report_analytic_line, report_task, hr_timesheet_sheet
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:project:Unmet dependencies: product, account, hr, process
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:hr_timesheet_sheet:Unmet dependencies: hr_timesheet, hr_timesheet_invoice, process
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:hr_timesheet_invoice:Unmet dependencies: account, hr_timesheet
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:report_timesheet:Unmet dependencies: hr_timesheet, hr_timesheet_invoice
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:report_task:Unmet dependencies: project
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:profile_service:Unmet dependencies: hr, project, board_project, account_analytic_analysis
[Sat Nov 29 21:22:40 2008] ERROR:init:addon:report_analytic_line:Unmet dependencies: account, hr_timesheet_invoice
[Sat Nov 29 21:22:40 2008] INFO:init:addon:base:registering classes
[Sat Nov 29 21:22:40 2008] INFO:init:addon:base
[Sat Nov 29 21:22:41 2008] INFO:init:addon:base:creating or updating database tables
[Sat Nov 29 21:22:47 2008] WARNING:init:unable to set a NOT NULL constraint on column name of the ir_actions table !
If you want to have it, you should update the records and execute manually:
ALTER TABLE ir_actions ALTER COLUMN name SET NOT NULL
[Sat Nov 29 21:22:50 2008] WARNING:init:unable to set a NOT NULL constraint on column complete_name of the ir_model_fields table !
If you want to have it, you should update the records and execute manually:
ALTER TABLE ir_model_fields ALTER COLUMN complete_name SET NOT NULL
[Sat Nov 29 21:22:59 2008] WARNING:init:column 'action' in table 'wkf_activity' has changed type (DB = varchar, def = text) !
[Sat Nov 29 21:23:06 2008] WARNING:init:column 'name' in table 'res_partner_address' has changed size (DB = 128, def = 64), DB size will be kept !
[Sat Nov 29 21:23:12 2008] INFO:init:addon:base:loading base_data.xml
[Sat Nov 29 21:23:16 2008] INFO:init:addon:base:loading base_menu.xml
[Sat Nov 29 21:23:17 2008] INFO:init:addon:base:loading security/base_security.xml
[Sat Nov 29 21:23:18 2008] INFO:init:addon:base:loading res/res_security.xml
[Sat Nov 29 21:23:18 2008] INFO:init:addon:base:loading base_update.xml
[Sat Nov 29 21:23:19 2008] INFO:init:addon:base:loading ir/wizard/wizard_menu_view.xml
[Sat Nov 29 21:23:19 2008] INFO:init:addon:base:loading ir/ir.xml
[Sat Nov 29 21:23:26 2008] INFO:init:addon:base:loading ir/workflow/workflow_view.xml
[Sat Nov 29 21:23:27 2008] INFO:init:addon:base:loading module/module_wizard.xml
[Sat Nov 29 21:23:28 2008] INFO:init:addon:base:loading module/module_view.xml
[Sat Nov 29 21:23:29 2008] INFO:init:addon:base:loading module/module_data.xml
[Sat Nov 29 21:23:30 2008] INFO:init:addon:base:loading module/module_report.xml
[Sat Nov 29 21:23:30 2008] INFO:init:addon:base:loading res/res_request_view.xml
[Sat Nov 29 21:23:30 2008] INFO:init:addon:base:loading res/res_lang_view.xml
[Sat Nov 29 21:23:30 2008] INFO:init:addon:base:loading res/partner/partner_report.xml
[Sat Nov 29 21:23:30 2008] INFO:init:addon:base:loading res/partner/partner_view.xml
[Sat Nov 29 21:23:33 2008] INFO:init:addon:base:loading res/partner/partner_wizard.xml
[Sat Nov 29 21:23:33 2008] INFO:init:addon:base:loading res/bank_view.xml
[Sat Nov 29 21:23:33 2008] INFO:init:addon:base:loading res/country_view.xml
[Sat Nov 29 21:23:34 2008] INFO:init:addon:base:loading res/res_currency_view.xml
[Sat Nov 29 21:23:34 2008] INFO:init:addon:base:loading res/partner/crm_view.xml
[Sat Nov 29 21:23:35 2008] INFO:init:addon:base:loading res/partner/partner_data.xml
[Sat Nov 29 21:23:35 2008] INFO:init:addon:base:loading res/ir_property_view.xml
[Sat Nov 29 21:23:35 2008] INFO:init:addon:base:loading security/base_security.xml
[Sat Nov 29 21:23:36 2008] INFO:init:addon:base:loading security/ir.model.access.csv
[Sat Nov 29 21:23:43 2008] INFO:init:addon:base_setup:registering classes
[Sat Nov 29 21:23:43 2008] INFO:init:addon:base_setup
[Sat Nov 29 21:23:43 2008] INFO:init:addon:base_setup:creating or updating database tables
[Sat Nov 29 21:23:43 2008] INFO:init:addon:base_setup:loading base_setup_data.xml
[Sat Nov 29 21:23:43 2008] INFO:init:addon:base_setup:loading security/ir.model.access.csv
[Sat Nov 29 21:23:43 2008] INFO:init:addon:base_setup:loading base_setup_wizard.xml
[Sat Nov 29 21:23:44 2008] INFO:init:addon:board:registering classes
[Sat Nov 29 21:23:44 2008] INFO:init:addon:board
[Sat Nov 29 21:23:44 2008] INFO:init:addon:board:creating or updating database tables
[Sat Nov 29 21:23:45 2008] INFO:init:addon:board:loading security/ir.model.access.csv
[Sat Nov 29 21:23:45 2008] INFO:init:addon:board:loading board_view.xml
[Sat Nov 29 21:23:46 2008] INFO:init:addon:crm:registering classes
[Sat Nov 29 21:23:46 2008] INFO:init:addon:crm
[Sat Nov 29 21:23:46 2008] INFO:init:addon:crm:creating or updating database tables
[Sat Nov 29 21:23:52 2008] INFO:init:addon:crm:loading crm_data.xml
[Sat Nov 29 21:23:52 2008] INFO:init:addon:crm:loading crm_view.xml
[Sat Nov 29 21:23:55 2008] INFO:init:addon:crm:loading crm_report.xml
[Sat Nov 29 21:23:55 2008] INFO:init:addon:crm:loading crm_wizard.xml
[Sat Nov 29 21:23:55 2008] INFO:init:addon:crm:loading security/crm_security.xml
[Sat Nov 29 21:23:55 2008] INFO:init:addon:crm:loading security/ir.model.access.csv
[Sat Nov 29 21:23:56 2008] WARNING:init:addon:object hr.action.reason (Action reason) has no access rules!
[Sat Nov 29 21:23:56 2008] WARNING:init:addon:object hr.attendance (Attendance) has no access rules!
[Sat Nov 29 21:23:56 2008] WARNING:init:addon:object account.config.wizard (account.config.wizard) has no access rules!
[Sat Nov 29 21:23:56 2008] WARNING:init:addon:object profile.service.config.install_modules_wizard (profile.service.config.install_modules_wizard) has no access rules!
[Sat Nov 29 21:23:56 2008] WARNING:init:addon:object account.budget (account.budget) has no access rules!
[Sat Nov 29 21:23:56 2008] WARNING:init:addon:object account.budget.item (account.budget.item) has no access rules!
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 12@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 76@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 86@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 77@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 88@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 74@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 89@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 91@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 41@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 42@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 10@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 1@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 11@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 8@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 7@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 9@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 83@ir.model.access
[Sat Nov 29 21:23:57 2008] INFO:init:Deleting 90@ir.model.access
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:account:Unmet dependencies: product, process
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:account_analytic_analysis:Unmet dependencies: account, hr_timesheet, hr_timesheet_invoice, project
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:report_analytic_planning:Unmet dependencies: account, hr_timesheet_invoice, project, report_analytic_line
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:account_payment:Unmet dependencies: account
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:hr:Unmet dependencies: process
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:hr_attendance:Unmet dependencies: hr
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:hr_timesheet:Unmet dependencies: account, hr, hr_attendance, process
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:product:Unmet dependencies: process
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:board_project:Unmet dependencies: project, report_timesheet, report_analytic_planning, report_analytic_line, report_task, hr_timesheet_sheet
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:project:Unmet dependencies: product, account, hr, process
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:hr_timesheet_sheet:Unmet dependencies: hr_timesheet, hr_timesheet_invoice, process
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:hr_timesheet_invoice:Unmet dependencies: account, hr_timesheet
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:report_timesheet:Unmet dependencies: hr_timesheet, hr_timesheet_invoice
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:report_task:Unmet dependencies: project
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:profile_service:Unmet dependencies: hr, project, board_project, account_analytic_analysis
[Sat Nov 29 21:23:58 2008] ERROR:init:addon:report_analytic_line:Unmet dependencies: account, hr_timesheet_invoice
[Sat Nov 29 21:23:58 2008] INFO:init:addon:base
[Sat Nov 29 21:23:59 2008] INFO:init:addon:base_setup
[Sat Nov 29 21:23:59 2008] INFO:init:addon:board
[Sat Nov 29 21:23:59 2008] INFO:init:addon:crm
[Sat Nov 29 21:23:59 2008] WARNING:init:addon:object hr.action.reason (Action reason) has no access rules!
[Sat Nov 29 21:23:59 2008] WARNING:init:addon:object hr.attendance (Attendance) has no access rules!
[Sat Nov 29 21:23:59 2008] WARNING:init:addon:object account.config.wizard (account.config.wizard) has no access rules!
[Sat Nov 29 21:23:59 2008] WARNING:init:addon:object profile.service.config.install_modules_wizard (profile.service.config.install_modules_wizard) has no access rules!
[Sat Nov 29 21:23:59 2008] WARNING:init:addon:object account.budget (account.budget) has no access rules!
[Sat Nov 29 21:23:59 2008] WARNING:init:addon:object account.budget.item (account.budget.item) has no access rules!
[Sat Nov 29 21:23:59 2008] INFO:web-services:starting XML-RPC services, port 8069
[Sat Nov 29 21:23:59 2008] INFO:web-services:starting NET-RPC service, port 8070
[Sat Nov 29 21:23:59 2008] INFO:web-services:the server is running, waiting for connections...

I start the client and login and then start getting some weird object and KeyErrors.

Code:

[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 0]: Traceback (most recent call last):
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 1]:   File "/root/build/openerp/server/bin/osv/osv.py", line 84, in execute_cr
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 2]:     'Object %s doesn\'t exist' % str(obj))
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 3]:   File "/root/build/openerp/server/bin/netsvc.py", line 114, in abortResponse
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 4]:     raise Exception("%s -- %s\n\n%s"%(origin, description, details))
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 5]: Exception: warning -- Object Error
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 6]: 
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 7]: Object account.invoice doesn't exist
[Sat Nov 29 22:42:31 2008] ERROR:web-services:[ 8]: 

So I go into Module Admin and run Update Module List. 113 updated 7 added. The list looks ok but objects that should exist do not show as existing.

So I logut and try creating a new database and get this error:

Code:

Error during database creation !

The server crashed during installation.
We suggest you to drop this database.

Here is the traceback:

Code:

Traceback (most recent call last):
  File "/root/build/openerp/server/bin/service/web_services.py", line 78, in __call__
    tools.init_db(cr)
  File "/root/build/openerp/server/bin/tools/misc.py", line 66, in init_db
    info = eval(zfile.read(os.path.join(i, '__terp__.py')))
  File "/usr/lib/python2.5/zipfile.py", line 471, in read
    zinfo = self.getinfo(name)
  File "/usr/lib/python2.5/zipfile.py", line 462, in getinfo
    return self.NameToInfo[name]
KeyError: 'grp_account_budget-5-1/__terp__.py'

So what went wrong here?

Regards,
Gerry

P.S. ALTER column issues:

Code:

=>  select * from ir_actions where name is null;
 id | name |         type          | usage | create_uid |        create_date         |         write_date         | write_uid | parent_id 
----+------+-----------------------+-------+------------+----------------------------+----------------------------+-----------+-----------
 90 |      | ir.actions.act_window |       |          1 | 2008-10-20 14:02:02.769886 |                            |           |          
 71 |      | ir.actions.act_window |       |          1 | 2008-10-20 13:59:55.648265 | 2008-11-29 22:43:31.595982 |         1 |          
(2 rows)

So is it ok to just put some value in the 'name' field for these?

Code:

=>  select count(*) from ir_model_fields where complete_name is null;
 count 
-------
  1693
(1 row)

And how should we generate the 1693 complete names for ir_model_fields since this is supposed to be not null now?

gegard · **Posted:** Mon Dec 01, 2008 11:22 am

greno wrote:

... So bzr pull finishes and I start the server with update=all. I get dependency errors... how should we generate the 1693 complete names for ir_model_fields since this is supposed to be not null now?

You'd normally use the migration scripts for such an update (they're in /doc/migrate) but I see that 4.2.0-4.4.0 hasn't been updated since July (which, I suppose, is when Tiny started to use bzr).

So I expect that these scripts will be updated before the main release (or 4.x-5.0.0 may be created), and they're where you would put updates for your own modules.

greno · **Joined:** Sat Aug 18, 2007 7:14 am **Posts:** 746

I would not expect to need the migration scripts when we are only updating from the same v5.0 tree. Going from 4.x to 5.0 yes but not when moving up just a few revisions in v5.0.

gegard · **Posted:** Mon Dec 01, 2008 4:00 pm

greno wrote:

... we are only updating from the same v5.0 tree. ...

Ok, I didn't realize.

I think that the getout clause is that earlier 5.0 revisions were pre-alpha so don't follow the standards.

greno · **Joined:** Sat Aug 18, 2007 7:14 am **Posts:** 746

If a bzr update cannot be successfully done then bzr should be prevented from performing such an update. Right now we have a big mess and a corrupted database.

Regards,
Gerry