Question DB Error

[1quicksi]

Thousands and thousands of emails all of a sudden...

Database error in vBulletin 4.2.5: Invalid SQL: INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken, dbtech_registration_firstactivity, vw_location) VALUES ('419d7eb6d1b6e162546c5c767d963cbf', 0, '114.119.159.7', '1902c6468770cdf86c3207bef30f7dd3', 1578917042, '/forums/tags/big.html', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Linux; Android 7.0; FRD-AL00 Build/HUAWEIFRD-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/53.0.2785.49 Mobile MQQBrowser/6.2 TBS/043602 Safari/537.36 MicroMessenger/6.5.16.1120 NetType/WIFI Language/zh_CN', 0, 0, 0, '', '1578917042', 'q:'); MySQL Error : The table 'session' is full Error Number : 1114 Request Date : Monday, January 13th 2020 @ 12:04:02 PM Error Date : Monday, January 13th 2020 @ 12:04:02 PM Script : MyDomain/forums/tags.big.html Referrer : IP Address : 114.119.159.7 Username : Unregistered Classname : vB_Database_MySQLi MySQL Version : Server : 131.153.7.194 User Agent : Stack Trace: #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395 #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 446 #2 vB_Database->query_write() called in [path]/includes/class_core.php on line 3800 #3 vB_Session->save() called in [path]/includes/functions.php on line 7580 #4 exec_shut_down() called in [path]/includes/functions.php on line 7316 #5 print_output() called in [path]/tags.php on line 116

 

[Fillip H.]

This has nothing to do with our add-on.

Error : The table 'session' is full

This means your MySQL server has run out of memory, as the session table uses memory to store vB sessions.

 

[1quicksi]

That is what I initially thought as did my developer. I increased the heap to 128mb and executed: TRUNCATE TABLE session The DB errors still persisted until I disabled this modification.. Once disabled the errors subsided. Has me a bit puzzled...

 

[1quicksi]

Well, maybe I spoke to soon. 2 hours latter and the DB errors are back. I also changed the cleanup and cleanup2 CRON to include logs. Any additional thoughts?

 

[Fillip H.]

I have never encountered this issue so I have no idea about the root cause, sorry. This might be better off being asked in the vBulletin support forum / support ticket system

 

[1quicksi]

vBulletin support.... That's the best laugh I have had all day

 

[DragonByte Technologies]

Hello @1quicksi,

We hope your ticket regarding Advanced Registration has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @1quicksi,

As we have not heard back from you, your ticket regarding Advanced Registration has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

Thank you.


- DragonByte Technologies, Ltd.