Server crashes (or takes several minutes to respond) when searching through a large amount of contacts
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Odoo Server (MOVED TO GITHUB) | Status tracked in Trunk | |||||
7.0 |
In Progress
|
Medium
|
OpenERP Publisher's Warranty Team | |||
Trunk |
Confirmed
|
Medium
|
OpenERP's Framework R&D |
Bug Description
With about 200.000 res_partner records in the database, when searching for name with "some" inexisting patterns:
- the server takes more than 4 minutes to respond with an empty list of results (tested on a windows machine double core with 3G of memory), or
- the server stops running without special message in the openerp.log file (tested on an Ubuntu machine double core with 2G of memory) producing the following message in the web browser:
XmlHttpRequestError Service Temporarily Unavailable
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>503 Service Temporarily Unavailable</title>
</head><body>
<h1>Service Temporarily Unavailable</h1>
<p>The server is temporarily unable to service your
request due to maintenance downtime or capacity
problems. Please try again later.</p>
<hr>
<address>
</body></html>
Tested on branch lp:~openerp/openobject-server/7.0
Steps to reproduce:
- restore the attached database dump
- logon with admin/admin credentials
- go to sales/sales/
- in the search box, rid off the "Customers" filter and type @, then accept the first option, i.e, "Search Name for: @"
tags: | added: maintenance |
Hello Olivier,
I have also tested this issue on Ubuntu 12.04. And when I were restore your database and then try to "search name for:@" system is becoming hang and server takes more 20 min to respond.
So, that's why I am confiming this issue.
Thank you.