点击参与 GreatSQL 8.0.32-26 文档捉虫~~~

GreatSQL社区

搜索

[已解决] Centos7二进制安装GreatSQL8.0.32-24初始化无法启动

1322 12 2024-4-24 16:43
环境信息

操作系统：Centos7.9
数据库版本：GreatSQL-8.0.32-24-Linux-glibc2.17-x86_6
二进制包

安装过程描述：
1、环境准备
关闭SWAP、关闭透明大页
swapoff -a  && echo "vm.swappiness = 0">>/etc/sysctl.conf && sysctp -p
echo never >/sys/kernel/mm/transparent_hugepage/enabled

echo never >/sys/kernel/mm/transparent_hugepage/defrag
优化内核参数
echo "fs.file-max = 1000000" >>/etc/sysctl.conf
echo "net.core.somaxconn = 32768">> /etc/sysctl.conf
echo "net.ipv4.tcp_tw_recycle = 0">> /etc/sysctl.conf
echo "net.ipv4.tcp_syncookies = 0">> /etc/sysctl.conf

echo "vm.overcommit_memory = 1" >> /etc/sysctl.conf
sysctp -p
修改limit
vim /etc/security/limits.conf
*          soft    nofile         65535
*          hard    nofile         65535
*          soft    stack          32768
*          hard    stack          32768
*          soft    nproc          65535
*          hard    nproc          65535


2、安装依赖
安装基础依赖
yum install -y perl libaio-devel numactl-develnumactl-libs net-tools openssl openssl-devel pkg-config
安装jemalloc
rpm -ivh jemalloc-5.3.0-1.el7.x86_64.rpm
echo ' /usr/local/jemalloc/lib/ ' > /etc/ld.so.conf.d/jemalloc.conf
ldconfig
echo -e "LD_PRELOAD=/usr/local/jemalloc/lib/libjemalloc.so\nTHP_SETTING=never"> /etc/sysconfig/mysql

3、下载安装包并解压
tar -xf GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64.tar.xz -C /usr/local/
ln -s /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/ /usr/local/greatsql
添加环境变量
vim /etc/profile
# GREATSQL_HOME
export GREATSQL_HOME=/usr/local/greatsql
# PATH
export PATH=$PATHGREATSQL_HOME/bin

source /etc/profile

4、准备配置文件文件
[client]
user = mysql
socket        = /data/greatsql/run/mysql.sock

[mysql]
loose-skip-binary-as-hex
prompt = "(\\D)[\\u@GreatSQL][\\d]>"
no-auto-rehash

[mysqld]
user        = mysql
port        = 3306
#主从复制或MGR集群中，server_id记得要不同
#另外，实例启动时会生成 auto.cnf，里面的 server_uuid 值也要不同
#server_uuid的值还可以自己手动指定，只要符合uuid的格式标准就可以
server_id = 3306
basedir = /usr/local/greatsql
datadir        = /data/greatsql/data
socket        = /data/greatsql/run/mysql.sock
pid-file = /data/greatsql/run/mysql.pid
character-set-server = UTF8MB4
skip_name_resolve = 1
#若你的MySQL数据库主要运行在境外，请务必根据实际情况调整本参数
default_time_zone = "+8:00"
bind_address = "0.0.0.0"

#performance setttings
lock_wait_timeout = 3600
open_files_limit    = 65535
back_log = 1024
max_connections = 2000
max_connect_errors = 1000000
table_open_cache = 1024
table_definition_cache = 1024
thread_stack = 512K
sort_buffer_size = 4M
join_buffer_size = 4M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 64M
thread_cache_size = 768
interactive_timeout = 600
wait_timeout = 600
tmp_table_size = 32M
max_heap_table_size = 32M
max_allowed_packet = 64M
net_buffer_shrink_interval = 180
#GIPK
loose-sql_generate_invisible_primary_key = ON

#log settings
#开启general日志
general_log = off
general_log_file = /data/greatsql/logs/audit.log
log_timestamps = SYSTEM
log_error = /data/greatsql/logs/error.log
log_error_verbosity = 3
slow_query_log = 1
log_slow_extra = 1
slow_query_log_file = /data/greatsql/logs/slow.log
#设置slow log文件大小1G及总文件数10
max_slowlog_size = 1073741824
max_slowlog_files = 10
long_query_time = 2
log_queries_not_using_indexes = 1
log_throttle_queries_not_using_indexes = 60
min_examined_row_limit = 100
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_bin = binlog
binlog_format = ROW
sync_binlog = 1
binlog_cache_size = 4M
max_binlog_cache_size = 2G
max_binlog_size = 1G
#控制binlog总大小，避免磁盘空间被撑爆
binlog_space_limit = 50G
binlog_rows_query_log_events = 1
binlog_expire_logs_seconds = 604800
#MySQL 8.0.22前，想启用MGR的话，需要设置binlog_checksum=NONE才行
binlog_checksum = CRC32
gtid_mode = ON
enforce_gtid_consistency = TRUE

#myisam settings
key_buffer_size = 32M
myisam_sort_buffer_size = 128M

#replication settings
relay_log_recovery = 1
slave_parallel_type = LOGICAL_CLOCK
#可以设置为逻辑CPU数量的2倍
replica_parallel_workers = 4
binlog_transaction_dependency_tracking = WRITESET
slave_preserve_commit_order = 1
slave_checkpoint_period = 2

#innodb settings
innodb_buffer_pool_size = 2G
innodb_buffer_pool_instances = 8
innodb_data_file_path = ibdata1:12M:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 2G
innodb_log_files_in_group = 3
innodb_redo_log_capacity = 6G
innodb_max_undo_log_size = 4G
# 根据您的服务器IOPS能力适当调整
# 一般配普通SSD盘的话，可以调整到 10000 - 20000
# 配置高端PCIe SSD卡的话，则可以调整的更高，比如 50000 - 80000
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_open_files = 65535
innodb_flush_method = O_DIRECT
innodb_lru_scan_depth = 4000
innodb_lock_wait_timeout = 10
innodb_rollback_on_timeout = 1
innodb_print_all_deadlocks = 1
innodb_online_alter_log_max_size = 4G
innodb_print_ddl_logs = 0
innodb_status_file = 1
#注意: 开启 innodb_status_output & innodb_status_output_locks 后, 可能会导致log_error文件增长较快
innodb_status_output = 0
innodb_status_output_locks = 1
innodb_sort_buffer_size = 67108864
innodb_adaptive_hash_index = 0
#开启NUMA支持
innodb_numa_interleave = ON
innodb_print_lock_wait_timeout_info = 1
#自动杀掉超过5分钟不活跃事务，避免行锁被长时间持有
kill_idle_transaction = 300
#异步清理大表
#innodb_data_file_async_purge = ON

#innodb monitor settings
innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash"

#innodb parallel query
loose-force_parallel_execute = OFF
loose-parallel_default_dop = 8
loose-parallel_max_threads = 8
loose-parallel_memory_limit = 512M

#pfs settings
performance_schema = 1
#performance_schema_instrument = '%memory%=on'
performance_schema_instrument = '%lock%=on'
performance_schema_session_connect_attrs_size = 4096


5、新建用户、目录及授权
groupadd mysql && useradd -g mysql mysql -M-s /sbin/nologin
mkdir -p /data/greatsql/{data,logs,run}
mkdir -p /var/lib/mysql-files
chown mysql:mysql -R /data/greatsql
chown mysql:mysql -R /var/lib/mysql-files
chown mysql:mysql -R /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64//usr/local/greatsql
chmod 700 -R /data/greatsql

6、配置系统服务
增加NUMA支持
vim /etc/systemd/system.conf
增加以下内容：(若是已有则可忽略)
NUMAPolicy=interleave

编辑gretasql的systemd启动文件
vim /etc/systemd/system/greatsql.service
填入以下内容：
[Unit]
Description=GreatSQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
# some limits
# file size
LimitFSIZE=infinity
# cpu time
LimitCPU=infinity
# virtual memory size
LimitAS=infinity
# open files
LimitNOFILE=65535
# processes/threads
LimitNPROC=65535
# locked memory
LimitMEMLOCK=infinity
# total threads (user+kernel)
TasksMax=infinity
TasksAccounting=false

User=mysql
Group=mysql
#如果是GreatSQL 5.7版本，此处需要改成simple模式，否则可能服务启用异常
#如果是GreatSQL 8.0版本则可以使用notify模式
#Type=simple
Type=notify
TimeoutSec=0
PermissionsStartOnly=true
ExecStartPre=/usr/local/greatsql/bin/mysqld_pre_systemd
ExecStart=/usr/local/greatsql/bin/mysqld$MYSQLD_OPTS
EnvironmentFile=-/etc/sysconfig/mysql
LimitNOFILE = 10000
Restart=on-failure
RestartPreventExitStatus=1
Environment=MYSQLD_PARENT_PID=1
PrivateTmp=false


7、初始化数据库

重新加载systemd
systemctl daemon-reload
执行下面的命令启动GreatSQL服务
systemctl start greatsql

