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 <t...@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.w...@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-requ...@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-requ...@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-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev