CheersnGears Posted February 18 Share Posted February 18 I have a stuck file move task that got to 79.61% and has stayed there. This is a move from S3 -> server file system. It is throwing a "MySQL server has gone away" in the log when I try to run it manually. Only the SQL server hasn't gone away... my site is operating fine otherwise. I've restarted SQL, I've restarted the server, but that task remains stuck. I've run a table optimization on my entire database (I didn't expect this to do anything, it was more to test the SQL server under some additional load), and it was completed without issue. Notably, when I manually run the task queue, a few PWA notification tasks will run first before the file move process starts failing. The only recent changes to the system I can think of are an upgrade from MariaDB 10.5->10.6 just before the move. I had temporarily enabled the EXEC directive in PHP for an unrelated task outside of the IPS system. Link to comment Share on other sites More sharing options...
Jim M Posted February 18 Share Posted February 18 For issues like this, you will need to contact your hosting provider as this is an issue with your MySQL server. Even if it only happens on certain conditions, they would need to assist. G17 Media 1 Link to comment Share on other sites More sharing options...
Solution CheersnGears Posted February 18 Author Solution Share Posted February 18 I increased my MySQL wait timeouts dramatically to see if that will help overnight. Running the task manually still doesn't seem to budge the task, but it's not putting errors into the logs anymore. Link to comment Share on other sites More sharing options...
Randy Calvert Posted February 18 Share Posted February 18 Leave it overnight and it should be fine. Had something similar happen when it appeared stuck. Left it and came back the next day with it finally completed. Link to comment Share on other sites More sharing options...
CheersnGears Posted February 18 Author Share Posted February 18 35 minutes ago, Randy Calvert said: Leave it overnight and it should be fine. Had something similar happen when it appeared stuck. Left it and came back the next day with it finally completed. Well, that jiggled it loose. It crept up to 81.03% done. Once it is done, I'll drop my wait timeout back down to a reasonable (but higher than before) level. Randy Calvert 1 Link to comment Share on other sites More sharing options...
Jim M Posted February 18 Share Posted February 18 Glad to hear you've figured things out. Link to comment Share on other sites More sharing options...
Recommended Posts