问题就出现在这，启动greatsql后，日志打印：
2024-04-24T16:20:19.415355+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2024-04-24T16:20:19.415391+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2024-04-24T16:20:19.415427+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-24T16:20:19.415455+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2024-04-24T16:20:19.420985+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2024-04-24T16:20:19.421706+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2024-04-24T16:20:19.421768+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2024-04-24T16:20:19.421815+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 0 files.
2024-04-24T16:20:19.423014+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2024-04-24T16:20:19.423043+08:00 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
2024-04-24T16:20:26.603570+08:00 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
2024-04-24T16:20:26.603718+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2024-04-24T16:20:26.631585+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2024-04-24T16:20:26.659625+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-24T16:20:26.742032+08:00 1 [Note] [MY-012266] [InnoDB] File './ibdata1' size is now 12 MB.
2024-04-24T16:20:26.742193+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 16
2024-04-24T16:20:26.742211+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2024-04-24T16:20:26.742286+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2024-04-24T16:20:26.744409+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2024-04-24T16:20:26.755663+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
2024-04-24T16:20:26.757519+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
2024-04-24T16:20:26.766802+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
2024-04-24T16:20:26.767782+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
2024-04-24T16:20:26.777708+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
2024-04-24T16:20:26.778419+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
2024-04-24T16:20:26.786429+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
2024-04-24T16:20:26.787510+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
2024-04-24T16:20:26.796796+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
2024-04-24T16:20:26.797696+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
2024-04-24T16:20:26.806101+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
2024-04-24T16:20:26.807151+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
2024-04-24T16:20:26.816803+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
2024-04-24T16:20:26.817970+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
2024-04-24T16:20:26.908992+08:00 1 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=8204
2024-04-24T16:20:26.909161+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2024-04-24T16:20:26.920661+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2024-04-24T16:20:26.920764+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 16 MB
2024-04-24T16:20:26.920772+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2024-04-24T16:20:27.007093+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2024-04-24T16:20:27.007142+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 16 MB
2024-04-24T16:20:27.007151+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2024-04-24T16:20:27.105418+08:00 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2024-04-24T16:20:27.105916+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2024-04-24T16:20:27.117692+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2024-04-24T16:20:27.117876+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 11958 ms.
2024-04-24T16:20:27.123036+08:00 1 [Note] [MY-011920] [InnoDB] Legacy doublewrite buffer not found: creating new
2024-04-24T16:20:27.127049+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=24] type 20 to 13 when flushing.
2024-04-24T16:20:27.127117+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=23] type 20 to 13 when flushing.
2024-04-24T16:20:27.127130+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=22] type 20 to 13 when flushing.
2024-04-24T16:20:27.127140+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=21] type 20 to 13 when flushing.
2024-04-24T16:20:27.128148+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=20] type 20 to 13 when flushing.
2024-04-24T16:20:27.128195+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=19] type 20 to 13 when flushing.
2024-04-24T16:20:27.128204+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=18] type 20 to 13 when flushing.
2024-04-24T16:20:27.128225+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=17] type 20 to 13 when flushing.
2024-04-24T16:20:27.128806+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=16] type 20 to 13 when flushing.
2024-04-24T16:20:27.128831+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=15] type 20 to 13 when flushing.
2024-04-24T16:20:27.128839+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=14] type 20 to 13 when flushing.
2024-04-24T16:20:27.128846+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=13] type 20 to 13 when flushing.
2024-04-24T16:20:27.129399+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=12] type 20 to 13 when flushing.
2024-04-24T16:20:27.129441+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=11] type 20 to 13 when flushing.
2024-04-24T16:20:27.129452+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=10] type 20 to 13 when flushing.
2024-04-24T16:20:27.129460+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=9] type 20 to 13 when flushing.
2024-04-24T16:20:27.130011+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=40] type 20 to 13 when flushing.
2024-04-24T16:20:27.130038+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=39] type 20 to 13 when flushing.
2024-04-24T16:20:27.130045+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=38] type 20 to 13 when flushing.
2024-04-24T16:20:27.130055+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=37] type 20 to 13 when flushing.
2024-04-24T16:20:27.130498+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=36] type 20 to 13 when flushing.
2024-04-24T16:20:27.130518+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=35] type 20 to 13 when flushing.
2024-04-24T16:20:27.130525+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=34] type 20 to 13 when flushing.
2024-04-24T16:20:27.130531+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=33] type 20 to 13 when flushing.
2024-04-24T16:20:27.131720+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=32] type 20 to 13 when flushing.
2024-04-24T16:20:27.131780+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=31] type 20 to 13 when flushing.
2024-04-24T16:20:27.131790+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=30] type 20 to 13 when flushing.
2024-04-24T16:20:27.131797+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=29] type 20 to 13 when flushing.
2024-04-24T16:20:27.132186+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=28] type 20 to 13 when flushing.
2024-04-24T16:20:27.132230+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=27] type 20 to 13 when flushing.
2024-04-24T16:20:27.132240+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=26] type 20 to 13 when flushing.
2024-04-24T16:20:27.132247+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=25] type 20 to 13 when flushing.
2024-04-24T16:20:27.132592+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=143] type 20 to 13 when flushing.
2024-04-24T16:20:27.132626+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=142] type 20 to 13 when flushing.
2024-04-24T16:20:27.132634+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=141] type 20 to 13 when flushing.
2024-04-24T16:20:27.132641+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=140] type 20 to 13 when flushing.
2024-04-24T16:20:27.133212+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=139] type 20 to 13 when flushing.
2024-04-24T16:20:27.133245+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=138] type 20 to 13 when flushing.
2024-04-24T16:20:27.133258+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=137] type 20 to 13 when flushing.
2024-04-24T16:20:27.133270+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=136] type 20 to 13 when flushing.
2024-04-24T16:20:27.133726+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=135] type 20 to 13 when flushing.
2024-04-24T16:20:27.133788+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=134] type 20 to 13 when flushing.
2024-04-24T16:20:27.133813+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=133] type 20 to 13 when flushing.
2024-04-24T16:20:27.133827+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=132] type 20 to 13 when flushing.
2024-04-24T16:20:27.134342+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=131] type 20 to 13 when flushing.
2024-04-24T16:20:27.134370+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=130] type 20 to 13 when flushing.
2024-04-24T16:20:27.134391+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=129] type 20 to 13 when flushing.
2024-04-24T16:20:27.134399+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=128] type 20 to 13 when flushing.
2024-04-24T16:20:27.134775+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=159] type 20 to 13 when flushing.
2024-04-24T16:20:27.134798+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=158] type 20 to 13 when flushing.
2024-04-24T16:20:27.134809+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=157] type 20 to 13 when flushing.
2024-04-24T16:20:27.134819+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=156] type 20 to 13 when flushing.
2024-04-24T16:20:27.135301+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=155] type 20 to 13 when flushing.
2024-04-24T16:20:27.135317+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=154] type 20 to 13 when flushing.
2024-04-24T16:20:27.135325+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=153] type 20 to 13 when flushing.
2024-04-24T16:20:27.135332+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=152] type 20 to 13 when flushing.
2024-04-24T16:20:27.135738+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=151] type 20 to 13 when flushing.
2024-04-24T16:20:27.135755+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=150] type 20 to 13 when flushing.
2024-04-24T16:20:27.135763+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=149] type 20 to 13 when flushing.
2024-04-24T16:20:27.135771+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=148] type 20 to 13 when flushing.
2024-04-24T16:20:27.136077+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=147] type 20 to 13 when flushing.
2024-04-24T16:20:27.136092+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=146] type 20 to 13 when flushing.
2024-04-24T16:20:27.136102+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=145] type 20 to 13 when flushing.
2024-04-24T16:20:27.136108+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=144] type 20 to 13 when flushing.
2024-04-24T16:20:27.136434+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=175] type 20 to 13 when flushing.
2024-04-24T16:20:27.136469+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=174] type 20 to 13 when flushing.
2024-04-24T16:20:27.136482+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=173] type 20 to 13 when flushing.
2024-04-24T16:20:27.136492+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=172] type 20 to 13 when flushing.
2024-04-24T16:20:27.137196+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=171] type 20 to 13 when flushing.
2024-04-24T16:20:27.137289+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=170] type 20 to 13 when flushing.
2024-04-24T16:20:27.137306+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=169] type 20 to 13 when flushing.
2024-04-24T16:20:27.137322+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=168] type 20 to 13 when flushing.
2024-04-24T16:20:27.138290+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=167] type 20 to 13 when flushing.
2024-04-24T16:20:27.138471+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=166] type 20 to 13 when flushing.
2024-04-24T16:20:27.138591+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=165] type 20 to 13 when flushing.
2024-04-24T16:20:27.138616+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=164] type 20 to 13 when flushing.
2024-04-24T16:20:27.139243+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=163] type 20 to 13 when flushing.
2024-04-24T16:20:27.139278+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=162] type 20 to 13 when flushing.
2024-04-24T16:20:27.139289+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=161] type 20 to 13 when flushing.
2024-04-24T16:20:27.139300+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=160] type 20 to 13 when flushing.
2024-04-24T16:20:27.139657+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=191] type 20 to 13 when flushing.
2024-04-24T16:20:27.139683+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=190] type 20 to 13 when flushing.
2024-04-24T16:20:27.139691+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=189] type 20 to 13 when flushing.
2024-04-24T16:20:27.139713+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=188] type 20 to 13 when flushing.
2024-04-24T16:20:27.140089+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=187] type 20 to 13 when flushing.
2024-04-24T16:20:27.140145+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=186] type 20 to 13 when flushing.
2024-04-24T16:20:27.140153+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=185] type 20 to 13 when flushing.
2024-04-24T16:20:27.140160+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=184] type 20 to 13 when flushing.
2024-04-24T16:20:27.140597+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=183] type 20 to 13 when flushing.
2024-04-24T16:20:27.140667+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=182] type 20 to 13 when flushing.
2024-04-24T16:20:27.140681+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=181] type 20 to 13 when flushing.
2024-04-24T16:20:27.140692+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=180] type 20 to 13 when flushing.
2024-04-24T16:20:27.141123+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=179] type 20 to 13 when flushing.
2024-04-24T16:20:27.141154+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=178] type 20 to 13 when flushing.
2024-04-24T16:20:27.141176+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=177] type 20 to 13 when flushing.
2024-04-24T16:20:27.141341+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=176] type 20 to 13 when flushing.
2024-04-24T16:20:27.142818+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=79] type 20 to 13 when flushing.
2024-04-24T16:20:27.142870+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=78] type 20 to 13 when flushing.
2024-04-24T16:20:27.142927+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=77] type 20 to 13 when flushing.
2024-04-24T16:20:27.142950+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=76] type 20 to 13 when flushing.
2024-04-24T16:20:27.142975+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=75] type 20 to 13 when flushing.
2024-04-24T16:20:27.143437+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=74] type 20 to 13 when flushing.
2024-04-24T16:20:27.143509+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=73] type 20 to 13 when flushing.
2024-04-24T16:20:27.143522+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=72] type 20 to 13 when flushing.
2024-04-24T16:20:27.143534+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=71] type 20 to 13 when flushing.
2024-04-24T16:20:27.144383+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=70] type 20 to 13 when flushing.
2024-04-24T16:20:27.144409+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=69] type 20 to 13 when flushing.
2024-04-24T16:20:27.144437+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=68] type 20 to 13 when flushing.
2024-04-24T16:20:27.144445+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=67] type 20 to 13 when flushing.
2024-04-24T16:20:27.144941+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=66] type 20 to 13 when flushing.
2024-04-24T16:20:27.144975+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=65] type 20 to 13 when flushing.
2024-04-24T16:20:27.144989+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=64] type 20 to 13 when flushing.
2024-04-24T16:20:27.145084+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=95] type 20 to 13 when flushing.
2024-04-24T16:20:27.145447+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=94] type 20 to 13 when flushing.
2024-04-24T16:20:27.145516+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=93] type 20 to 13 when flushing.
2024-04-24T16:20:27.145529+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=92] type 20 to 13 when flushing.
2024-04-24T16:20:27.145540+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=91] type 20 to 13 when flushing.
2024-04-24T16:20:27.145933+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=90] type 20 to 13 when flushing.
2024-04-24T16:20:27.145962+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=89] type 20 to 13 when flushing.
2024-04-24T16:20:27.145970+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=88] type 20 to 13 when flushing.
2024-04-24T16:20:27.145977+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=87] type 20 to 13 when flushing.
2024-04-24T16:20:27.146464+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=86] type 20 to 13 when flushing.
2024-04-24T16:20:27.146496+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=85] type 20 to 13 when flushing.
2024-04-24T16:20:27.146508+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=84] type 20 to 13 when flushing.
2024-04-24T16:20:27.146524+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=83] type 20 to 13 when flushing.
2024-04-24T16:20:27.146966+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=82] type 20 to 13 when flushing.
2024-04-24T16:20:27.146999+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=81] type 20 to 13 when flushing.
2024-04-24T16:20:27.147018+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=80] type 20 to 13 when flushing.
2024-04-24T16:20:27.147170+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=111] type 20 to 13 when flushing.
2024-04-24T16:20:27.147524+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=110] type 20 to 13 when flushing.
2024-04-24T16:20:27.147573+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=109] type 20 to 13 when flushing.
2024-04-24T16:20:27.147590+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=108] type 20 to 13 when flushing.
2024-04-24T16:20:27.147597+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=107] type 20 to 13 when flushing.
2024-04-24T16:20:27.148064+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=106] type 20 to 13 when flushing.
2024-04-24T16:20:27.148095+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=105] type 20 to 13 when flushing.
2024-04-24T16:20:27.148105+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=104] type 20 to 13 when flushing.
2024-04-24T16:20:27.148114+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=103] type 20 to 13 when flushing.
2024-04-24T16:20:27.148497+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=102] type 20 to 13 when flushing.
2024-04-24T16:20:27.148517+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=101] type 20 to 13 when flushing.
2024-04-24T16:20:27.148525+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=100] type 20 to 13 when flushing.
2024-04-24T16:20:27.148533+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=99] type 20 to 13 when flushing.
2024-04-24T16:20:27.148965+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=98] type 20 to 13 when flushing.
2024-04-24T16:20:27.148986+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=97] type 20 to 13 when flushing.
2024-04-24T16:20:27.148992+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=96] type 20 to 13 when flushing.
2024-04-24T16:20:27.149000+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=127] type 20 to 13 when flushing.
2024-04-24T16:20:27.149439+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=126] type 20 to 13 when flushing.
2024-04-24T16:20:27.149462+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=125] type 20 to 13 when flushing.
2024-04-24T16:20:27.149470+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=124] type 20 to 13 when flushing.
2024-04-24T16:20:27.149478+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=123] type 20 to 13 when flushing.
2024-04-24T16:20:27.149937+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=122] type 20 to 13 when flushing.
2024-04-24T16:20:27.149956+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=121] type 20 to 13 when flushing.
2024-04-24T16:20:27.149967+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=120] type 20 to 13 when flushing.
2024-04-24T16:20:27.149973+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=119] type 20 to 13 when flushing.
2024-04-24T16:20:27.150403+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=118] type 20 to 13 when flushing.
2024-04-24T16:20:27.150441+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=117] type 20 to 13 when flushing.
2024-04-24T16:20:27.150453+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=116] type 20 to 13 when flushing.
2024-04-24T16:20:27.150464+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=115] type 20 to 13 when flushing.
2024-04-24T16:20:27.150888+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=114] type 20 to 13 when flushing.
2024-04-24T16:20:27.150913+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=113] type 20 to 13 when flushing.
2024-04-24T16:20:27.150930+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=112] type 20 to 13 when flushing.
2024-04-24T16:20:27.154005+08:00 1 [Note] [MY-011924] [InnoDB] Legacy atomic write buffer created
2024-04-24T16:20:27.154238+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2024-04-24T16:20:27.154362+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-24T16:20:27.229650+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2024-04-24T16:20:27.251645+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2024-04-24T16:20:27.254742+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2024-04-24T16:20:27.257623+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2024-04-24T16:20:27.314862+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 2399391
2024-04-24T16:20:27.316519+08:00 1 [Warning] [MY-011056] [InnoDB] Invalid monitor counter : module_server.
2024-04-24T16:20:27.316762+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-04-24T16:20:27.360475+08:00 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2024-04-24T16:20:27.702399+08:00 1 [Note] [MY-010007] [Server] Installed data dictionary with version 80023
2024-04-24T16:20:27.906345+08:00 2 [Note] [MY-011019] [Server] Created system views with I_S version 80023.
2024-04-24T08:20:28Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=5850d8e16b7845a955d11d6965d9d658fd24b257

