Timeout when upgrading modules

[Jim Norman]

When upgrading modules, the following behavior is observed:

GTK client times out:

Connection refused !

timed out

following shown with ps:

jim@HPWonder:/opt/openerp/newtrunk/openerp/client/bin$ ps -ef | grep openerp
jim 11170 2094 0 10:59 pts/0 00:00:01 /usr/bin/python ./openerp-server.py trunk
jim 11186 10927 0 11:00 pts/3 00:00:00 tail -f openerp-server.log
postgres 11196 11152 0 11:00 ? 00:00:00 postgres: openerp joncodiev6 127.0.0.1(46317) idle in transaction
postgres 11198 11152 0 11:01 ? 00:00:00 postgres: openerp joncodiev6 127.0.0.1(46318) UPDATE waiting
postgres 11380 11152 0 11:18 ? 00:00:00 postgres: openerp joncodiev6 127.0.0.1(46663) idle
jim 11431 10711 0 11:20 pts/2 00:00:00 grep openerp

queries show:

119 query: SELECT * FROM ir_act_report_xml WHERE auto=%s ORDER BY id params: (True,)
119 query: UPDATE ir_cron set nextcall = '2010-07-19 11:00:00' where numbercall<>0 and active and model='base.action.rule' params: None
119 query: select * from ir_cron where numbercall<>0 and active and nextcall<=now() order by priority params: None
119 query: select calendar_alarm.id from "calendar_alarm" where (calendar_alarm.active = %s) AND (calendar_alarm.state != %s) order by id params: ['True', 'done']
119 query: update ir_cron set nextcall=%s, numbercall=%s where id=%s params: ('2010-07-19 11:45:25', -1, 2)
119 query: select base_action_rule.id from "base_action_rule" where (base_action_rule.active = %s) order by sequence params: ['True']
119 query: update ir_cron set nextcall=%s, numbercall=%s where id=%s params: ('2010-07-19 15:00:00', -1, 1)

(119 is line number is sql_db.py)

It appears that a transaction is not completing on update ir_cron, and another transaction is trying to start.

Selecting "Administration" from the menu again, and "Apply Scheduled Upgrades" allows configuration to continue, but it will hang again, the next time the update ir_cron query is issued.

[Olivier Dony (Odoo) (odo-openerp)]

Can you specify the version of the addons and server that you are running? This has normally been fixed in addons-trunk revision 3897 <email address hidden>

Thanks!

[Jim Norman (jim-jsnorman)]

The problem was experienced with 2433 server and 3796 addons.

I have updated to the latest code (4263 addons, 2548 server), and I am
now unable to create a database:

Error during database creation !

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

Jim Norman

On 07/28/2010 12:15 PM, Olivier Dony (OpenERP) wrote:
> Can you specify the version of the addons and server that you are
> running? This has normally been fixed in addons-trunk revision 3897
> <email address hidden>
>
> Thanks!
>
> ** Changed in: openobject-server
> Status: New => Incomplete
>
>

[Jim Norman (jim-jsnorman)]

Latest code fixes problem.

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

Thanks Jim.