Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

在k8s上挂载给mysql做数据存储,mysql8无法启动,初始化失败 #240

Open
fu7100 opened this issue Jul 10, 2024 · 0 comments

Comments

@fu7100
Copy link

fu7100 commented Jul 10, 2024

//mysql容器已经挂载成功
$ df -Th
Filesystem Type Size Used Avail Use% Mounted on
overlay overlay 62G 12G 51G 18% /
tmpfs tmpfs 64M 0 64M 0% /dev
tmpfs tmpfs 3.3G 0 3.3G 0% /sys/fs/cgroup
s3fs fuse.s3fs 16E 0 16E 0% /bitnami/mysql
/dev/mapper/klas-root xfs 62G 12G 51G 18% /etc/hosts
shm tmpfs 64M 0 64M 0% /dev/shm
tmpfs tmpfs 6.5G 12K 6.5G 1% /run/secrets/kubernetes.io/serviceaccount
tmpfs tmpfs 3.3G 0 3.3G 0% /proc/acpi
tmpfs tmpfs 3.3G 0 3.3G 0% /proc/scsi
tmpfs tmpfs 3.3G 0 3.3G 0% /sys/firmware

// mysql无法初始化
[root@master minio-s3]# kubectl logs mysql-0 -f
mysql 17:25:45.15
mysql 17:25:45.16 Welcome to the Bitnami mysql container
mysql 17:25:45.16 Subscribe to project updates by watching https://github.com/bitnami/containers
mysql 17:25:45.16 Submit issues and feature requests at https://github.com/bitnami/containers/issues
mysql 17:25:45.17
mysql 17:25:45.17 INFO ==> ** Starting MySQL setup **
mysql 17:25:45.22 INFO ==> Validating settings in MYSQL_/MARIADB_ env vars
mysql 17:25:45.23 INFO ==> Initializing mysql database
mysql 17:25:45.26 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 17:25:45.27 INFO ==> Using persisted data
mysql 17:25:45.33 INFO ==> Running mysql_upgrade
mysql 17:25:45.34 INFO ==> Starting mysql in background
2024-07-09T17:25:45.770033Z 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-07-09T17:25:45.770337Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-07-09T17:25:45.770400Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.0.33) starting as process 46
2024-07-09T17:25:45.775789Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-07-09T17:25:45.775813Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2024-07-09T17:25:45.939039Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-09T17:25:51.041457Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2024-07-09T17:25:51.111504Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-07-09T17:25:51.112003Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-07-09T17:25:51.112066Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-09T17:25:51.114075Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.33) Source distribution.

就是这个错,网上也没找到有效解决方法
Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant