venus deployment is missing the db sync process

Bug #2030358 reported by howard lee
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla-ansible
In Progress
Medium
howard lee
Antelope
Confirmed
Medium
Unassigned
Bobcat
In Progress
Medium
howard lee
Zed
Confirmed
Medium
Unassigned

Bug Description

After the venus deployment is complete, there is an error message in the venus_manager log, as shown below:
(Background on this error at: https://sqlalche.me/e/14/f405): sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'venus.t_mo_custom_config' doesn't exist")

Enter the venus database and find that there is no database table in the venus database:
(venv) [root@openstack-node01 ~]# docker exec -u 0 -it mariadb /bin/bash
(mariadb)[root@openstack-node01 /]# mysql -uroot -p5yosuXzXkTRtrLkvgfrzSEQXkhbmKTbDN1GDG93c
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 959528
Server version: 10.11.4-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| cinder |
| glance |
| heat |
| information_schema |
| keystone |
| mysql |
| neutron |
| nova |
| nova_api |
| nova_cell0 |
| performance_schema |
| placement |
| sys |
| venus |
+--------------------+
14 rows in set (0.001 sec)

MariaDB [(none)]> use venus;
Database changed
MariaDB [venus]> show tables;
Empty set (0.000 sec)

MariaDB [venus]>

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (master)
Changed in kolla-ansible:
status: New → In Progress
howard lee (howardlee)
Changed in kolla-ansible:
assignee: nobody → howard lee (howardlee)
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.