Ask Your Question
0

OCATA: I Cannot Create BGP-SPEAKER

asked 2017-07-24 18:10:59 -0600

Rajab gravatar image

I am executing this command below

neutron bgp-speaker-create --ip-version 6 --local-as 200 bgpspeaker-v6

Openstack throw an error below Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-61a3cce9-58e8-4a0b-9a89-34d1b0b9f756']

Checking on neutron-server log, there was an error DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'project_id' in 'field list'") [SQL: u'INSERT INTO bgp_speakers (project_id, id, name, local_as, advertise_floating_ip_host_routes, advertise_tenant_networks, ip_version) VALUES (%(project_id)s, %(id)s, %(name)s, %(local_as)s, %(advertise_floating_ip_host_routes)s, %(advertise_tenant_networks)s, %(ip_version)s)']

Checking out this bgp-speaker Table, there is no "project_id" column

MariaDB [neutron]> describe bgp_speakers; +-----------------------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------------+--------------+------+-----+---------+-------+ | id | varchar(36) | NO | PRI | NULL | | | name | varchar(255) | NO | | NULL | | | local_as | int(11) | NO | | NULL | | | ip_version | int(11) | NO | | NULL | | | tenant_id | varchar(255) | YES | MUL | NULL | | | advertise_floating_ip_host_routes | tinyint(1) | NO | | NULL | | | advertise_tenant_networks | tinyint(1) | NO | | NULL | | +-----------------------------------+--------------+------+-----+---------+-------+

Is this a bug?

Other than adding this missing field into this table, what would be official recommendation for solving this problem?

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2017-07-24 18:18:07 -0600

Rajab gravatar image

Solved

I added "project_id" column to the table and all is well

ALTER TABLE bgp_speakers ADD project_id varchar(255) NOT NULL;

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2017-07-24 18:10:59 -0600

Seen: 75 times

Last updated: Jul 24 '17