Could not increase number of max_open_files to more than 15000

albatroz

• June 08, 2020 11:14

Hello, I recently got this error message when I restarted the MYSQL service. Can you tell how to fix this?

• 

  SamuelM

  • June 11, 2020 02:37

  Hello @albatroz Can you check if the "Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?" option is enabled in the Tweak Settings interface in WHM?

  0
• 

  sajithgsm

  • October 16, 2021 10:17

  Hi, this happened me today. I have run this. /usr/local/cpanel/scripts/auto-adjust-mysql-limits But its getting a error like this. warn [auto-adjust-mysql-limits] Adjust called while MySQL is not running, OpenFiles cannot be adjusted at this time Is there any way to solve this issue?

  0
• 

  cPRex Jurassic Moderator

  • October 18, 2021 13:23

  @sajithgsm - that error would seem to indicate that MySQL is not running on the system. Can you send me the output of this command from your server? ps aux | grep -i mysql
  

  0
• 

  sajithgsm

  • October 18, 2021 13:28

  this is the result root 19771 0.0 0.0 112808 1004 pts/0 S+ 09:28 0:00 grep --color=auto -i mysql

  0
• 

  cPRex Jurassic Moderator

  • October 18, 2021 13:35

  Thanks for that output - that would indicate that MySQL is not running on that server. Are you possibly running MariaDB instead?

  0
• 

  sajithgsm

  • October 18, 2021 13:39

  Hi, I was running MariaDB on the server. [root@cdn ~]# ps aux | grep -i mariadb root 21204 0.0 0.0 112808 1004 pts/0 S+ 09:37 0:00 grep --color=auto -i mariadb [root@cdn ~]# I just tried to upgrade mariadb 10.3 to 10.5 also. It also failed.

  0
• 

  cPRex Jurassic Moderator

  • October 18, 2021 14:02

  Since the upgrade failed it appears there are not any databases running on the machine, so that command wouldn't work. It might be best to submit a ticket to our team so we can checked the failed database upgrade and the system with you.

  0

Please sign in to leave a comment.