<div dir="ltr">According to the error message, looks like no enough mysql db connections for the HA Congress server launching.<div><br></div><div>Can you double check your mysql '<b>max_connections</b>' option in my.cnf and show the active connections in mysql console like this:</div><div><br></div><div><b>msyql> show full processlist;</b><br></div><div><br></div><div>more details:</div><div><br></div><div><a href="https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html">https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html</a><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-07-28 6:46 GMT+08:00 Tim Hinrichs <span dir="ltr"><<a href="mailto:tim@styra.com" target="_blank">tim@styra.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Could you show us the contents of <span style="font-size:13.1999998092651px;line-height:19.7999992370605px">/tmp/congress.conf?</span><div><span style="font-size:13.1999998092651px;line-height:19.7999992370605px"><br></span></div><div><span style="font-size:13.1999998092651px;line-height:19.7999992370605px">Tim</span></div><div><span style="font-size:13.1999998092651px;line-height:19.7999992370605px"><br></span></div></div><br><div class="gmail_quote"><div><div class="h5"><div dir="ltr">On Mon, Jul 27, 2015 at 3:09 PM Wong, Hong <<a href="mailto:hong.wong@hp.com" target="_blank">hong.wong@hp.com</a>> wrote:<br></div></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hi Tim and Alex,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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"<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service Traceback (most recent call last):<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service File "/opt/stack/congress/congress/service.py", line 32, in wrapper<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service return f(*args, **kw)<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service File "/opt/stack/congress/congress/service.py", line 50, in congress_app_factory<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service cage = harness.create(root_path, data_path)<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service File "/opt/stack/congress/congress/harness.py", line 151, in create<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service for policy in db_policy_rules.get_policies():<u></u><u></u></p>
<p class="MsoNormal">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<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service session = session or db.get_session()<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service File "/opt/stack/congress/congress/db/api.py", line 40, in get_session<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service facade = _create_facade_lazily()<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service File "/opt/stack/congress/congress/db/api.py", line 27, in _create_facade_lazily<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service _FACADE = session.EngineFacade.from_config(cfg.CONF, sqlite_fk=True)<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", lin<u></u><u></u></p>
<p class="MsoNormal">.....<u></u><u></u></p>
<p class="MsoNormal">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<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service raise errorclass(errno, errorvalue)<u></u><u></u></p>
<p class="MsoNormal">2015-07-27 14:56:33.592 TRACE congress.service OperationalError: (pymysql.err.OperationalError) (1040, u'Too many connections')<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I got the same error when running the tempest test as well. Any idea ?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal">Hong<u></u><u></u></p>
</div>
</div></div></div>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div>
<br>__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div><br></div>