[openstack-dev] [Congress] How to start a replica ?

2015-07-27 Thread Wong, Hong 
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

Re: [openstack-dev] [Congress] How to start a replica ?

2015-07-27 Thread Tim Hinrichs 
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

Re: [openstack-dev] [Congress] How to start a replica ?

2015-07-27 Thread Rui Chen 
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

Re: [openstack-dev] [Congress] How to start a replica ?

2015-07-27 Thread Rui Chen 
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