[bitnami/mariadb-galera] Can't use version other than 10.6 -> Installation of system tables failed! Examine the logs in

[MiKuBB]

Name and Version

bitnami/maria-galera 7.4.8

What steps will reproduce the bug?

helm install -n test db1 --set image.tag=10.7.4-debian-11-r15 bitnami/mariadb-galera

Are you using any custom parameters or values?

image:
  tag: other than 10.6.x, for example 10.7.4-debian-11-r15

What is the expected behavior?

No response

What do you see instead?

Fri, Nov 11 2022 10:10:09 pm | mariadb 21:10:09.42 Welcome to the Bitnami mariadb-galera container
Fri, Nov 11 2022 10:10:09 pm | mariadb 21:10:09.43 Subscribe to project updates by watching https://github.com/bitnami/containers
Fri, Nov 11 2022 10:10:09 pm | mariadb 21:10:09.43 Submit issues and feature requests at https://github.com/bitnami/containers/issues
Fri, Nov 11 2022 10:10:09 pm | mariadb 21:10:09.43
Fri, Nov 11 2022 10:10:09 pm | mariadb 21:10:09.43 INFO ==> ** Starting MariaDB setup **
Fri, Nov 11 2022 10:10:09 pm | mariadb 21:10:09.45 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.54 DEBUG ==> Set Galera cluster address to gcomm://
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.55 INFO ==> Initializing mariadb database
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.55 DEBUG ==> Ensuring expected directories/files exist
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.58 INFO ==> Found mounted configuration directory
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.58 INFO ==> Updating 'my.cnf' with custom configuration
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.59 INFO ==> Setting user option
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.59 DEBUG ==> Setting user to 'zxc' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.60 INFO ==> Setting slow_query_log option
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.60 DEBUG ==> Setting slow_query_log to '0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.60 INFO ==> Setting long_query_time option
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.61 DEBUG ==> Setting long_query_time to '10.0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.61 INFO ==> Setting wsrep_node_name option
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.62 DEBUG ==> Setting wsrep_node_name to 'db1-mariadb-galera-0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.63 INFO ==> Setting wsrep_node_address option
Fri, Nov 11 2022 10:10:25 pm | mariadb 21:10:25.63 DEBUG ==> Setting wsrep_node_address to '10.42.3.49' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
Fri, Nov 11 2022 10:10:33 pm | mariadb 21:10:33.68 DEBUG ==> Set Galera cluster address to gcomm://
Fri, Nov 11 2022 10:10:33 pm | mariadb 21:10:33.68 INFO ==> Setting wsrep_sst_auth option
Fri, Nov 11 2022 10:10:33 pm | mariadb 21:10:33.68 DEBUG ==> Setting wsrep_sst_auth to 'mariabackup:qwe' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
Fri, Nov 11 2022 10:10:41 pm | mariadb 21:10:41.73 DEBUG ==> Cleaning data directory to ensure successfully initialization
Fri, Nov 11 2022 10:10:41 pm | Installing MariaDB/MySQL system tables in '/bitnami/mariadb/data' ...
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | Installation of system tables failed! Examine the logs in
Fri, Nov 11 2022 10:10:42 pm | /bitnami/mariadb/data for more information.
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | The problem could be conflicting information in an external
Fri, Nov 11 2022 10:10:42 pm | my.cnf files. You can ignore these by doing:
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | shell> /opt/bitnami/mariadb/bin/mysql_install_db --defaults-file=~/.my.cnf
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | You can also try to start the mysqld daemon with:
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | shell> /opt/bitnami/mariadb/sbin/mariadbd --skip-grant-tables --general-log &
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | and use the command line tool /opt/bitnami/mariadb/bin/mariadb
Fri, Nov 11 2022 10:10:42 pm | to connect to the mysql database and look at the grant tables:
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | shell> /opt/bitnami/mariadb/bin/mysql -u root mysql
Fri, Nov 11 2022 10:10:42 pm | mysql> show tables;
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | Try 'mysqld --help' if you have problems with paths. Using
Fri, Nov 11 2022 10:10:42 pm | --general-log gives you a log in /bitnami/mariadb/data that may be helpful.
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | The latest information about mysql_install_db is available at
Fri, Nov 11 2022 10:10:42 pm | https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
Fri, Nov 11 2022 10:10:42 pm | You can find the latest source at https://downloads.mariadb.org and
Fri, Nov 11 2022 10:10:42 pm | the maria-discuss email list at https://launchpad.net/~maria-discuss
Fri, Nov 11 2022 10:10:42 pm |  
Fri, Nov 11 2022 10:10:42 pm | Please check all of the above before submitting a bug report
Fri, Nov 11 2022 10:10:42 pm | at https://mariadb.org/jira
Fri, Nov 11 2022 10:10:42 pm

Additional information

No response

[javsalgar]

Hi,

Thanks for letting us know! Right now the chart officially supports version 10.6 of MariaDB. However, there are plans on bumping the supported version, so this issue will be reviewed and fixed.

[renemadsen]

Any new status on this?

[jvimont]

Hello,

I'm trying to deploy chart v8.0.0 and i still have : mariadb-galera Installation of system tables failed!

Julien

[javsalgar]

Hi Julien, is this happening on a fresh installation without changing the values?

[jvimont]

Hello @javsalgar ,

Yes, exactly. Is there some changes to operate in the values in order to upgrade?

Regards,

[javsalgar]

From which version do you want to upgrade?

[jvimont]

Hello @javsalgar ,

From 7.5.2.

Julien

[javsalgar]

Hi,

This is upgrading between different major versions of MariaDB:

-appVersion: 10.6.12
+appVersion: 10.11.2

Probably this may require some manual intervention following the MariaDB instructions: https://mariadb.com/kb/en/upgrading/

[jvimont]

Hello,

I have the same issue with a fresh install and no data on helm chart v10.0.0 :

Regards

[javsalgar]

Could you confirm that you don't have leftovers from previous deployments? Statefulset PVCs don't get removed on uninstalls

[jvimont]

Yes. I rebuild my k8s cluster with flux and helm chart from scratch.

Values are the same though.

[javsalgar]

Hi!

Any reason for not using version of the chart 11.x.x?

[jvimont]

Ok, it was a removed option (wsrep_replicate_myisam) still present in configuration that breaks the statefulset.

Everything's ok now.

Thank you.

[javsalgar]

Thanks for letting us know!