redhat7.2环境lnmp1.7离线安装MariaDB启动失败
安装环境：redhat7.2 ，安装了两次一直启动不了，nginx和php正常，页面也可以正常打开，请大佬们帮帮忙# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.# systemctl status mariadb.service
● mariadb.service - MariaDB Server
Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Thu 2020-08-20 10:59:34 CST; 29s ago
Process: 5845 ExecStart=/etc/init.d/mariadb start (code=exited, status=1/FAILURE)
Aug 20 10:59:30 QCDXT-HX10 systemd: Starting MariaDB Server...
Aug 20 10:59:31 QCDXT-HX10 mariadb: Starting MariaDB.200820 10:59:31 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
Aug 20 10:59:31 QCDXT-HX10 mariadb: 200820 10:59:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
Aug 20 10:59:34 QCDXT-HX10 mariadb: ../etc/init.d/mariadb: line 265: kill: (5961) - No such process
Aug 20 10:59:34 QCDXT-HX10 mariadb: ERROR!
Aug 20 10:59:34 QCDXT-HX10 systemd: mariadb.service: control process exited, code=exited status=1
Aug 20 10:59:34 QCDXT-HX10 systemd: Failed to start MariaDB Server.
Aug 20 10:59:34 QCDXT-HX10 systemd: Unit mariadb.service entered failed state.
Aug 20 10:59:34 QCDXT-HX10 systemd: mariadb.service failed.# cat /usr/local/mariadb/var/mariadb.err
200820 10:59:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
200820 10:59:31 /usr/local/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 6513 ...
200820 10:59:31 InnoDB: The InnoDB memory heap is disabled
200820 10:59:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200820 10:59:31 InnoDB: Compressed tables use zlib 1.2.7
200820 10:59:31 InnoDB: Using Linux native AIO
200820 10:59:31 InnoDB: Initializing buffer pool, size = 4.0G
200820 10:59:32 InnoDB: Completed initialization of buffer pool
200820 10:59:32 InnoDB: highest supported file format is Barracuda.
200820 10:59:32InnoDB: Starting crash recovery from checkpoint LSN=50535
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
200820 10:59:32InnoDB: Starting final batch to recover 9 pages from redo log
200820 10:59:32InnoDB: Waiting for the background threads to start
200820 10:59:33 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1597945
200820 10:59:33 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
200820 10:59:33 Recovering after a crash using mysql-bin
200820 10:59:33 Starting crash recovery...
200820 10:59:33 Crash recovery finished.
200820 10:59:33 Server socket created on IP: '0.0.0.0'.
200820 10:59:33 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
200820 10:59:34 mysqld_safe mysqld from pid file /usr/local/mariadb/var/mariadb.pid ended
这是lnmp的安装的报错日志
Installing MariaDB/MySQL system tables in '/usr/local/mariadb/var' ...
2008209:42:38 /usr/local/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 15989 ...
2008209:42:38 mysqld: Can't create/write to file '/usr/local/mariadb/var/aria_log_control' (Errcode: 13)
2008209:42:38 mysqld: Got error 'Can't create file' when trying to use aria control file '/usr/local/mariadb/var/aria_log_control'
2008209:42:38 Plugin 'Aria' init function returned error.
2008209:42:38 Plugin 'Aria' registration as a STORAGE ENGINE failed.
ERROR: 1Can't create/write to file '/usr/local/mariadb/var/mysql/db.MYI' (Errcode: 13)
2008209:42:38 Aborting
2008209:42:38 /usr/local/mariadb/bin/mysqld: Shutdown complete
Installation of system tables failed!Examine the logs in
/usr/local/mariadb/var for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> /usr/local/mariadb/scripts/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> /usr/local/mariadb/bin/mysqld --skip-grant-tables --general-log &
and use the command line tool /usr/local/mariadb/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/local/mariadb/bin/mysql -u root mysql
mysql> show tables;
Try 'mysqld --help' if you have problems with paths.Using
--general-log gives you a log in /usr/local/mariadb/var that may be helpful.
The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
You can find the latest source at https://downloads.mariadb.org and
the maria-discuss email list at https://launchpad.net/~maria-discuss
Please check all of the above before submitting a bug report
at http://mariadb.org/jira
Add mariadb service at system startup...
Starting MariaDB.200820 09:42:39 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
200820 09:42:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
......./etc/init.d/mariadb: line 265: kill: (16166) - No such process
ERROR!
ERROR! MariaDB server PID file could not be found!
Starting MariaDB.200820 09:42:48 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
200820 09:42:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
../etc/init.d/mariadb: line 265: kill: (17129) - No such process
ERROR!
/usr/local/mariadb/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
ERROR! MariaDB server PID file could not be found!
Starting MariaDB.200820 09:42:53 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
200820 09:42:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
../etc/init.d/mariadb: line 265: kill: (18071) - No such process
ERROR!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, try other way...
ERROR! MariaDB server PID file could not be found!
Starting MariaDB.200820 09:42:57 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
200820 09:42:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
.../etc/init.d/mariadb: line 265: kill: (19024) - No such process
ERROR!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Set password failed!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
FLUSH PRIVILEGES failed!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Update root password...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
... Failed!
Remove anonymous users...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
... Failed!
Disallow root login remotely...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
... Failed!
Remove test database...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
... Failed!
Reload privilege tables...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
... Failed!
ERROR! MariaDB server PID file could not be found!
Clean database src directory...
redhat7.2环境lnmp1.7离线安装MariaDB启动失败
本帖最后由 chenchen 于 2020-8-20 11:41 编辑上一个帖子没说明白，抱歉。
安装环境：redhat7.2 ，安装了两次一直启动不了，nginx和php正常，页面也可以正常打开，请大佬们帮帮忙
安装日志lnmp-install.log：https://cowtransfer.com/s/a28c72319d1c46
数据库日志mariadb.err：https://cowtransfer.com/s/02090d825f404a
# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
# systemctl status mariadb.service
● mariadb.service - MariaDB Server
Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Thu 2020-08-20 11:35:59 CST; 5s ago
Process: 8143 ExecStart=/etc/init.d/mariadb start (code=exited, status=1/FAILURE)
Aug 20 11:35:55 QCDXT-HX10 systemd: Starting MariaDB Server...
Aug 20 11:35:56 QCDXT-HX10 mariadb: Starting MariaDB.200820 11:35:56 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
Aug 20 11:35:56 QCDXT-HX10 mariadb: 200820 11:35:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
Aug 20 11:35:59 QCDXT-HX10 mariadb: .../etc/init.d/mariadb: line 265: kill: (8259) - No such process
Aug 20 11:35:59 QCDXT-HX10 mariadb: ERROR!
Aug 20 11:35:59 QCDXT-HX10 systemd: mariadb.service: control process exited, code=exited status=1
Aug 20 11:35:59 QCDXT-HX10 systemd: Failed to start MariaDB Server.
Aug 20 11:35:59 QCDXT-HX10 systemd: Unit mariadb.service entered failed state.
Aug 20 11:35:59 QCDXT-HX10 systemd: mariadb.service failed.
Installing MariaDB/MySQL system tables in '/usr/local/mariadb/var' ...
2008209:42:38 /usr/local/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 15989 ...
2008209:42:38 mysqld: Can't create/write to file '/usr/local/mariadb/var/aria_log_control' (Errcode: 13)
2008209:42:38 mysqld: Got error 'Can't create file' when trying to use aria control file '/usr/local/mariadb/var/aria_log_control'
2008209:42:38 Plugin 'Aria' init function returned error.
2008209:42:38 Plugin 'Aria' registration as a STORAGE ENGINE failed.
ERROR: 1Can't create/write to file '/usr/local/mariadb/var/mysql/db.MYI' (Errcode: 13)
2008209:42:38 Aborting
你系统上Mariadb这个安装位置的目录可能目录权限有问题或者可能当前这个分区空间不足或inodes不足
页:
[1]