Running Ubuntu server 20.04. After a normal " sudo apt update && sudo apt dist-upgrade " done end of February, Percona server won’t start.
mysql Ver 8.0.36-28 for Linux on x86_64 (Percona Server (GPL), Release ‘28’, Revision ‘47601f19’$) - start failure after suso apt update && sudo apt dist-upgrade
Logfile:
2024-03-10T18:22:14.203662Z 0 [Warning] [MY-000081] [Server] option 'table_open_cache': unsigned value 33554432 adjusted to 524288.
2024-03-10T18:22:14.203836Z 0 [Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 1049086)
2024-03-10T18:22:14.203846Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4745 (requested 524288)
2024-03-10T18:22:14.461909Z 0 [Warning] [MY-010080] [Server] The use of InnoDB is mandatory since MySQL 5.7. The former options like '--innodb=0/1/OFF/ON' or '--skip-innodb' are ignored.
2024-03-10T18:22:14.461934Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2024-03-10T18:22:14.461991Z 0 [Warning] [MY-010084] [Server] options --log-slow-admin-statements, --log-queries-not-using-indexes, --log-slow-replica-statements and --log-query-errors have no effect if --slow-query-log is not set
2024-03-10T18:22:14.464610Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-03-10T18:22:14.465251Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-28) starting as process 3844
2024-03-10T18:22:14.488599Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=4294967296. Please use innodb_redo_log_capacity instead.
2024-03-10T18:22:14.500808Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-10T18:22:16.189827Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-10T18:22:16.973295Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973355Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973392Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973404Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_background_job_status' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973431Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973443Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_file_map' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973471Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973483Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_fractal_tree_block_map' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973518Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973531Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_fractal_tree_info' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973551Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973562Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_locks' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973582Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973605Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_lock_waits' with soname 'ha_tokudb.so'.
2024-03-10T18:22:16.973627Z 0 [ERROR] [MY-010901] [Server] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' (errno: 0 /usr/lib/mysql/plugin/ha_tokudb.so: cannot open shared object file: No such file or directory).
2024-03-10T18:22:16.973638Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'TokuDB_trx' with soname 'ha_tokudb.so'.
2024-03-10T18:22:17.006106Z 4 [System] [MY-013381] [Server] Server upgrade from '80035' to '80036' started.
2024-03-10T18:22:22.233169Z 4 [System] [MY-013381] [Server] Server upgrade from '80035' to '80036' completed.
2024-03-10T18:22:22.388107Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-10T18:22:22.388146Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-10T18:22:22.391248Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query-cache-type=0'.
2024-03-10T18:22:22.391312Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-10T18:22:24.844386Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-28) Percona Server (GPL), Release '28', Revision '47601f19'$.
My mysqld.cnf file:
# Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
# Configuration name HP-2-26g-ram generated for **************** at 2016-10-18 19:09:33
[mysql]
#default-authentication-plugin=mysql_native_password
# CLIENT #
bind-address = 127.0.0.1
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
# GENERAL #
user = mysql
default-storage-engine = InnoDB
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
# MyISAM #
key-buffer-size = 32M
# SAFETY #
max-allowed-packet = 16M
max-connect-errors = 1000000
skip-name-resolve
#sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
sql-mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
sysdate-is-now = 1
innodb = FORCE
# DATA STORAGE #
datadir = /var/lib/mysql/
# BINARY LOGGING #
log-bin = /var/lib/mysql/mysql-bin
#expire-logs-days = 14
sync-binlog = 1
binlog_expire_logs_seconds = 1209600
server-id = 12345
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 32M
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 2048M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 20G
innodb_buffer_pool_instances = 8
innodb_file_per_table = ON
innodb_stats_on_metadata = OFF
# LOGGING #
log-error = /var/log/mysql/error.log
log-queries-not-using-indexes = 1
slow-query-log = 0
slow-query-log-file = /var/log/mysql/mysql-slow.log
My website is DOWN and I urgent" need feedback, so I can solve this problem, Anyone who can help ?