| 2017-02-07 07:25:10 |
wangxiyuan |
description |
Now, when use sqlalchemy backend, the tables in db are created by the first API call.
So before the tables are created, if there are some API calls at the same time, the sql will raise an error, say that the table has already existed.
LOG: |
Now, when use sqlalchemy backend, the tables in db are created by the first API call.
So before the tables are created, if there are some API calls at the same time, the sql will raise an error, say that the table has already existed.
LOG:
2017-02-07 02:30:51.975 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queue item PUT: {"project_id": "ce9142070e6c4e24bb72d71538fcd808", "queue_name": "Queues-Test-730891586"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.979 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queue item PUT: {"project_id": "1ab4c6a3b43e486188799bc7bf561aee", "queue_name": "tempest-test-416030871"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.998 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queues item PUT: {"project_id": "70ca574bfc8546f596a9ed907a075af0", "queue_name": "tempest-Queues-Test-2003718952"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.999 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Messages collection POST: {"project_id": "63c782f774d647b1899dcedc595e66e0", "queue_name": "Queues-Test-73604307"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.999 685 DEBUG oslo_policy._cache_handler [(None,) - - - - -] Reloading cached file /etc/zaqar/policy.json read_cached_file /usr/local/lib/python2.7/dist-packages/oslo_policy/_cache_handler.py:40
2017-02-07 02:30:52.004 685 DEBUG oslo_policy._cache_handler [(None,) - - - - -] Reloading cached file /etc/zaqar/policy.json read_cached_file /usr/local/lib/python2.7/dist-packages/oslo_policy/_cache_handler.py:40
2017-02-07 02:30:52.008 685 DEBUG oslo_policy.policy [(None,) - - - - -] Reloaded policy file: /etc/zaqar/policy.json _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:666
2017-02-07 02:30:52.008 685 DEBUG oslo_policy.policy [(None,) - - - - -] Reloaded policy file: /etc/zaqar/policy.json _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:666
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues Traceback (most recent call last):
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v2_0/queues.py", line 93, in on_put
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues project=project_id)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tmp = target(*args, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/base.py", line 370, in create
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self._create(name, metadata, project)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 214, in _create
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues self._pool_catalog.register(name, project=project, flavor=flavor)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 521, in register
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues if not self._catalogue_ctrl.exists(project, queue):
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 62, in exists
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self.get(project, queue) is not None
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tables=tables)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues **kwargs).traverse_single(element)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues _is_metadata_operation=True)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(self, multiparams, params)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues compiled
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues context)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues exc_info
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues context)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues cursor.execute(statement, parameters)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues result = self._query(query)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues conn.query(q)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues result.read()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues first_packet = self.connection._read_packet()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues packet.check_error()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues raise errorclass(errno, errval)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues
[pid: 685|app: 0|req: 4/1] 10.24.190.216 () {34 vars in 690 bytes} [Tue Feb 7 02:30:51 2017] PUT /v2/queues/tempest-Queues-Test-2003718952 => generated 135 bytes in 268 msecs (HTTP/1.1 503) 5 headers in 154 bytes (1 switches on core 2)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver Traceback (most recent call last):
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/falcon/api.py", line 209, in __call__
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver responder(req, resp, **params)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 50, in wrapper
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return func(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/transport/acl.py", line 41, in handler
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return func(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v2_0/messages.py", line 167, in on_post
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver project_id)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver tmp = target(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 254, in get_metadata
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver control = self._get_controller(name, project)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 577, in get_queue_controller
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver target = self.lookup(queue, project)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 678, in lookup
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver pool_id = self._pool_id(queue, project)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 138, in wrapper
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver value = getter(self, *args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 493, in _pool_id
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return self._catalogue_ctrl.get(project, queue)['pool']
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver tables=tables)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver **kwargs).traverse_single(element)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return meth(obj, **kw)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver _is_metadata_operation=True)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return meth(obj, **kw)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return meth(self, multiparams, params)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver compiled
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver context)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver exc_info
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver context)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver cursor.execute(statement, parameters)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver result = self._query(query)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver conn.query(q)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver result.read()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver first_packet = self.connection._read_packet()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver packet.check_error()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver raise errorclass(errno, errval)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver
[pid: 685|app: 0|req: 5/2] 10.24.190.216 () {38 vars in 751 bytes} [Tue Feb 7 02:30:51 2017] POST /v2/queues/Queues-Test-73604307/messages => generated 442 bytes in 276 msecs (HTTP/1.1 500) 4 headers in 139 bytes (1 switches on core 1)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues Traceback (most recent call last):
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v1_0/queues.py", line 42, in on_put
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues queue_name, project=project_id)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues tmp = target(*args, **kwargs)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/base.py", line 370, in create
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return self._create(name, metadata, project)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 214, in _create
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues self._pool_catalog.register(name, project=project, flavor=flavor)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 521, in register
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues if not self._catalogue_ctrl.exists(project, queue):
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 62, in exists
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return self.get(project, queue) is not None
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues tables=tables)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues **kwargs).traverse_single(element)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues _is_metadata_operation=True)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return meth(self, multiparams, params)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues compiled
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues context)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues exc_info
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues context)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues cursor.execute(statement, parameters)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues result = self._query(query)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues conn.query(q)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues result.read()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues first_packet = self.connection._read_packet()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues packet.check_error()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues raise errorclass(errno, errval)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues
[pid: 685|app: 0|req: 6/3] 10.24.190.216 () {36 vars in 686 bytes} [Tue Feb 7 02:30:51 2017] PUT /v1/queues/tempest-test-416030871 => generated 135 bytes in 271 msecs (HTTP/1.1 503) 5 headers in 154 bytes (1 switches on core 3) |
|
| 2017-02-07 07:26:53 |
wangxiyuan |
description |
Now, when use sqlalchemy backend, the tables in db are created by the first API call.
So before the tables are created, if there are some API calls at the same time, the sql will raise an error, say that the table has already existed.
LOG:
2017-02-07 02:30:51.975 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queue item PUT: {"project_id": "ce9142070e6c4e24bb72d71538fcd808", "queue_name": "Queues-Test-730891586"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.979 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queue item PUT: {"project_id": "1ab4c6a3b43e486188799bc7bf561aee", "queue_name": "tempest-test-416030871"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.998 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queues item PUT: {"project_id": "70ca574bfc8546f596a9ed907a075af0", "queue_name": "tempest-Queues-Test-2003718952"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.999 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Messages collection POST: {"project_id": "63c782f774d647b1899dcedc595e66e0", "queue_name": "Queues-Test-73604307"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.999 685 DEBUG oslo_policy._cache_handler [(None,) - - - - -] Reloading cached file /etc/zaqar/policy.json read_cached_file /usr/local/lib/python2.7/dist-packages/oslo_policy/_cache_handler.py:40
2017-02-07 02:30:52.004 685 DEBUG oslo_policy._cache_handler [(None,) - - - - -] Reloading cached file /etc/zaqar/policy.json read_cached_file /usr/local/lib/python2.7/dist-packages/oslo_policy/_cache_handler.py:40
2017-02-07 02:30:52.008 685 DEBUG oslo_policy.policy [(None,) - - - - -] Reloaded policy file: /etc/zaqar/policy.json _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:666
2017-02-07 02:30:52.008 685 DEBUG oslo_policy.policy [(None,) - - - - -] Reloaded policy file: /etc/zaqar/policy.json _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:666
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues Traceback (most recent call last):
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v2_0/queues.py", line 93, in on_put
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues project=project_id)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tmp = target(*args, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/base.py", line 370, in create
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self._create(name, metadata, project)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 214, in _create
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues self._pool_catalog.register(name, project=project, flavor=flavor)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 521, in register
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues if not self._catalogue_ctrl.exists(project, queue):
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 62, in exists
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self.get(project, queue) is not None
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tables=tables)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues **kwargs).traverse_single(element)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues _is_metadata_operation=True)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(self, multiparams, params)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues compiled
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues context)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues exc_info
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues context)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues cursor.execute(statement, parameters)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues result = self._query(query)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues conn.query(q)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues result.read()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues first_packet = self.connection._read_packet()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues packet.check_error()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues raise errorclass(errno, errval)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues
[pid: 685|app: 0|req: 4/1] 10.24.190.216 () {34 vars in 690 bytes} [Tue Feb 7 02:30:51 2017] PUT /v2/queues/tempest-Queues-Test-2003718952 => generated 135 bytes in 268 msecs (HTTP/1.1 503) 5 headers in 154 bytes (1 switches on core 2)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver Traceback (most recent call last):
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/falcon/api.py", line 209, in __call__
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver responder(req, resp, **params)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 50, in wrapper
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return func(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/transport/acl.py", line 41, in handler
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return func(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v2_0/messages.py", line 167, in on_post
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver project_id)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver tmp = target(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 254, in get_metadata
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver control = self._get_controller(name, project)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 577, in get_queue_controller
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver target = self.lookup(queue, project)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 678, in lookup
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver pool_id = self._pool_id(queue, project)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 138, in wrapper
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver value = getter(self, *args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 493, in _pool_id
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return self._catalogue_ctrl.get(project, queue)['pool']
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver tables=tables)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver **kwargs).traverse_single(element)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return meth(obj, **kw)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver _is_metadata_operation=True)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return meth(obj, **kw)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return meth(self, multiparams, params)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver compiled
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver context)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver exc_info
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver context)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver cursor.execute(statement, parameters)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver result = self._query(query)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver conn.query(q)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver result.read()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver first_packet = self.connection._read_packet()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver packet.check_error()
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver raise errorclass(errno, errval)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver
[pid: 685|app: 0|req: 5/2] 10.24.190.216 () {38 vars in 751 bytes} [Tue Feb 7 02:30:51 2017] POST /v2/queues/Queues-Test-73604307/messages => generated 442 bytes in 276 msecs (HTTP/1.1 500) 4 headers in 139 bytes (1 switches on core 1)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues Traceback (most recent call last):
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v1_0/queues.py", line 42, in on_put
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues queue_name, project=project_id)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues tmp = target(*args, **kwargs)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/base.py", line 370, in create
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return self._create(name, metadata, project)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 214, in _create
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues self._pool_catalog.register(name, project=project, flavor=flavor)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 521, in register
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues if not self._catalogue_ctrl.exists(project, queue):
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 62, in exists
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return self.get(project, queue) is not None
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues tables=tables)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues **kwargs).traverse_single(element)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues _is_metadata_operation=True)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return meth(self, multiparams, params)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues compiled
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues context)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues exc_info
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues context)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues cursor.execute(statement, parameters)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues result = self._query(query)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues conn.query(q)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues result.read()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues first_packet = self.connection._read_packet()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues packet.check_error()
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues raise errorclass(errno, errval)
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.117 685 ERROR zaqar.transport.wsgi.v1_0.queues
[pid: 685|app: 0|req: 6/3] 10.24.190.216 () {36 vars in 686 bytes} [Tue Feb 7 02:30:51 2017] PUT /v1/queues/tempest-test-416030871 => generated 135 bytes in 271 msecs (HTTP/1.1 503) 5 headers in 154 bytes (1 switches on core 3) |
Now, when use sqlalchemy backend, the tables in db are created by the first API call.
So before the tables are created, if there are some API calls at the same time, the sql will raise an error, say that the table has already existed.
LOG:
2017-02-07 02:30:51.975 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queue item PUT: {"project_id": "ce9142070e6c4e24bb72d71538fcd808", "queue_name": "Queues-Test-730891586"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.979 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queue item PUT: {"project_id": "1ab4c6a3b43e486188799bc7bf561aee", "queue_name": "tempest-test-416030871"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.998 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Queues item PUT: {"project_id": "70ca574bfc8546f596a9ed907a075af0", "queue_name": "tempest-Queues-Test-2003718952"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.999 685 DEBUG zaqar.common.decorators [(None,) - - - - -] Messages collection POST: {"project_id": "63c782f774d647b1899dcedc595e66e0", "queue_name": "Queues-Test-73604307"} wrapper /opt/stack/new/zaqar/zaqar/common/decorators.py:49
2017-02-07 02:30:51.999 685 DEBUG oslo_policy._cache_handler [(None,) - - - - -] Reloading cached file /etc/zaqar/policy.json read_cached_file /usr/local/lib/python2.7/dist-packages/oslo_policy/_cache_handler.py:40
2017-02-07 02:30:52.004 685 DEBUG oslo_policy._cache_handler [(None,) - - - - -] Reloading cached file /etc/zaqar/policy.json read_cached_file /usr/local/lib/python2.7/dist-packages/oslo_policy/_cache_handler.py:40
2017-02-07 02:30:52.008 685 DEBUG oslo_policy.policy [(None,) - - - - -] Reloaded policy file: /etc/zaqar/policy.json _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:666
2017-02-07 02:30:52.008 685 DEBUG oslo_policy.policy [(None,) - - - - -] Reloaded policy file: /etc/zaqar/policy.json _load_policy_file /usr/local/lib/python2.7/dist-packages/oslo_policy/policy.py:666
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues Traceback (most recent call last):
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/transport/wsgi/v2_0/queues.py", line 93, in on_put
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues project=project_id)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/pipeline.py", line 97, in consumer
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tmp = target(*args, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/base.py", line 370, in create
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self._create(name, metadata, project)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 214, in _create
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues self._pool_catalog.register(name, project=project, flavor=flavor)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/pooling.py", line 521, in register
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues if not self._catalogue_ctrl.exists(project, queue):
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 62, in exists
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self.get(project, queue) is not None
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/catalogue.py", line 53, in get
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues entry = self.driver.run(stmt).fetchone()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 84, in run
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return self.connection.execute(*args, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 79, in connection
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues session = scoped_session(sessionmaker(bind=self.engine,
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/common/decorators.py", line 175, in getter
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues setattr(self, attr_name, fn(self))
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/opt/stack/new/zaqar/zaqar/storage/sqlalchemy/driver.py", line 64, in engine
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tables.metadata.create_all(engine, checkfirst=True)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues tables=tables)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues conn._run_visitor(visitorcallable, element, **kwargs)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues **kwargs).traverse_single(element)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues _is_metadata_operation=True)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(obj, **kw)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues include_foreign_key_constraints=include_foreign_key_constraints
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return meth(self, multiparams, params)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues return connection._execute_ddl(self, multiparams, params)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues compiled
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues context)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues exc_info
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues reraise(type(exception), exception, tb=exc_tb, cause=cause)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues context)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues cursor.execute(statement, parameters)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues result = self._query(query)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues conn.query(q)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues result.read()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues first_packet = self.connection._read_packet()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues packet.check_error()
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues err.raise_mysql_exception(self._data)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues raise errorclass(errno, errval)
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues InternalError: (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n']
2017-02-07 02:30:52.100 685 ERROR zaqar.transport.wsgi.v2_0.queues
[pid: 685|app: 0|req: 4/1] 10.24.190.216 () {34 vars in 690 bytes} [Tue Feb 7 02:30:51 2017] PUT /v2/queues/tempest-Queues-Test-2003718952 => generated 135 bytes in 268 msecs (HTTP/1.1 503) 5 headers in 154 bytes (1 switches on core 2)
2017-02-07 02:30:52.116 685 ERROR zaqar.transport.wsgi.driver [(None,) - - - - -] (pymysql.err.InternalError) (1050, u"Table 'Pools' already exists") [SQL: u'\nCREATE TABLE `Pools` (\n\tname VARCHAR(64) NOT NULL, \n\t`group` VARCHAR(64), \n\turi VARCHAR(255) NOT NULL, \n\tweight INTEGER NOT NULL, \n\toptions TEXT, \n\tPRIMARY KEY (name), \n\tFOREIGN KEY(`group`) REFERENCES `PoolGroup` (name) ON DELETE CASCADE, \n\tUNIQUE (uri)\n)\n\n'] |
|
