Starting MySQL.The server quit without updating PID file (/[FAILED]

25># service mysqld start
Starting MySQL.The server quit without updating PID file (/[FAILED]ql3306/iZ23e11dfakZ.pid).


26># tail -30 /data/mysql/iZ23e11dfakZ.err
InnoDB: Log scan progressed past the checkpoint lsn 4 1555849939
141218 20:26:20  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 4 1556005614
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 11 row operations to undo
InnoDB: Trx id counter is 0 9201152
141218 20:26:20  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
InnoDB: Starting in background the rollback of uncommitted transactions
InnoDB: Cleaning up trx with id 0 9153524
141218 20:26:21  InnoDB: Rollback of non-prepared transactions completed
141218 20:26:21  InnoDB: Started; log sequence number 4 1556005614
/usr/local/mysql/libexec/mysqld: File '/data/httpd/logs/slow.log' not found (Errcode: 13)
141218 20:26:21 [ERROR] Could not use /data/httpd/logs/slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
141218 20:26:21 [Note] Event Scheduler: Loaded 0 events
141218 20:26:21 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
141218 20:26:21 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

141218 20:26:21 [Note] Event Scheduler: Purging the queue. 0 events
141218 20:26:21  InnoDB: Starting shutdown...
141218 20:26:26  InnoDB: Shutdown completed; log sequence number 4 1556005614
141218 20:26:26 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

141218 20:26:26 mysqld_safe mysqld from pid file /data/mysql/iZ23e11dfakZ.pid ended

问题主要在:

[ERROR] Could not use /data/httpd/logs/slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.

30># df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/hda3              56G   22G   32G  41% /
/dev/hda1             190M   12M  169M   7% /boot
tmpfs                 2.0G     0  2.0G   0% /dev/shm
/dev/xvdb1             89G   87G     0 100% /data

发现磁盘满了  没有空间了

找找大文件  

find /data -type f -size +100M

删除下 没有用的文件     老日志、老备份之类的  腾出来些空间

空间有了  再重启  就可以了 

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Starting MySQL..The server quit without updating PID file ([FAILED]ver/data/dedu1.pid)这个问题通常是由于MySQL启动失败导致的。在CentOS安装MySQL时,可能会遇到一些问题,例如数据库初始化失败或者权限配置不正确等等。根据引用中提到的背景描述和部署步骤,可以尝试以下解决办法来解决这个问题。 首先,你可以尝试重新初始化MySQL数据库。根据引用中提到的命令"./mysqld --initialize",可以使用这个命令来重新初始化MySQL数据库。确保指定了正确的用户、数据目录和基础目录等参数。 如果重新初始化数据库仍然无法解决问题,你可以检查MySQL的日志文件以获取更多的详细信息。根据引用中提到的错误消息,可以查找并打开MySQL的日志文件,通常位于"/var/log/mysqld.log"。在日志文件中,你可能会找到更多关于启动失败的错误信息,例如权限问题或者配置错误等。根据这些错误信息,你可以进一步调查和解决问题。 另外,还可以检查MySQL相关的配置文件,例如my.cnf文件。确保配置文件中的参数设置正确,特别是与数据目录、日志文件和PID文件等相关的参数。确认这些参数的路径和文件名是否正确,并且有正确的权限进行读写操作。 最后,如果以上方法仍然无法解决问题,可以尝试重新安装MySQL。根据引用中提到的问题背景描述和网上解决办法汇总,重新安装MySQL可能是解决启动失败的最后一种选择。确保在重新安装之前,彻底清理残留的MySQL文件和目录,以免影响新安装的MySQL。 综上所述,如果你遇到了"Starting MySQL..The server quit without updating PID file"的错误消息,可以按照以上的方法进行尝试和排查,从重新初始化数据库、检查日志文件、检查配置文件到重新安装MySQL等等。希望这些解决办法能够帮助你解决问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [Starting MySQL...The server quit without updating PID file [FAILED]ysql/mysql.pid).](https://blog.csdn.net/Cookie_1030/article/details/127610424)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [CentOS安装mysql The server quit without updating PID file问题](https://download.csdn.net/download/weixin_38672739/13684722)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [ ERROR The server quit without updating PID file (/xxx/xxx/xxx/mysqldb/xxx..pid)](https://blog.csdn.net/Liuj666/article/details/122330792)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值