VPS侦探论坛

 找回密码
 注册
查看: 713|回复: 5

[MySQL] mariadb 启动不了,是什么问题

[复制链接]
发表于 2020-12-26 15:29:51 | 显示全部楼层 |阅读模式



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


美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2020-12-26 19:59:33 | 显示全部楼层


你自己改动了配置文件autoextend那边吧
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2020-12-27 09:09:26 | 显示全部楼层



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

没有改过
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2020-12-27 09:11:27 | 显示全部楼层



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


Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
发表于 2020-12-27 16:59:17 | 显示全部楼层

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

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2020-12-27 19:01:56 | 显示全部楼层

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

原来一直运行的,突然出现这个情况 ,现在是删除mariadb重新安装mariadb就好了
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2021-9-23 09:46 , Processed in 0.059398 second(s), 26 queries .

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

快速回复 返回顶部 返回列表