Tapatalk large threads

[pmct]

vBulletin Version:
- 5.7.1

PHP Version:
- 8.1.12

Database Version:
- MariaDB 10.5.17

HArdware
MAria DB dual Xeon E 5260 V4 128GB ram 16 cores


Issue Description: (Include error message(s), if any)


- VEry slow large threads , query take several minutes

this query for example was killed after running fo 5 minutes
Database error in vBulletin 5.7.1:

Invalid SQL:

SELECT DISTINCT node.starter AS nodeid
FROM AHOnode as node

LEFT JOIN AHOnode AS starter ON starter.nodeid = IF(node.starter = 0, node.nodeid, node.starter)
JOIN AHOclosure AS closure ON node.nodeid = closure.child
LEFT JOIN AHOclosure AS exclude_closure
ON (exclude_closure.child = closure.child AND
exclude_closure.parent IN (16,30,33,20,9 ))

WHERE node.contenttypeid <> 19 AND
closure.parent = '2' AND
node.nodeid <> closure.parent AND
closure.depth <= 10000 AND
node.inlist = 1 AND
exclude_closure.child IS NULL
AND (node.public_preview = 1 OR ( ( ( (starter.parentid IN (1,2,6,14,15,18,7,8,9,12,19,21,23,26,27,28,29,32,3 5,22,24,25,34) AND (starter.parentid IN (1,2,6,14,15,18,7,8,9,12,19,21,23,26,27,28,29,32,3 5,22,24,25,34) OR node.showpublished > 0)) AND (node.showapproved > 0 OR node.userid = 118067) AND node.viewperms > 0 ))
OR starter.parentid = 9 AND node.userid IN (118067) OR (node.starter = 0 AND node.nodeid IN (1,2,6,14,15,18,7,8,9,12,19,21,23,26,27,28,29,32,3 5,22,24,25,34))))


ORDER BY starter.lastcontent DESC
LIMIT 50

/** getSearchResults**/;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, November 10th 2022 @ 08:34:03 AM
Error Date : Thursday, November 10th 2022 @ 08:38:05 AM
Script : https://forum.motorguia.net/mobiquo....t_latest_topic
Referrer :
IP Address : 81.84.121.139
Username : Icas
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1202
Home vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 236
Forum vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 602
#3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 148
Blogs vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68
Groups vB_dB_Result->__construct() called in phar://[path]/vb/vb.phar/db/querydefs.php on line 157
Uncategorized Groups vB_dB_QueryDefs->getResultSetInternal() called in phar://[path]/vb/vb.phar/db/querydefs.php on line 140
Special vB_dB_QueryDefs->getResultSetUnbuffered() called in [path]/packages/vbdbsearch/db/mysql/querydefs.php on line 601
Visitor Messages vBDBSearch_dB_MYSQL_QueryDefs->getSearchResults() called in phar://[path]/vb/vb.phar/db/query/method.php on line 67
Private Messages vB_dB_Query_Method->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 245
Albums vB_dB_Assertor->assertQuery() called in [path]/packages/vbdbsearch/core.php on line 467
#11 vBDBSearch_Core->getResults() called in [path]/packages/vbsphinxsearch/core.php on line 498
#12 vBSphinxSearch_Core->getResults() called in phar://[path]/vb/vb.phar/api/search.php on line 159
CSS Examples vB_Api_Search->getSearchResultsCriteria() called in phar://[path]/vb/vb.phar/api/search.php on line 131
Articles vB_Api_Search->getSearchResult() called in phar://[path]/vb/vb.phar/api/search.php on line 221
#15 vB_Api_Search->getInitialResults() called in /var/www/html/mobiquo/mbqClass/lib/read/MbqRdForumSearch.php on line 64
#16 MbqRdForumSearch->forumAdvancedSearch() called in /var/www/html/mobiquo/mbqFrame/mbqBaseAction/MbqBaseActGetLatestTopic.php on line 57
#17 MbqBaseActGetLatestTopic->actionImplement() called in /var/www/html/mobiquo/mbqAction/MbqActGetLatestTopic.php on line 20
#18 MbqActGetLatestTopic->actionImplement() called in /var/www/html/mobiquo/mobiquoCommon.php on line 102
#19 MbqMain::action() called in /var/www/html/mobiquo/mobiquo.php on line 19

Affected Browser(s):
-

Steps to Reproduce: Expected Result:
-

Actual Result: (Include screenshot(s), if possible)
-

[glennrocksvb]

Does this issue only happen in Tapatalk and not on the web version?

[pmct]

Does this issue only happen in Tapatalk and not on the web version?

YEs , and on very large topics.
The query generated is huge .

my board as almost 10M post, and some topics have 300 000 posts
The vb4 as had no problems, but is was. simple structure.
in Vb5 the joins are muche bigger

[glennrocksvb]

https://forum.vbulletin.com/forum/vbulletin-5-connect/support-issues-questions/4408927-mysql-error-mysql-server-has-gone-away-error-number-2006?p=4408940#post4408940