设为首页收藏本站
切换到窄版

VPS侦探论坛

 找回密码
 注册
VPS侦探论坛»VPS侦探论坛 › 技术交流区 › LNMP一键安装包 › redhat7.2环境lnmp1.7离线安装MariaDB启动失败 ...
返回列表 发新帖
查看: 1921|回复: 3

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

[复制链接]
chenchen
发表于 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)

  7. Aug 20 10:59:30 QCDXT-HX10 systemd[1]: Starting MariaDB Server...
  8. 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'.
  9. 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
  10. Aug 20 10:59:34 QCDXT-HX10 mariadb[5845]: ../etc/init.d/mariadb: line 265: kill: (5961) - No such process
  11. Aug 20 10:59:34 QCDXT-HX10 mariadb[5845]: ERROR!
  12. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: mariadb.service: control process exited, code=exited status=1
  13. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: Failed to start MariaDB Server.
  14. Aug 20 10:59:34 QCDXT-HX10 systemd[1]: Unit mariadb.service entered failed state.
  15. 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推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复

举报

chenchen
 楼主| 发表于 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

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


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

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

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

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

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

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

  28.     shell> /usr/local/mariadb/bin/mysql -u root mysql
  29.     mysql> show tables;

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

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

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

  42. Add mariadb service at system startup...
  43. Starting MariaDB.200820 09:42:39 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  44. 200820 09:42:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  45. ......./etc/init.d/mariadb: line 265: kill: (16166) - No such process
  46. ERROR!
  47. ERROR! MariaDB server PID file could not be found!
  48. Starting MariaDB.200820 09:42:48 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  49. 200820 09:42:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  50. ../etc/init.d/mariadb: line 265: kill: (17129) - No such process
  51. ERROR!
  52. /usr/local/mariadb/bin/mysqladmin: connect to server at 'localhost' failed
  53. error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
  54. Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
  55. ERROR! MariaDB server PID file could not be found!
  56. Starting MariaDB.200820 09:42:53 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  57. 200820 09:42:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  58. ../etc/init.d/mariadb: line 265: kill: (18071) - No such process
  59. ERROR!
  60. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  61. failed, try other way...
  62. ERROR! MariaDB server PID file could not be found!
  63. Starting MariaDB.200820 09:42:57 mysqld_safe Logging to '/usr/local/mariadb/var/mariadb.err'.
  64. 200820 09:42:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mariadb/var
  65. .../etc/init.d/mariadb: line 265: kill: (19024) - No such process
  66. ERROR!
  67. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  68. Set password failed!
  69. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  70. FLUSH PRIVILEGES failed!
  71. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  72. Update root password...
  73. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  74. ... Failed!
  75. Remove anonymous users...
  76. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  77. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  78. ... Failed!
  79. Disallow root login remotely...
  80. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  81. ... Failed!
  82. Remove test database...
  83. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  84. ... Failed!
  85. Reload privilege tables...
  86. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  87. ... Failed!
  88. ERROR! MariaDB server PID file could not be found!
  89. Clean database src directory...
复制代码
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

chenchen
 楼主| 发表于 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)

  7. Aug 20 11:35:55 QCDXT-HX10 systemd[1]: Starting MariaDB Server...
  8. 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'.
  9. 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
  10. Aug 20 11:35:59 QCDXT-HX10 mariadb[8143]: .../etc/init.d/mariadb: line 265: kill: (8259) - No such process
  11. Aug 20 11:35:59 QCDXT-HX10 mariadb[8143]: ERROR!
  12. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: mariadb.service: control process exited, code=exited status=1
  13. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: Failed to start MariaDB Server.
  14. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: Unit mariadb.service entered failed state.
  15. Aug 20 11:35:59 QCDXT-HX10 systemd[1]: mariadb.service failed.
复制代码


美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

licess
发表于 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
回复 支持 反对

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-11-27 00:48 , Processed in 0.027222 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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