Directory /var/run/mysqld deleted after server reboot (Graceful Server Reboot)

galileuNet

• April 01, 2022 07:01

Hello, A few motnhs ago I uptaded my server from MySQL 5.7 to MariaDB 10.3. All works great, but when the server reestarts the mysql proces no reestarted (?") After a investigation with a ticket to cpanel for some reason, the directory: /var/run/mysqld did not exists, therefore, it was deleted. (very strange) I created it and change it to correct ownership and MySQL started without any issues. After this all works ok, but this issue occurs again and again if the server is rebooted: the /var/run/mysqld it's deleted. I can't not found what makes this directory delation. Can anyone help?

• 

  kodeslogic

  • April 01, 2022 14:08

  Can you please share the output of: #cat /etc/my.cnf
  

  0
• 

  galileuNet

  • April 01, 2022 17:29

  Yes, shure: -------------------------------------------- # For advice on how to change settings please see # MySQL :: MySQL 5.7 Reference Manual :: 5.1.2 Server Configuration Defaults [mysqld] performance-schema=0 # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid innodb_buffer_pool_size=52428800 max_allowed_packet=268435456 open_files_limit=40000 innodb_file_per_table=0 sql_mode="" -------------------------------

  0
• 

  kodeslogic

  • April 01, 2022 18:00

  Try commenting pid-file=/var/run/mysqld/mysqld.pid
  line in your /etc/my.cnf file. We have a server with MariaDB 10.3 without pid-file=/var/run/mysqld/mysqld.pid line /etc/my.cnf file.

  0
• 

  quietFinn

  • April 01, 2022 18:38

  It's not really correct to say that "/var/run/mysqld is deleted after server reboot", because the /var/run/ files and folders are created by the system upon each reboot. I found this, it might help in this situation:

  0
• 

  galileuNet

  • April 01, 2022 18:46

  It's not really correct to say that "/var/run/mysqld is deleted after server reboot", because the /var/run/ files and folders are created by the system upon each reboot. I found this, it might help in this situation:

  0
• 

  galileuNet

  • April 01, 2022 18:47

  Try commenting pid-file=/var/run/mysqld/mysqld.pid
  line in your /etc/my.cnf file. We have a server with MariaDB 10.3 without pid-file=/var/run/mysqld/mysqld.pid line /etc/my.cnf file.

  
  Thanks, I try

  0
• 

  galileuNet

  • April 01, 2022 20:33

  Try commenting pid-file=/var/run/mysqld/mysqld.pid
  line in your /etc/my.cnf file. We have a server with MariaDB 10.3 without pid-file=/var/run/mysqld/mysqld.pid line /etc/my.cnf file.

  
  It works! (i don't know why) I have ticket opened. I also wait for cpanel response. Thanks!

  0
• 

  quietFinn

  • April 01, 2022 21:02

  I think the pid file is in /var/lib/mysql/ :rolleyes: If you try to force it to /var/run/mysqld/ in /etc/my.cnf it fails.

  0
• 

  galileuNet

  • April 01, 2022 21:45

  I think the pid file is in /var/lib/mysql/ :rolleyes: If you try to force it to /var/run/mysqld/ in /etc/my.cnf it fails.

  
  Its' possible, but in MySQL 5.7 it works. When I update to MariaDB 10.3 it crashed. After commenting the line, it works again. Thanks!

  0
• 

  kodeslogic

  • April 01, 2022 21:53

  It works! (i don't know why) I have ticket opened. I also wait for cpanel response. Thanks!

  
  @galileuNet I am glad I've been able to help.

  0

Please sign in to leave a comment.