Build ID: 5850d8e16b7845a955d11d6965d9d658fd24b257
Server Version: 8.0.32-24 GreatSQL, Release 24, Revision 3714067bc8c

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x80000
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x225a6cd]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(print_fatal_signal(int)+0x3cf) [0x12b1adf]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(handle_fatal_signal+0xc5) [0x12b1bb5]
/lib64/libpthread.so.0(+0xf630) [0x7f7f2eb47630]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(File_query_log::set_rotated_name(bool)+0x1be) [0xf5254e]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(File_query_log::set_file(char const*)+0x83) [0xf52e33]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(Query_logger::set_log_file(enum_log_table_type)+0x55) [0xf52f35]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld() [0xf76051]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld(mysqld_main(int, char**)+0x2343) [0xf7dcf3]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f7f2d044555]
/usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/bin/mysqld() [0xd8ef44]
Please help us make Percona Server better by reporting any

You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.



然后一直不断重启，不知道怎么回事。
我以前按照这个步骤进行安装是没有问题的






数据库, GreatSQL, CentOS
全部回复(12)
只看楼主
yejr 2024-4-25 10:13:13
从日志无法直接看出来什么原因。

systemd配置文件中有一行，缺了空格，请先改一下

  2. ExecStart=/usr/local/greatsql/bin/mysqld $MYSQLD_OPTS
复制代码


