yahoo-eng-team team mailing list archive

[Kevin Benton <1619299@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Behavior observed in the gate is that microseconds on datetime object
for created_at/updated_at are being used to round up the second instead
of truncate it.

2016-08-31 09:16:20.652 14411 INFO sqlalchemy.engine.base.Engine [req-c9350354-e963-4a2e-b1cb-71444094111c tempest-SecGroupIPv6Test-1503726360 -] INSERT INTO standardattributes (created_at, updated_at, resource_type, description, revision_number) VALUES (%(created_at)s, %(updated_at)s, %(resource_type)s, %(description)s, %(revision_number)s)
2016-08-31 09:16:20.652 14411 INFO sqlalchemy.engine.base.Engine [req-c9350354-e963-4a2e-b1cb-71444094111c tempest-SecGroupIPv6Test-1503726360 -] {'revision_number': 1, 'created_at': datetime.datetime(2016, 8, 31, 9, 16, 20, 650708), 'description': '', 'resource_type': 'securitygrouprules', 'updated_at': datetime.datetime(2016, 8, 31, 9, 16, 20, 650708)}

2016-08-31 09:16:20.700 14411 DEBUG sqlalchemy.engine.base.Engine [req-9033b306-113f-45ad-a7db-3e2f79124b37 tempest-SecGroupIPv6Test-1503726360 -] Col (u'securitygrouprules_project_id', u'securitygrouprules_id', u'securitygrouprules_security_group_id', u'securitygrouprules_remote_group_id', u'securitygrouprules_direction', u'securitygrouprules_ethertype', u'securitygrouprules_protocol', u'securitygrouprules_port_range_min', u'securitygrouprules_port_range_max', u'securitygrouprules_remote_ip_prefix', u'securitygrouprules_standard_attr_id', u'standardattributes_1_created_at', u'standardattributes_1_updated_at', u'standardattributes_1_id', u'standardattributes_1_resource_type', u'standardattributes_1_description', u'standardattributes_1_revision_number', u'tags_1_standard_attr_id', u'tags_1_tag') _init_metadata /usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/result.py:529
2016-08-31 09:16:20.701 14411 DEBUG sqlalchemy.engine.base.Engine [req-9033b306-113f-45ad-a7db-3e2f79124b37 tempest-SecGroupIPv6Test-1503726360 -] Row (u'0252352f1fb84f59a2c0db9e2cb21515', u'd6f8b7b8-4bcb-4876-96e2-343fbb3202d6', u'02fb88e6-4fe6-4cda-b9bf-96a41fe91e5f', None, u'ingress', u'IPv6', u'udp', None, None, None, 2520, datetime.datetime(2016, 8, 31, 9, 16, 21), datetime.datetime(2016, 8, 31, 9, 16, 21), 2520, u'securitygrouprules', u'', 1, None, None) process_rows /usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/result.py:939
2016-08-31 09:16:20.704 14411 INFO neutron.wsgi [req-9033b306-113f-45ad-a7db-3e2f79124b37 tempest-SecGroupIPv6Test-1503726360 -] 127.0.0.1 - - [31/Aug/2016 09:16:20] "GET /v2.0/security-group-rules/d6f8b7b8-4bcb-4876-96e2-343fbb3202d6 HTTP/1.1" 200 646 0.014147

** Affects: neutron
     Importance: Undecided
     Assignee: Kevin Benton (kevinbenton)
         Status: In Progress

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1619299

Title:
  some backends round timestamp up instead of truncate

Status in neutron:
  In Progress

Bug description:
  Behavior observed in the gate is that microseconds on datetime object
  for created_at/updated_at are being used to round up the second
  instead of truncate it.

  2016-08-31 09:16:20.652 14411 INFO sqlalchemy.engine.base.Engine [req-c9350354-e963-4a2e-b1cb-71444094111c tempest-SecGroupIPv6Test-1503726360 -] INSERT INTO standardattributes (created_at, updated_at, resource_type, description, revision_number) VALUES (%(created_at)s, %(updated_at)s, %(resource_type)s, %(description)s, %(revision_number)s)
  2016-08-31 09:16:20.652 14411 INFO sqlalchemy.engine.base.Engine [req-c9350354-e963-4a2e-b1cb-71444094111c tempest-SecGroupIPv6Test-1503726360 -] {'revision_number': 1, 'created_at': datetime.datetime(2016, 8, 31, 9, 16, 20, 650708), 'description': '', 'resource_type': 'securitygrouprules', 'updated_at': datetime.datetime(2016, 8, 31, 9, 16, 20, 650708)}

  2016-08-31 09:16:20.700 14411 DEBUG sqlalchemy.engine.base.Engine [req-9033b306-113f-45ad-a7db-3e2f79124b37 tempest-SecGroupIPv6Test-1503726360 -] Col (u'securitygrouprules_project_id', u'securitygrouprules_id', u'securitygrouprules_security_group_id', u'securitygrouprules_remote_group_id', u'securitygrouprules_direction', u'securitygrouprules_ethertype', u'securitygrouprules_protocol', u'securitygrouprules_port_range_min', u'securitygrouprules_port_range_max', u'securitygrouprules_remote_ip_prefix', u'securitygrouprules_standard_attr_id', u'standardattributes_1_created_at', u'standardattributes_1_updated_at', u'standardattributes_1_id', u'standardattributes_1_resource_type', u'standardattributes_1_description', u'standardattributes_1_revision_number', u'tags_1_standard_attr_id', u'tags_1_tag') _init_metadata /usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/result.py:529
  2016-08-31 09:16:20.701 14411 DEBUG sqlalchemy.engine.base.Engine [req-9033b306-113f-45ad-a7db-3e2f79124b37 tempest-SecGroupIPv6Test-1503726360 -] Row (u'0252352f1fb84f59a2c0db9e2cb21515', u'd6f8b7b8-4bcb-4876-96e2-343fbb3202d6', u'02fb88e6-4fe6-4cda-b9bf-96a41fe91e5f', None, u'ingress', u'IPv6', u'udp', None, None, None, 2520, datetime.datetime(2016, 8, 31, 9, 16, 21), datetime.datetime(2016, 8, 31, 9, 16, 21), 2520, u'securitygrouprules', u'', 1, None, None) process_rows /usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/result.py:939
  2016-08-31 09:16:20.704 14411 INFO neutron.wsgi [req-9033b306-113f-45ad-a7db-3e2f79124b37 tempest-SecGroupIPv6Test-1503726360 -] 127.0.0.1 - - [31/Aug/2016 09:16:20] "GET /v2.0/security-group-rules/d6f8b7b8-4bcb-4876-96e2-343fbb3202d6 HTTP/1.1" 200 646 0.014147

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1619299/+subscriptions