When does maintenence happen?

Scott Galambos

• May 20, 2022 14:27

We have a problem with cPanel maintenance timing . We have scripts that sync products in the middle of the night. most of the time its fine. Occasionally though cPanel has to shut down MySQL and our scripts fails. this is bad. eg. Fatal error: Uncaught PDOException: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress in /home/site/public_html/asite.com/cron/product_sync/includes/engine_functions.inc:78 The question is, exactly when does MySQL go offline? For how long? We can probably time/cron around this downtime if I knew when it happened. This is under cPanel & WHM v102.0.11. Any idea?

• 

  cPRex Jurassic Moderator

  • May 20, 2022 19:49

  Hey there! All maintenance would be called as part of the nightly update script. The time that runs is controlled by a root cron job, so you can see that by accessing root's crontab on the server. Here's the entry you'll be looking for: (/usr/local/cpanel/scripts/fix-cpanel-perl; /usr/local/cpanel/scripts/upcp --cron > /dev/null)
  Feel free to modify that time so it runs when it is convenient for your server and users.

  0
• 

  quietFinn

  • May 20, 2022 20:56

  You can modify that time in WHM -> Server Configuration -> Configure cPanel Cron Jobs -> Command: upcp

  0
• 

  Scott Galambos

  • May 21, 2022 00:01

  Ok, from my root cron I got this: 0 6 * * * /usr/local/cpanel/scripts/exim_tidydb > /dev/null 2>&1 30 5 * * * /usr/local/cpanel/scripts/optimize_eximstats > /dev/null 2>&1 32 1 * * * (/usr/local/cpanel/scripts/fix-cpanel-perl; /usr/local/cpanel/scripts/upcp --cron > /dev/null) 0 2 * * * /usr/local/cpanel/bin/backup 35 * * * * /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check 45 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_mailman_cache && /usr/local/cpanel/scripts/update_mailman_cache 30 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache 25 */2 * * * /usr/local/cpanel/bin/mysqluserstore >/dev/null 2>&1 15 */2 * * * /usr/local/cpanel/bin/dbindex >/dev/null 2>&1 15 */6 * * * /usr/local/cpanel/scripts/autorepair recoverymgmt >/dev/null 2>&1 */5 * * * * /usr/local/cpanel/scripts/dcpumon-wrapper >/dev/null 2>&1 49 2 * * * /usr/local/cpanel/whostmgr/docroot/cgi/cpaddons_report.pl --notify 11,26,41,56 * * * * /usr/local/cpanel/whostmgr/bin/dnsqueue > /dev/null 2>&1 @reboot /usr/local/cpanel/bin/onboot_handler 5,20,35,50 * * * * /usr/local/cpanel/scripts/eximstats_spam_check 2>&1 0 */2 * * * /usr/local/cpanel/scripts/shrink_modsec_ip_database -x 2>&1 Does anyone know exactly what jobs might take down MySQL? Just "/usr/local/cpanel/scripts/fix-cpanel-perl; /usr/local/cpanel/scripts/upcp" then? On a separate note, every time I click the CODE button in this editor I get a popup forum listing. Why? Why can't I ever select text to be code? I keep getting this stupid popup at

  0
• 

  Spirogg

  • May 21, 2022 01:45

  Ok, from my root cron I got this: 0 6 * * * /usr/local/cpanel/scripts/exim_tidydb > /dev/null 2>&1 30 5 * * * /usr/local/cpanel/scripts/optimize_eximstats > /dev/null 2>&1 32 1 * * * (/usr/local/cpanel/scripts/fix-cpanel-perl; /usr/local/cpanel/scripts/upcp --cron > /dev/null) 0 2 * * * /usr/local/cpanel/bin/backup 35 * * * * /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check 45 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_mailman_cache && /usr/local/cpanel/scripts/update_mailman_cache 30 */4 * * * /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache 25 */2 * * * /usr/local/cpanel/bin/mysqluserstore >/dev/null 2>&1 15 */2 * * * /usr/local/cpanel/bin/dbindex >/dev/null 2>&1 15 */6 * * * /usr/local/cpanel/scripts/autorepair recoverymgmt >/dev/null 2>&1 */5 * * * * /usr/local/cpanel/scripts/dcpumon-wrapper >/dev/null 2>&1 49 2 * * * /usr/local/cpanel/whostmgr/docroot/cgi/cpaddons_report.pl --notify 11,26,41,56 * * * * /usr/local/cpanel/whostmgr/bin/dnsqueue > /dev/null 2>&1 @reboot /usr/local/cpanel/bin/onboot_handler 5,20,35,50 * * * * /usr/local/cpanel/scripts/eximstats_spam_check 2>&1 0 */2 * * * /usr/local/cpanel/scripts/shrink_modsec_ip_database -x 2>&1 Does anyone know exactly what jobs might take down MySQL? Just "/usr/local/cpanel/scripts/fix-cpanel-perl; /usr/local/cpanel/scripts/upcp" then? On a separate note, every time I click the CODE button in this editor I get a popup forum listing. Why? Why can't I ever select text to be code? I keep getting this stupid popup at

  0
• 

  cPRex Jurassic Moderator

  • May 23, 2022 13:08

  I wouldn't expect *any* process to take down MySQL. If there is a minor upgrade to the MySQL version, such as going from 8.0.28 to 8.0.29, it may need to restart, but that would be a quick process.

  0
• 

  Spirogg

  • May 23, 2022 18:34

  The poop forum listing is an issue that we reported already supposed to get fixed. When not sure But you can do [ code ] Your test copy paste here [ /code ] Make sure there is no space between [ and code ] Same for [ /code ] Hope this helps :)

  
  @cPRex I posted this In The wrong thread. You can delete it. Sorry

  0
• 

  cPRex Jurassic Moderator

  • May 23, 2022 18:35

  I think it still applies since he mentioned it, so it's all good.

  0

Please sign in to leave a comment.