/var/log/pacct file leads to MySQL startup failed case sharing

Source: Internet
Author: User

Without warning, MySQL went on strike. After starting with the Mysql.server startup script, there is no hint that the message ends, and the mysqld process is naturally not up.

Put the mysql.server inside $bindir/mysqld_safe--datadir= $datadir--pid-file= $server _pid_file >/dev/null This sentence output redirect after the operation, the results found error: File size limit exceedednohup ...

So it seems natural that there are too big a file. But look at the MySQL data directory related to the database files and log files, the largest is hundreds of trillion. Ulimit-a View also does not have any restrictions on file size.

After N minutes of depression, decided to use Find/-size +2048000k search the entire hard disk suspicious files. The result:/var/log/pacct this large 2G file. Obviously, this is the log file that was generated after the SA activated the Accton and did not roll back. Apart, empty/var/log/pacct and start again MySQL, everything back to normal!

What I don't understand is why MySQL's startup scripts are affected by such a trivial process statistic log that the mysqld process does not start completely. Estimating is still a problem with Mysql.server/mysqld_safe scripting logic.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.