yahoo-eng-team team mailing list archive

[Xu Han Peng <pengxuhan@xxxxxxxxx>]

Public bug reported:

When upgrading Neutron with DB2, the following error will be seen at
step 50d5ba354c23_ml2_binding_vif_details

sqlalchemy.exc.ProgrammingError: (ProgrammingError)
ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI
Driver][DB2/LINUXPPC64] SQL0401N  The data types of the operands for the
operation "=" are not compatible or comparable.  SQLSTATE=42818
SQLCODE=-401 'UPDATE ml2_port_bindings SET vif_details =
\'{"port_filter": true}\' WHERE cap_port_filter = true' ()


The reason is DB2 doesn't support Boolean type but uses small int

** Affects: neutron
     Importance: Undecided
     Assignee: Xu Han Peng (xuhanp)
         Status: New

** Changed in: neutron
     Assignee: (unassigned) => Xu Han Peng (xuhanp)

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

Title:
  DB2 upgrade failure for 50d5ba354c23_ml2_binding_vif_details

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  When upgrading Neutron with DB2, the following error will be seen at
  step 50d5ba354c23_ml2_binding_vif_details

  sqlalchemy.exc.ProgrammingError: (ProgrammingError)
  ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI
  Driver][DB2/LINUXPPC64] SQL0401N  The data types of the operands for
  the operation "=" are not compatible or comparable.  SQLSTATE=42818
  SQLCODE=-401 'UPDATE ml2_port_bindings SET vif_details =
  \'{"port_filter": true}\' WHERE cap_port_filter = true' ()

  
  The reason is DB2 doesn't support Boolean type but uses small int

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