[bitnami/mariadb] Error installing MariaDB - Githubissues

bitnami / charts

Bitnami Helm Charts

https://bitnami.com

Other

8.92k stars 9.18k forks source link

[bitnami/mariadb] Error installing MariaDB #15137

Closed scorpius81 closed 1 year ago

scorpius81 commented 1 year ago

Name and Version

mariadb 11.0.4

What steps will reproduce the bug?

helm install my-mariadb bitnami/mariadb

Are you using any custom parameters or values?

image:
  debug: true

What is the expected behavior?

Install MariaDB

What do you see instead?

CrashLoopBackOff

Additional information

To debug I ran:

helm install my-mariadb-try12 bitnami/mariadb -f values.yaml ; watch -n1 "kubectl logs my-mariadb-try12-0 >> my-mariadb-try12.log"

This is output

[38;5;6mmariadb [38;5;5m10:45:45.77 [0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m[1mWelcome to the Bitnami mariadb container[0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb/issues[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m10:45:45.83 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m10:45:45.87 [0m[38;5;3mWARN [0m ==> The mariadb configuration file '/opt/bitnami/mariadb/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;5mDEBUG[0m ==> Cleaning data directory to ensure successfully initialization
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;2mINFO [0m ==> Installing database

OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:

'/opt/bitnami/mariadb/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/opt/bitnami/mariadb' ; /opt/bitnami/mariadb/bin/mysqld_safe --datadir='/bitnami/mariadb/data'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/bitnami/mariadb/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

[38;5;6mmariadb [38;5;5m10:45:56.55 [0m[38;5;2mINFO [0m ==> Starting mariadb in background
2023-02-24 10:45:56 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (server 10.6.7-MariaDB) starting as process 98 ...
2023-02-24 10:45:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-02-24 10:45:56 0 [Note] InnoDB: Number of pools: 1
2023-02-24 10:45:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-02-24 10:45:56 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2023-02-24 10:45:56 0 [Note] InnoDB: Using Linux native AIO
2023-02-24 10:45:56 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2023-02-24 10:45:56 0 [Note] InnoDB: Completed initialization of buffer pool
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m[1mWelcome to the Bitnami mariadb container[0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb/issues[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m10:45:45.83 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m10:45:45.87 [0m[38;5;3mWARN [0m ==> The mariadb configuration file '/opt/bitnami/mariadb/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;5mDEBUG[0m ==> Cleaning data directory to ensure successfully initialization
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;2mINFO [0m ==> Installing database
Installing MariaDB/MySQL system tables in '/bitnami/mariadb/data' ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:

'/opt/bitnami/mariadb/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/opt/bitnami/mariadb' ; /opt/bitnami/mariadb/bin/mysqld_safe --datadir='/bitnami/mariadb/data'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/bitnami/mariadb/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

[38;5;6mmariadb [38;5;5m10:45:56.55 [0m[38;5;2mINFO [0m ==> Starting mariadb in background
2023-02-24 10:45:56 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (server 10.6.7-MariaDB) starting as process 98 ...
2023-02-24 10:45:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-02-24 10:45:56 0 [Note] InnoDB: Number of pools: 1
2023-02-24 10:45:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-02-24 10:45:56 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2023-02-24 10:45:56 0 [Note] InnoDB: Using Linux native AIO
2023-02-24 10:45:56 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2023-02-24 10:45:56 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-24 10:45:56 0 [Note] InnoDB: 128 rollback segments are active.
2023-02-24 10:45:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-24 10:45:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-24 10:45:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-02-24 10:45:59 0 [Note] InnoDB: 10.6.7 started; log sequence number 42173; transaction id 14
2023-02-24 10:45:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-24 10:45:59 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2023-02-24 10:45:59 0 [Note] InnoDB: Buffer pool(s) load completed at 230224 10:45:59
2023-02-24 10:45:59 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-02-24 10:45:59 0 [Warning] 'user' entry 'root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Warning] 'user' entry '@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Warning] 'proxies_priv' entry '@% root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.6.7-MariaDB'  socket: '/opt/bitnami/mariadb/tmp/mysql.sock'  port: 3306  Source distribution
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m[1mWelcome to the Bitnami mariadb container[0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb/issues[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m10:45:45.83 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m10:45:45.87 [0m[38;5;3mWARN [0m ==> The mariadb configuration file '/opt/bitnami/mariadb/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;5mDEBUG[0m ==> Cleaning data directory to ensure successfully initialization
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;2mINFO [0m ==> Installing database
Installing MariaDB/MySQL system tables in '/bitnami/mariadb/data' ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:

'/opt/bitnami/mariadb/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/opt/bitnami/mariadb' ; /opt/bitnami/mariadb/bin/mysqld_safe --datadir='/bitnami/mariadb/data'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/bitnami/mariadb/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

[38;5;6mmariadb [38;5;5m10:45:56.55 [0m[38;5;2mINFO [0m ==> Starting mariadb in background
2023-02-24 10:45:56 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (server 10.6.7-MariaDB) starting as process 98 ...
2023-02-24 10:45:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-02-24 10:45:56 0 [Note] InnoDB: Number of pools: 1
2023-02-24 10:45:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-02-24 10:45:56 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2023-02-24 10:45:56 0 [Note] InnoDB: Using Linux native AIO
2023-02-24 10:45:56 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2023-02-24 10:45:56 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-24 10:45:56 0 [Note] InnoDB: 128 rollback segments are active.
2023-02-24 10:45:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-24 10:45:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-24 10:45:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-02-24 10:45:59 0 [Note] InnoDB: 10.6.7 started; log sequence number 42173; transaction id 14
2023-02-24 10:45:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-24 10:45:59 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2023-02-24 10:45:59 0 [Note] InnoDB: Buffer pool(s) load completed at 230224 10:45:59
2023-02-24 10:45:59 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-02-24 10:45:59 0 [Warning] 'user' entry 'root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Warning] 'user' entry '@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Warning] 'proxies_priv' entry '@% root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.6.7-MariaDB'  socket: '/opt/bitnami/mariadb/tmp/mysql.sock'  port: 3306  Source distribution
[38;5;6mmariadb [38;5;5m10:46:00.57 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
select 1
1
[38;5;6mmariadb [38;5;5m10:46:00.59 [0m[38;5;2mINFO [0m ==> Configuring authentication
[38;5;6mmariadb [38;5;5m10:46:00.59 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
DELETE FROM mysql.user WHERE user not in ('mysql.sys','mariadb.sys');
[38;5;6mmariadb [38;5;5m10:46:00.64 [0m[38;5;5mDEBUG[0m ==> Configuring root user credentials
[38;5;6mmariadb [38;5;5m10:46:00.65 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
-- create root@localhost user for local admin access
-- create user 'root'@'localhost' identified by "KLSdg0bAF2";
-- grant all on *.* to 'root'@'localhost' with grant option;
-- create admin user for remote access
create user 'root'@'%' identified  by "KLSdg0bAF2";
grant all on *.* to 'root'@'%' with grant option;
flush privileges;
2023-02-24 10:46:00 5 [Warning] 'proxies_priv' entry '@% root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
[38;5;6mmariadb [38;5;5m10:46:00.67 [0m[38;5;5mDEBUG[0m ==> removing the unknown user
[38;5;6mmariadb [38;5;5m10:46:00.68 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
select Host from user where User='';
[38;5;6mmariadb [38;5;5m10:46:00.70 [0m[38;5;5mDEBUG[0m ==> Creating database my_database
[38;5;6mmariadb [38;5;5m10:46:00.71 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
create database if not exists `my_database` ;
[38;5;6mmariadb [38;5;5m10:46:00.78 [0m[38;5;2mINFO [0m ==> Running mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Phase 2/7: Installing used storage engines... Skipped
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0m[1mWelcome to the Bitnami mariadb container[0m
[38;5;6mmariadb [38;5;5m10:45:45.77 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb/issues[0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m
[38;5;6mmariadb [38;5;5m10:45:45.78 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m10:45:45.83 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m10:45:45.84 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m10:45:45.87 [0m[38;5;3mWARN [0m ==> The mariadb configuration file '/opt/bitnami/mariadb/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;5mDEBUG[0m ==> Cleaning data directory to ensure successfully initialization
[38;5;6mmariadb [38;5;5m10:45:45.88 [0m[38;5;2mINFO [0m ==> Installing database
Installing MariaDB/MySQL system tables in '/bitnami/mariadb/data' ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:

'/opt/bitnami/mariadb/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/opt/bitnami/mariadb' ; /opt/bitnami/mariadb/bin/mysqld_safe --datadir='/bitnami/mariadb/data'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/opt/bitnami/mariadb/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

[38;5;6mmariadb [38;5;5m10:45:56.55 [0m[38;5;2mINFO [0m ==> Starting mariadb in background
2023-02-24 10:45:56 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (server 10.6.7-MariaDB) starting as process 98 ...
2023-02-24 10:45:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-02-24 10:45:56 0 [Note] InnoDB: Number of pools: 1
2023-02-24 10:45:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-02-24 10:45:56 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2023-02-24 10:45:56 0 [Note] InnoDB: Using Linux native AIO
2023-02-24 10:45:56 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2023-02-24 10:45:56 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-24 10:45:56 0 [Note] InnoDB: 128 rollback segments are active.
2023-02-24 10:45:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-24 10:45:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-24 10:45:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-02-24 10:45:59 0 [Note] InnoDB: 10.6.7 started; log sequence number 42173; transaction id 14
2023-02-24 10:45:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-24 10:45:59 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2023-02-24 10:45:59 0 [Note] InnoDB: Buffer pool(s) load completed at 230224 10:45:59
2023-02-24 10:45:59 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-02-24 10:45:59 0 [Warning] 'user' entry 'root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Warning] 'user' entry '@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Warning] 'proxies_priv' entry '@% root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
2023-02-24 10:45:59 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.6.7-MariaDB'  socket: '/opt/bitnami/mariadb/tmp/mysql.sock'  port: 3306  Source distribution
[38;5;6mmariadb [38;5;5m10:46:00.57 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
select 1
1
[38;5;6mmariadb [38;5;5m10:46:00.59 [0m[38;5;2mINFO [0m ==> Configuring authentication
[38;5;6mmariadb [38;5;5m10:46:00.59 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
DELETE FROM mysql.user WHERE user not in ('mysql.sys','mariadb.sys');
[38;5;6mmariadb [38;5;5m10:46:00.64 [0m[38;5;5mDEBUG[0m ==> Configuring root user credentials
[38;5;6mmariadb [38;5;5m10:46:00.65 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
-- create root@localhost user for local admin access
-- create user 'root'@'localhost' identified by "KLSdg0bAF2";
-- grant all on *.* to 'root'@'localhost' with grant option;
-- create admin user for remote access
create user 'root'@'%' identified  by "KLSdg0bAF2";
grant all on *.* to 'root'@'%' with grant option;
flush privileges;
2023-02-24 10:46:00 5 [Warning] 'proxies_priv' entry '@% root@my-mariadb-try12-0' ignored in --skip-name-resolve mode.
[38;5;6mmariadb [38;5;5m10:46:00.67 [0m[38;5;5mDEBUG[0m ==> removing the unknown user
[38;5;6mmariadb [38;5;5m10:46:00.68 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
select Host from user where User='';
[38;5;6mmariadb [38;5;5m10:46:00.70 [0m[38;5;5mDEBUG[0m ==> Creating database my_database
[38;5;6mmariadb [38;5;5m10:46:00.71 [0m[38;5;5mDEBUG[0m ==> Executing SQL command:
create database if not exists `my_database` ;
[38;5;6mmariadb [38;5;5m10:46:00.78 [0m[38;5;2mINFO [0m ==> Running mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
mysql.user                                         OK
sys.host_summary                                   OK
sys.host_summary_by_file_io                        OK
sys.host_summary_by_file_io_type                   OK
sys.host_summary_by_stages                         OK
sys.host_summary_by_statement_latency              OK
sys.host_summary_by_statement_type                 OK
sys.innodb_buffer_stats_by_schema                  OK
sys.innodb_buffer_stats_by_table                   OK
sys.innodb_lock_waits                              OK
sys.io_by_thread_by_latency                        OK
sys.io_global_by_file_by_bytes                     OK
sys.io_global_by_file_by_latency                   OK
sys.io_global_by_wait_by_bytes                     OK
sys.io_global_by_wait_by_latency                   OK
sys.latest_file_io                                 OK
sys.memory_by_host_by_current_bytes                OK
sys.memory_by_thread_by_current_bytes              OK
sys.memory_by_user_by_current_bytes                OK
sys.memory_global_by_current_bytes                 OK
sys.memory_global_total                            OK
sys.metrics                                        OK
sys.processlist                                    OK
sys.ps_check_lost_instrumentation                  OK
sys.schema_auto_increment_columns                  OK
sys.schema_index_statistics                        OK
sys.schema_object_overview                         OK
sys.schema_redundant_indexes                       OK
sys.schema_table_lock_waits                        OK
sys.schema_table_statistics                        OK
sys.schema_table_statistics_with_buffer            OK
sys.schema_tables_with_full_table_scans            OK
sys.schema_unused_indexes                          OK
sys.session                                        OK
sys.session_ssl_status                             OK
sys.statement_analysis                             OK
sys.statements_with_errors_or_warnings             OK
sys.statements_with_full_table_scans               OK
sys.statements_with_runtimes_in_95th_percentile    OK
sys.statements_with_sorting                        OK
sys.statements_with_temp_tables                    OK
sys.user_summary                                   OK
sys.user_summary_by_file_io                        OK
sys.user_summary_by_file_io_type                   OK
sys.user_summary_by_stages                         OK
sys.user_summary_by_statement_latency              OK
sys.user_summary_by_statement_type                 OK
sys.version                                        OK
sys.wait_classes_global_by_avg_latency             OK
sys.wait_classes_global_by_latency                 OK
sys.waits_by_host_by_latency                       OK
sys.waits_by_user_by_latency                       OK
sys.waits_global_by_latency                        OK
sys.x$host_summary                                 OK
sys.x$host_summary_by_file_io                      OK
sys.x$host_summary_by_file_io_type                 OK
sys.x$host_summary_by_stages                       OK
sys.x$host_summary_by_statement_latency            OK
sys.x$host_summary_by_statement_type               OK
sys.x$innodb_buffer_stats_by_schema                OK
sys.x$innodb_buffer_stats_by_table                 OK
sys.x$innodb_lock_waits                            OK
sys.x$io_by_thread_by_latency                      OK
sys.x$io_global_by_file_by_bytes                   OK
sys.x$io_global_by_file_by_latency                 OK
sys.x$io_global_by_wait_by_bytes                   OK
sys.x$io_global_by_wait_by_latency                 OK
sys.x$latest_file_io                               OK
sys.x$memory_by_host_by_current_bytes              OK
sys.x$memory_by_thread_by_current_bytes            OK
sys.x$memory_by_user_by_current_bytes              OK
sys.x$memory_global_by_current_bytes               OK
sys.x$memory_global_total                          OK
sys.x$processlist                                  OK
sys.x$ps_digest_95th_percentile_by_avg_us          OK
sys.x$ps_digest_avg_latency_distribution           OK
sys.x$ps_schema_table_statistics_io                OK
sys.x$schema_flattened_keys                        OK
sys.x$schema_index_statistics                      OK
sys.x$schema_table_lock_waits                      OK
sys.x$schema_table_statistics                      OK
sys.x$schema_table_statistics_with_buffer          OK
sys.x$schema_tables_with_full_table_scans          OK
sys.x$session                                      OK
sys.x$statement_analysis                           OK
sys.x$statements_with_errors_or_warnings           OK
sys.x$statements_with_full_table_scans             OK
sys.x$statements_with_runtimes_in_95th_percentile  OK
sys.x$statements_with_sorting                      OK
sys.x$statements_with_temp_tables                  OK
sys.x$user_summary                                 OK
sys.x$user_summary_by_file_io                      OK
sys.x$user_summary_by_file_io_type                 OK
sys.x$user_summary_by_stages                       OK
sys.x$user_summary_by_statement_latency            OK
sys.x$user_summary_by_statement_type               OK
sys.x$wait_classes_global_by_avg_latency           OK
sys.x$wait_classes_global_by_latency               OK
sys.x$waits_by_host_by_latency                     OK
sys.x$waits_by_user_by_latency                     OK
sys.x$waits_global_by_latency                      OK
Phase 4/7: Running 'mysql_fix_privilege_tables'

ERROR 35 (HY000) at line 807: Warning: Can't copy ownership for file './sys/version.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2287: Warning: Can't copy ownership for file './sys/schema_object_overview.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2306: Warning: Can't copy ownership for file './sys/schema_auto_increment_columns.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2354: Warning: Can't copy ownership for file './sys/x@0024schema_flattened_keys.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2379: Warning: Can't copy ownership for file './sys/schema_redundant_indexes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2438: Warning: Can't copy ownership for file './sys/ps_check_lost_instrumentation.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2451: Warning: Can't copy ownership for file './sys/latest_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2476: Warning: Can't copy ownership for file './sys/x@0024latest_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2501: Warning: Can't copy ownership for file './sys/io_by_thread_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2533: Warning: Can't copy ownership for file './sys/x@0024io_by_thread_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2565: Warning: Can't copy ownership for file './sys/io_global_by_file_by_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2591: Warning: Can't copy ownership for file './sys/x@0024io_global_by_file_by_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2617: Warning: Can't copy ownership for file './sys/io_global_by_file_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2643: Warning: Can't copy ownership for file './sys/x@0024io_global_by_file_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2669: Warning: Can't copy ownership for file './sys/io_global_by_wait_by_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2705: Warning: Can't copy ownership for file './sys/x@0024io_global_by_wait_by_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2741: Warning: Can't copy ownership for file './sys/io_global_by_wait_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2779: Warning: Can't copy ownership for file './sys/x@0024io_global_by_wait_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2817: Warning: Can't copy ownership for file './sys/memory_by_user_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2838: Warning: Can't copy ownership for file './sys/x@0024memory_by_user_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2859: Warning: Can't copy ownership for file './sys/memory_by_host_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2880: Warning: Can't copy ownership for file './sys/x@0024memory_by_host_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2901: Warning: Can't copy ownership for file './sys/memory_by_thread_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2929: Warning: Can't copy ownership for file './sys/x@0024memory_by_thread_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2957: Warning: Can't copy ownership for file './sys/memory_global_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 2980: Warning: Can't copy ownership for file './sys/x@0024memory_global_by_current_bytes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3003: Warning: Can't copy ownership for file './sys/memory_global_total.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3012: Warning: Can't copy ownership for file './sys/x@0024memory_global_total.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3021: Warning: Can't copy ownership for file './sys/schema_index_statistics.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3052: Warning: Can't copy ownership for file './sys/x@0024schema_index_statistics.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3083: Warning: Can't copy ownership for file './sys/x@0024ps_schema_table_statistics_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3111: Warning: Can't copy ownership for file './sys/schema_table_statistics.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3160: Warning: Can't copy ownership for file './sys/x@0024schema_table_statistics.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3347: Warning: Can't copy ownership for file './sys/schema_tables_with_full_table_scans.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3365: Warning: Can't copy ownership for file './sys/x@0024schema_tables_with_full_table_scans.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3383: Warning: Can't copy ownership for file './sys/schema_unused_indexes.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3401: Warning: Can't copy ownership for file './sys/schema_table_lock_waits.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3455: Warning: Can't copy ownership for file './sys/x@0024schema_table_lock_waits.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3509: Warning: Can't copy ownership for file './sys/statement_analysis.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3563: Warning: Can't copy ownership for file './sys/x@0024statement_analysis.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3617: Warning: Can't copy ownership for file './sys/statements_with_errors_or_warnings.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3647: Warning: Can't copy ownership for file './sys/x@0024statements_with_errors_or_warnings.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3677: Warning: Can't copy ownership for file './sys/statements_with_full_table_scans.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3716: Warning: Can't copy ownership for file './sys/x@0024statements_with_full_table_scans.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3755: Warning: Can't copy ownership for file './sys/x@0024ps_digest_avg_latency_distribution.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3767: Warning: Can't copy ownership for file './sys/x@0024ps_digest_95th_percentile_by_avg_us.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3784: Warning: Can't copy ownership for file './sys/statements_with_runtimes_in_95th_percentile.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3826: Warning: Can't copy ownership for file './sys/x@0024statements_with_runtimes_in_95th_percentile.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3868: Warning: Can't copy ownership for file './sys/statements_with_sorting.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3903: Warning: Can't copy ownership for file './sys/x@0024statements_with_sorting.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3938: Warning: Can't copy ownership for file './sys/statements_with_temp_tables.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 3969: Warning: Can't copy ownership for file './sys/x@0024statements_with_temp_tables.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4000: Warning: Can't copy ownership for file './sys/user_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4020: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4040: Warning: Can't copy ownership for file './sys/user_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4056: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4072: Warning: Can't copy ownership for file './sys/user_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4101: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4130: Warning: Can't copy ownership for file './sys/user_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4157: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4184: Warning: Can't copy ownership for file './sys/user_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4203: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4222: Warning: Can't copy ownership for file './sys/user_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4258: Warning: Can't copy ownership for file './sys/x@0024user_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4294: Warning: Can't copy ownership for file './sys/host_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4314: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4334: Warning: Can't copy ownership for file './sys/host_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4350: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4366: Warning: Can't copy ownership for file './sys/host_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4395: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4424: Warning: Can't copy ownership for file './sys/host_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4451: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4478: Warning: Can't copy ownership for file './sys/host_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4497: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4516: Warning: Can't copy ownership for file './sys/host_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4551: Warning: Can't copy ownership for file './sys/x@0024host_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4586: Warning: Can't copy ownership for file './sys/wait_classes_global_by_avg_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4609: Warning: Can't copy ownership for file './sys/x@0024wait_classes_global_by_avg_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4632: Warning: Can't copy ownership for file './sys/wait_classes_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4655: Warning: Can't copy ownership for file './sys/x@0024wait_classes_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4678: Warning: Can't copy ownership for file './sys/waits_by_user_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4701: Warning: Can't copy ownership for file './sys/x@0024waits_by_user_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4724: Warning: Can't copy ownership for file './sys/waits_by_host_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4746: Warning: Can't copy ownership for file './sys/x@0024waits_by_host_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4768: Warning: Can't copy ownership for file './sys/waits_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4788: Warning: Can't copy ownership for file './sys/x@0024waits_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4860: Warning: Can't copy ownership for file './sys/processlist.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4945: Warning: Can't copy ownership for file './sys/x@0024processlist.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 5030: Warning: Can't copy ownership for file './sys/session.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 5037: Warning: Can't copy ownership for file './sys/x@0024session.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 5044: Warning: Can't copy ownership for file './sys/session_ssl_status.frm-' (Errcode: 1 "Operation not permitted")
FATAL ERROR: Upgrade failed

javsalgar commented 1 year ago

Hi,

Could you add more details on the persistence technology you are using in the cluster? It seems to be that it may be related to the issue.

scorpius81 commented 1 year ago

Hi,

Could you add more details on the persistence technology you are using in the cluster? It seems to be that it may be related to the issue. Hi my Kubernetes is deploy on bear metal

kubectl describe sc nfs-storage-huawei

Name:            nfs-storage-huawei
IsDefaultClass:  Yes
Annotations:     kubectl.kubernetes.io/last-applied-configuration={"allowVolumeExpansion":true,"apiVersion":"storage.k8s.io/v1","kind":"StorageClass","metadata":{"annotations":{"storageclass.kubernetes.io/is-default-class":"true"},"name":"nfs-storage-huawei"},"provisioner":"hwnas.int.xxx.it","reclaimPolicy":"Retain"}
,storageclass.kubernetes.io/is-default-class=true
Provisioner:           hwnas.int.xxx.it
Parameters:            <none>
AllowVolumeExpansion:  True
MountOptions:          <none>
ReclaimPolicy:         Retain
VolumeBindingMode:     Immediate
Events:                <none>

kubectl describe pvc data-my-mariadb-try12-0 -n default

Name:          data-my-mariadb-try12-0
Namespace:     default
StorageClass:  nfs-storage-huawei
Status:        Bound
Volume:        pvc-76a1d085-5845-4f62-af79-bcbf93033922
Labels:        app.kubernetes.io/component=primary
               app.kubernetes.io/instance=my-mariadb-try12
               app.kubernetes.io/name=mariadb
Annotations:   pv.kubernetes.io/bind-completed: yes
               pv.kubernetes.io/bound-by-controller: yes
               volume.beta.kubernetes.io/storage-provisioner: hwnas.int.xxx.it
Finalizers:    [kubernetes.io/pvc-protection]
Capacity:      8Gi
Access Modes:  RWO
VolumeMode:    Filesystem
Used By:       my-mariadb-try12-0
Events:        <none>

javsalgar commented 1 year ago

Does the issue happen with other persistent volume technology?

scorpius81 commented 1 year ago

I also tried to use another sc. The same problem occurred.

javsalgar commented 1 year ago

Which one did you try?

scorpius81 commented 1 year ago

kubectl describe sc managed-nfs-storage

Name:                  managed-nfs-storage
IsDefaultClass:        No
Annotations:           storageclass.kubernetes.io/is-default-class=false
Provisioner:           alessandria-store02.xxxxx.it/k8s
Parameters:            archiveOnDelete=false
AllowVolumeExpansion:  <unset>
MountOptions:          <none>
ReclaimPolicy:         Delete
VolumeBindingMode:     Immediate
Events:                <none>

javsalgar commented 1 year ago

Did you enable the volumePermissions init container? This may help for this kind of scenarios.

scorpius81 commented 1 year ago

Did you enable the volumePermissions init container? This may help for this kind of scenarios.

In the previous test no, now I have enabled it but it doesn't work

ERROR 35 (HY000) at line 4021: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4041: Warning: Can't copy ownership for file './sys/user_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4057: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4073: Warning: Can't copy ownership for file './sys/user_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4102: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4131: Warning: Can't copy ownership for file './sys/user_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4158: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4185: Warning: Can't copy ownership for file './sys/user_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4204: Warning: Can't copy ownership for file './sys/x@0024user_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4223: Warning: Can't copy ownership for file './sys/user_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4259: Warning: Can't copy ownership for file './sys/x@0024user_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4295: Warning: Can't copy ownership for file './sys/host_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4315: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_file_io_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4335: Warning: Can't copy ownership for file './sys/host_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4351: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_file_io.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4367: Warning: Can't copy ownership for file './sys/host_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4396: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_statement_type.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4425: Warning: Can't copy ownership for file './sys/host_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4452: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_statement_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4479: Warning: Can't copy ownership for file './sys/host_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4498: Warning: Can't copy ownership for file './sys/x@0024host_summary_by_stages.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4517: Warning: Can't copy ownership for file './sys/host_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4552: Warning: Can't copy ownership for file './sys/x@0024host_summary.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4587: Warning: Can't copy ownership for file './sys/wait_classes_global_by_avg_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4610: Warning: Can't copy ownership for file './sys/x@0024wait_classes_global_by_avg_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4633: Warning: Can't copy ownership for file './sys/wait_classes_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4656: Warning: Can't copy ownership for file './sys/x@0024wait_classes_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4679: Warning: Can't copy ownership for file './sys/waits_by_user_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4702: Warning: Can't copy ownership for file './sys/x@0024waits_by_user_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4725: Warning: Can't copy ownership for file './sys/waits_by_host_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4747: Warning: Can't copy ownership for file './sys/x@0024waits_by_host_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4769: Warning: Can't copy ownership for file './sys/waits_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4789: Warning: Can't copy ownership for file './sys/x@0024waits_global_by_latency.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4861: Warning: Can't copy ownership for file './sys/processlist.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 4946: Warning: Can't copy ownership for file './sys/x@0024processlist.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 5031: Warning: Can't copy ownership for file './sys/session.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 5038: Warning: Can't copy ownership for file './sys/x@0024session.frm-' (Errcode: 1 "Operation not permitted")
ERROR 35 (HY000) at line 5045: Warning: Can't copy ownership for file './sys/session_ssl_status.frm-' (Errcode: 1 "Operation not permitted")
FATAL ERROR: Upgrade failed
mariadb 10:13:13.97 INFO  ==> Stopping mariadb
2023-03-02 10:13:13 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2023-03-02 10:13:13 0 [Note] InnoDB: FTS optimize thread exiting.
2023-03-02 10:13:14 0 [Note] InnoDB: Starting shutdown...
2023-03-02 10:13:14 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2023-03-02 10:13:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 230302 10:13:14
2023-03-02 10:13:14 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-03-02 10:13:14 0 [Note] InnoDB: Shutdown completed; log sequence number 42228; transaction id 18
2023-03-02 10:13:14 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete
mariadb 10:13:14.98 DEBUG ==> Waiting for mariadb to unlock db files

javsalgar commented 1 year ago

Hi,

It seems to me that there is a some sort of incompatibility with the volume provider, which is not allowing certain permission operations. We tried with the cloud major volume providers and found no issues.

github-actions[bot] commented 1 year ago

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.

github-actions[bot] commented 1 year ago

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.

scorpius81 commented 1 year ago

sorry for the delay, I did other tests. If I install an older version it works.

helm install my-mariadb-try15 bitnami/mariadb --version 10.0.1

This version work

rafariossaa commented 1 year ago

Hi, I agree with @javsalgar , it seems something related with your cluster. Could you indicate the cluster provider you are using ? There are too many changes from 10.0.1 to 11.0.4. Did you try other versions 11.x.y ? Did you went through other chart versions to 10.0.1 and none of them worked ? Could you try the chart in, for example, a kind or minikube kubernetes ?

github-actions[bot] commented 1 year ago

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.

github-actions[bot] commented 1 year ago

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.