Error during Neutron and OVN database sync

Bug #1692419 reported by Ivan Denezhkin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
networking-ovn
New
Undecided
Unassigned
neutron
Invalid
Undecided
Unassigned

Bug Description

I have Openstack Ocata deployed from the github and Openvswich OVN for networking. Then neutron server starts and begin database synchroniztion with Openvswich OVN it send error message into neutron log

 Starting OVN-Northbound DB sync process _sync /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:73
2017-05-22 06:40:47.903 7545 DEBUG networking_ovn.ovn_db_sync [req-589f2abe-079d-43de-b81f-8bd16bb1a821 - - - - -] Address-Set-SYNC: started @ 2017-05-22 06:40:47.903722 sync_address_sets /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:172
2017-05-22 06:40:47.914 7545 DEBUG networking_ovn.ovn_db_sync [-] Starting OVN-Southbound DB sync process _sync /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:703
2017-05-22 06:40:47.915 7545 DEBUG networking_ovn.ovn_db_sync [req-52d9b774-1c60-447b-bdb5-2f32caf89adc - - - - -] OVN-SB Sync hostname and physical networks started sync_hostname_and_physical_networks /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:711
2017-05-22 06:40:47.996 7545 DEBUG networking_ovn.ovn_db_sync [req-52d9b774-1c60-447b-bdb5-2f32caf89adc - - - - -] New host compute2 found in OVN SB DB, but not in Neutron. Add its SegmentHostMapping in Neutron sync_hostname_and_physical_networks /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:725
2017-05-22 06:40:48.002 7545 DEBUG networking_ovn.ovn_db_sync [req-52d9b774-1c60-447b-bdb5-2f32caf89adc - - - - -] OVN-SB Sync hostname and physical networks finished sync_hostname_and_physical_networks /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:737
2017-05-22 06:40:48.003 7545 INFO networking_ovn.l3.l3_ovn [req-52d9b774-1c60-447b-bdb5-2f32caf89adc - - - - -] Getting OvsdbSbOvnIdl
2017-05-22 06:40:48.004 7545 INFO networking_ovn.l3.l3_ovn [req-52d9b774-1c60-447b-bdb5-2f32caf89adc - - - - -] Getting OvsdbNbOvnIdl
2017-05-22 06:40:48.040 7545 DEBUG networking_ovn.ovn_db_sync [req-589f2abe-079d-43de-b81f-8bd16bb1a821 - - - - -] Address_Sets added 0, removed 0, updated 0 sync_address_sets /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:204
2017-05-22 06:40:48.041 7545 DEBUG networking_ovn.ovn_db_sync [req-589f2abe-079d-43de-b81f-8bd16bb1a821 - - - - -] OVN-NB Sync networks, ports and DHCP options started sync_networks_ports_and_dhcp_opts /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:583
2017-05-22 06:40:48.303 7545 DEBUG networking_ovn.ovn_db_sync [req-589f2abe-079d-43de-b81f-8bd16bb1a821 - - - - -] OVN-NB Sync DHCP options for Neutron subnets started _sync_subnet_dhcp_options /usr/lib64/python2.7/site-packages/networking_ovn/ovn_db_sync.py:456
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters [req-589f2abe-079d-43de-b81f-8bd16bb1a821 - - - - -] DBAPIError exception wrapped from (psycopg2.ProgrammingError) operator does not exist: boolean = integer
LINE 3: WHERE subnets.enable_dhcp IN (1)
                                  ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
 [SQL: 'SELECT subnets.project_id AS subnets_project_id, subnets.id AS subnets_id, subnets.name AS subnets_name, subnets.network_id AS subnets_network_id, subnets.segment_id AS subnets_segment_id, subnets.subnetpool_id AS subnets_subnetpool_id, subnets.ip_version AS subnets_ip_version, subnets.cidr AS subnets_cidr, subnets.gateway_ip AS subnets_gateway_ip, subnets.enable_dhcp AS subnets_enable_dhcp, subnets.ipv6_ra_mode AS subnets_ipv6_ra_mode, subnets.ipv6_address_mode AS subnets_ipv6_address_mode, subnets.standard_attr_id AS subnets_standard_attr_id, standardattributes_1.id AS standardattributes_1_id, standardattributes_1.resource_type AS standardattributes_1_resource_type, standardattributes_1.description AS standardattributes_1_description, standardattributes_1.revision_number AS standardattributes_1_revision_number, standardattributes_1.created_at AS standardattributes_1_created_at, standardattributes_1.updated_at AS standardattributes_1_updated_at, subnetpools_1.project_id AS subnetpools_1_project_id, subnetpools_1.id AS subnetpools_1_id, subnetpools_1.name AS subnetpools_1_name, subnetpools_1.ip_version AS subnetpools_1_ip_version, subnetpools_1.default_prefixlen AS subnetpools_1_default_prefixlen, subnetpools_1.min_prefixlen AS subnetpools_1_min_prefixlen, subnetpools_1.max_prefixlen AS subnetpools_1_max_prefixlen, subnetpools_1.shared AS subnetpools_1_shared, subnetpools_1.is_default AS subnetpools_1_is_default, subnetpools_1.default_quota AS subnetpools_1_default_quota, subnetpools_1.hash AS subnetpools_1_hash, subnetpools_1.address_scope_id AS subnetpools_1_address_scope_id, subnetpools_1.standard_attr_id AS subnetpools_1_standard_attr_id, standardattributes_2.id AS standardattributes_2_id, standardattributes_2.resource_type AS standardattributes_2_resource_type, standardattributes_2.description AS standardattributes_2_description, standardattributes_2.revision_number AS standardattributes_2_revision_number, standardattributes_2.created_at AS standardattributes_2_created_at, standardattributes_2.updated_at AS standardattributes_2_updated_at \nFROM subnets LEFT OUTER JOIN subnetpools AS subnetpools_1 ON subnets.subnetpool_id = subnetpools_1.id LEFT OUTER JOIN standardattributes AS standardattributes_1 ON standardattributes_1.id = subnetpools_1.standard_attr_id LEFT OUTER JOIN standardattributes AS standardattributes_2 ON standardattributes_2.id = subnets.standard_attr_id \nWHERE subnets.enable_dhcp IN (%(enable_dhcp_1)s)'] [parameters: {'enable_dhcp_1': 1}]
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters context)
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters ProgrammingError: operator does not exist: boolean = integer
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters LINE 3: WHERE subnets.enable_dhcp IN (1)
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters ^
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters
2017-05-22 06:40:48.342 7545 ERROR oslo_db.sqlalchemy.exc_filters

Revision history for this message
Hirofumi Ichihara (ichihara-hirofumi) wrote :

It looks like networking-ovn side.

Changed in neutron:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.