Public bug reported:
Installation works about few months, got this message in logstash.
Happens once, there is no surrounding activity (no requests to API).
Havanna, ubuntu-cloud-archive, 2013.2.3-0ubuntu1.1
Aug 17 21:48:59 api1 neutron.openstack.common.db.sqlalchemy.session[12400]:
ERROR DB exception wrapped.
Traceback (most recent call last):
File
"/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py",
line 524, in _wrap
return f(*args, **kwargs)
File
"/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py",
line 718, in flush
return super(Session, self).flush(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1818,
in flush
self._flush(objects)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1936,
in _flush
transaction.rollback(_capture_exception=True)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line
58, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1900,
in _flush
flush_context.execute()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
372, in execute
rec.execute(self)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
525, in execute
uow
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line
64, in save_obj
table, insert)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line
541, in _emit_insert_statements
execute(statement, multiparams)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662,
in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761,
in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874,
in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024,
in _handle_dbapi_exception
exc_info
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 195,
in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867,
in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
324, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (ProgrammingError) (1064, 'You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near \':
"\'eaa6e8e248ce4f3784282b0c3f51384a\'", u\'created_at\':
"\'2014-08-05T06:34:28+00:\' at line 1') 'INSERT INTO meteringlabels
(tenant_id, id, name, description) VALUES (%s, %s, %s, %s)'
({u'keystone_tenant_id': u'eaa6e8e248ce4f3784282b0c3f51384a',
u'created_at': u'2014-08-05T06:34:28+00:00', u'updated_at':
u'2014-08-05T06:34:28+00:00', u'admin_blocked': False, u'id': 817,
u'blocked': False}, '81070432-d514-4606-b564-e7f76138d985', 'billable',
'')
** Affects: cloud-archive
Importance: Undecided
Status: New
** Affects: neutron
Importance: Undecided
Status: New
** Affects: neutron (Ubuntu)
Importance: Undecided
Status: New
** Also affects: cloud-archive
Importance: Undecided
Status: New
** Also affects: neutron (Ubuntu)
Importance: Undecided
Status: New
** Description changed:
Installation works about few months, got this message in logstash.
Happens once, there is no surrounding activity (no requests to API).
+ Havanna, ubuntu-cloud-archive, 2013.2.3-0ubuntu1.1
+
Aug 17 21:48:59 api1 neutron.openstack.common.db.sqlalchemy.session[12400]:
ERROR DB exception wrapped.
Traceback (most recent call last):
- File
"/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py",
line 524, in _wrap
- return f(*args, **kwargs)
- File
"/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py",
line 718, in flush
- return super(Session, self).flush(*args, **kwargs)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
1818, in flush
- self._flush(objects)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
1936, in _flush
- transaction.rollback(_capture_exception=True)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py",
line 58, in __exit__
- compat.reraise(exc_type, exc_value, exc_tb)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
1900, in _flush
- flush_context.execute()
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
372, in execute
- rec.execute(self)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
525, in execute
- uow
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line
64, in save_obj
- table, insert)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line
541, in _emit_insert_statements
- execute(statement, multiparams)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
662, in execute
- params)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
761, in _execute_clauseelement
- compiled_sql, distilled_params
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
874, in _execute_context
- context)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1024, in _handle_dbapi_exception
+ File
"/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py",
line 524, in _wrap
+ return f(*args, **kwargs)
+ File
"/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py",
line 718, in flush
+ return super(Session, self).flush(*args, **kwargs)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
1818, in flush
+ self._flush(objects)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
1936, in _flush
+ transaction.rollback(_capture_exception=True)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py",
line 58, in __exit__
+ compat.reraise(exc_type, exc_value, exc_tb)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
1900, in _flush
+ flush_context.execute()
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
372, in execute
+ rec.execute(self)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line
525, in execute
+ uow
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line
64, in save_obj
+ table, insert)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line
541, in _emit_insert_statements
+ execute(statement, multiparams)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
662, in execute
+ params)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
761, in _execute_clauseelement
+ compiled_sql, distilled_params
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
874, in _execute_context
+ context)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1024, in _handle_dbapi_exception
exc_info
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line
195, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
867, in _execute_context
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line
195, in raise_from_cause
+ reraise(type(exception), exception, tb=exc_tb)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
867, in _execute_context
-
- context)
- File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
324, in do_execute
- cursor.execute(statement, parameters)
- File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
- self.errorhandler(self, exc, value)
- File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
- raise errorclass, errorvalue
+ context)
+ File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
324, in do_execute
+ cursor.execute(statement, parameters)
+ File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
+ self.errorhandler(self, exc, value)
+ File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
+ raise errorclass, errorvalue
ProgrammingError: (ProgrammingError) (1064, 'You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near \':
"\'eaa6e8e248ce4f3784282b0c3f51384a\'", u\'created_at\':
"\'2014-08-05T06:34:28+00:\' at line 1') 'INSERT INTO meteringlabels
(tenant_id, id, name, description) VALUES (%s, %s, %s, %s)'
({u'keystone_tenant_id': u'eaa6e8e248ce4f3784282b0c3f51384a',
u'created_at': u'2014-08-05T06:34:28+00:00', u'updated_at':
u'2014-08-05T06:34:28+00:00', u'admin_blocked': False, u'id': 817,
u'blocked': False}, '81070432-d514-4606-b564-e7f76138d985', 'billable',
'')
--
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to neutron in Ubuntu.
https://bugs.launchpad.net/bugs/1358147
Title:
ProgrammingError: You have an error in your SQL syntax 'INSERT INTO
meteringlabels'
To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
