Open Stack

Hi,

I am using trove wallaby release and trying to create a database instance
with MySQL 8.0. I have created a mysql datastore version 8.0. The instance
deployment failed with ERROR.

Digging it further in guest agent logs, it is found that MySQL 8.0
container is not booting up and getting failed with below errors.

2021-04-28 09:35:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL
Server 8.0.24-1debian10 started.
2021-04-28T09:35:28.496216Z 0 [System] [MY-010116] [Server]
/usr/sbin/mysqld (mysqld 8.0.24) starting as process 1
2021-04-28T09:35:28.574978Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2021-04-28T09:35:29.318823Z 1 [System] [MY-013577] [InnoDB] InnoDB
initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2021-04-28T09:35:29.566920Z 0 [ERROR] [MY-010735] [Server] Could not open
the mysql.plugin table. Please perform the MySQL upgrade procedure.
2021-04-28T09:35:29.568058Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.569103Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.570029Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.570986Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.571894Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.572835Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.573939Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.576559Z 0 [System] [MY-011323] [Server] X Plugin ready
for connections. Bind-address: '::' port: 33060, socket:
/var/run/mysqld/mysqlx.sock
2021-04-28T09:35:29.665764Z 0 [Warning] [MY-010015] [Repl] Gtid table is
not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-04-28T09:35:29.705075Z 0 [Warning] [MY-010015] [Repl] Gtid table is
not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-04-28T09:35:29.718900Z 0 [Warning] [MY-010068] [Server] CA certificate
ca.pem is self signed.
2021-04-28T09:35:29.719698Z 0 [System] [MY-013602] [Server] Channel
mysql_main configured to support TLS. Encrypted connections are now
supported for this channel.
2021-04-28T09:35:29.724833Z 0 [Warning] [MY-010441] [Server] Failed to open
optimizer cost constant tables
2021-04-28T09:35:29.725997Z 0 [ERROR] [MY-013129] [Server] A message
intended for a client cannot be sent there as no client-session is
attached. Therefore, we're sending the information to the error-log
instead: MY-001146 - Table 'mysql.component' doesn't exist
2021-04-28T09:35:29.726837Z 0 [Warning] [MY-013129] [Server] A message
intended for a client cannot be sent there as no client-session is
attached. Therefore, we're sending the information to the error-log
instead: MY-003543 - The mysql.component table is missing or has an
incorrect definition.
2021-04-28T09:35:29.727818Z 0 [ERROR] [MY-000067] [Server] unknown variable
'ignore-db-dir=lost+found'.
2021-04-28T09:35:29.729297Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-04-28T09:35:31.237003Z 0 [System] [MY-010910] [Server]
/usr/sbin/mysqld: Shutdown complete (mysqld 8.0.24)  MySQL Community Server
- GPL. get_actual_db_status
/opt/guest-agent-venv/lib/python3.6/site-packages/trove/guestagent/datastore/mysql_common/service.py:80
2021-04-28 09:35:31.266 930 DEBUG trove.guestagent.datastore.service [-]
Waiting for DB status to change from running to healthy. wait_for_status
/opt/guest-agent-venv/lib/python3.6/site-packages/trove/guestagent/datastore/service.py:319

I think this requires some changes in config.template of mysql.

-- 
Regards,


Syed Ammad Ali
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20210429/f124733e/attachment.html>