mariadb 启动不了，是什么问题
2020-12-26 15:28:26 0 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 Plugin 'Aria' init function returned error.
2020-12-26 15:28:26 0 Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:26 0 InnoDB: Using Linux native AIO
2020-12-26 15:28:26 0 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-26 15:28:26 0 InnoDB: Uses event mutexes
2020-12-26 15:28:26 0 InnoDB: Compressed tables use zlib 1.2.7
2020-12-26 15:28:26 0 InnoDB: Number of pools: 1
2020-12-26 15:28:26 0 InnoDB: Using SSE2 crc32 instructions
2020-12-26 15:28:26 0 mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-12-26 15:28:26 0 InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-12-26 15:28:26 0 InnoDB: Completed initialization of buffer pool
2020-12-26 15:28:26 0 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 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 InnoDB: Plugin initialization aborted with error Generic error
2020-12-26 15:28:26 0 InnoDB: Starting shutdown...
2020-12-26 15:28:26 0 Plugin 'InnoDB' init function returned error.
2020-12-26 15:28:26 0 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:26 0 Plugin 'FEEDBACK' is disabled.
2020-12-26 15:28:26 0 Could not open mysql.plugin table. Some plugins may be not loaded
2020-12-26 15:28:26 0 Failed to initialize plugins.
2020-12-26 15:28:26 0 Aborting
2020-12-26 15:28:29 0 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 Plugin 'Aria' init function returned error.
2020-12-26 15:28:29 0 Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:29 0 InnoDB: Using Linux native AIO
2020-12-26 15:28:29 0 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-26 15:28:29 0 InnoDB: Uses event mutexes
2020-12-26 15:28:29 0 InnoDB: Compressed tables use zlib 1.2.7
2020-12-26 15:28:29 0 InnoDB: Number of pools: 1
2020-12-26 15:28:29 0 InnoDB: Using SSE2 crc32 instructions
2020-12-26 15:28:29 0 mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-12-26 15:28:29 0 InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-12-26 15:28:29 0 InnoDB: Completed initialization of buffer pool
2020-12-26 15:28:29 0 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 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 InnoDB: Plugin initialization aborted with error Generic error
2020-12-26 15:28:29 0 InnoDB: Starting shutdown...
2020-12-26 15:28:29 0 Plugin 'InnoDB' init function returned error.
2020-12-26 15:28:29 0 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-26 15:28:29 0 Plugin 'FEEDBACK' is disabled.
2020-12-26 15:28:29 0 Could not open mysql.plugin table. Some plugins may be not loaded
2020-12-26 15:28:29 0 Failed to initialize plugins.
2020-12-26 15:28:29 0 Aborting
你自己改动了配置文件autoextend那边吧 licess 发表于 2020-12-26 19:59
你自己改动了配置文件autoextend那边吧
没有改过 licess 发表于 2020-12-26 19:59
你自己改动了配置文件autoextend那边吧
#password = your_password
port = 3306
socket = /tmp/mysql.sock
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
quick
max_allowed_packet = 16M
no-auto-rehash
key_buffer_size = 32M
sort_buffer_size = 768K
read_buffer = 2M
write_buffer = 2M
interactive-timeout
df -h 查看一下硬盘占用情况和 /usr/local/mariadb/var 目录及目录下文件的属主属组是否是mariadb
mariadb什么版本？新装的还是以前就已经运行过一段时间？新装的提供安装日志，什么环境？
之前做过什么操作？
上传完整的mariadb日志 licess 发表于 2020-12-27 16:59
df -h 查看一下硬盘占用情况和 /usr/local/mariadb/var 目录及目录下文件的属主属组是否是mariadb
mariadb ...
原来一直运行的，突然出现这个情况 ，现在是删除mariadb重新安装mariadb就好了
页:
[1]