尝试把 /data/greatsql/data 目录清空

  2. rm -fr /data/greatsql/data/*
复制代码


然后手动方式初始化，看还会不会报错

  2. /usr/local/greatsql/bin/mysqld --datadir=/data/greatsql/data --user=mysql --initialize-insecure
复制代码
回复 采纳

举报

驭无殇1998 2024-4-25 14:11:35
yejr 发表于 2024-4-25 10:13
从日志无法直接看出来什么原因。

systemd配置文件中有一行，缺了空格，请先改一下

systemd那个空格的是复制过了的时候可能自动消失了


重新清空数据目录/data/greatsql/data，然后手动执行初始化，还是不行
初始化日志全部内容：
2024-04-25T14:08:55.631904+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
2024-04-25T14:08:55.632026+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
2024-04-25T14:08:55.632038+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2024-04-25T14:08:55.632074+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
2024-04-25T14:08:55.632100+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
2024-04-25T14:08:55.632467+08:00 0 [Note] [MY-010096] [Server] Ignoring --secure-file-priv value as server is running with --initialize(-insecure).
2024-04-25T14:08:55.632483+08:00 0 [Note] [MY-010096] [Server] Ignoring --secure-log-path value as server is running with --initialize(-insecure).
2024-04-25T14:08:55.633112+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=5850d8e16b7845a955d11d6965d9d658fd24b257
2024-04-25T14:08:55.633128+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/.
2024-04-25T14:08:55.633233+08:00 0 [System] [MY-013169] [Server] /usr/local/greatsql/bin/mysqld (mysqld 8.0.32-24) initializing of server in progress as process 14933
2024-04-25T14:08:55.644522+08:00 0 [Note] [MY-010458] [Server] --initialize specified on an existing data directory.
2024-04-25T14:08:55.682512+08:00 0 [Note] [MY-010938] [Server] Generating a new UUID: 4c32c00c-02ca-11ef-8a9a-000c295e99d7.
2024-04-25T14:08:55.687540+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2024-04-25T14:08:55.687699+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead.
2024-04-25T14:08:55.687715+08:00 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacity instead.
2024-04-25T14:08:55.688270+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2024-04-25T14:08:55.688646+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2024-04-25T14:08:55.688721+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2024-04-25T14:08:55.688739+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2024-04-25T14:08:55.694846+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-25T14:08:55.694950+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2024-04-25T14:08:55.695041+08:00 1 [Note] [MY-012274] [InnoDB] The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2024-04-25T14:08:55.695142+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2024-04-25T14:08:55.695239+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2024-04-25T14:08:55.695256+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-25T14:08:55.695292+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2024-04-25T14:08:55.722886+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2024-04-25T14:08:55.724229+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2024-04-25T14:08:55.724377+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2024-04-25T14:08:55.724477+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 0 files.
2024-04-25T14:08:55.729017+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2024-04-25T14:08:55.729146+08:00 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
2024-04-25T14:08:59.982912+08:00 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
2024-04-25T14:08:59.983065+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2024-04-25T14:09:00.018668+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2024-04-25T14:09:00.048507+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-25T14:09:00.074865+08:00 1 [Note] [MY-012266] [InnoDB] File './ibdata1' size is now 12 MB.
2024-04-25T14:09:00.075116+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 16
2024-04-25T14:09:00.075168+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2024-04-25T14:09:00.075291+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2024-04-25T14:09:00.075843+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2024-04-25T14:09:00.079538+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
2024-04-25T14:09:00.079855+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
2024-04-25T14:09:00.080878+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
2024-04-25T14:09:00.081162+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
2024-04-25T14:09:00.082212+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
2024-04-25T14:09:00.082748+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
2024-04-25T14:09:00.084076+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
2024-04-25T14:09:00.084310+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
2024-04-25T14:09:00.085251+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
2024-04-25T14:09:00.085581+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
2024-04-25T14:09:00.086718+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
2024-04-25T14:09:00.086943+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
2024-04-25T14:09:00.088180+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
2024-04-25T14:09:00.088772+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
2024-04-25T14:09:00.289692+08:00 1 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=8204
2024-04-25T14:09:00.290402+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2024-04-25T14:09:00.314632+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2024-04-25T14:09:00.314682+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 16 MB
2024-04-25T14:09:00.314692+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2024-04-25T14:09:00.340245+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2024-04-25T14:09:00.340288+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 16 MB
2024-04-25T14:09:00.340297+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2024-04-25T14:09:00.374028+08:00 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2024-04-25T14:09:00.374608+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2024-04-25T14:09:00.376881+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2024-04-25T14:09:00.377069+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 2467 ms.
2024-04-25T14:09:00.386640+08:00 1 [Note] [MY-011920] [InnoDB] Legacy doublewrite buffer not found: creating new
2024-04-25T14:09:00.390276+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=24] type 20 to 13 when flushing.
2024-04-25T14:09:00.390379+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=23] type 20 to 13 when flushing.
2024-04-25T14:09:00.390456+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=22] type 20 to 13 when flushing.
2024-04-25T14:09:00.390784+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=21] type 20 to 13 when flushing.
2024-04-25T14:09:00.391534+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=20] type 20 to 13 when flushing.
2024-04-25T14:09:00.391592+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=19] type 20 to 13 when flushing.
2024-04-25T14:09:00.391610+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=18] type 20 to 13 when flushing.
2024-04-25T14:09:00.391623+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=17] type 20 to 13 when flushing.
2024-04-25T14:09:00.392563+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=16] type 20 to 13 when flushing.
2024-04-25T14:09:00.392606+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=15] type 20 to 13 when flushing.
2024-04-25T14:09:00.392634+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=14] type 20 to 13 when flushing.
2024-04-25T14:09:00.392647+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=13] type 20 to 13 when flushing.
2024-04-25T14:09:00.393153+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=12] type 20 to 13 when flushing.
2024-04-25T14:09:00.393199+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=11] type 20 to 13 when flushing.
2024-04-25T14:09:00.393215+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=10] type 20 to 13 when flushing.
2024-04-25T14:09:00.393228+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=9] type 20 to 13 when flushing.
2024-04-25T14:09:00.393970+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=40] type 20 to 13 when flushing.
2024-04-25T14:09:00.394011+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=39] type 20 to 13 when flushing.
2024-04-25T14:09:00.394027+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=38] type 20 to 13 when flushing.
2024-04-25T14:09:00.394042+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=37] type 20 to 13 when flushing.
2024-04-25T14:09:00.395001+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=36] type 20 to 13 when flushing.
2024-04-25T14:09:00.395157+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=35] type 20 to 13 when flushing.
2024-04-25T14:09:00.395172+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=34] type 20 to 13 when flushing.
2024-04-25T14:09:00.395181+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=33] type 20 to 13 when flushing.
2024-04-25T14:09:00.396074+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=32] type 20 to 13 when flushing.
2024-04-25T14:09:00.396125+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=31] type 20 to 13 when flushing.
2024-04-25T14:09:00.396135+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=30] type 20 to 13 when flushing.
2024-04-25T14:09:00.396144+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=29] type 20 to 13 when flushing.
2024-04-25T14:09:00.396673+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=28] type 20 to 13 when flushing.
2024-04-25T14:09:00.396755+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=27] type 20 to 13 when flushing.
2024-04-25T14:09:00.396767+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=26] type 20 to 13 when flushing.
2024-04-25T14:09:00.396828+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=25] type 20 to 13 when flushing.
2024-04-25T14:09:00.397266+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=143] type 20 to 13 when flushing.
2024-04-25T14:09:00.397292+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=142] type 20 to 13 when flushing.
2024-04-25T14:09:00.397299+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=141] type 20 to 13 when flushing.
2024-04-25T14:09:00.397309+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=140] type 20 to 13 when flushing.
2024-04-25T14:09:00.397845+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=139] type 20 to 13 when flushing.
2024-04-25T14:09:00.397883+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=138] type 20 to 13 when flushing.
2024-04-25T14:09:00.397894+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=137] type 20 to 13 when flushing.
2024-04-25T14:09:00.397904+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=136] type 20 to 13 when flushing.
2024-04-25T14:09:00.398365+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=135] type 20 to 13 when flushing.
2024-04-25T14:09:00.398389+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=134] type 20 to 13 when flushing.
2024-04-25T14:09:00.398397+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=133] type 20 to 13 when flushing.
2024-04-25T14:09:00.398403+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=132] type 20 to 13 when flushing.
2024-04-25T14:09:00.398754+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=131] type 20 to 13 when flushing.
2024-04-25T14:09:00.398810+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=130] type 20 to 13 when flushing.
2024-04-25T14:09:00.398822+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=129] type 20 to 13 when flushing.
2024-04-25T14:09:00.398833+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=128] type 20 to 13 when flushing.
2024-04-25T14:09:00.399301+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=159] type 20 to 13 when flushing.
2024-04-25T14:09:00.399332+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=158] type 20 to 13 when flushing.
2024-04-25T14:09:00.399344+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=157] type 20 to 13 when flushing.
2024-04-25T14:09:00.399353+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=156] type 20 to 13 when flushing.
2024-04-25T14:09:00.399648+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=155] type 20 to 13 when flushing.
2024-04-25T14:09:00.399668+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=154] type 20 to 13 when flushing.
2024-04-25T14:09:00.399677+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=153] type 20 to 13 when flushing.
2024-04-25T14:09:00.399687+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=152] type 20 to 13 when flushing.
2024-04-25T14:09:00.399975+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=151] type 20 to 13 when flushing.
2024-04-25T14:09:00.400038+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=150] type 20 to 13 when flushing.
2024-04-25T14:09:00.400050+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=149] type 20 to 13 when flushing.
2024-04-25T14:09:00.400057+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=148] type 20 to 13 when flushing.
2024-04-25T14:09:00.400475+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=147] type 20 to 13 when flushing.
2024-04-25T14:09:00.400499+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=146] type 20 to 13 when flushing.
2024-04-25T14:09:00.400506+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=145] type 20 to 13 when flushing.
2024-04-25T14:09:00.400513+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=144] type 20 to 13 when flushing.
2024-04-25T14:09:00.400895+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=175] type 20 to 13 when flushing.
2024-04-25T14:09:00.400915+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=174] type 20 to 13 when flushing.
2024-04-25T14:09:00.400922+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=173] type 20 to 13 when flushing.
2024-04-25T14:09:00.400928+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=172] type 20 to 13 when flushing.
2024-04-25T14:09:00.401312+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=171] type 20 to 13 when flushing.
2024-04-25T14:09:00.401330+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=170] type 20 to 13 when flushing.
2024-04-25T14:09:00.401341+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=169] type 20 to 13 when flushing.
2024-04-25T14:09:00.401348+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=168] type 20 to 13 when flushing.
2024-04-25T14:09:00.401619+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=167] type 20 to 13 when flushing.
2024-04-25T14:09:00.401641+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=166] type 20 to 13 when flushing.
2024-04-25T14:09:00.401648+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=165] type 20 to 13 when flushing.
2024-04-25T14:09:00.401655+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=164] type 20 to 13 when flushing.
2024-04-25T14:09:00.402136+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=163] type 20 to 13 when flushing.
2024-04-25T14:09:00.402176+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=162] type 20 to 13 when flushing.
2024-04-25T14:09:00.402188+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=161] type 20 to 13 when flushing.
2024-04-25T14:09:00.402198+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=160] type 20 to 13 when flushing.
2024-04-25T14:09:00.402649+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=191] type 20 to 13 when flushing.
2024-04-25T14:09:00.402676+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=190] type 20 to 13 when flushing.
2024-04-25T14:09:00.402688+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=189] type 20 to 13 when flushing.
2024-04-25T14:09:00.402724+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=188] type 20 to 13 when flushing.
2024-04-25T14:09:00.403098+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=187] type 20 to 13 when flushing.
2024-04-25T14:09:00.403116+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=186] type 20 to 13 when flushing.
2024-04-25T14:09:00.403123+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=185] type 20 to 13 when flushing.
2024-04-25T14:09:00.403131+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=184] type 20 to 13 when flushing.
2024-04-25T14:09:00.403483+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=183] type 20 to 13 when flushing.
2024-04-25T14:09:00.403500+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=182] type 20 to 13 when flushing.
2024-04-25T14:09:00.403507+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=181] type 20 to 13 when flushing.
2024-04-25T14:09:00.403514+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=180] type 20 to 13 when flushing.
2024-04-25T14:09:00.404134+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=179] type 20 to 13 when flushing.
2024-04-25T14:09:00.404175+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=178] type 20 to 13 when flushing.
2024-04-25T14:09:00.404190+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=177] type 20 to 13 when flushing.
2024-04-25T14:09:00.404239+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=176] type 20 to 13 when flushing.
2024-04-25T14:09:00.405491+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=79] type 20 to 13 when flushing.
2024-04-25T14:09:00.405622+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=78] type 20 to 13 when flushing.
2024-04-25T14:09:00.405688+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=77] type 20 to 13 when flushing.
2024-04-25T14:09:00.405741+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=76] type 20 to 13 when flushing.
2024-04-25T14:09:00.405830+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=75] type 20 to 13 when flushing.
2024-04-25T14:09:00.406700+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=74] type 20 to 13 when flushing.
2024-04-25T14:09:00.406787+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=73] type 20 to 13 when flushing.
2024-04-25T14:09:00.406804+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=72] type 20 to 13 when flushing.
2024-04-25T14:09:00.406822+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=71] type 20 to 13 when flushing.
2024-04-25T14:09:00.407476+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=70] type 20 to 13 when flushing.
2024-04-25T14:09:00.407601+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=69] type 20 to 13 when flushing.
2024-04-25T14:09:00.407618+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=68] type 20 to 13 when flushing.
2024-04-25T14:09:00.407631+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=67] type 20 to 13 when flushing.
2024-04-25T14:09:00.408754+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=66] type 20 to 13 when flushing.
2024-04-25T14:09:00.408811+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=65] type 20 to 13 when flushing.
2024-04-25T14:09:00.408825+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=64] type 20 to 13 when flushing.
2024-04-25T14:09:00.408873+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=95] type 20 to 13 when flushing.
2024-04-25T14:09:00.409392+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=94] type 20 to 13 when flushing.
2024-04-25T14:09:00.409421+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=93] type 20 to 13 when flushing.
2024-04-25T14:09:00.409429+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=92] type 20 to 13 when flushing.
2024-04-25T14:09:00.409437+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=91] type 20 to 13 when flushing.
2024-04-25T14:09:00.409824+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=90] type 20 to 13 when flushing.
2024-04-25T14:09:00.409857+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=89] type 20 to 13 when flushing.
2024-04-25T14:09:00.409874+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=88] type 20 to 13 when flushing.
2024-04-25T14:09:00.409885+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=87] type 20 to 13 when flushing.
2024-04-25T14:09:00.410589+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=86] type 20 to 13 when flushing.
2024-04-25T14:09:00.410624+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=85] type 20 to 13 when flushing.
2024-04-25T14:09:00.410635+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=84] type 20 to 13 when flushing.
2024-04-25T14:09:00.410644+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=83] type 20 to 13 when flushing.
2024-04-25T14:09:00.411331+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=82] type 20 to 13 when flushing.
2024-04-25T14:09:00.411370+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=81] type 20 to 13 when flushing.
2024-04-25T14:09:00.411383+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=80] type 20 to 13 when flushing.
2024-04-25T14:09:00.411393+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=111] type 20 to 13 when flushing.
2024-04-25T14:09:00.411721+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=110] type 20 to 13 when flushing.
2024-04-25T14:09:00.411744+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=109] type 20 to 13 when flushing.
2024-04-25T14:09:00.411754+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=108] type 20 to 13 when flushing.
2024-04-25T14:09:00.411765+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=107] type 20 to 13 when flushing.
2024-04-25T14:09:00.412199+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=106] type 20 to 13 when flushing.
2024-04-25T14:09:00.412251+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=105] type 20 to 13 when flushing.
2024-04-25T14:09:00.412265+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=104] type 20 to 13 when flushing.
2024-04-25T14:09:00.412278+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=103] type 20 to 13 when flushing.
2024-04-25T14:09:00.412735+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=102] type 20 to 13 when flushing.
2024-04-25T14:09:00.412815+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=101] type 20 to 13 when flushing.
2024-04-25T14:09:00.412845+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=100] type 20 to 13 when flushing.
2024-04-25T14:09:00.412932+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=99] type 20 to 13 when flushing.
2024-04-25T14:09:00.413243+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=98] type 20 to 13 when flushing.
2024-04-25T14:09:00.413262+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=97] type 20 to 13 when flushing.
2024-04-25T14:09:00.413269+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=96] type 20 to 13 when flushing.
2024-04-25T14:09:00.413275+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=127] type 20 to 13 when flushing.
2024-04-25T14:09:00.413789+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=126] type 20 to 13 when flushing.
2024-04-25T14:09:00.413811+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=125] type 20 to 13 when flushing.
2024-04-25T14:09:00.413820+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=124] type 20 to 13 when flushing.
2024-04-25T14:09:00.413827+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=123] type 20 to 13 when flushing.
2024-04-25T14:09:00.414244+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=122] type 20 to 13 when flushing.
2024-04-25T14:09:00.414282+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=121] type 20 to 13 when flushing.
2024-04-25T14:09:00.414293+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=120] type 20 to 13 when flushing.
2024-04-25T14:09:00.414300+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=119] type 20 to 13 when flushing.
2024-04-25T14:09:00.414687+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=118] type 20 to 13 when flushing.
2024-04-25T14:09:00.414721+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=117] type 20 to 13 when flushing.
2024-04-25T14:09:00.414734+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=116] type 20 to 13 when flushing.
2024-04-25T14:09:00.414746+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=115] type 20 to 13 when flushing.
2024-04-25T14:09:00.415216+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=114] type 20 to 13 when flushing.
2024-04-25T14:09:00.415246+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=113] type 20 to 13 when flushing.
2024-04-25T14:09:00.415270+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=112] type 20 to 13 when flushing.
2024-04-25T14:09:00.417801+08:00 1 [Note] [MY-011924] [InnoDB] Legacy atomic write buffer created
2024-04-25T14:09:00.417849+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2024-04-25T14:09:00.417903+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-25T14:09:00.432621+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2024-04-25T14:09:00.438998+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2024-04-25T14:09:00.442903+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2024-04-25T14:09:00.446221+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2024-04-25T14:09:00.500483+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 2399391
2024-04-25T14:09:00.502735+08:00 1 [Warning] [MY-011056] [InnoDB] Invalid monitor counter : module_server.
2024-04-25T14:09:00.502993+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-04-25T14:09:00.537565+08:00 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2024-04-25T14:09:00.779578+08:00 1 [Note] [MY-010007] [Server] Installed data dictionary with version 80023
2024-04-25T14:09:00.900421+08:00 2 [Note] [MY-011019] [Server] Created system views with I_S version 80023.
2024-04-25T06:09:01Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=5850d8e16b7845a955d11d6965d9d658fd24b257

Build ID: 5850d8e16b7845a955d11d6965d9d658fd24b257
Server Version: 8.0.32-24 GreatSQL, Release 24, Revision 3714067bc8c

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x80000
/usr/local/greatsql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x225a6cd]
/usr/local/greatsql/bin/mysqld(print_fatal_signal(int)+0x3cf) [0x12b1adf]
/usr/local/greatsql/bin/mysqld(handle_fatal_signal+0xc5) [0x12b1bb5]
/lib64/libpthread.so.0(+0xf630) [0x7f7386813630]
/usr/local/greatsql/bin/mysqld(File_query_log::set_rotated_name(bool)+0x1be) [0xf5254e]
/usr/local/greatsql/bin/mysqld(File_query_log::set_file(char const*)+0x83) [0xf52e33]
/usr/local/greatsql/bin/mysqld(Query_logger::set_log_file(enum_log_table_type)+0x55) [0xf52f35]
/usr/local/greatsql/bin/mysqld() [0xf76051]
/usr/local/greatsql/bin/mysqld(mysqld_main(int, char**)+0x2343) [0xf7dcf3]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f7384d10555]
/usr/local/greatsql/bin/mysqld() [0xd8ef44]
Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/

You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
回复 采纳

举报

驭无殇1998 2024-4-25 14:19:56
yejr 发表于 2024-4-25 10:13
从日志无法直接看出来什么原因。

systemd配置文件中有一行，缺了空格，请先改一下

更换GreatSQL8.0.32-25版本后，依旧报错：
2024-04-25T14:18:26.016843+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
2024-04-25T14:18:26.016911+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
2024-04-25T14:18:26.016919+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2024-04-25T14:18:26.016939+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
2024-04-25T14:18:26.016951+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
2024-04-25T14:18:26.017067+08:00 0 [Note] [MY-010096] [Server] Ignoring --secure-file-priv value as server is running with --initialize(-insecure).
2024-04-25T14:18:26.017078+08:00 0 [Note] [MY-010096] [Server] Ignoring --secure-log-path value as server is running with --initialize(-insecure).
2024-04-25T14:18:26.017163+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=029072ec4fefcea616d05fa2631b046215e2e6dc
2024-04-25T14:18:26.017173+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/.
2024-04-25T14:18:26.017188+08:00 0 [System] [MY-013169] [Server] /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld (mysqld 8.0.32-25) initializing of server in progress as process 15318
2024-04-25T14:18:26.019956+08:00 0 [Note] [MY-010458] [Server] --initialize specified on an existing data directory.
2024-04-25T14:18:26.024772+08:00 0 [Note] [MY-010938] [Server] Generating a new UUID: a02629f6-02cb-11ef-b069-000c295e99d7.
2024-04-25T14:18:26.027193+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2024-04-25T14:18:26.027275+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead.
2024-04-25T14:18:26.027296+08:00 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacity instead.
2024-04-25T14:18:26.027477+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2024-04-25T14:18:26.027610+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2024-04-25T14:18:26.027638+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2024-04-25T14:18:26.027650+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2024-04-25T14:18:26.030106+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-25T14:18:26.030162+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2024-04-25T14:18:26.030184+08:00 1 [Note] [MY-012274] [InnoDB] The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2024-04-25T14:18:26.030206+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2024-04-25T14:18:26.030224+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2024-04-25T14:18:26.030234+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-25T14:18:26.030244+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2024-04-25T14:18:26.033178+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/greatsql/data/#file_purge
2024-04-25T14:18:26.033274+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2024-04-25T14:18:26.033648+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2024-04-25T14:18:26.033699+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2024-04-25T14:18:26.033754+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 0 files.
2024-04-25T14:18:26.035075+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2024-04-25T14:18:26.035121+08:00 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
2024-04-25T14:18:27.196333+08:00 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
2024-04-25T14:18:27.196487+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2024-04-25T14:18:27.203590+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2024-04-25T14:18:27.235702+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-25T14:18:27.249763+08:00 1 [Note] [MY-012266] [InnoDB] File './ibdata1' size is now 12 MB.
2024-04-25T14:18:27.249909+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 16
2024-04-25T14:18:27.249926+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2024-04-25T14:18:27.250031+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2024-04-25T14:18:27.250386+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2024-04-25T14:18:27.252065+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
2024-04-25T14:18:27.252513+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
2024-04-25T14:18:27.253917+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
2024-04-25T14:18:27.254238+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
2024-04-25T14:18:27.255200+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
2024-04-25T14:18:27.255401+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
2024-04-25T14:18:27.256308+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
2024-04-25T14:18:27.256493+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
2024-04-25T14:18:27.257668+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
2024-04-25T14:18:27.258134+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
2024-04-25T14:18:27.260297+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
2024-04-25T14:18:27.261104+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
2024-04-25T14:18:27.262314+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
2024-04-25T14:18:27.262636+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
2024-04-25T14:18:27.350112+08:00 1 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=8204
2024-04-25T14:18:27.350390+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2024-04-25T14:18:27.389254+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_001
2024-04-25T14:18:27.389402+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_001 size to 16 MB
2024-04-25T14:18:27.389435+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2024-04-25T14:18:27.413131+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace ./undo_002
2024-04-25T14:18:27.413191+08:00 1 [Note] [MY-012897] [InnoDB] Setting file ./undo_002 size to 16 MB
2024-04-25T14:18:27.413243+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2024-04-25T14:18:27.434009+08:00 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2024-04-25T14:18:27.434650+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2024-04-25T14:18:27.444399+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2024-04-25T14:18:27.444535+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 9897 ms.
2024-04-25T14:18:27.448050+08:00 1 [Note] [MY-011920] [InnoDB] Legacy doublewrite buffer not found: creating new
2024-04-25T14:18:27.451566+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=24] type 20 to 13 when flushing.
2024-04-25T14:18:27.451729+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=23] type 20 to 13 when flushing.
2024-04-25T14:18:27.451749+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=22] type 20 to 13 when flushing.
2024-04-25T14:18:27.451760+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=21] type 20 to 13 when flushing.
2024-04-25T14:18:27.452529+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=20] type 20 to 13 when flushing.
2024-04-25T14:18:27.452563+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=19] type 20 to 13 when flushing.
2024-04-25T14:18:27.452572+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=18] type 20 to 13 when flushing.
2024-04-25T14:18:27.452580+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=17] type 20 to 13 when flushing.
2024-04-25T14:18:27.453287+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=16] type 20 to 13 when flushing.
2024-04-25T14:18:27.453350+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=15] type 20 to 13 when flushing.
2024-04-25T14:18:27.453359+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=14] type 20 to 13 when flushing.
2024-04-25T14:18:27.453366+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=13] type 20 to 13 when flushing.
2024-04-25T14:18:27.453755+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=12] type 20 to 13 when flushing.
2024-04-25T14:18:27.453778+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=11] type 20 to 13 when flushing.
2024-04-25T14:18:27.453788+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=10] type 20 to 13 when flushing.
2024-04-25T14:18:27.453795+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=9] type 20 to 13 when flushing.
2024-04-25T14:18:27.454344+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=40] type 20 to 13 when flushing.
2024-04-25T14:18:27.454386+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=39] type 20 to 13 when flushing.
2024-04-25T14:18:27.454407+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=38] type 20 to 13 when flushing.
2024-04-25T14:18:27.454419+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=37] type 20 to 13 when flushing.
2024-04-25T14:18:27.454907+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=36] type 20 to 13 when flushing.
2024-04-25T14:18:27.454928+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=35] type 20 to 13 when flushing.
2024-04-25T14:18:27.454936+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=34] type 20 to 13 when flushing.
2024-04-25T14:18:27.454943+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=33] type 20 to 13 when flushing.
2024-04-25T14:18:27.455262+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=32] type 20 to 13 when flushing.
2024-04-25T14:18:27.455299+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=31] type 20 to 13 when flushing.
2024-04-25T14:18:27.455308+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=30] type 20 to 13 when flushing.
2024-04-25T14:18:27.455316+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=29] type 20 to 13 when flushing.
2024-04-25T14:18:27.455730+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=28] type 20 to 13 when flushing.
2024-04-25T14:18:27.455750+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=27] type 20 to 13 when flushing.
2024-04-25T14:18:27.455758+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=26] type 20 to 13 when flushing.
2024-04-25T14:18:27.455765+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=25] type 20 to 13 when flushing.
2024-04-25T14:18:27.456152+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=143] type 20 to 13 when flushing.
2024-04-25T14:18:27.456185+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=142] type 20 to 13 when flushing.
2024-04-25T14:18:27.456196+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=141] type 20 to 13 when flushing.
2024-04-25T14:18:27.456204+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=140] type 20 to 13 when flushing.
2024-04-25T14:18:27.456559+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=139] type 20 to 13 when flushing.
2024-04-25T14:18:27.456585+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=138] type 20 to 13 when flushing.
2024-04-25T14:18:27.456594+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=137] type 20 to 13 when flushing.
2024-04-25T14:18:27.456603+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=136] type 20 to 13 when flushing.
2024-04-25T14:18:27.458400+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=135] type 20 to 13 when flushing.
2024-04-25T14:18:27.458435+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=134] type 20 to 13 when flushing.
2024-04-25T14:18:27.458447+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=133] type 20 to 13 when flushing.
2024-04-25T14:18:27.458457+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=132] type 20 to 13 when flushing.
2024-04-25T14:18:27.458958+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=131] type 20 to 13 when flushing.
2024-04-25T14:18:27.459002+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=130] type 20 to 13 when flushing.
2024-04-25T14:18:27.459013+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=129] type 20 to 13 when flushing.
2024-04-25T14:18:27.459023+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=128] type 20 to 13 when flushing.
2024-04-25T14:18:27.459855+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=159] type 20 to 13 when flushing.
2024-04-25T14:18:27.459933+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=158] type 20 to 13 when flushing.
2024-04-25T14:18:27.459956+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=157] type 20 to 13 when flushing.
2024-04-25T14:18:27.459971+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=156] type 20 to 13 when flushing.
2024-04-25T14:18:27.460466+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=155] type 20 to 13 when flushing.
2024-04-25T14:18:27.460497+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=154] type 20 to 13 when flushing.
2024-04-25T14:18:27.460511+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=153] type 20 to 13 when flushing.
2024-04-25T14:18:27.460538+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=152] type 20 to 13 when flushing.
2024-04-25T14:18:27.460948+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=151] type 20 to 13 when flushing.
2024-04-25T14:18:27.461006+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=150] type 20 to 13 when flushing.
2024-04-25T14:18:27.461035+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=149] type 20 to 13 when flushing.
2024-04-25T14:18:27.461136+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=148] type 20 to 13 when flushing.
2024-04-25T14:18:27.461825+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=147] type 20 to 13 when flushing.
2024-04-25T14:18:27.461857+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=146] type 20 to 13 when flushing.
2024-04-25T14:18:27.461867+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=145] type 20 to 13 when flushing.
2024-04-25T14:18:27.461876+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=144] type 20 to 13 when flushing.
2024-04-25T14:18:27.462258+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=175] type 20 to 13 when flushing.
2024-04-25T14:18:27.462284+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=174] type 20 to 13 when flushing.
2024-04-25T14:18:27.462292+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=173] type 20 to 13 when flushing.
2024-04-25T14:18:27.462301+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=172] type 20 to 13 when flushing.
2024-04-25T14:18:27.462969+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=171] type 20 to 13 when flushing.
2024-04-25T14:18:27.463018+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=170] type 20 to 13 when flushing.
2024-04-25T14:18:27.463031+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=169] type 20 to 13 when flushing.
2024-04-25T14:18:27.463041+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=168] type 20 to 13 when flushing.
2024-04-25T14:18:27.463434+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=167] type 20 to 13 when flushing.
2024-04-25T14:18:27.463482+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=166] type 20 to 13 when flushing.
2024-04-25T14:18:27.463494+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=165] type 20 to 13 when flushing.
2024-04-25T14:18:27.463504+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=164] type 20 to 13 when flushing.
2024-04-25T14:18:27.463936+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=163] type 20 to 13 when flushing.
2024-04-25T14:18:27.463964+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=162] type 20 to 13 when flushing.
2024-04-25T14:18:27.463973+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=161] type 20 to 13 when flushing.
2024-04-25T14:18:27.463981+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=160] type 20 to 13 when flushing.
2024-04-25T14:18:27.464480+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=191] type 20 to 13 when flushing.
2024-04-25T14:18:27.464509+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=190] type 20 to 13 when flushing.
2024-04-25T14:18:27.464530+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=189] type 20 to 13 when flushing.
2024-04-25T14:18:27.464631+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=188] type 20 to 13 when flushing.
2024-04-25T14:18:27.465093+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=187] type 20 to 13 when flushing.
2024-04-25T14:18:27.465116+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=186] type 20 to 13 when flushing.
2024-04-25T14:18:27.465124+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=185] type 20 to 13 when flushing.
2024-04-25T14:18:27.465131+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=184] type 20 to 13 when flushing.
2024-04-25T14:18:27.465398+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=183] type 20 to 13 when flushing.
2024-04-25T14:18:27.465415+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=182] type 20 to 13 when flushing.
2024-04-25T14:18:27.465423+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=181] type 20 to 13 when flushing.
2024-04-25T14:18:27.465430+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=180] type 20 to 13 when flushing.
2024-04-25T14:18:27.465937+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=179] type 20 to 13 when flushing.
2024-04-25T14:18:27.465990+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=178] type 20 to 13 when flushing.
2024-04-25T14:18:27.466000+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=177] type 20 to 13 when flushing.
2024-04-25T14:18:27.466009+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=176] type 20 to 13 when flushing.
2024-04-25T14:18:27.466971+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=79] type 20 to 13 when flushing.
2024-04-25T14:18:27.466997+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=78] type 20 to 13 when flushing.
2024-04-25T14:18:27.467009+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=77] type 20 to 13 when flushing.
2024-04-25T14:18:27.467083+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=76] type 20 to 13 when flushing.
2024-04-25T14:18:27.467106+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=75] type 20 to 13 when flushing.
2024-04-25T14:18:27.467459+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=74] type 20 to 13 when flushing.
2024-04-25T14:18:27.467485+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=73] type 20 to 13 when flushing.
2024-04-25T14:18:27.467505+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=72] type 20 to 13 when flushing.
2024-04-25T14:18:27.467516+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=71] type 20 to 13 when flushing.
2024-04-25T14:18:27.468114+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=70] type 20 to 13 when flushing.
2024-04-25T14:18:27.468139+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=69] type 20 to 13 when flushing.
2024-04-25T14:18:27.468150+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=68] type 20 to 13 when flushing.
2024-04-25T14:18:27.468178+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=67] type 20 to 13 when flushing.
2024-04-25T14:18:27.468599+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=66] type 20 to 13 when flushing.
2024-04-25T14:18:27.468632+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=65] type 20 to 13 when flushing.
2024-04-25T14:18:27.468645+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=64] type 20 to 13 when flushing.
2024-04-25T14:18:27.468659+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=95] type 20 to 13 when flushing.
2024-04-25T14:18:27.469001+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=94] type 20 to 13 when flushing.
2024-04-25T14:18:27.469056+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=93] type 20 to 13 when flushing.
2024-04-25T14:18:27.469077+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=92] type 20 to 13 when flushing.
2024-04-25T14:18:27.469168+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=91] type 20 to 13 when flushing.
2024-04-25T14:18:27.469569+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=90] type 20 to 13 when flushing.
2024-04-25T14:18:27.469597+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=89] type 20 to 13 when flushing.
2024-04-25T14:18:27.469606+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=88] type 20 to 13 when flushing.
2024-04-25T14:18:27.469615+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=87] type 20 to 13 when flushing.
2024-04-25T14:18:27.469945+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=86] type 20 to 13 when flushing.
2024-04-25T14:18:27.469992+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=85] type 20 to 13 when flushing.
2024-04-25T14:18:27.470004+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=84] type 20 to 13 when flushing.
2024-04-25T14:18:27.470015+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=83] type 20 to 13 when flushing.
2024-04-25T14:18:27.470335+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=82] type 20 to 13 when flushing.
2024-04-25T14:18:27.470350+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=81] type 20 to 13 when flushing.
2024-04-25T14:18:27.470357+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=80] type 20 to 13 when flushing.
2024-04-25T14:18:27.470365+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=111] type 20 to 13 when flushing.
2024-04-25T14:18:27.470719+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=110] type 20 to 13 when flushing.
2024-04-25T14:18:27.470770+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=109] type 20 to 13 when flushing.
2024-04-25T14:18:27.470778+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=108] type 20 to 13 when flushing.
2024-04-25T14:18:27.470785+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=107] type 20 to 13 when flushing.
2024-04-25T14:18:27.471079+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=106] type 20 to 13 when flushing.
2024-04-25T14:18:27.471098+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=105] type 20 to 13 when flushing.
2024-04-25T14:18:27.471107+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=104] type 20 to 13 when flushing.
2024-04-25T14:18:27.471118+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=103] type 20 to 13 when flushing.
2024-04-25T14:18:27.471440+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=102] type 20 to 13 when flushing.
2024-04-25T14:18:27.471454+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=101] type 20 to 13 when flushing.
2024-04-25T14:18:27.471462+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=100] type 20 to 13 when flushing.
2024-04-25T14:18:27.471468+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=99] type 20 to 13 when flushing.
2024-04-25T14:18:27.471752+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=98] type 20 to 13 when flushing.
2024-04-25T14:18:27.471768+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=97] type 20 to 13 when flushing.
2024-04-25T14:18:27.471777+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=96] type 20 to 13 when flushing.
2024-04-25T14:18:27.471790+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=127] type 20 to 13 when flushing.
2024-04-25T14:18:27.472055+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=126] type 20 to 13 when flushing.
2024-04-25T14:18:27.472075+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=125] type 20 to 13 when flushing.
2024-04-25T14:18:27.472083+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=124] type 20 to 13 when flushing.
2024-04-25T14:18:27.472091+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=123] type 20 to 13 when flushing.
2024-04-25T14:18:27.472406+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=122] type 20 to 13 when flushing.
2024-04-25T14:18:27.472436+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=121] type 20 to 13 when flushing.
2024-04-25T14:18:27.472444+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=120] type 20 to 13 when flushing.
2024-04-25T14:18:27.472452+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=119] type 20 to 13 when flushing.
2024-04-25T14:18:27.472769+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=118] type 20 to 13 when flushing.
2024-04-25T14:18:27.472828+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=117] type 20 to 13 when flushing.
2024-04-25T14:18:27.472854+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=116] type 20 to 13 when flushing.
2024-04-25T14:18:27.472920+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=115] type 20 to 13 when flushing.
2024-04-25T14:18:27.473239+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=114] type 20 to 13 when flushing.
2024-04-25T14:18:27.473257+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=113] type 20 to 13 when flushing.
2024-04-25T14:18:27.473265+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=112] type 20 to 13 when flushing.
2024-04-25T14:18:27.477350+08:00 1 [Note] [MY-011924] [InnoDB] Legacy atomic write buffer created
2024-04-25T14:18:27.477435+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2024-04-25T14:18:27.477500+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-25T14:18:27.487068+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2024-04-25T14:18:27.493928+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2024-04-25T14:18:27.497321+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2024-04-25T14:18:27.500459+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2024-04-25T14:18:27.553701+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-8.0.32 started; log sequence number 2399391
2024-04-25T14:18:27.555497+08:00 1 [Warning] [MY-011056] [InnoDB] Invalid monitor counter : module_server.
2024-04-25T14:18:27.555800+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-04-25T14:18:27.558958+08:00 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80023'.
2024-04-25T14:18:27.773292+08:00 1 [Note] [MY-010007] [Server] Installed data dictionary with version 80023
2024-04-25T14:18:27.858148+08:00 2 [Note] [MY-011019] [Server] Created system views with I_S version 80023.
2024-04-25T06:18:28Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=029072ec4fefcea616d05fa2631b046215e2e6dc

Build ID: 029072ec4fefcea616d05fa2631b046215e2e6dc
Server Version: 8.0.32-25 GreatSQL, Release 25, Revision 79f57097e3f

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x80000
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x2322cdd]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(print_fatal_signal(int)+0x3cf) [0x135b0cf]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(handle_fatal_signal+0xc5) [0x135b1a5]
/lib64/libpthread.so.0(+0xf630) [0x7f741d60c630]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(File_query_log::set_rotated_name(bool)+0x1be) [0xfa34ee]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(File_query_log::set_file(char const*)+0x83) [0xfa3dd3]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(Query_logger::set_log_file(enum_log_table_type)+0x55) [0xfa3ed5]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld() [0xfc7c91]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld(mysqld_main(int, char**)+0x2343) [0xfcf923]
/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f741bb09555]
/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld() [0xdba084]
Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/

You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
2024-04-25T14:18:28.937179+08:00 0 [Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)
2024-04-25T14:18:29.201202+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
2024-04-25T14:18:29.201320+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
2024-04-25T14:18:29.201340+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
2024-04-25T14:18:29.201367+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
2024-04-25T14:18:29.201392+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
2024-04-25T14:18:29.201534+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-04-25T14:18:29.201547+08:00 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-04-25T14:18:29.201654+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=029072ec4fefcea616d05fa2631b046215e2e6dc
2024-04-25T14:18:29.201665+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/.
2024-04-25T14:18:29.201677+08:00 0 [System] [MY-010116] [Server] /usr/local/greatsql/bin/mysqld (mysqld 8.0.32-25) starting as process 15396
2024-04-25T14:18:29.215896+08:00 0 [Warning] [MY-012364] [InnoDB] innodb_open_files should not be greater than the open_files_limit.
2024-04-25T14:18:29.216031+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2024-04-25T14:18:29.216089+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead.
2024-04-25T14:18:29.216108+08:00 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacity instead.
2024-04-25T14:18:29.216502+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2024-04-25T14:18:29.216668+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2024-04-25T14:18:29.216722+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2024-04-25T14:18:29.216741+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2024-04-25T14:18:29.220294+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-04-25T14:18:29.220520+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2024-04-25T14:18:29.220598+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2024-04-25T14:18:29.220625+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2024-04-25T14:18:29.220641+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-25T14:18:29.220658+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2024-04-25T14:18:29.228377+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/greatsql/data/#file_purge
2024-04-25T14:18:29.228892+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2024-04-25T14:18:29.230413+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2024-04-25T14:18:29.230663+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2024-04-25T14:18:29.235174+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 3 files.
2024-04-25T14:18:29.236989+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 8, chunk size =128.000000M
2024-04-25T14:18:29.237074+08:00 1 [Note] [MY-011872] [InnoDB] Setting NUMA memory policy to MPOL_INTERLEAVE
2024-04-25T14:18:30.673600+08:00 1 [Note] [MY-011874] [InnoDB] Setting NUMA memory policy to MPOL_DEFAULT
2024-04-25T14:18:30.673746+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2024-04-25T14:18:30.681736+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority().
2024-04-25T14:18:30.711301+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2024-04-25T14:18:30.711643+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2024-04-25T14:18:30.713732+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_2.dblwr' for doublewrite
2024-04-25T14:18:30.714301+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_3.dblwr' for doublewrite
2024-04-25T14:18:30.717269+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_4.dblwr' for doublewrite
2024-04-25T14:18:30.717752+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_5.dblwr' for doublewrite
2024-04-25T14:18:30.720048+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_6.dblwr' for doublewrite
2024-04-25T14:18:30.720396+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_7.dblwr' for doublewrite
2024-04-25T14:18:30.727868+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_8.dblwr' for doublewrite
2024-04-25T14:18:30.728497+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_9.dblwr' for doublewrite
2024-04-25T14:18:30.731098+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_10.dblwr' for doublewrite
2024-04-25T14:18:30.731534+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_11.dblwr' for doublewrite
2024-04-25T14:18:30.734078+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_12.dblwr' for doublewrite
2024-04-25T14:18:30.734883+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_13.dblwr' for doublewrite
2024-04-25T14:18:30.737995+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_14.dblwr' for doublewrite
2024-04-25T14:18:30.738558+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_15.dblwr' for doublewrite
2024-04-25T14:18:30.741925+08:00 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-04-25T14:18:31.710248+08:00 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-04-25T14:18:31.710891+08:00 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-04-25T14:18:31.711013+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2024-04-25T14:18:31.711093+08:00 0 [Note] [MY-010120] [Server] Binlog end
2024-04-25T14:18:31.711240+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2024-04-25T14:18:31.711314+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2024-04-25T14:18:31.711387+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2024-04-25T14:18:31.711404+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2024-04-25T14:18:31.711907+08:00 0 [System] [MY-010910] [Server] /usr/local/greatsql/bin/mysqld: Shutdown complete (mysqld 8.0.32-25)  GreatSQL, Release 25, Revision 79f57097e3f.
回复 采纳

举报

驭无殇1998 2024-4-25 15:07:24
我将虚拟机重新恢复初始状态，然后重新按照步骤来，发现又可以了，就是配置文件修改了一下：

以下是操作步骤：

关闭swap
swapoff -a
修改/etc/sysctl.conf配置
echo "vm.swappiness = 0">> /etc/sysctl.conf
刷新生效
sysctl -p

先检查当前设置：
cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
如果输出结果不是 never 的话，则需要执行下面的命令关闭：
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag

建议调整优化下面几个内核参数：
echo "fs.file-max = 1000000" >> /etc/sysctl.conf
echo "net.core.somaxconn = 32768" >> /etc/sysctl.conf
echo "net.ipv4.tcp_tw_recycle = 0" >> /etc/sysctl.conf
echo "net.ipv4.tcp_syncookies = 0" >> /etc/sysctl.conf
echo "vm.overcommit_memory = 1" >> /etc/sysctl.conf
刷新生效
sysctl -p

修改 /etc/security/limits.conf 系统文件，调高mysql系统账户的上限：
vim /etc/security/limits.conf
填入以下内容：
*           soft    nofile         65535
*           hard    nofile         65535
*           soft    stack          32768
*           hard    stack          32768
*           soft    nproc          65535
*           hard    nproc          65535

yum安装相关依赖
yum install -y perl libaio-devel numactl-devel numactl-libs net-tools openssl openssl-devel pkg-config
将rpm包上传，然后执行命令安装：
rpm -ivh jemalloc-5.3.0-1.el7.x86_64.rpm
添加动态库
echo ' /usr/local/jemalloc/lib/ ' > /etc/ld.so.conf.d/jemalloc.conf
刷新动态库
ldconfig
再次查看jemalloc 是否安装
ldconfig -p | grep jemalloc
添加/修改系统文件 /etc/sysconfig/mysql：
echo -e "LD_PRELOAD=/usr/local/jemalloc/lib/libjemalloc.so\nTHP_SETTING=never" > /etc/sysconfig/mysql

解压安装包
tar -xf GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64.tar.xz -C /usr/local
创建软链接（方便以后升级）
ln -s /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64 /usr/local/greatsql
添加全局变量
vim /etc/profile
补充以下内容：
# GREATSQL_HOME
export GREATSQL_HOME=/usr/local/greatsql
# PATH
export PATH=$PATHGREATSQL_HOME/bin
刷新全局变量
source /etc/profile

准备配置文件：
[client]
user = mysql
socket        = /data/greatsql/run/mysql.sock

[mysql]
loose-skip-binary-as-hex
prompt = "(\\D)[\\u@GreatSQL][\\d]>"
no-auto-rehash

[mysqld]
user        = mysql
port        = 3306
#主从复制或MGR集群中，server_id记得要不同
#另外，实例启动时会生成 auto.cnf，里面的 server_uuid 值也要不同
#server_uuid的值还可以自己手动指定，只要符合uuid的格式标准就可以
server_id = 3306
basedir = /usr/local/greatsql
datadir        = /data/greatsql/data
socket        = /data/greatsql/run/mysql.sock
pid-file = /data/greatsql/run/mysql.pid
character-set-server = UTF8MB4
skip_name_resolve = 1
#若你的MySQL数据库主要运行在境外，请务必根据实际情况调整本参数
default_time_zone = "+8:00"
bind_address = "0.0.0.0"

#performance setttings
lock_wait_timeout = 3600
open_files_limit    = 65535
back_log = 1024
max_connections = 2000
max_connect_errors = 1000000
table_open_cache = 1024
table_definition_cache = 1024
thread_stack = 512K
sort_buffer_size = 4M
join_buffer_size = 4M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 64M
thread_cache_size = 768
interactive_timeout = 600
wait_timeout = 600
tmp_table_size = 32M
max_heap_table_size = 32M
max_allowed_packet = 64M
net_buffer_shrink_interval = 180
#GIPK
loose-sql_generate_invisible_primary_key = ON

#开启SSL认证
#ssl-ca=/data/greatsql/ssl/ca.pem
#ssl-cert=/data/greatsql/ssl/server-cert.pem
#ssl-key=/data/greatsql/ssl/server-key.pem
#log settings
#开启general日志
general_log = off
general_log_file = /data/greatsql/logs/audit.log
log_timestamps = SYSTEM
log_error = /data/greatsql/logs/error.log
log_error_verbosity = 3
slow_query_log = 1
log_slow_extra = 1
slow_query_log_file = /data/greatsql/logs/slow.log
#设置slow log文件大小1G及总文件数10
max_slowlog_size = 1073741824
max_slowlog_files = 10
long_query_time = 2
log_queries_not_using_indexes = 1
log_throttle_queries_not_using_indexes = 60
min_examined_row_limit = 100
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_bin = /data/greatsql/logs/binlog
log-bin-index= /data/greatsql/logs/binlog.index
binlog_format = ROW
sync_binlog = 1
binlog_cache_size = 4M
max_binlog_cache_size = 2G
max_binlog_size = 1G
#控制binlog总大小，避免磁盘空间被撑爆
binlog_space_limit = 50G
binlog_rows_query_log_events = 1
binlog_expire_logs_seconds = 604800
#MySQL 8.0.22前，想启用MGR的话，需要设置binlog_checksum=NONE才行
binlog_checksum = CRC32
gtid_mode = ON
enforce_gtid_consistency = TRUE

#myisam settings
key_buffer_size = 32M
myisam_sort_buffer_size = 128M

#replication settings
relay_log_recovery = 1
slave_parallel_type = LOGICAL_CLOCK
#可以设置为逻辑CPU数量的2倍
replica_parallel_workers = 4
binlog_transaction_dependency_tracking = WRITESET
slave_preserve_commit_order = 1
slave_checkpoint_period = 2

##mgr settings
#loose-plugin_load_add = 'mysql_clone.so'
#loose-plugin_load_add = 'group_replication.so'
#loose-group_replication_group_name = "c20a1190-8366-4da4-acd5-82dec9cd0e91"
##MGR本地节点IPORT，请自行替换
#loose-group_replication_local_address = "greatsql_cluster_node1:33061"
##MGR集群所有节点IPORT，请自行替换
#loose-group_replication_group_seeds = "greatsql_cluster_node1:33061,greatsql_cluster_node2:33061,greatsql_cluster_node3:33061"
#loose-group_replication_start_on_boot = OFF
#loose-group_replication_bootstrap_group = OFF
#loose-group_replication_exit_state_action = READ_ONLY
#loose-group_replication_flow_control_mode = "DISABLED"
#loose-group_replication_single_primary_mode = ON
#loose-group_replication_majority_after_mode = ON
#loose-group_replication_communication_max_message_size = 10M
#loose-group_replication_arbitrator = 0
#loose-group_replication_single_primary_fast_mode = 1
#loose-group_replication_request_time_threshold = 100
#loose-group_replication_primary_election_mode = GTID_FIRST
#loose-group_replication_unreachable_majority_timeout = 0
#loose-group_replication_member_expel_timeout = 5
#loose-group_replication_autorejoin_tries = 288
##report_host = "xxx.xxx.xx.xxx"

#innodb settings
innodb_buffer_pool_size = 1G
innodb_buffer_pool_instances = 8
innodb_data_file_path = ibdata1:12M:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 2G
innodb_log_files_in_group = 3
innodb_redo_log_capacity = 6G
innodb_max_undo_log_size = 4G
# 根据您的服务器IOPS能力适当调整
# 一般配普通SSD盘的话，可以调整到 10000 - 20000
# 配置高端PCIe SSD卡的话，则可以调整的更高，比如 50000 - 80000
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_open_files = 65535
innodb_flush_method = O_DIRECT
innodb_lru_scan_depth = 4000
innodb_lock_wait_timeout = 10
innodb_rollback_on_timeout = 1
innodb_print_all_deadlocks = 1
innodb_online_alter_log_max_size = 4G
innodb_print_ddl_logs = 0
innodb_status_file = 1
#注意: 开启 innodb_status_output & innodb_status_output_locks 后, 可能会导致log_error文件增长较快
innodb_status_output = 0
innodb_status_output_locks = 1
innodb_sort_buffer_size = 67108864
innodb_adaptive_hash_index = 0
#开启NUMA支持
innodb_numa_interleave = ON
innodb_print_lock_wait_timeout_info = 1
#自动杀掉超过5分钟不活跃事务，避免行锁被长时间持有
kill_idle_transaction = 300
#异步清理大表
#innodb_data_file_async_purge = ON

#innodb monitor settings
innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash"

#innodb parallel query
loose-force_parallel_execute = OFF
loose-parallel_default_dop = 8
loose-parallel_max_threads = 8
loose-parallel_memory_limit = 512M

#pfs settings
performance_schema = 1
#performance_schema_instrument = '%memory%=on'
performance_schema_instrument = '%lock%=on'
performance_schema_session_connect_attrs_size = 4096


新建mysql用户：
groupadd mysql && useradd -g mysql mysql -M -s /sbin/nologin
新建数据及日志目录
mkdir -p /data/greatsql/{data,logs,run}
新建初始化临时目录
mkdir -p /var/lib/mysql-files
修改所属用户
chown mysql:mysql -R /data/greatsql
chown mysql:mysql -R /var/lib/mysql-files
chown mysql:mysql -R /usr/local/GreatSQL-8.0.32-24-Linux-glibc2.17-x86_64/ /usr/local/greatsql
增加NUMA支持
编辑文件
vim /etc/systemd/system.conf
增加以下内容：(若是已有则可忽略)
NUMAPolicy=interleave
编辑gretasql的systemd启动文件
vim /etc/systemd/system/greatsql.service
填入以下内容：
[Unit]
Description=GreatSQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
# some limits
# file size
LimitFSIZE=infinity
# cpu time
LimitCPU=infinity
# virtual memory size
LimitAS=infinity
# open files
LimitNOFILE=65535
# processes/threads
LimitNPROC=65535
# locked memory
LimitMEMLOCK=infinity
# total threads (user+kernel)
TasksMax=infinity
TasksAccounting=false

User=mysql
Group=mysql
#如果是GreatSQL 5.7版本，此处需要改成simple模式，否则可能服务启用异常
#如果是GreatSQL 8.0版本则可以使用notify模式
#Type=simple
Type=notify
TimeoutSec=0
PermissionsStartOnly=true
ExecStartPre=/usr/local/greatsql/bin/mysqld_pre_systemd
ExecStart=/usr/local/greatsql/bin/mysqld $MYSQLD_OPTS
EnvironmentFile=-/etc/sysconfig/mysql
LimitNOFILE = 10000
Restart=on-failure
RestartPreventExitStatus=1
Environment=MYSQLD_PARENT_PID=1
PrivateTmp=false

重新加载systemd
systemctl daemon-reload
执行下面的命令启动GreatSQL服务
systemctl start greatsql
回复 采纳

举报

yejr 2024-4-25 15:31:30
驭无殇1998 发表于 2024-4-25 15:07
我将虚拟机重新恢复初始状态，然后重新按照步骤来，发现又可以了，就是配置文件修改了一下：

以下是操作步 ...

看起来像是你的虚机环境有问题导致的，比如文件系统错误等原因
回复 采纳

举报

驭无殇1998 2024-4-25 15:34:46
yejr 发表于 2024-4-25 15:31
看起来像是你的虚机环境有问题导致的，比如文件系统错误等原因

但是这个问题我前俩天在我们公司的测试环境安装的时候也会出现，所以才在本地虚拟机想测试看看是什么问题。不过在测试环境是把NUMA的配置注释掉后就正常初始化，在我虚拟机这里，我前面几次初始化虚拟机都是有问题，后面换了一台虚拟机执行就没问题了，然后又回到之前的虚拟机，又可以了，我怀疑可能是某个配置导致的
回复 采纳

举报

yejr 2024-4-25 15:43:50
驭无殇1998 发表于 2024-4-25 15:34
但是这个问题我前俩天在我们公司的测试环境安装的时候也会出现，所以才在本地虚拟机想测试看看是什么问题 ...

这样吧，看能不能找到可以稳定复现的规律哈，也没准真的存在某些未知bug
回复 采纳

举报

驭无殇1998 2024-4-28 09:43:26
yejr 发表于 2024-4-25 15:43
这样吧，看能不能找到可以稳定复现的规律哈，也没准真的存在某些未知bug ...

嗯嗯，我后面空闲的时候都试一下，哈哈哈哈
回复 采纳

举报

reddey 2024-5-1 17:01:30
本帖最后由 15167759230 于 2024-5-1 17:04 编辑
驭无殇1998 发表于 2024-4-28 09:43
嗯嗯，我后面空闲的时候都试一下，哈哈哈哈

建议在虚拟机做实验时，虚拟机环境最好是干净的。然后按官方文档做实验，我在二进制安装时，启动数据库后，系统中没生成日志文件，也就没找到ROOT用户的密码。反复试用各种数据库安装包，还是同样问题。后来恢复快照为最初操作系统安装时状态。重新做实验，问题解决了。
一个学艺不精的国产数据库爱好者
回复 采纳

举报

下一页 »
12下一页
驭无殇1998

22

主题

0

博客

181

贡献

中级会员

Rank: 3Rank: 3

积分
297

勤学好问（铜）助人为乐（银）

发消息
互动与交流
社区活动
论坛问答
加入社区
贡献者指南
学习与应用
文章博客
文档资料
视频资料
常见问题
发现社区
社区准则
建议反馈
社区之星

合作电话：010-64087828

社区邮箱：greatsql@greatdb.com

社区公众号
社区小助手
QQ群
友情链接
万里数据库开源中国墨天轮开放原子开源基金会OpenEuler
©2022 GreatSQL All Rights Reserved. ( 京ICP备06057874号 )
GMT+8, 2024-12-4 15:48 , Processed in 0.033228 second(s), 22 queries , Redis On.
快速回复 返回顶部 返回列表