yahoo-eng-team team mailing list archive

[Andrew Bogott <1498197@xxxxxxxxxxxxxxxxxx>]

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