From user-return-27843-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Fri Jul 27 04:25:48 2012 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E2F67D1C3 for ; Fri, 27 Jul 2012 04:25:48 +0000 (UTC) Received: (qmail 9262 invoked by uid 500); 27 Jul 2012 04:25:46 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 8994 invoked by uid 500); 27 Jul 2012 04:25:45 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 8965 invoked by uid 99); 27 Jul 2012 04:25:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jul 2012 04:25:44 +0000 X-ASF-Spam-Status: No, hits=4.5 required=5.0 tests=HTML_MESSAGE,HTTP_ESCAPED_HOST,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [98.130.1.164] (HELO mail508.opentransfer.com) (98.130.1.164) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jul 2012 04:25:39 +0000 Received: (qmail 9252 invoked by uid 399); 27 Jul 2012 04:25:13 -0000 Received: from unknown (HELO ?172.16.100.162?) (pbs:adeel.akbar@panasiangroup.com@182.185.200.7) by mail508.opentransfer.com with ESMTPM; 27 Jul 2012 04:25:13 -0000 X-Originating-IP: 182.185.200.7 Message-ID: <50121823.20800@panasiangroup.com> Date: Fri, 27 Jul 2012 09:25:07 +0500 From: Adeel Akbar User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: Connection issue in Cassandra References: <500FAEB5.80208@panasiangroup.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------010106060703020802040709" X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------010106060703020802040709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 > > > 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 > --------------010106060703020802040709 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
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


--------------010106060703020802040709--