From user-return-27808-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed Jul 25 08:31:29 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 8FD1FDF9C for ; Wed, 25 Jul 2012 08:31:29 +0000 (UTC) Received: (qmail 83857 invoked by uid 500); 25 Jul 2012 08:31:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 83780 invoked by uid 500); 25 Jul 2012 08:31:25 -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 83721 invoked by uid 99); 25 Jul 2012 08:31:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jul 2012 08:31:23 +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 (nike.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; Wed, 25 Jul 2012 08:31:14 +0000 Received: (qmail 23801 invoked by uid 399); 25 Jul 2012 08:30:49 -0000 Received: from unknown (HELO ?172.16.100.162?) (pbs:adeel.akbar@panasiangroup.com@182.185.142.119) by mail508.opentransfer.com with ESMTPM; 25 Jul 2012 08:30:49 -0000 X-Originating-IP: 182.185.142.119 Message-ID: <500FAEB5.80208@panasiangroup.com> Date: Wed, 25 Jul 2012 13:30:45 +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: Connection issue in Cassandra Content-Type: multipart/alternative; boundary="------------000704070001050604030501" This is a multi-part message in MIME format. --------------000704070001050604030501 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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* --------------000704070001050604030501 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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

--------------000704070001050604030501--