Open Stack

According to the error message, looks like no enough mysql db connections
for the HA Congress server launching.

Can you double check your mysql '*max_connections*' option in my.cnf and
show the active connections in mysql console like this:

*msyql> show full processlist;*

more details:

https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html


2015-07-28 6:46 GMT+08:00 Tim Hinrichs <tim at styra.com>:

> Could you show us the contents of /tmp/congress.conf?
>
> Tim
>
>
> On Mon, Jul 27, 2015 at 3:09 PM Wong, Hong <hong.wong at hp.com> wrote:
>
>>  Hi Tim and Alex,
>>
>>
>>
>> I see congress recently added the HA functionality, and I was looking at
>> the tempest test code to understand how to start a replica.  I created a
>> new congress.conf file with the different "bind_port" and set the
>> "datasource_sync_period" value to 5.  However, I got the errors below when
>> I try to bring up the replica:
>>
>>
>>
>> to start the replica: cd /opt/stack/congress && python
>> /usr/local/bin/congress-server --config-file /tmp/congress.conf & echo $!
>> >/tmp/congress.pid; fg || echo "congress failed to start" | tee
>> "/tmp/congress.failure"
>>
>>
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service Traceback (most recent
>> call last):
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/opt/stack/congress/congress/service.py", line 32, in wrapper
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     return f(*args, **kw)
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/opt/stack/congress/congress/service.py", line 50, in congress_app_factory
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     cage =
>> harness.create(root_path, data_path)
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/opt/stack/congress/congress/harness.py", line 151, in create
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     for policy in
>> db_policy_rules.get_policies():
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/opt/stack/congress/congress/db/db_policy_rules.py", line 84, in
>> get_policies
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     session = session or
>> db.get_session()
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/opt/stack/congress/congress/db/api.py", line 40, in get_session
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     facade =
>> _create_facade_lazily()
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/opt/stack/congress/congress/db/api.py", line 27, in _create_facade_lazily
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     _FACADE =
>> session.EngineFacade.from_config(cfg.CONF, sqlite_fk=True)
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
>> lin
>>
>> .....
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service   File
>> "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in
>> _check_mysql_exception
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service     raise
>> errorclass(errno, errorvalue)
>>
>> 2015-07-27 14:56:33.592 TRACE congress.service OperationalError:
>> (pymysql.err.OperationalError) (1040, u'Too many connections')
>>
>>
>>
>> I got the same error when running the tempest test as well.  Any idea ?
>>
>>
>>
>> Thanks,
>>
>> Hong
>>
>> __________________________________________________________________________
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe:
>> OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>>
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150728/c921db18/attachment-0001.html>