poolstatisticss table should have columns of type bigint

[Stephen Gran]

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}

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/75976
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=706a8b1ff30c011169846ed5e38f06aa9f15faf2
Submitter: Jenkins
Branch: master

commit 706a8b1ff30c011169846ed5e38f06aa9f15faf2
Author: Stephen Gran <email address hidden>
Date: Mon Feb 24 20:18:49 2014 +0000

    stats table needs columns to be bigint

    Bandwidth measurements trivially overrun 32bit counters. Change storage
    type to BigInteger from Integer.

    Closes-Bug: #1284314
    Change-Id: I20db25f374de66b8443ff50bac979bff634d8a14
    Signed-off-by: Stephen Gran <email address hidden>