Ubuntu 18.04 in openstack MySQL Neutron.QuotaUsage Table Error

Bug #1808915 reported by Sistem Tasarim
This bug report is a duplicate of:  Bug #1807609: mariadb not found in ubuntu 18.04. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
openstack-manuals
New
Undecided
Unassigned

Bug Description

Hello there;

We are planning to establish an OpenStack Platform consisting of 2 Controller Node, 2 Compute Node and 4 Ceph Node. Our Physical Servers
We are installing Ubuntu 18.04 on the HP DL380 Gen9 and physical servers. After setting up 1 Controller Node and 1 Compute Node we encountered a problem in the process of creating a virtual server for testing purposes.
As a first step, we created 1 Sub Self Service Network oluştur, followed by 1 "Subnet İlk. We have successfully done this creation. Then we restarted the "MySQL" service. After the restart "Neutron.QuotaUsage" table gives a constant error and "Neutron" do not allow us to do any action on. Then, we created the "Neutron" Databaseini and all the tables in the same process. Everything is going well until MySql is "Restart" (or until you restart the physical server). Then again on the same table to prevent us from giving error. Although we tried many times, we encountered the same error. The MySQL (MariaDB) we use is 10.3.11 . Thank you in advance for your help.

(2018-12-18 09:33:34.877 7629 ERROR oslo_messaging.rpc.server DBError: (pymysql.err.InternalError) (1932, u"Table 'neutron.agents' doesn't exist in engine") [SQL: u'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents.`binary` AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.`load` AS agents_load \nFROM agents \nWHERE agents.host IN (%(host_1)s) AND agents.agent_type IN (%(agent_type_1)s)'] [parameters: {u'host_1': u'xxxxxxxx', u'agent_type_1': u'L3 agent'}] (Background on this error at: http://sqlalche.me/e/2j85)
2018-12-18 09:33:34.877 7629 ERROR oslo_messaging.rpc.server)

description: updated
Revision history for this message
Alexandra Settle (alexandra-settle) wrote :
Revision history for this message
Alexandra Settle (alexandra-settle) wrote :

For support help, please use the following resources, this is the documentation bug page:

 - Ask OpenStack: http://ask.openstack.org
 - The mailing list: http://lists.openstack.org
 - IRC: 'openstack' channel on Freenode

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.