Bug 1148526

Summary: nova: fail to edit project quota with DataError from nova
Product: [Community] RDO Reporter: Dafna Ron <dron>
Component: openstack-novaAssignee: Eoghan Glynn <eglynn>
Status: CLOSED EOL QA Contact: Shai Revivo <srevivo>
Severity: high Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: berrange, dasmith, eglynn, rbryant, sbauza, sferdjao, sgordon, srevivo, vromanso
Target Milestone: ---Keywords: Regression
Target Release: Juno   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-05-19 15:47:52 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
logs none

Description Dafna Ron 2014-10-01 16:03:27 UTC
Description of problem:

after installing allinone juno I logged into horizon and tried to modify admin project quota. 
I am failing and looking at the log this seems to be an error coming fro nova. 

Version-Release number of selected component (if applicable):

root@greta ~]# rpm -qa |grep horizon
python-django-horizon-2014.2-0.4.b3.el7.centos.noarch
[root@greta ~]# rpm -qa |grep nova
openstack-nova-novncproxy-2014.2-0.4.b3.el7.centos.noarch
python-novaclient-2.18.1-1.el7.centos.noarch
python-nova-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-conductor-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-scheduler-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-api-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-console-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-cert-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-common-2014.2-0.4.b3.el7.centos.noarch
openstack-nova-compute-2014.2-0.4.b3.el7.centos.noarch
[root@greta ~]# 

How reproducible:

100%

Steps to Reproduce:
1. install allinone
2. log into horizon and try to modify admin project's quota
3. 

Actual results:

we fail to modify quota

Expected results:

we should be able to modify quota 

Additional info:

2014-10-01 18:56:01.673 29330 TRACE nova.openstack.common.db.sqlalchemy.session 
2014-10-01 18:56:01.676 29330 ERROR nova.api.openstack [req-788ef675-d8a1-40bb-8353-1c79bec7470a None] Caught error: (DataError) (1264, "Out of range value for column 'hard_limit' at row 1") 'INSERT INTO quotas (created_at, updated_at, 
deleted_at, deleted, project_id, resource, hard_limit) VALUES (%s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2014, 10, 1, 15, 56, 1, 672909), None, None, 0, 'a2a577cbc9a142b69ecaaed20b99a165', 'metadata_items', 12800000000000000)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack Traceback (most recent call last):
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/api/openstack/__init__.py", line 124, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return req.get_response(self.application)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/request.py", line 1296, in send
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     application, catch_exc_info=False)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/request.py", line 1260, in call_application
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     app_iter = application(self.environ, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return resp(environ, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/keystonemiddleware/auth_token.py", line 661, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return self._app(env, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return resp(environ, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return resp(environ, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/routes/middleware.py", line 131, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     response = self.app(environ, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return resp(environ, start_response)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     resp = self.call_func(req, *args, **self.kwargs)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return self.func(req, *args, **kwargs)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/api/openstack/wsgi.py", line 908, in __call__
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     content_type, body, accept)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/api/openstack/wsgi.py", line 974, in _process_stack
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     action_result = self.dispatch(meth, request, action_args)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/api/openstack/wsgi.py", line 1058, in dispatch
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     return method(req=request, **action_args)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/api/openstack/compute/contrib/quotas.py", line 200, in update
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     key, value, user_id=user_id)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/objects/base.py", line 155, in wrapper
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     result = fn(cls, context, *args, **kwargs)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/objects/quotas.py", line 119, in create_limit
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack     db.quota_create(context, project_id, resource, limit, user_id=user_id)
2014-10-01 18:56:01.676 29330 TRACE nova.api.openstack   File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 1073, in quota_create

Comment 1 Dafna Ron 2014-10-01 16:11:22 UTC
Created attachment 943138 [details]
logs

Comment 4 Chandan Kumar 2016-05-19 15:47:52 UTC
This bug is against a Version which has reached End of Life.
If it's still present in supported release (http://releases.openstack.org), please update Version and reopen.