System Error occurs when a query is done

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1.First I populated the database. There are 998 records in it
2.Then this error occured. 
3.Each time when I run the program again, I get the same aerror

What is the expected output? What do you see instead?
I expect that the program runs the query and then gets and uses the result. How 
ever, when it wants to use the result, the following error code is given.

if len(result) == 0:
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/client.py", line 987, in __len__
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/client.py", line 1003, in rows
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/client.py", line 990, in _fetch
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/client.py", line 914, in _exec
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/http.py", line 399, in post_json
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/http.py", line 381, in post
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/http.py", line 419, in _request
  File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/couchdb/http.py", line 310, in request
couchdb.http.ServerError: (500, ('error', 'system_limit'))

What version of the product are you using? On what operating system?
apache Couchdb 0.10.0
Apache 2.0

Please provide any additional information below.
I am using python-couchdb to implement the program. It is being written with 
python.
The code segment where the error occurs:

result = self.dns_db.query(code)
if len(result) == 0:             #error on this line
    return True
else:
    return False

Original issue reported on code.google.com by shn...@gmail.com on 12 Jul 2012 at 6:54

GoogleCodeExporter commented 9 years ago

How many databases are there? I think there might be an issue with the number 
of open files your operating system allows any process to have at a time. Since 
you seem to be using something UNIXish, have a look at raising the number of 
open files allowed using the ulimit command. I'm fairly sure this is not a bug 
in CouchDB-Python.

Original comment by djc.ochtman on 12 Jul 2012 at 7:00

Changed state: Invalid

GoogleCodeExporter commented 9 years ago

There is just one database in the server, on which I couldn't do any other 
operation(insersion, deletion, query etc). ulimit command gives the answers 
"unlimited". I am open to suggestions. Because I am new on this area, I need 
and appriciate your helps.

I forgot to indicate the operating system. It is Ubuntu 12.04 LTS

Original comment by shn...@gmail.com on 12 Jul 2012 at 7:05

GoogleCodeExporter commented 9 years ago

Still, it's a problem with your OS-level setup. You should probably ask this on 
user@couchdb.apache.org. I should also mention you seem to be running an 
exceedingly old version of CouchDB; you might want to try something newer.

Original comment by djc.ochtman on 12 Jul 2012 at 7:12

jur9526 / couchdb-python

System Error occurs when a query is done #212