VPS侦探论坛

标题: mariadb 启动不了，是什么问题 [打印本页]

作者: ww82ke 时间: 2020-12-26 15:29
标题: mariadb 启动不了，是什么问题
2020-12-26 15:28:26 0 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/usr/local/mariadb/var/aria_log_control'
2020-12-26 15:28:26 0 [ERROR] Plugin 'Aria' init function returned error.
2020-12-26 15:28:26 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:26 0 [Note] InnoDB: Using Linux native AIO
2020-12-26 15:28:26 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-26 15:28:26 0 [Note] InnoDB: Uses event mutexes
2020-12-26 15:28:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-26 15:28:26 0 [Note] InnoDB: Number of pools: 1
2020-12-26 15:28:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-26 15:28:26 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-12-26 15:28:26 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-12-26 15:28:26 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-26 15:28:26 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-26 15:28:26 0 [ERROR] InnoDB: The Auto-extending innodb_system data file '/usr/local/mariadb/var/ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 640 pages, max 0 (relevant if non-zero) pages!
2020-12-26 15:28:26 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-26 15:28:26 0 [Note] InnoDB: Starting shutdown...
2020-12-26 15:28:26 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-26 15:28:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-26 15:28:26 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-12-26 15:28:26 0 [ERROR] Failed to initialize plugins.
2020-12-26 15:28:26 0 [ERROR] Aborting
2020-12-26 15:28:29 0 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/usr/local/mariadb/var/aria_log_control'
2020-12-26 15:28:29 0 [ERROR] Plugin 'Aria' init function returned error.
2020-12-26 15:28:29 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:29 0 [Note] InnoDB: Using Linux native AIO
2020-12-26 15:28:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-26 15:28:29 0 [Note] InnoDB: Uses event mutexes
2020-12-26 15:28:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-26 15:28:29 0 [Note] InnoDB: Number of pools: 1
2020-12-26 15:28:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-26 15:28:29 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-12-26 15:28:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-12-26 15:28:29 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-26 15:28:29 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-26 15:28:29 0 [ERROR] InnoDB: The Auto-extending innodb_system data file '/usr/local/mariadb/var/ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 640 pages, max 0 (relevant if non-zero) pages!
2020-12-26 15:28:29 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-26 15:28:29 0 [Note] InnoDB: Starting shutdown...
2020-12-26 15:28:29 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-26 15:28:29 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-26 15:28:29 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-12-26 15:28:29 0 [ERROR] Failed to initialize plugins.
2020-12-26 15:28:29 0 [ERROR] Aborting

作者: licess 时间: 2020-12-26 19:59
你自己改动了配置文件autoextend那边吧

作者: ww82ke 时间: 2020-12-27 09:09

licess 发表于 2020-12-26 19:59
你自己改动了配置文件autoextend那边吧

没有改过

作者: ww82ke 时间: 2020-12-27 09:11

licess 发表于 2020-12-26 19:59
你自己改动了配置文件autoextend那边吧

[client]
#password = your_password
port       = 3306
socket    = /tmp/mysql.sock

[mysqld]
port       = 3306
socket    = /tmp/mysql.sock
user = mariadb
basedir = /usr/local/mariadb
datadir = /usr/local/mariadb/var
log_error = /usr/local/mariadb/var/mariadb.err
pid-file = /usr/local/mariadb/var/mariadb.pid
skip-external-locking
key_buffer_size = 32M
max_allowed_packet = 1M
table_open_cache = 128
sort_buffer_size = 768K
net_buffer_length = 8K
read_buffer_size = 768K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_cache_size = 16
query_cache_size = 16M
tmp_table_size = 32M

explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535

log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10

default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_data_home_dir = /usr/local/mariadb/var
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mariadb/var
innodb_buffer_pool_size = 128M
innodb_log_file_size = 32M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 32M
sort_buffer_size = 768K
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

作者: licess 时间: 2020-12-27 16:59
df -h 查看一下硬盘占用情况和 /usr/local/mariadb/var 目录及目录下文件的属主属组是否是mariadb
mariadb什么版本？新装的还是以前就已经运行过一段时间？新装的提供安装日志，什么环境？
之前做过什么操作？
上传完整的mariadb日志

作者: ww82ke 时间: 2020-12-27 19:01

licess 发表于 2020-12-27 16:59
df -h 查看一下硬盘占用情况和 /usr/local/mariadb/var 目录及目录下文件的属主属组是否是mariadb
mariadb ...

原来一直运行的，突然出现这个情况，现在是删除mariadb重新安装mariadb就好了

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)