I used Cassandra 0.8.1 and pycasa 0.2. If I upgrade pycasa, then it have compatibility issue. please suggest


Thanks & Regards

Adeel Akbar

On 7/25/2012 10:13 PM, Tyler Hobbs wrote:
That's a pretty old version of pycassa; it was release before 0.7.0 came out.  I suggest upgrading.

It's possible this was caused by an old bug, but in general, this indicates that you have more threads trying to use the ConnectionPool concurrently than there are connections.

On Wed, Jul 25, 2012 at 3:30 AM, Adeel Akbar <adeel.akbar@panasiangroup.com> wrote:
Hi,

I have created 2 node cluster and use with application. My application unable to connect with database. Please find below logs;

NoConnectionAvailable at /

ConnectionPool limit of size 2 overflow 2 reached, unable to obtain connection after 30 seconds
Request Method: GET
Request URL: http://172.16.100.131/
Django Version: 1.4
Exception Type: NoConnectionAvailable
Exception Value:
ConnectionPool limit of size 2 overflow 2 reached, unable to obtain connection after 30 seconds
Exception Location: /usr/local/lib/python2.6/site-packages/pycassa-1.0.8-py2.6.egg/pycassa/pool.py in get, line 738
Python Executable: /usr/local/bin/python
Python Version: 2.6.4
Python Path:
['/var/www/bs_ping',
 '/usr/local/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/amqplib-0.6.1-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/BeautifulSoup-3.1.0.1-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/python_dateutil-1.4.1-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/feedparser-4.1-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/python_twitter-0.6-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/simplejson-2.0.9-py2.6-linux-i686.egg',
 '/usr/local/lib/python2.6/site-packages/txAMQP-0.3-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/Twisted-8.2.0-py2.6-linux-i686.egg',
 '/usr/local/lib/python2.6/site-packages/zope.interface-3.5.2-py2.6-linux-i686.egg',
 '/usr/local/lib/python2.6/site-packages/UnicodeUtils-0.3.2-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/pytz-2009p-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/ScriptUtils-0.5.5-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/MySQL_python-1.2.3c1-py2.6-linux-i686.egg',
 '/usr/local/lib/python2.6/site-packages/python_memcached-1.44-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/coverage-3.2b1-py2.6-linux-i686.egg',
 '/usr/local/lib/python2.6/site-packages/flup-1.0.3.dev_20091027-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/oauth-1.0.1-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/pyOpenSSL-0.10-py2.6-linux-i686.egg',
 '/usr/local/lib/python2.6/site-packages/pycassa-1.0.8-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/wadofstuff_django_serializers-1.1.0-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/jsonpickle-0.4.0-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/django_compressor-1.1.2-py2.6.egg',
 '/usr/local/lib/python2.6/site-packages/django_appconf-0.5-py2.6.egg',
 '/usr/local/lib/python26.zip',
 '/usr/local/lib/python2.6',
 '/usr/local/lib/python2.6/plat-linux2',
 '/usr/local/lib/python2.6/lib-tk',
 '/usr/local/lib/python2.6/lib-old',
 '/usr/local/lib/python2.6/lib-dynload',
 '/usr/local/lib/python2.6/site-packages',
 '/usr/local/lib/python2.6/site-packages/PIL',
 '/var/www/bs_ping/',
 '/var/www']
Server time: Wed, 25 Jul 2012 13:17:33 +0500

--


Thanks & Regards

Adeel Akbar




--
Tyler Hobbs
DataStax