yahoo-eng-team team mailing list archive

[James Page <james.page@xxxxxxxxxx>]

2013.2 (havana) is no longer supported by Canonical in the Cloud Archive
so marking 'Won't Fix'; leaving main distro task open.

** Changed in: neutron (Ubuntu)
   Importance: Undecided => Low

** Changed in: cloud-archive
   Importance: Undecided => Low

** Changed in: cloud-archive
       Status: New => Won't Fix

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1358147

Title:
  ProgrammingError: You have an error in your SQL syntax 'INSERT INTO
  meteringlabels'

Status in Ubuntu Cloud Archive:
  Won't Fix
Status in OpenStack Neutron (virtual network service):
  Incomplete
Status in “neutron” package in Ubuntu:
  New

Bug description:
  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', '')

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions