Issue 212 in couchdb-python: System Error occurs when a query is done

[couchdb...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 212 by shn...@gmail.com: System Error occurs when a query is done
http://code.google.com/p/couchdb-python/issues/detail?id=212

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

[couchdb...@googlecode.com]

Updates:
Status: Invalid

Comment #1 on issue 212 by djc.ochtman: System Error occurs when a query is
done
http://code.google.com/p/couchdb-python/issues/detail?id=212

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.

[couchdb...@googlecode.com]

Comment #2 on issue 212 by shn...@gmail.com: System Error occurs when a

query is done
http://code.google.com/p/couchdb-python/issues/detail?id=212

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

[couchdb...@googlecode.com]

Comment #3 on issue 212 by djc.ochtman: System Error occurs when a query is
done
http://code.google.com/p/couchdb-python/issues/detail?id=212

Still, it's a problem with your OS-level setup. You should probably ask
this on us...@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.