VPS侦探论坛

 找回密码
 注册
查看: 122|回复: 3

redhat7.2环境lnmp1.7离线安装MariaDB启动失败

[复制链接]
发表于 2020-8-20 11:02:27 | 显示全部楼层 |阅读模式



安装环境:redhat7.2 ,安装了两次一直启动不了,nginx和php正常,页面也可以正常打开,请大佬们帮帮忙
  1. [root@QCDXT-HX10 ~]# systemctl start mariadb
  2. Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
复制代码
  1. [root@QCDXT-HX10 ~]# systemctl status mariadb.service
  2. ● mariadb.service - MariaDB Server
  3.    Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  4.    Active: failed (Result: exit-code) since Thu 2020-08-20 10:59:34 CST; 29s ago
  5.   Process: 5845 ExecStart=/etc/init.d/mariadb start (code=exited, status=1/FAILURE)

  6. Aug 20 10:59:30 QCDXT-HX10 systemd[1]: Starting MariaDB Server...
  7. Aug 20 10:59:31 QCDXT-HX10 mariadb[5845]: Starting MariaDB.200820 10:59:31 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  8. Aug 20 10:59:31 QCDXT-HX10 mariadb[5845]: 200820 10:59:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  9. Aug 20 10:59:34 QCDXT-HX10 mariadb[5845]: ../etc/init.d/mariadb: line 265: kill: (5961) - No such process
  10. Aug 20 10:59:34 QCDXT-HX10 mariadb[5845]: ERROR!
  11. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: mariadb.service: control process exited, code=exited status=1
  12. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: Failed to start MariaDB Server.
  13. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: Unit mariadb.service entered failed state.
  14. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: mariadb.service failed.
复制代码
  1. [root@QCDXT-HX10 ~]# cat /usr/local/mariadb/var/mariadb.err
  2. 200820 10:59:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  3. 200820 10:59:31 [Note] /usr/local/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 6513 ...
  4. 200820 10:59:31 InnoDB: The InnoDB memory heap is disabled
  5. 200820 10:59:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  6. 200820 10:59:31 InnoDB: Compressed tables use zlib 1.2.7
  7. 200820 10:59:31 InnoDB: Using Linux native AIO
  8. 200820 10:59:31 InnoDB: Initializing buffer pool, size = 4.0G
  9. 200820 10:59:32 InnoDB: Completed initialization of buffer pool
  10. 200820 10:59:32 InnoDB: highest supported file format is Barracuda.
  11. 200820 10:59:32  InnoDB: Starting crash recovery from checkpoint LSN=50535
  12. InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
  13. 200820 10:59:32  InnoDB: Starting final batch to recover 9 pages from redo log
  14. 200820 10:59:32  InnoDB: Waiting for the background threads to start
  15. 200820 10:59:33 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 1597945
  16. 200820 10:59:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  17. 200820 10:59:33 [Note] Recovering after a crash using mysql-bin
  18. 200820 10:59:33 [Note] Starting crash recovery...
  19. 200820 10:59:33 [Note] Crash recovery finished.
  20. 200820 10:59:33 [Note] Server socket created on IP: '0.0.0.0'.
  21. 200820 10:59:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  22. 200820 10:59:34 mysqld_safe mysqld from pid file /usr/local/mariadb/var/mariadb.pid ended
复制代码


本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

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


