Hi all. Hope you could help me with my problem. My server usually stops responding. Just the Open ERP server. Apache and Postgres are OK. Server log looks like this
[2010-02-23 14:47:16,524] INFO:dbpool:Connecting to template1 [2010-02-23 14:47:16,532] INFO:dbpool:Closing all connections to template1 [2010-02-23 14:50:45,396] INFO:dbpool:Connecting to template1 [2010-02-23 14:50:45,402] INFO:dbpool:Closing all connections to template1 [2010-02-23 14:52:10,045] INFO:dbpool:Connecting to template1 [2010-02-23 14:52:10,052] INFO:dbpool:Closing all connections to template1 [2010-02-23 14:53:27,473] INFO:dbpool:Connecting to template1 [2010-02-23 14:53:27,479] INFO:dbpool:Closing all connections to template1 [2010-02-23 14:55:30,844] INFO:dbpool:Connecting to template1 [2010-02-23 14:55:30,851] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:00:01,835] INFO:dbpool:Connecting to template1 [2010-02-23 15:00:01,842] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:03:49,828] INFO:dbpool:Connecting to template1 [2010-02-23 15:03:49,834] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:18:04,299] INFO:dbpool:Connecting to template1 [2010-02-23 15:18:04,306] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:27:06,548] INFO:dbpool:Connecting to template1 [2010-02-23 15:27:06,554] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:27:07,457] INFO:dbpool:Connecting to template1 [2010-02-23 15:27:07,463] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:29:16,817] INFO:dbpool:Connecting to template1 [2010-02-23 15:29:16,823] INFO:dbpool:Closing all connections to template1 [2010-02-23 15:36:29,757] INFO:dbpool:Connecting to template1 [2010-02-23 15:36:29,763] INFO:dbpool:Closing all connections to template1 Then I would just initiate sudo /etc/init.d/openerp-server restart Then the log continues [2010-02-23 15:37:34,304] INFO:shutdown:Shutdown Server! - SIGTERM [2010-02-23 15:37:35,517] INFO:server:version - 5.0.6 [2010-02-23 15:37:35,518] INFO:server:addons_path - /usr/lib/python2.5/site-packages/openerp-server/addons [2010-02-23 15:37:35,518] INFO:server:database hostname - localhost [2010-02-23 15:37:35,518] INFO:server:database port - 5432 [2010-02-23 15:37:35,518] INFO:server:database user - openerp [2010-02-23 15:37:35,518] INFO:objects:initialising distributed objects services [2010-02-23 15:37:35,687] INFO:web-services:starting XML-RPC services, port 8069 [2010-02-23 15:37:35,687] INFO:web-services:starting NET-RPC service, port 8070 [2010-02-23 15:37:35,687] INFO:web-services:the server is running, waiting for connections... I'm not sure if these error messages are causing the server to stall [2010-02-23 14:40:07,799] ERROR:web-services:[02]: Environment Information : [2010-02-23 14:40:07,799] ERROR:web-services:[03]: System : Linux-2.6.24-25-openvz-x86_64-with-debian-lenny-sid [2010-02-23 14:40:07,799] ERROR:web-services:[04]: OS Name : posix[2010-02-23 14:40:07,799] ERROR:web-services:[05]: Distributor ID: Ubuntu [2010-02-23 14:40:07,799] ERROR:web-services:[06]: Description: Ubuntu 8.04.3 LTS [2010-02-23 14:40:07,799] ERROR:web-services:[07]: Release: 8.04 [2010-02-23 14:40:07,799] ERROR:web-services:[08]: Codename: hardy[2010-02-23 14:40:07,800] ERROR:web-services:[09]: Operating System Release : 2.6.24-25-openvz [2010-02-23 14:40:07,800] ERROR:web-services:[10]: Operating System Version : #1 SMP Tue Oct 20 09:23:00 UTC 2009 [2010-02-23 14:40:07,800] ERROR:web-services:[11]: Operating System Architecture : 64bit [2010-02-23 14:40:07,800] ERROR:web-services:[12]: Operating System Locale : en_PH.UTF8[2010-02-23 14:40:07,800] ERROR:web-services:[13]: Python Version : 2.5.2 [2010-02-23 14:40:07,800] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.6[2010-02-23 14:40:07,800] ERROR:web-services:[15]: Last revision No. & ID : [2010-02-23 14:40:07,800] ERROR:web-services:[16]: Traceback (most recent call last): [2010-02-23 14:40:07,800] ERROR:web-services:[17]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 59, in wrapper [2010-02-23 14:40:07,801] ERROR:web-services:[18]: return f(self, dbname, *args, **kwargs)[2010-02-23 14:40:07,801] ERROR:web-services:[19]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 118, in execut e [2010-02-23 14:40:07,801] ERROR:web-services:[20]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw) [2010-02-23 14:40:07,801] ERROR:web-services:[21]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 110, in execut e_cr [2010-02-23 14:40:07,801] ERROR:web-services:[22]: return getattr(object, method)(cr, uid, *args, **kw) [2010-02-23 14:40:07,801] ERROR:web-services:[23]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/account/account_move_line .py", line 63, in default_get [2010-02-23 14:40:07,801] ERROR:web-services:[24]: data = self._default_get(cr, uid, fields, context) [2010-02-23 14:40:07,801] ERROR:web-services:[25]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/account/account_move_line.py", line 107, in _default_get [2010-02-23 14:40:07,802] ERROR:web-services:[26]: total_new +=(i[2]['debit'] or 0.00)- (i[2]['credit'] or 0.00) [2010-02-23 14:40:07,802] ERROR:web-services:[27]: TypeError: list indices must be integers [2010-02-23 14:40:17,917] ERROR:web-services:[02]: Environment Information : [2010-02-23 14:40:17,917] ERROR:web-services:[03]: System : Linux-2.6.24-25-openvz-x86_64-with-debian-lenny-sid [2010-02-23 14:40:17,917] ERROR:web-services:[04]: OS Name : posix [2010-02-23 14:40:17,917] ERROR:web-services:[05]: Distributor ID: Ubuntu [2010-02-23 14:40:17,917] ERROR:web-services:[06]: Description: Ubuntu 8.04.3 LTS [2010-02-23 14:40:17,917] ERROR:web-services:[07]: Release: 8.04 [2010-02-23 14:40:17,917] ERROR:web-services:[08]: Codename: hardy [2010-02-23 14:40:17,917] ERROR:web-services:[09]: Operating System Release : 2.6.24-25-openvz [2010-02-23 14:40:17,918] ERROR:web-services:[10]: Operating System Version : #1 SMP Tue Oct 20 09:23:00 UTC 2009 [2010-02-23 14:40:17,918] ERROR:web-services:[11]: Operating System Architecture : 64bit [2010-02-23 14:40:17,918] ERROR:web-services:[12]: Operating System Locale : en_PH.UTF8 [2010-02-23 14:40:17,918] ERROR:web-services:[13]: Python Version : 2.5.2 [2010-02-23 14:40:17,918] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.6 [2010-02-23 14:40:17,918] ERROR:web-services:[15]: Last revision No. & ID : [2010-02-23 14:40:17,918] ERROR:web-services:[16]: Traceback (most recent call last): [2010-02-23 14:40:17,918] ERROR:web-services:[17]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 59, in wrapper[2010-02-23 14:40:17,918] ERROR:web-services:[18]: return f(self, dbname, *args, **kwargs) [2010-02-23 14:40:17,918] ERROR:web-services:[19]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 118, in execut e[2010-02-23 14:40:17,919] ERROR:web-services:[20]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw) [2010-02-23 14:40:17,919] ERROR:web-services:[21]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 110, in execut e_cr[2010-02-23 14:40:17,919] ERROR:web-services:[22]: return getattr(object, method)(cr, uid, *args, **kw) [2010-02-23 14:40:17,919] ERROR:web-services:[23]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/account/account.py", line 829, in write [2010-02-23 14:40:17,919] ERROR:web-services:[24]: result = super(osv.osv, self).write(cr, uid, ids, vals, c)[2010-02-23 14:40:17,919] ERROR:web-services:[25]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2479, in write [2010-02-23 14:40:17,919] ERROR:web-services:[26]: result += self._columns[field].set(cr, self, id, field, vals[field], user, context=r el_context) or [] [2010-02-23 14:40:17,919] ERROR:web-services:[27]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/fields.py", line 446, in set[2010-02-23 14:40:17,919] ERROR:web-services:[28]: id_new = obj.create(cr, user, act[2], context=context) [2010-02-23 14:40:17,920] ERROR:web-services:[29]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/account/account_move_line.py", line 793, in create [2010-02-23 14:40:17,920] ERROR:web-services:[30]: if ('account_id' in vals) and not account_obj.read(cr, uid, vals['account_id'], ['active'])['active']: [2010-02-23 14:40:17,920] ERROR:web-services:[31]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2084, in read [2010-02-23 14:40:17,920] ERROR:web-services:[32]: result = self._read_flat(cr, user, select, fields, context, load) [2010-02-23 14:40:17,920] ERROR:web-services:[33]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2130, in _read_flat [2010-02-23 14:40:17,920] ERROR:web-services:[34]: self._order),sub_ids + d2) [2010-02-23 14:40:17,920] ERROR:web-services:[35]: File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 76, in wrapper [2010-02-23 14:40:17,920] ERROR:web-services:[36]: return f(self, *args, **kwargs) [2010-02-23 14:40:17,920] ERROR:web-services:[37]: File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 120, in execute [2010-02-23 14:40:17,921] ERROR:web-services:[38]: res = self._obj.execute(query, params) [2010-02-23 14:40:17,921] ERROR:web-services:[39]: ProgrammingError: operator does not exist: integer = boolean [2010-02-23 14:40:17,921] ERROR:web-services:[40]: LINE 1: ...ELECT "active",id FROM "account_account" WHERE id IN (false)... [2010-02-23 14:40:17,921] ERROR:web-services:[41]: ^ [2010-02-23 14:40:17,921] ERROR:web-services:[42]: HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=51696#51696 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
