Issue: Vault Wiki cron job blocking cron for system

Issue Tools
- View Changes

September 25, 2024 3:29 PM

tommythejoat

Regular Member

Vault Wiki cron job blocking cron for system

Problem with insert into xf_vw_permission

We have been having problems with VaultWiki background jobs. I reported the one with rebuilding permissions but it is still occuring.
Today I see this process error report:

There are manual rebuild jobs awaiting completion. Continue running them.

When I click on the link in that message I see error below and that error also gets recorded in the error log.

ErrorException: [E_WARNING] Trying to access array offset on value of type bool in src/addons/vw/vw/Handler/Search/Data/Comment.php at line 29
XF::handlePhpError() in src/addons/vw/vw/Handler/Search/Data/Comment.php at line 29
vw\vw\Handler\Search\Data\Comment->getIndexData() in src/XF/Search/Search.php at line 39
XF\Search\Search->index() in src/addons/SV/SearchImprovements/XF/Search/SearchPatch.php at line 119
SV\SearchImprovements\XF\Search\SearchPatch->index() in src/addons/SV/ElasticSearchEssentials/XF/Search/Search.php at line 83
SV\ElasticSearchEssentials\XF\Search\Search->index() in src/XF/Search/Search.php at line 61
XF\Search\Search->indexEntities() in src/XF/Search/Search.php at line 87
XF\Search\Search->indexRange() in src/XF/Job/SearchRebuild.php at line 66
XF\Job\SearchRebuild->run() in src/XF/Job/Manager.php at line 260
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 86
XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 141
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
XF\App->run() in src/XF.php at line 524
XF::runApp() in admin.php at line 13

We are also seeing this alert "There are manual rebuild jobs awaiting completion. Continue running them." When I click on the link, I see:

ErrorException: [E_WARNING] Trying to access array offset on value of type bool in src/addons/vw/vw/Handler/Search/Data/Comment.php at line 29
XF::handlePhpError() in src/addons/vw/vw/Handler/Search/Data/Comment.php at line 29
vw\vw\Handler\Search\Data\Comment->getIndexData() in src/XF/Search/Search.php at line 39
XF\Search\Search->index() in src/addons/SV/SearchImprovements/XF/Search/SearchPatch.php at line 119
SV\SearchImprovements\XF\Search\SearchPatch->index() in src/addons/SV/ElasticSearchEssentials/XF/Search/Search.php at line 83
SV\ElasticSearchEssentials\XF\Search\Search->index() in src/XF/Search/Search.php at line 61
XF\Search\Search->indexEntities() in src/XF/Search/Search.php at line 87
XF\Search\Search->indexRange() in src/XF/Job/SearchRebuild.php at line 66
XF\Job\SearchRebuild->run() in src/XF/Job/Manager.php at line 260
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 202
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 86
XF\Job\Manager->runQueue() in src/XF/Admin/Controller/Tools.php at line 141
XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
XF\App->run() in src/XF.php at line 524
XF::runApp() in admin.php at line 13

This is the Request State associated with the error:

Request state
array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(44) "https://mb.nawcc.org/admin.php?tools/run-job"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(10) "/admin.php"
["_xfToken"] => string(8) "********"
["only_ids"] => string(0) ""
}
}

There are also frequent errors reported with a very long description:

Request state

Request state
array(4) {
["url"] => string(33) "/wiki-asset/?pid=2557&x=180&dpr=2"
["referrer"] => string(152) "https://mb.nawcc.org/wiki/Encyclopedia-Subjects/American-Pocket-Watches/100-Plus-Years-of-Railroad-Watches-and-Railroad-Watch-Standards-in-North-America"
["_GET"] => array(3) {
["pid"] => string(4) "2557"
["x"] => string(3) "180"
["dpr"] => string(1) "2"
}
["_POST"] => array(0) {
}
}

Issue Details

Issue Number 6432

Issue Type Bug

Project VaultWiki 4.x Series

Category Admin Panel

Status Duplicate

Priority 4 - Warnings / Script Errors

Affected Version 4.1.7

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags admin, database, permissions

September 25, 2024 7:21 PM

pegasus

VaultWiki Team

I don't see any reports opened by you about rebuilding permissions, but I believe I remember some messages from you that were about the same as this:
https://www.vaultwiki.org/issues/6415/
As mentioned in the past, these types of rebuilding permissions errors are normal to occur and do not cause any problems. They are basically from trying to rebuild too many things at once, like when multiple tabs are loading and rebuilding the same things. The rebuild succeeds once, and the other attempts log errors for an uncompleted rebuild (because another tab did it already). To the end user, this is seamless and they never see an error message. But we logged the events and this was apparently annoying to many admins.
We stopped logging this in 4.1.8.

Your rebuild jobs error (Search rebuild related) seems to be a Duplicate of:
https://www.vaultwiki.org/issues/6378/
This was fixed in 4.1.8.

I'm not sure what your last error is because you omitted the long description. But it is related to displaying wiki assets judging by the URL. In 4.1.8 we made significant changes to this, specifically when it was necessary to rebuild multiple thumbnails on the fly. Some users had errors rebuilding multiple thumbnails when the page they were trying to load had a lot of pictures showing. The wiki page in your error message appears to have a lot of pictures showing.

Based on your errors, you would benefit from the changes in 4.1.8. Even though you originally reported this as happening in 4.1.8, our records indicate you are actually using 4.1.7. I have updated the report accordingly. If you continue to have new instances of these errors after you have upgraded, please don't hesitate to post new reports with updated error traces.

Reply
September 26, 2024 11:48 AM

tommythejoat

Regular Member

Thanks for the guidance.
I was looking at one of the giant notices just now and clicked on it to see the rest of the message. Here is the stack trace and request state

Stack trace
#0 src/addons/vw/vw/_core/model/db/mysql/vw.php(1316): vw_DB_Controller_XF2->halt('Database Error:...')
#1 src/addons/vw/vw/_core/model/shutdown/vw.php(135): vw_DB_MySQL_Model->replace(Array)
#2 src/addons/vw/vw/_core/model/shutdown/xf2.php(70): vw_Shutdown_Model->shutdown()
#3 src/addons/vw/vw/Listener.php(308): vw_Shutdown_Model_XF2->shutdown()
#4 src/XF/Extension.php(69): vw\vw\Listener::app_complete(Object(XF\Pub\App), Object(XF\Http\Response))
#5 src/XF/App.php(2990): XF\Extension->fire('app_complete', Array, NULL)
#6 src/XF/App.php(2249): XF\App->fire('app_complete', Array)
#7 src/XF/Pub/App.php(456): XF\App->complete(Object(XF\Http\Response))
#8 src/XF/App.php(2486): XF\Pub\App->complete(Object(XF\Http\Response))
#9 src/XF.php(524): XF\App->run()
#10 index.php(20): XF::runApp('XF\\Pub\\App')
#11 {main}

Here is the Request State that appears to show the problem comes from the New Content feature. I investigated the reference and did not see and wiki connection. Of course, that is just my guess. I will order the update.

Request state
array(4) {
["url"] => string(47) "/threads/vedette-wall-clock-chime-lever.211108/"
["referrer"] => string(45) "https://mb.nawcc.org/whats-new/posts/2518137/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

Reply

+ Reply

All times are GMT -4. The time now is 1:20 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Vault Wiki cron job blocking cron for system

Issue Tools