Server crash when pushing search more button with 70000 products
I'm on Ubuntu 12.04 and OpenERP 7.0.
I've experiencing an issue when I've done : Quotation / create / add an item / search more
The issue raised is a XmlHttpRequestError, which hide the fact that the server was down...
Can someone explain me how to fix this / how these actions can make the server goes down ?
Thanks all !
(sorry for bad English)
I've opened the web console when the error occurs, and there's this entry :
POST [path]/web/dataset/call_kw send jQuery.extend.ajax instance.web.JsonRPC.instance.web.Class.extend.rpc_json instance.web.JsonRPC.instance.web.Class.extend.rpc instance.web.Session.instance.web.JsonRPC.extend.rpc prototype.(anonymous function) instance.web.Model.instance.web.Class.extend.call instance.web.DataSet.instance.web.Class.extend.name_search values.push.action $input.autocomplete.select $.Widget._trigger _on.menuselect handlerProxy jQuery.event.dispatch elemData.handle.eventHandle jQuery.event.trigger (anonymous function) jQuery.extend.each jQuery.fn.jQuery.each jQuery.fn.extend.trigger $.Widget._trigger $.widget.select (anonymous function) _on.click .ui-menu-item:has(a) handlerProxy jQuery.event.dispatch elemData.handle.eventHandle
Does anyone know how to fix this ? I tried to go into the core of openerp-server, but I can't find in wich file the event is handled...
EDIT 2: And why I can't see any changes in the log when I use the --debug starting option ?
EDIT 3: this happen with any form, if this button is present, and if I push it.
I've made things yesterday, and now I think I understand what happen :
- created a new base
- imported products (csv again) in the new base
- deleted products in the old base
Now that there's less products in the old base, the "Search more" button works fine... So, that seems to be a size problem (size of the table products_products, and/or products_template, ....)
But, why OpenERP is so popular, if a problem like the number of products can simply makes your server crash ? And, again, any idea ? How to fix this ? ^^
I've now tried to start openERP in front, with the --debug and --log-level, but that dont seem to change anything.. I were not prompted when the server crashed. Just a "Processus stopped"... Plus, no error occurs in this log when the XmlHttpRequestError occurs on the client side...
PS : And I can't post the log, because this site don't allow be to post links (even if there's no links in the text I wan't to post...)