[General] Site is crashing every half hour

[jcoffman99]

Hey all,

I'm at my wits end. I've been trying for two days to solve this issue and am about to give up.

My site scifikitbash.com has started hanging up every half hour for several minutes. It will then run fine for about 25 minutes. The homepage won't even load. It just spins and spins until after a few minutes it suddenly reloads. This is killing me and mu users. In cPanel I see this error:

[Wed Aug 07 10:08:14.897803 2024] [lsapi:error] [pid 905149:tid 22591370385152] [remote 104.251.70.189:58553] [host scifikitbash.com] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: MySQL server has gone away in /home3/jtnxjlmy/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbss_u...')\n#1 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbss_u...', 0, 1)\n#2 /home3/jtnxjlmy/public_html/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbss_u...')\n#3 /home3/jtnxjlmy/public_html/inc/class_core.php(616): run_shutdown()\n#4 [internal function]: MyBB->__destruct()\n#5 {main}\n  thrown in /home3/jtnxjlmy/public_html/inc/db_mysqli.php on line 335\n, referer: https://scifikitbash.com/showthread.php?tid=450
[Wed Aug 07 10:08:14.897752 2024] [lsapi:error] [pid 905149:tid 22591370385152] [remote 104.251.70.189:58553] [host scifikitbash.com] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: MySQL server has gone away in /home3/jtnxjlmy/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbss_u...')\n#1 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbss_u...', 0, 1)\n#2 /home3/jtnxjlmy/public_html/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbss_u...')\n#3 [internal function]: run_shutdown()\n#4 {main}\n  thrown in /home3/jtnxjlmy/public_html/inc/db_mysqli.php on line 335\n, referer: https://scifikitbash.com/showthread.php?tid=450
[Wed Aug 07 10:08:14.892651 2024] [lsapi:error] [pid 905149:tid 22591277930240] [remote 104.251.70.189:58553] [host scifikitbash.com] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: MySQL server has gone away in /home3/jtnxjlmy/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbss_u...')\n#1 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbss_u...', 0, 1)\n#2 /home3/jtnxjlmy/public_html/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbss_u...')\n#3 /home3/jtnxjlmy/public_html/inc/class_core.php(616): run_shutdown()\n#4 [internal function]: MyBB->__destruct()\n#5 {main}\n  thrown in /home3/jtnxjlmy/public_html/inc/db_mysqli.php on line 335\n, referer: https://scifikitbash.com/showthread.php?tid=450
[Wed Aug 07 10:08:14.892586 2024] [lsapi:error] [pid 905149:tid 22591277930240] [remote 104.251.70.189:58553] [host scifikitbash.com] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: MySQL server has gone away in /home3/jtnxjlmy/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbss_u...')\n#1 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbss_u...', 0, 1)\n#2 /home3/jtnxjlmy/public_html/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbss_u...')\n#3 [internal function]: run_shutdown()\n#4 {main}\n  thrown in /home3/jtnxjlmy/public_html/inc/db_mysqli.php on line 335\n, referer: https://scifikitbash.com/showthread.php?tid=450
[Wed Aug 07 10:07:04.747650 2024] [lsapi:error] [pid 905149:tid 22591311550208] [remote 104.251.70.189:58553] [host scifikitbash.com] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: MySQL server has gone away in /home3/jtnxjlmy/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbss_u...')\n#1 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbss_u...', 0, 1)\n#2 /home3/jtnxjlmy/public_html/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbss_u...')\n#3 /home3/jtnxjlmy/public_html/inc/class_core.php(616): run_shutdown()\n#4 [internal function]: MyBB->__destruct()\n#5 {main}\n  thrown in /home3/jtnxjlmy/public_html/inc/db_mysqli.php on line 335\n, referer: https://scifikitbash.com/showthread.php?tid=450
[Wed Aug 07 10:07:04.747595 2024] [lsapi:error] [pid 905149:tid 22591311550208] [remote 104.251.70.189:58553] [host scifikitbash.com] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: MySQL server has gone away in /home3/jtnxjlmy/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(335): mysqli_query(Object(mysqli), 'UPDATE mybbss_u...')\n#1 /home3/jtnxjlmy/public_html/inc/db_mysqli.php(378): DB_MySQLi->query('UPDATE mybbss_u...', 0, 1)\n#2 /home3/jtnxjlmy/public_html/inc/functions.php(234): DB_MySQLi->write_query('UPDATE mybbss_u...')\n#3 [internal function]: run_shutdown()\n#4 {main}\n  thrown in /home3/jtnxjlmy/public_html/inc/db_mysqli.php on line 335\n, referer: https://scifikitbash.com/showthread.php?tid=450

Any ideas before I shut it down?

Thanks,
John

[Crazycat]

Because the MySQL server go away.
It's probably because the MySQL is too weak or a trouble in its configuration/tuning.

The trouble is not MyBB itself. Check your MySQL and particulary available memory and number of connections.
You can also repair the tables and/or the database