Public bug reported:
Security groups and rules worked fine in Juno, but ever since my upgrade
to Kilo I'm unable to delete rules.
andrew@labcontrol1001:~$ nova secgroup-delete-rule default tcp 666 666
10.0.0.0/8
+-------------+-----------+---------+------------+--------------+
| IP Protocol | From Port | To Port | IP Range | Source Group |
+-------------+-----------+---------+------------+--------------+
| tcp | 666 | 666 | 10.0.0.0/8 | |
+-------------+-----------+---------+------------+--------------+
ERROR (ClientException): The server has either erred or is incapable of
performing the requested operation. (HTTP 500)
Here's the interesting bit of the stack trace:
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in
_execute_context
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack context)
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in
do_execute
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack cursor.execute(statement,
parameters)
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack self.errorhandler(self,
exc, value)
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack raise errorclass,
errorvalue
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack DBError: (DataError)
(1264, "Out of range value for column 'deleted' at row 1") 'UPDATE
security_group_rules SET updated_at=updated_at, deleted_at=%s, deleted=id WHERE
security_group_rules.deleted = %s AND security_group_rules.id = %s'
(datetime.datetime(2015, 9, 16, 21, 34, 31, 99896), 0, 2769L)
I've no doubt that this feature works in a fresh install of Kilo, and
that my db schema is messed up due to a faulty upgrade script.
** Affects: nova
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1498197
Title:
No longer able to delete service group rules in kilo
Status in OpenStack Compute (nova):
New
Bug description:
Security groups and rules worked fine in Juno, but ever since my
upgrade to Kilo I'm unable to delete rules.
andrew@labcontrol1001:~$ nova secgroup-delete-rule default tcp 666 666
10.0.0.0/8
+-------------+-----------+---------+------------+--------------+
| IP Protocol | From Port | To Port | IP Range | Source Group |
+-------------+-----------+---------+------------+--------------+
| tcp | 666 | 666 | 10.0.0.0/8 | |
+-------------+-----------+---------+------------+--------------+
ERROR (ClientException): The server has either erred or is incapable of
performing the requested operation. (HTTP 500)
Here's the interesting bit of the stack trace:
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in
_execute_context
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack context)
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in
do_execute
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack
cursor.execute(statement, parameters)
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack self.errorhandler(self,
exc, value)
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack raise errorclass,
errorvalue
2015-09-16 21:34:31.105 3179 TRACE nova.api.openstack DBError: (DataError)
(1264, "Out of range value for column 'deleted' at row 1") 'UPDATE
security_group_rules SET updated_at=updated_at, deleted_at=%s, deleted=id WHERE
security_group_rules.deleted = %s AND security_group_rules.id = %s'
(datetime.datetime(2015, 9, 16, 21, 34, 31, 99896), 0, 2769L)
I've no doubt that this feature works in a fresh install of Kilo, and
that my db schema is messed up due to a faulty upgrade script.
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1498197/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
