unknown variable 'master-info-repository=TABLE'

[entrymon]

Name and Version

bitnami/mysql

What architecture are you using?

amd64

What steps will reproduce the bug?

1. Install the latest mysql helm chart for bitnami with replication and below config

[mysqld]
default_authentication_plugin=caching_sha2_password
lower_case_table_names=1
skip-name-resolve
explicit_defaults_for_timestamp
basedir=/opt/bitnami/mysql
plugin_dir=/opt/bitnami/mysql/lib/plugin
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
datadir=/bitnami/mysql/data
tmpdir=/opt/bitnami/mysql/tmp
max_allowed_packet=128M
bind-address=0.0.0.0
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
log-error=/opt/bitnami/mysql/logs/mysqld.log
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
slow_query_log=0
slow_query_log_file=/opt/bitnami/mysql/logs/mysqld.log
long_query_time=10.0
server-id=184054
log_bin=mysql-bin
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_rows_query_log_events=ON

[client]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
default-character-set=UTF8
plugin_dir=/opt/bitnami/mysql/lib/plugin

[manager]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid

2. The primary server starts
3. but the secondary fails with error unknown variable 'master-info-repository=TABLE'

What do you see instead?

Seeing error starting secondary server

[entrymon]

Entire log

mysql 08:40:16.40 INFO  ==> Welcome to the Bitnami mysql container
mysql 08:40:16.40 INFO  ==> Subscribe to project updates by watching https://github.com/bitnami/containers
mysql 08:40:16.41 INFO  ==> Submit issues and feature requests at https://github.com/bitnami/containers/issues
mysql 08:40:16.41 INFO  ==> 
mysql 08:40:16.41 INFO  ==> ** Starting MySQL setup **
mysql 08:40:16.44 INFO  ==> Validating settings in MYSQL_*/MARIADB_* env vars
mysql 08:40:16.44 INFO  ==> Initializing mysql database
mysql 08:40:16.44 DEBUG ==> Ensuring expected directories/files exist
mysql 08:40:16.45 WARN  ==> The mysql configuration file '/opt/bitnami/mysql/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.
mysql 08:40:16.46 INFO  ==> Using persisted data
mysql 08:40:16.48 INFO  ==> Running mysql_upgrade
mysql 08:40:16.50 INFO  ==> Starting mysql in background
2024-02-13T08:40:16.518837Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-02-13T08:40:16.813524Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-02-13T08:40:16.813550Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-02-13T08:40:16.813576Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2024-02-13T08:40:16.813594Z 0 [Warning] [MY-011068] [Server] The syntax 'skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
2024-02-13T08:40:16.813747Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.3.0) starting as process 51
2024-02-13T08:40:16.833432Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-13T08:40:18.375704Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-13T08:40:18.580589Z 4 [System] [MY-013381] [Server] Server upgrade from '80300' to '80300' started.
2024-02-13T08:40:25.261464Z 4 [System] [MY-013381] [Server] Server upgrade from '80300' to '80300' completed.
2024-02-13T08:40:25.437187Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-02-13T08:40:25.437307Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-02-13T08:40:25.444579Z 0 [ERROR] [MY-000067] [Server] unknown variable 'master-info-repository=TABLE'.
2024-02-13T08:40:25.448030Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-02-13T08:40:27.797376Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld: Shutdown complete (mysqld 8.3.0)  Source distribution.
2024-02-13T08:40:27.797407Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[dgomezleon]

Hi @entrymon ,

I was not able to reproduce the error. This are my changes:

diff --git a/bitnami/mysql/values.yaml b/bitnami/mysql/values.yaml
index f5fb356c15..61d83d1370 100644
--- a/bitnami/mysql/values.yaml
+++ b/bitnami/mysql/values.yaml
@@ -105,7 +105,7 @@ image:
   debug: false
 ## @param architecture MySQL architecture (`standalone` or `replication`)
 ##
-architecture: standalone
+architecture: replication
 ## MySQL Authentication parameters
 ##
 auth:
@@ -207,20 +207,22 @@ primary:
   ##
   configuration: |-
     [mysqld]
-    default_authentication_plugin={{- .Values.auth.defaultAuthenticationPlugin | default "mysql_native_password" }}
+    default_authentication_plugin=caching_sha2_password
+    lower_case_table_names=1
     skip-name-resolve
     explicit_defaults_for_timestamp
     basedir=/opt/bitnami/mysql
     plugin_dir=/opt/bitnami/mysql/lib/plugin
-    port= {{ .Values.primary.containerPorts.mysql }}
+    port=3306
     socket=/opt/bitnami/mysql/tmp/mysql.sock
     datadir=/bitnami/mysql/data
     tmpdir=/opt/bitnami/mysql/tmp
-    max_allowed_packet=16M
-    bind-address=*
+    max_allowed_packet=128M
+    bind-address=0.0.0.0
     pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
     log-error=/opt/bitnami/mysql/logs/mysqld.log
-    character-set-server=UTF8
+    character-set-server=utf8mb4
+    collation-server=utf8mb4_0900_ai_ci
     slow_query_log=0
     long_query_time=10.0
 
@@ -623,20 +625,22 @@ secondary:
   ##
   configuration: |-
     [mysqld]
-    default_authentication_plugin=mysql_native_password
+    default_authentication_plugin=caching_sha2_password
+    lower_case_table_names=1
     skip-name-resolve
     explicit_defaults_for_timestamp
     basedir=/opt/bitnami/mysql
     plugin_dir=/opt/bitnami/mysql/lib/plugin
-    port={{ .Values.secondary.containerPorts.mysql }}
+    port=3306
     socket=/opt/bitnami/mysql/tmp/mysql.sock
     datadir=/bitnami/mysql/data
     tmpdir=/opt/bitnami/mysql/tmp
-    max_allowed_packet=16M
-    bind-address=*
+    max_allowed_packet=128M
+    bind-address=0.0.0.0
     pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
     log-error=/opt/bitnami/mysql/logs/mysqld.log
-    character-set-server=UTF8
+    character-set-server=utf8mb4
+    collation-server=utf8mb4_0900_ai_ci
     slow_query_log=0
     long_query_time=10.0
 

Do you have something different? Did you update both configuration sections for primary and `secondary?

[github-actions[bot]]

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

[entrymon]

This was probably because i upgraded from 8.1.0 to 8.3.0