* Login   * Register Feed - OpenERP Feed - OpenERP * FAQ    * Search
It is currently Mon May 21, 2012 4:58 pm

View unanswered posts | View active topics


Board index » Users Questions » General discussion

All times are UTC + 2 hours




Post new topic Reply to topic  Page 1 of 1
  [ 10 posts ] 
  Print view Previous topic | Next topic 
Author Message
webmonster
 Post subject: openerp server stalled
PostPosted: Wed Feb 24, 2010 1:49 am 
Offline

Joined: Mon Mar 23, 2009 12:08 pm
Posts: 10
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

Code:
[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

Code:
sudo /etc/init.d/openerp-server restart


Then the log continues

Code:
[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

Code:
[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


Code:
[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.
Top
 Profile  
 
hda
 Post subject:
PostPosted: Wed Feb 24, 2010 8:18 am 
Offline

Joined: Mon Dec 03, 2007 8:22 am
Posts: 1472
Location: India
Hello,

Which version of OpenERP are you using?
I checked on stable 5.0.7 and can't reproduce an error.
can you describe the steps to reproduce an error?

_________________
OpenERP=Easier, Adaptable, Affordable, Modular

Top
 Profile  
 
webmonster
 Post subject:
PostPosted: Thu Feb 25, 2010 5:02 am 
Offline

Joined: Mon Mar 23, 2009 12:08 pm
Posts: 10
Hi. Thanks for the reply. I'm not sure how you can reproduce the problem. I also don't know what triggers it. Anyway, here's more info on the system:

Server OS: Ubuntu Server 8.0.4 (64 bit) with latest packages
Open ERP version: 5.0.6
Open ERP clients: Windows version
Installed modules:

account
account_balance
account_budget
account_chart
account_tax_include
audittrail
base
base_iban
base_setup
base_vat
board
crm
crm_configuration
document
document_ics
fs3_account_cic
fs3_base_partner_cic
fs3_coa_cic
fs3_tax_codes_extended
hr
hr_attendance
hr_timesheet
hr_timesheet_invoice
hr_timesheet_sheet
mrp
multi_company
multi_company_account
process
product
project
project_retro_planning
purchase
report_account
report_crm
report_project
report_task
sale
sgc_base_mod
sgc_check_voucher
sgc_custom_menu
sgc_supplier_invoice
stock
subscription
wiki
Top
 Profile  
 
hda
 Post subject:
PostPosted: Thu Feb 25, 2010 9:11 am 
Offline

Joined: Mon Dec 03, 2007 8:22 am
Posts: 1472
Location: India
Account_id in account_move_line is compulsary field.
and with original addons you will never enter account_move_line without account.
i thing error occurs because of one of these modules.
fs3_account_cic
fs3_base_partner_cic
fs3_coa_cic
fs3_tax_codes_extended
sgc_base_mod
sgc_check_voucher
sgc_custom_menu
sgc_supplier_invoice

It is passing account_id = False in account_move_line.
you must get this error at the time of confirming invoice or by entering accounting entries manually.

Try to create new database with simple account module and try to create invoice and confirm>pay it. if it will work then there must be error in above modules.

_________________
OpenERP=Easier, Adaptable, Affordable, Modular

Top
 Profile  
 
jacorbacho
 Post subject:
PostPosted: Fri Feb 26, 2010 11:50 am 
Offline

Joined: Fri Jan 08, 2010 11:55 am
Posts: 25
Additionally, if hda's solution does not fix your problem, try removing audittrail

_________________
Jose A. Corbacho
Trobz (www.trobz.com)

Top
 Profile  
 
ferdinand
 Post subject:
PostPosted: Fri Feb 26, 2010 12:36 pm 
Offline

Joined: Sat Sep 17, 2005 7:51 pm
Posts: 648
I have terrible problems with stalled server
branch-server 1902
will try to update ths weekend

the problems are various - so I have created an autorestart script - testing the availability of the server
usually I get this

Code:
sock_common = xmlrpclib.ServerProxy ('http://my-IP:8069/xmlrpc/common')
    try:
        uid = sock_common.login(dbname, username, pwd)
    except:
        print 'Cant get UID'


but sometimes this works and only NET-RPC or Pyro (Koo) are blocked

sometime I think it's caused by upgrading only ONE database and hence the server fails serving other database with not matching tables/objects

I assume that ONE server instance can only use ONE python code and hence all databases must have the same revision. which obviosuly creates a problem during upgrade, which takes it's time especially if one or more languages are to be loaded
Top
 Profile  
 
webmonster
 Post subject:
PostPosted: Wed Mar 10, 2010 10:02 am 
Offline

Joined: Mon Mar 23, 2009 12:08 pm
Posts: 10
Hi Ferdinand. I was actually thinking of making an auto-restart script. I wonder if you could share yours so I don't have to make one?

Thanks.
Top
 Profile  
 
webmonster
 Post subject:
PostPosted: Mon Mar 22, 2010 11:51 am 
Offline

Joined: Mon Mar 23, 2009 12:08 pm
Posts: 10
hda wrote:
Account_id in account_move_line is compulsary field.
and with original addons you will never enter account_move_line without account.
i thing error occurs because of one of these modules.
fs3_account_cic
fs3_base_partner_cic
fs3_coa_cic
fs3_tax_codes_extended
sgc_base_mod
sgc_check_voucher
sgc_custom_menu
sgc_supplier_invoice

It is passing account_id = False in account_move_line.
you must get this error at the time of confirming invoice or by entering accounting entries manually.

Try to create new database with simple account module and try to create invoice and confirm>pay it. if it will work then there must be error in above modules.


Hi hda. Thanks for the reply. Since I posted this for over a month ago, the problem only happened again twice so I just restarted the server to fix it.

Just today, it happened again. So I decided to revisit this thread. I checked the modules above but I did not find any line that passes something in account_move_line. The database doesn't have any record that has a null value in the account_id.

What else could be the culprit? Could it be the audittrail?
Top
 Profile  
 
albertca
 Post subject:
PostPosted: Mon Mar 22, 2010 12:08 pm 
Offline

Joined: Sun Sep 02, 2007 10:47 pm
Posts: 253
The probable reason of this problem is in the openobject-server and a proper fix has already been commited:

https://bugs.launchpad.net/openobject-s ... bug/538399

Please, try the patch in the report or update to latest bazaar version.

_________________
Albert Cervera i Areny
http://www.NaN-tic.com

http://twitter.com/albertnan

Top
 Profile  
 
webmonster
 Post subject:
PostPosted: Mon Mar 22, 2010 3:46 pm 
Offline

Joined: Mon Mar 23, 2009 12:08 pm
Posts: 10
Thanks Albert. I've already applied the patch. Hopefully the problem won't happen again. Will let you know after a week. ;)
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 10 posts ] 

Board index » Users Questions » General discussion

All times are UTC + 2 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:

Protected by Anti-Spam ACP