[wallaby][trove] MySQL 8.0 Support

Ammad Syed syedammad83 at gmail.com
Thu Apr 29 05:58:50 UTC 2021


It Looks like the problem is in the guest image. I am using victoria image
from below repo.

https://tarballs.opendev.org/openstack/trove/images/

On Thu, Apr 29, 2021 at 10:37 AM Ammad Syed <syedammad83 at gmail.com> wrote:

> 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
>


-- 
Regards,


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


More information about the openstack-discuss mailing list