initrunonce fails with opendaylight

Bug #1835735 reported by Carlos Letamendía
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla-ansible
Won't Fix
Undecided
Eduardo Gonzalez

Bug Description

kolla-ansible: rocky
openstack: rocky

Error msg:
Configuring neutron.
Error while executing command: ConflictException: 409, Error cannot perform precommit_create due to Callback networking_odl.common.callback.OdlSecurityGroupsHandler.sg_callback_precommit--9223372036854636689 failed with "(pymysql.err.ProgrammingError) (1146, u"Table 'neutron.opendaylightjournal' doesn't exist") [SQL: u'INSERT INTO opendaylightjournal (object_type, object_uuid, operation, data, state, retry_count, version_id) VALUES (%(object_type)s, %(object_uuid)s, %(operation)s, %(data)s, %(state)s, %(retry_count)s, %(version_id)s)'] [parameters: {'object_uuid': 'a30dba8d-bbe2-4b6b-87b1-322a3b331216', 'object_type': 'security_group', 'version_id': 1, 'retry_count': 0, 'state': 'pending', 'operation': 'create', 'data': bytearray(b'\x80\x02}q\x01(U\x0bdescriptionq\x02X\x16\x00\x00\x00Default security groupq\x03U\x04tagsq\x04]U\ttenant_idq\x05X \x00\x00\x00fedb122b4243 ... (1318 characters truncated) ... 08T11:33:55Zh\x16h\x14h\x05h\x06h\x17Nh\x18X\x04\x00\x00\x00IPv4q&h\x1ah\x06ueh\x10K\x01h\x1ah\x06h\x11h\x14U\x04nameq\'X\x07\x00\x00\x00defaultq(u.')}] (Background on this error at: http://sqlalche.me/e/f405)" while attempting the operation.
No Network found for public1
Error while executing command: ConflictException: 409, Error cannot perform precommit_create due to Callback networking_odl.common.callback.OdlSecurityGroupsHandler.sg_callback_precommit--9223372036854636689 failed with "(pymysql.err.ProgrammingError) (1146, u"Table 'neutron.opendaylightjournal' doesn't exist") [SQL: u'INSERT INTO opendaylightjournal (object_type, object_uuid, operation, data, state, retry_count, version_id) VALUES (%(object_type)s, %(object_uuid)s, %(operation)s, %(data)s, %(state)s, %(retry_count)s, %(version_id)s)'] [parameters: {'object_uuid': '46492147-5ad6-413b-8db3-7bc2b24fb900', 'object_type': 'security_group', 'version_id': 1, 'retry_count': 0, 'state': 'pending', 'operation': 'create', 'data': bytearray(b'\x80\x02}q\x01(U\x0bdescriptionq\x02X\x16\x00\x00\x00Default security groupq\x03U\x04tagsq\x04]U\ttenant_idq\x05X \x00\x00\x00fedb122b4243 ... (1318 characters truncated) ... 08T11:34:01Zh\x15h\x16h\x05h\x06h\x17Nh\x18X\x04\x00\x00\x00IPv6q&h\x1ah\x06ueh\x10K\x01h\x1ah\x06h\x11h\x16U\x04nameq\'X\x07\x00\x00\x00defaultq(u.')}] (Background on this error at: http://sqlalche.me/e/f405)" while attempting the operation.
No Network found for demo-net
HttpException: 500: Server Error for url: http://192.168.200.100:9696/v2.0/routers, Request Failed: internal server error while processing your request.
No Subnet found for demo-subnet
No Network found for public1
ConflictException: 409: Client Error for url: http://192.168.200.100:9696/v2.0/security-groups?tenant_id=fedb122b42434cfebe620cd09dff0bcd, Error cannot perform precommit_create due to Callback networking_odl.common.callback.OdlSecurityGroupsHandler.sg_callback_precommit--9223372036854636689 failed with "(pymysql.err.ProgrammingError) (1146, u"Table 'neutron.opendaylightjournal' doesn't exist") [SQL: u'INSERT INTO opendaylightjournal (object_type, object_uuid, operation, data, state, retry_count, version_id) VALUES (%(object_type)s, %(object_uuid)s, %(operation)s, %(data)s, %(state)s, %(retry_count)s, %(version_id)s)'] [parameters: {'object_uuid': '9e3e2f3d-6d49-4a38-a4aa-dd49497468de', 'object_type': 'security_group', 'version_id': 1, 'retry_count': 0, 'state': 'pending', 'operation': 'create', 'data': bytearray(b'\x80\x02}q\x01(U\x0bdescriptionq\x02X\x16\x00\x00\x00Default security groupq\x03U\x04tagsq\x04]U\ttenant_idq\x05X \x00\x00\x00fedb122b4243 ... (1318 characters truncated) ... 08T11:34:26Zh\x15h\x16h\x05h\x06h\x17Nh\x18X\x04\x00\x00\x00IPv4q&h\x1ah\x06ueh\x10K\x01h\x1ah\x06h\x11h\x16U\x04nameq\'X\x07\x00\x00\x00defaultq(u.')}] (Background on this error at: http://sqlalche.me/e/f405)" while attempting the operation.

Revision history for this message
Eduardo Gonzalez (egonzalez90) wrote :

Can you please share karaf.log from opendaylight? Likely ODL havent started yet or have some errors?

Revision history for this message
Mark Goddard (mgoddard) wrote :

It looks to me like the neutron ODL plugin's database tables have not been created.

Revision history for this message
Eduardo Gonzalez (egonzalez90) wrote :

Yes, seems this patch broke the migration of other services https://review.opendev.org/#/c/663436/

Changed in kolla-ansible:
status: New → Triaged
assignee: nobody → Eduardo Gonzalez (egonzalez90)
Revision history for this message
Mark Goddard (mgoddard) wrote :

Do you know what the reasoning was behind not migrating all services?

Revision history for this message
Eduardo Gonzalez (egonzalez90) wrote :

Changed project to kolla where the patch is going

affects: kolla-ansible → kolla
Changed in kolla:
status: Triaged → In Progress
Mark Goddard (mgoddard)
affects: kolla → kolla-ansible
Revision history for this message
Radosław Piliszek (yoctozepto) wrote :

Which patch to kolla was relevant? @egonzalez

Revision history for this message
Mark Goddard (mgoddard) wrote :

Dropping OpenDaylight support in Ussuri.

Changed in kolla-ansible:
status: In Progress → Won't Fix
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.