XF 2.2 issue with queries mysql

S

sandokloud

Active member
Hi, i need support my site go down , i need support for fix:

| 137260 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 658 | Creating sort index | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137391 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 645 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137413 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 643 | Creating sort index | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137460 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 639 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137501 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 636 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137715 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 617 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137743 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 615 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137744 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 615 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137829 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 609 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137867 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 605 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137876 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 604 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137933 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 598 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 138390 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 555 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 138632 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 538 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 138643 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 537 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 138758 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 526 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 138807 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 521 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 138818 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 521 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139009 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 498 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139262 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 473 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139375 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 464 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139385 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 464 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139469 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 456 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139672 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 437 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139741 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 431 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139751 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 430 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 139808 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 427 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
 
Sort by date Sort by votes
We are getting a lot of these queries in MySQL:

+------+---------------------+-----------+---------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+---------------------+-----------+---------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| 125 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 83 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 131 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 83 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 229 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 75 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 272 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 72 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 372 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 65 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 439 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 59 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 445 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 58 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 477 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 55 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
| 614 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 43 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
+------+---------------------+-----------+---------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
 
Upvote 0 Downvote

Server error log​

  • Error: Call to a member function getIdentifier() on null
  • src/XF/Mvc/Entity/Finder.php:1384
  • Generated by: example
  • Aug 7, 2021 at 5:11 AM

Stack trace​

#0 src/XF/Search/Data/AbstractData.php(161): XF\Mvc\Entity\Finder->fetch('15000')
#1 src/XF/Search/Search.php(79): XF\Search\Data\AbstractData->getContentInRange(4519665, '15000')
#2 src/XF/Job/SearchRebuild.php(57): XF\Search\Search->indexRange('post', 4519665, '15000')
#3 src/XF/Job/Manager.php(258): XF\Job\SearchRebuild->run(8)
#4 src/XF/Job/Manager.php(200): XF\Job\Manager->runJobInternal(Array, 8)
#5 src/XF/Job/Manager.php(84): XF\Job\Manager->runJobEntry(Array, 8)
#6 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 8)
#7 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#9 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#10 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(2344): XF\Mvc\Dispatcher->run()
#12 src/XF.php(512): XF\App->run()
#13 admin.php(13): XF::runApp('XF\\Admin\\App')
#14 {main}

Request state​

array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(44) "https://example.com/admin.php?tools/run-job"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(30) "https://example.com/admin.php"
["_xfToken"] => string(8) "********"
["only_ids"] => string(0) ""
}
}
 
Upvote 0 Downvote

Server error log​

  • ErrorException: [E_NOTICE] Undefined index:
  • src/XF/Mvc/Entity/Manager.php:582
  • Generated by: example
  • Aug 7, 2021 at 5:11 AM

Stack trace​

#0 src/XF/Mvc/Entity/Manager.php(582): XF::handlePhpError(8, '[E_NOTICE] Unde...', '/home/kikdirty/...', 582, Array)
#1 src/XF/Mvc/Entity/Finder.php(1383): XF\Mvc\Entity\Manager->hydrateFromGrouped(Array, Array)
#2 src/XF/Search/Data/AbstractData.php(161): XF\Mvc\Entity\Finder->fetch('15000')
#3 src/XF/Search/Search.php(79): XF\Search\Data\AbstractData->getContentInRange(4519665, '15000')
#4 src/XF/Job/SearchRebuild.php(57): XF\Search\Search->indexRange('post', 4519665, '15000')
#5 src/XF/Job/Manager.php(258): XF\Job\SearchRebuild->run(8)
#6 src/XF/Job/Manager.php(200): XF\Job\Manager->runJobInternal(Array, 8)
#7 src/XF/Job/Manager.php(84): XF\Job\Manager->runJobEntry(Array, 8)
#8 src/XF/Admin/Controller/Tools.php(139): XF\Job\Manager->runQueue(true, 8)
#9 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2344): XF\Mvc\Dispatcher->run()
#14 src/XF.php(512): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}

Request state​

array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(44) "https://example.com/admin.php?tools/run-job"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(30) "https://example.com/admin.php"
["_xfToken"] => string(8) "********"
["only_ids"] => string(0) ""
}
}
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

U
  • Question Question
XF 2.2 A malfunction in the number of queries caused by the site and a load on the database
Replies
2
Views
124
urivil
U
M
  • Question Question
XF 2.2 Issue with quoting feature
Replies
3
Views
540
MatthewC
M
A
  • Question Question
XF 2.2 problem with thousands of database queries
Replies
6
Views
472
albertc.s
A
S
  • Question Question
XF 2.2 issue with a overload
Replies
0
Views
530
sandokloud
S
V
Fixed Minor cosmetic issue with Quote and navbar
Replies
15
Views
2K
Chris D
Chris D
Top Bottom