yahoo-eng-team team mailing list archive

[Roman Podoliaka <rpodolyaka+bugs@xxxxxxxxxxxx>]

This fails directly in PostgreSQL when the SQL statement is executed.
There is nothing oslo.db can do for you except raising a correct
exception (DataError).

** Changed in: oslo.db
       Status: New => Invalid

-- 
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/1386525

Title:
  (DataError) invalid input syntax for type inet: "my.invalid.ip"

Status in OpenStack Compute (Nova):
  Confirmed
Status in Oslo Database library:
  Invalid

Bug description:
  DataError: (DataError) invalid input syntax for type inet:
  "my.invalid.ip"

  
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 59, in _handle_dbapi_exception
      e, statement, parameters, cursor, context)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
      exc_info
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
      reraise(type(exception), exception, tb=exc_tb)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
      context)
    File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, in do_execute
      cursor.execute(statement, parameters)
  DataError: (DataError) invalid input syntax for type inet: "my.invalid.ip"
  LINE 3: ...ERE fixed_ips.deleted = 0 AND fixed_ips.address = 'my.invali... 
                                                               ^
   'SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_uuid AS fixed_ips_instance_uuid, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host \nFROM fixed_ips \nWHERE fixed_ips.deleted = %(deleted_1)s AND fixed_ips.address = %(address_1)s \n LIMIT %(param_1)s' {'param_1': 1, 'address_1': 'my.invalid.ip', 'deleted_1': 0}
  2014-10-27 17:44:32.094 25193 TRACE oslo.db.sqlalchemy.exc_filters 

  Seen in nova-api

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