← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #10183

[Bug 1284314] [NEW] poolstatisticss table should have columns of type bigint

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

2014-02-24 17:44:45.585 5282 TRACE neutron.openstack.common.db.sqlalchemy.session 
2014-02-24 17:44:45.589 5282 ERROR neutron.openstack.common.rpc.amqp [-] Exception during message handling
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp Traceback (most recent call last):
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/rp
c/amqp.py", line 438, in _process_data
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     **args)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/common/rpc.py", lin
e 44, in dispatch
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     neutron_ctxt, version, method, namespace, **kwargs)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/rp
c/dispatcher.py", line 172, in dispatch
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     result = getattr(proxyobj, method)(ctxt, **kwargs)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/services/loadbalanc
er/drivers/stingray/plugin_driver.py", line 155, in update_pool_stats
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.plugin.update_pool_stats(context, pool_id, data=stats)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/db/loadbalancer/loa
dbalancer_db.py", line 500, in update_pool_stats
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.update_status(context, Member, member, stats_status)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
 line 447, in __exit__
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.rollback()
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers
.py", line 58, in __exit__
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     compat.reraise(exc_type, exc_value, exc_tb)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
 line 444, in __exit__
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.commit()
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
 line 354, in commit
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self._prepare_impl()
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
 line 334, in _prepare_impl
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.session.flush()
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/db
/sqlalchemy/session.py", line 545, in _wrap
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     raise exception.DBError(e)
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp DBError: (DataError) integer out of range
2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp  'UPDATE poolstatisticss SET bytes_in=%(bytes_in)s, bytes_out=%(byte
s_out)s, active_connections=%(active_connections)s, total_connections=%(total_connections)s WHERE poolstatisticss.pool_id = %(poolstatist
icss_pool_id)s' {'bytes_in': 290286902, 'poolstatisticss_pool_id': u'0df91b58-e04b-4a36-bed8-8fcb3f73ed6e', 'total_connections': 2362054,
 'active_connections': 1, 'bytes_out': 3152985859}

** Affects: neutron
     Importance: Undecided
     Assignee: Stephen Gran (sgran)
         Status: In Progress

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

Title:
  poolstatisticss table should have columns of type bigint

Status in OpenStack Neutron (virtual network service):
  In Progress

Bug description:
  2014-02-24 17:44:45.585 5282 TRACE neutron.openstack.common.db.sqlalchemy.session 
  2014-02-24 17:44:45.589 5282 ERROR neutron.openstack.common.rpc.amqp [-] Exception during message handling
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp Traceback (most recent call last):
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/rp
  c/amqp.py", line 438, in _process_data
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     **args)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/common/rpc.py", lin
  e 44, in dispatch
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     neutron_ctxt, version, method, namespace, **kwargs)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/rp
  c/dispatcher.py", line 172, in dispatch
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     result = getattr(proxyobj, method)(ctxt, **kwargs)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/services/loadbalanc
  er/drivers/stingray/plugin_driver.py", line 155, in update_pool_stats
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.plugin.update_pool_stats(context, pool_id, data=stats)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/db/loadbalancer/loa
  dbalancer_db.py", line 500, in update_pool_stats
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.update_status(context, Member, member, stats_status)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
   line 447, in __exit__
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.rollback()
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers
  .py", line 58, in __exit__
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     compat.reraise(exc_type, exc_value, exc_tb)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
   line 444, in __exit__
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.commit()
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
   line 354, in commit
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self._prepare_impl()
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
   line 334, in _prepare_impl
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     self.session.flush()
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/db
  /sqlalchemy/session.py", line 545, in _wrap
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp     raise exception.DBError(e)
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp DBError: (DataError) integer out of range
  2014-02-24 17:44:45.589 5282 TRACE neutron.openstack.common.rpc.amqp  'UPDATE poolstatisticss SET bytes_in=%(bytes_in)s, bytes_out=%(byte
  s_out)s, active_connections=%(active_connections)s, total_connections=%(total_connections)s WHERE poolstatisticss.pool_id = %(poolstatist
  icss_pool_id)s' {'bytes_in': 290286902, 'poolstatisticss_pool_id': u'0df91b58-e04b-4a36-bed8-8fcb3f73ed6e', 'total_connections': 2362054,
   'active_connections': 1, 'bytes_out': 3152985859}

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1284314/+subscriptions

Follow ups

References

  Thread Previous • Date Previous • • Thread Next