这是lnmp的安装的报错日志
  1. Installing MariaDB/MySQL system tables in '/usr/local/mariadb/var' ...
  2. 200820  9:42:38 [Note] /usr/local/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 15989 ...
  3. 200820  9:42:38 [ERROR] mysqld: Can't create/write to file '/usr/local/mariadb/var/aria_log_control' (Errcode: 13)
  4. 200820  9:42:38 [ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '/usr/local/mariadb/var/aria_log_control'
  5. 200820  9:42:38 [ERROR] Plugin 'Aria' init function returned error.
  6. 200820  9:42:38 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
  7. ERROR: 1  Can't create/write to file '/usr/local/mariadb/var/mysql/db.MYI' (Errcode: 13)
  8. 200820  9:42:38 [ERROR] Aborting

  9. 200820  9:42:38 [Note] /usr/local/mariadb/bin/mysqld: Shutdown complete


  10. Installation of system tables failed!  Examine the logs in
  11. /usr/local/mariadb/var for more information.

  12. The problem could be conflicting information in an external
  13. my.cnf files. You can ignore these by doing:

  14.     shell> /usr/local/mariadb/scripts/mysql_install_db --defaults-file=~/.my.cnf

  15. You can also try to start the mysqld daemon with:

  16.     shell> /usr/local/mariadb/bin/mysqld --skip-grant-tables --general-log &

  17. and use the command line tool /usr/local/mariadb/bin/mysql
  18. to connect to the mysql database and look at the grant tables:

  19.     shell> /usr/local/mariadb/bin/mysql -u root mysql
  20.     mysql> show tables;

  21. Try 'mysqld --help' if you have problems with paths.  Using
  22. --general-log gives you a log in /usr/local/mariadb/var that may be helpful.

  23. The latest information about mysql_install_db is available at
  24. https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
  25. You can find the latest source at https://downloads.mariadb.org and
  26. the maria-discuss email list at https://launchpad.net/~maria-discuss

  27. Please check all of the above before submitting a bug report
  28. at http://mariadb.org/jira

  29. Add mariadb service at system startup...
  30. Starting MariaDB.200820 09:42:39 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  31. 200820 09:42:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  32. ......./etc/init.d/mariadb: line 265: kill: (16166) - No such process
  33. ERROR!
  34. ERROR! MariaDB server PID file could not be found!
  35. Starting MariaDB.200820 09:42:48 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  36. 200820 09:42:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  37. ../etc/init.d/mariadb: line 265: kill: (17129) - No such process
  38. ERROR!
  39. /usr/local/mariadb/bin/mysqladmin: connect to server at 'localhost' failed
  40. error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
  41. Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
  42. ERROR! MariaDB server PID file could not be found!
  43. Starting MariaDB.200820 09:42:53 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  44. 200820 09:42:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  45. ../etc/init.d/mariadb: line 265: kill: (18071) - No such process
  46. ERROR!
  47. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  48. failed, try other way...
  49. ERROR! MariaDB server PID file could not be found!
  50. Starting MariaDB.200820 09:42:57 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  51. 200820 09:42:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  52. .../etc/init.d/mariadb: line 265: kill: (19024) - No such process
  53. ERROR!
  54. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  55. Set password failed!
  56. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  57. FLUSH PRIVILEGES failed!
  58. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  59. Update root password...
  60. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  61. ... Failed!
  62. Remove anonymous users...
  63. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  64. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  65. ... Failed!
  66. Disallow root login remotely...
  67. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  68. ... Failed!
  69. Remove test database...
  70. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  71. ... Failed!
  72. Reload privilege tables...
  73. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  74. ... Failed!
  75. ERROR! MariaDB server PID file could not be found!
  76. Clean database src directory...
复制代码
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2020-8-20 11:36:41 | 显示全部楼层

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
  1. [root@QCDXT-HX10 ~]# systemctl start mariadb
  2. Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
复制代码

  1. [root@QCDXT-HX10 ~]# systemctl status mariadb.service
  2. ● mariadb.service - MariaDB Server
  3.    Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  4.    Active: failed (Result: exit-code) since Thu 2020-08-20 11:35:59 CST; 5s ago
  5.   Process: 8143 ExecStart=/etc/init.d/mariadb start (code=exited, status=1/FAILURE)

  6. Aug 20 11:35:55 QCDXT-HX10 systemd[1]: Starting MariaDB Server...
  7. Aug 20 11:35:56 QCDXT-HX10 mariadb[8143]: Starting MariaDB.200820 11:35:56 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  8. Aug 20 11:35:56 QCDXT-HX10 mariadb[8143]: 200820 11:35:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  9. Aug 20 11:35:59 QCDXT-HX10 mariadb[8143]: .../etc/init.d/mariadb: line 265: kill: (8259) - No such process
  10. Aug 20 11:35:59 QCDXT-HX10 mariadb[8143]: ERROR!
  11. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: mariadb.service: control process exited, code=exited status=1
  12. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: Failed to start MariaDB Server.
  13. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: Unit mariadb.service entered failed state.
  14. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: mariadb.service failed.
复制代码


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



Installing MariaDB/MySQL system tables in '/usr/local/mariadb/var' ...
200820  9:42:38 [Note] /usr/local/mariadb/bin/mysqld (mysqld 5.5.68-MariaDB) starting as process 15989 ...
200820  9:42:38 [ERROR] mysqld: Can't create/write to file '/usr/local/mariadb/var/aria_log_control' (Errcode: 13)
200820  9:42:38 [ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '/usr/local/mariadb/var/aria_log_control'
200820  9:42:38 [ERROR] Plugin 'Aria' init function returned error.
200820  9:42:38 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
ERROR: 1  Can't create/write to file '/usr/local/mariadb/var/mysql/db.MYI' (Errcode: 13)
200820  9:42:38 [ERROR] Aborting

你系统上Mariadb这个安装位置的目录可能目录权限有问题或者可能当前这个分区空间不足或inodes不足
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2020-10-1 10:44 , Processed in 0.062171 second(s), 27 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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