polardb-x auto restarts frequently. #45
Description
this is my my.cnf configuration file.
[mysqld]
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamp = 0
#log_bin_trust_function_creators = 1
#loose_polar_log_bin = OFF
binlog_expire_logs_seconds = 86400
binlog_expire_logs_auto_purge = ON
basedir = /opt/polardbx_engine
log_error_verbosity = 2
default_authentication_plugin = mysql_native_password
gtid_mode = ON
enforce_gtid_consistency = ON
log_timestamps = system
secure_file_priv = "/"
innodb_strict_mode = 0
local_infile = ON
datadir = /opt/mysql/data/data
tmpdir = /opt/mysql/data/tmp
socket = /opt/mysql/data/tmp.mysql.sock
log_error = /opt/mysql/data/log/alert.log
port = 3307
cluster_id = 1234
cluster_info = 127.0.0.1:14886@1
server_id = 2712347953
max_connections = 1024
[mysqld_safe]
pid_file = /opt/mysql/data/run/mysql.pid
I found that there was an exception message at startup, and then the process could not start properly, and would keep restarting.
2024-12-30T09:38:33.672276+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2024-12-30T09:38:33.675796+08:00 0 [System] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2024-12-30T09:38:33.675823+08:00 0 [System] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2024-12-30T09:38:33.675832+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
2024-12-30T09:38:33.692492+08:00 0 [ERROR] [MY-025030] [XPaxos] init_last_index_of_term for recovery failed
2024-12-30T09:38:33.692517+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2024-12-30T09:38:33.692541+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc get shutdown notify.'
2024-12-30T09:39:08.463672+08:00 0 [System] [MY-010910] [Server] /opt/polardbx_engine/bin/mysqld: Shutdown complete (mysqld 8.0.32-X-Cluster-8.4.19) Source distribution.
2024-12-30T01:39:08.596475Z mysqld_safe mysqld from pid file /opt/mysql/data/run/mysql.pid ended
2024-12-30T01:39:18.900715Z mysqld_safe Logging to '/opt/mysql/data/log/alert.log'.
2024-12-30T01:39:18.927034Z mysqld_safe Starting mysqld daemon with databases from /opt/mysql/data/data
2024-12-30T09:39:18.945927+08:00 0 [System] [MY-025030] [XPaxos] XPaxos server start.
2024-12-30T09:39:19.126793+08:00 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-12-30T09:39:19.126810+08:00 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-12-30T09:39:19.127315+08:00 0 [Warning] [MY-010099] [Server] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
2024-12-30T09:39:19.127327+08:00 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2024-12-30T09:39:19.127388+08:00 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-12-30T09:39:19.127414+08:00 0 [System] [MY-010116] [Server] /opt/polardbx_engine/bin/mysqld (mysqld 8.0.32-X-Cluster-8.4.19) starting as process 1279186
2024-12-30T09:39:19.140108+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-30T09:39:19.651232+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-30T09:39:20.065267+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc start up.'
2024-12-30T09:39:20.065462+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'MtEpoll start with detected 8 CPUs.'
2024-12-30T09:39:20.067397+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'MtEpoll start with 32 groups with each group 4 threads.'
2024-12-30T09:39:20.067614+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Listen on port 33660.'
2024-12-30T09:39:20.144647+08:00 0 [System] [MY-025031] [XPaxos] [Recovery] Consensus_binlog_recovery::recover end , file_size 252, curr_position 252, m_current_index 11976, m_start_pos 4, m_end_pos 4, m_valid_pos 252, m_valid_index 11976, m_is_malformed 0, m_in_transaction 0, get_error_type 1, get_error 0, get_error_message
2024-12-30T09:39:20.144691+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2024-12-30T09:39:20.148188+08:00 0 [System] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2024-12-30T09:39:20.148213+08:00 0 [System] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2024-12-30T09:39:20.148223+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
2024-12-30T09:39:20.171860+08:00 0 [ERROR] [MY-025030] [XPaxos] init_last_index_of_term for recovery failed
2024-12-30T09:39:20.171889+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2024-12-30T09:39:20.171912+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc get shutdown notify.'
2024-12-30T09:39:20.171922+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:20.172516+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc watch dog exit.'
2024-12-30T09:39:21.172010+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:22.172158+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:23.172302+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:24.172465+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:25.172618+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:26.172775+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:27.172916+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:28.173056+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'
2024-12-30T09:39:29.173199+08:00 0 [Warning] [MY-000000] [Server] Plugin polarx_rpc reported: 'Plugin polarx_rpc exiting still 128 threads running.'