When connected to multiple powervc hypervisors there is an arithmetic overflow when accessing the hypervisors panel in horizon

Bug #1370895 reported by Zi Lian Ji
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
powervc-driver
Fix Committed
High
Zi Lian Ji

Bug Description

2014-08-20 05:54:59.527 15356 ERROR nova.api.openstack [req-fa4d794a-4cb2-43dc-bf8d-3c44c12b71fb 046411ecbd0e43428d2ce83c6c61a830 cfeb1b256a0d42a7a4808f0a9bb6e731] NV-A68A08C Caught error: (DataError) ibm_db_dbi::DataError: Fetch Failure: [IBM][CLI Driver][DB2/LINUXX8664] SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003 SQLCODE=-802 None None
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack Traceback (most recent call last):
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/api/openstack/__init__.py", line 125, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return req.get_response(self.application)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/request.py", line 1296, in send
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack application, catch_exc_info=False)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/request.py", line 1260, in call_application
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack app_iter = application(self.environ, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/dec.py", line 144, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return resp(environ, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/keystoneclient/middleware/auth_token.py", line 679, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return self.app(env, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/dec.py", line 144, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return resp(environ, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/dec.py", line 144, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return resp(environ, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/routes/middleware.py", line 131, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack response = self.app(environ, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/dec.py", line 144, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return resp(environ, start_response)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/dec.py", line 130, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack resp = self.call_func(req, *args, **self.kwargs)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/webob/dec.py", line 195, in call_func
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return self.func(req, *args, **kwargs)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/api/openstack/wsgi.py", line 920, in __call__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack content_type, body, accept)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/api/openstack/wsgi.py", line 986, in _process_stack
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack action_result = self.dispatch(meth, request, action_args)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/api/openstack/wsgi.py", line 1073, in dispatch
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return method(req=request, **action_args)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/api/openstack/compute/contrib/hypervisors.py", line 290, in statistics
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack stats = self.host_api.compute_node_statistics(context)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/compute/api.py", line 3284, in compute_node_statistics
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return self.db.compute_node_statistics(context)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/db/api.py", line 255, in compute_node_statistics
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return IMPL.compute_node_statistics(context)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py", line 686, in compute_node_statistics
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack read_deleted="no").first()
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 2156, in first
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack ret = list(self[0:1])
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 2023, in __getitem__
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return list(res)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/query.py", line 2341, in instances
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack fetch = cursor.fetchall()
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 3210, in fetchall
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack self.cursor, self.context)
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 3204, in fetchall
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack l = self.process_rows(self._fetchall_impl())
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 3171, in _fetchall_impl
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return self.cursor.fetchall()
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/ibm_db_dbi.py", line 1460, in fetchall
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack return self._fetch_helper()
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack File "/usr/lib64/python2.6/site-packages/ibm_db_dbi.py", line 1417, in _fetch_helper
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack raise self.messages[len(self.messages) - 1]
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack DataError: (DataError) ibm_db_dbi::DataError: Fetch Failure: [IBM][CLI Driver][DB2/LINUXX8664] SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003 SQLCODE=-802 None None
2014-08-20 05:54:59.527 15356 TRACE nova.api.openstack

Zi Lian Ji (jizilian)
Changed in powervc-driver:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Zi Lian Ji (jizilian)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to powervc-driver (master)

Fix proposed to branch: master
Review: https://review.openstack.org/127145

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to powervc-driver (master)

Reviewed: https://review.openstack.org/127145
Committed: https://git.openstack.org/cgit/stackforge/powervc-driver/commit/?id=e165253c6f1d1284b7f24df9a1f5a909fe281723
Submitter: Jenkins
Branch: master

commit e165253c6f1d1284b7f24df9a1f5a909fe281723
Author: <email address hidden> <email address hidden>
Date: Thu Oct 9 02:51:46 2014 -0400

    Fix overflow problem when connecting to multiple PowerVC hypervisors

    The value of the property 'free_disk_gb' in the hypervisor info is
    invalid in the Powervc. And the PowerVC will set it as a big value.
    It will lead the overflow of the database.

    Change-Id: I0eae9f393cd1c191230c71687450318539d58e02
    Closes-Bug: 1370895

Changed in powervc-driver:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.