Elasticsearch Indexing Failed

[Joe Link]

I just updated Elasticsearch, then tried to re-index. Indexing failed with this error. If I need to check the server log, can someone tell me how to go about that?

An exception occurred: Elasticsearch indexing failed. See the server error log for more details. in /home/public_html/library/XenES/Search/SourceHandler/ElasticSearch.php on line 968

1. XenES_Search_SourceHandler_ElasticSearch->_triggerFailedIndexError() in XenES/Search/SourceHandler/ElasticSearch.php at line 76
2. XenES_Search_SourceHandler_ElasticSearch->finalizeRebuildSet() in XenForo/Search/Indexer.php at line 125
3. XenForo_Search_Indexer->finalizeRebuildSet() in XenForo/Deferred/SearchIndex.php at line 74
4. XenForo_Deferred_SearchIndex->execute() in XenForo/Model/Deferred.php at line 256
5. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
6. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 335
7. XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
8. XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() in XenForo/ViewRenderer/HtmlAdmin.php at line 130
9. XenForo_ViewRenderer_HtmlAdmin->renderContainer() in XenForo/FrontController.php at line 618
10. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
11. XenForo_FrontController->run() in /home/nwfa/public_html/admin.php at line 13

 

[Slavik]

AdminCP > Tools > Server Error log.

Post the error up.

 

[Joe Link]

Thanks @Slavik. There are actually 8 different entries, that all look very similar. I'll post the two that look like they're most different from each other.

Error Info
XenForo_Exception: Elasticsearch indexing failed for post-1041025 Elasticsearch error: MapperParsingException[failed to parse [prefix]]; nested: NumberFormatException[For input string: "1,2"]; - library/XenES/Search/SourceHandler/ElasticSearch.php:840
Generated By:, Today at 3:12 AM
Stack Trace
#0 /home/public_html/library/XenES/Search/SourceHandler/ElasticSearch.php(958): XenES_Search_SourceHandler_ElasticSearch->_logSearchResponseError('MapperParsingEx...', true, 'Elasticsearch i...')
#1 /home/public_html/library/XenES/Search/SourceHandler/ElasticSearch.php(76): XenES_Search_SourceHandler_ElasticSearch->_triggerFailedIndexError(Object(stdClass), Array)
#2 /home/public_html/library/XenForo/Search/Indexer.php(125): XenES_Search_SourceHandler_ElasticSearch->finalizeRebuildSet()
#3 /home/public_html/library/XenForo/Deferred/SearchIndex.php(74): XenForo_Search_Indexer->finalizeRebuildSet()
#4 /home/public_html/library/XenForo/Model/Deferred.php(256): XenForo_Deferred_SearchIndex->execute(Array, Array, 7.68187117577, '')
#5 /home/public_html/library/XenForo/Model/Deferred.php(390): XenForo_Model_Deferred->runDeferred(Array, 7.68187117577, '', false)
#6 /home/public_html/library/XenForo/Model/Deferred.php(335): XenForo_Model_Deferred->_runInternal(Array, 7.68187403679, '', false)
#7 /home/public_html/library/XenForo/ViewRenderer/Abstract.php(352): XenForo_Model_Deferred->run(true, 7.68187403679)
#8 /home/public_html/library/XenForo/ViewRenderer/Json.php(147): XenForo_ViewRenderer_Abstract::hasManualDeferredToRun()
#9 /home/public_html/library/XenForo/ViewRenderer/Json.php(185): XenForo_ViewRenderer_Json::_addDefaultParams(Array)
#10 /home/public_html/library/XenForo/ViewRenderer/Json.php(61): XenForo_ViewRenderer_Json::jsonEncodeForOutput(Array)
#11 /home/public_html/library/XenForo/FrontController.php(574): XenForo_ViewRenderer_Json->renderError('Elasticsearch i...')
#12 /home/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_Error), Object(XenForo_ViewRenderer_Json), Array)
#13 /home/public_html/admin.php(13): XenForo_FrontController->run()
#14 {main}
Request State
array(3) {
["url"] => string(61) "http://www.com/admin.php?tools/run-deferred"
["_GET"] => array(1) {
["tools/run-deferred"] => string(0) ""
}
["_POST"] => array(5) {
["execute"] => string(1) "1"
["_xfRequestUri"] => string(24) "/admin.php?tools/rebuild"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}

Error Info
XenForo_Exception: Elasticsearch indexing failed. See the server error log for more details. - library/XenES/Search/SourceHandler/ElasticSearch.php:968
Generated By: Today at 3:09 AM
Stack Trace
#0 /home/public_html/library/XenES/Search/SourceHandler/ElasticSearch.php(76): XenES_Search_SourceHandler_ElasticSearch->_triggerFailedIndexError(Object(stdClass), Array)
#1 /home/public_html/library/XenForo/Search/Indexer.php(125): XenES_Search_SourceHandler_ElasticSearch->finalizeRebuildSet()
#2 /home/public_html/library/XenForo/Deferred/SearchIndex.php(74): XenForo_Search_Indexer->finalizeRebuildSet()
#3 /home/public_html/library/XenForo/Model/Deferred.php(256): XenForo_Deferred_SearchIndex->execute(Array, Array, 4.92365407944, '')
#4 /home/public_html/library/XenForo/Model/Deferred.php(390): XenForo_Model_Deferred->runDeferred(Array, 4.92365407944, '', false)
#5 /home/public_html/library/XenForo/Model/Deferred.php(335): XenForo_Model_Deferred->_runInternal(Array, 4.92365598679, '', false)
#6 /home/public_html/library/XenForo/ViewRenderer/Abstract.php(352): XenForo_Model_Deferred->run(true, 4.92365598679)
#7 /home/public_html/library/XenForo/ViewRenderer/HtmlAdmin.php(130): XenForo_ViewRenderer_Abstract::hasManualDeferredToRun(true)
#8 /home/public_html/library/XenForo/FrontController.php(618): XenForo_ViewRenderer_HtmlAdmin->renderContainer(Object(XenForo_Template_Admin), Array)
#9 /home/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_Error), Object(XenForo_ViewRenderer_HtmlAdmin), Array)
#10 /home/public_html/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
["url"] => string(61) "http://www.com/admin.php?tools/run-deferred"
["_GET"] => array(1) {
["tools/run-deferred"] => string(0) ""
}
["_POST"] => array(3) {
["redirect"] => string(66) "http://www.com/admin.php?tools/rebuild&success=1"
["execute"] => string(1) "1"
["_xfToken"] => string(8) "********"
}
}

 

[Mike]

It looks like you may have an add-on that allows multiple prefixes. The author would need to see what changes are needed for elasticsearch then.

 

[rdn]

It's @Daniel Hood I think.

 

[Joe Link]

Thanks for the info guys, hopefully he'll offer a suggestion.

I don't actually use that plugin, would it be worthwhile to uninstall it and try running the index again?

 

[Daniel Hood]

I don't have access to elastic search or a server that I can install it on. If you'd like to give me ftp access I'll try to take a look later.

 

[Slavik]

Thanks for the info guys, hopefully he'll offer a suggestion.

I don't actually use that plugin, would it be worthwhile to uninstall it and try running the index again?

Yup

 

[Joe Link]

I don't have access to elastic search or a server that I can install it on. If you'd like to give me ftp access I'll try to take a look later.

I appreciate the offer, Daniel. I'd rather not waste your time, if I can just get this uninstalled.

Yup

I tried to uninstall it via the AdminCP, here's the error I got.

Server Error
Mysqli statement execute error : Data truncated for column 'prefix_id' at row 147035

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in XenMods/MultiPrefix/Install.php at line 20
4. XenMods_MultiPrefix_Install::UnInstall()
5. call_user_func() in XenForo/DataWriter/AddOn.php at line 200
6. XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1779
7. XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 122
8. XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 347
9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
10. XenForo_FrontController->run() in /home/nwfa/public_html/admin.php at line 13

 

[Joe Link]

Hmm, I'm not sure if it worked or not (due to the error), but it's not on the add-on list now.

Should I try running the index now?

 

[Daniel Hood]

Yes, that error makes sense because it's changing the field type of the table. Run the index again and you should be good.

 

[Joe Link]

Thanks, I'll try that. I just went into the tools section, clicked the Rebuild Caches square, and this error popped up before I could click rebuild search index.

I'm going to run the rebuild now.

An exception occurred: Elasticsearch indexing failed. See the server error log for more details. in /home/public_html/library/XenES/Search/SourceHandler/ElasticSearch.php on line 968

1. XenES_Search_SourceHandler_ElasticSearch->_triggerFailedIndexError() inXenES/Search/SourceHandler/ElasticSearch.php at line 76
2. XenES_Search_SourceHandler_ElasticSearch->finalizeRebuildSet() inXenForo/Search/Indexer.php at line 125
3. XenForo_Search_Indexer->finalizeRebuildSet() in XenForo/Deferred/SearchIndex.php at line 74
4. XenForo_Deferred_SearchIndex->execute() in XenForo/Model/Deferred.php at line 256
5. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
6. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 335
7. XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
8. XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() inXenForo/ViewRenderer/Json.php at line 147
9. XenForo_ViewRenderer_Json::_addDefaultParams() in XenForo/ViewRenderer/Json.phpat line 185
10. XenForo_ViewRenderer_Json::jsonEncodeForOutput() in XenForo/ViewRenderer/Json.phpat line 61
11. XenForo_ViewRenderer_Json->renderError() in XenForo/FrontController.php at line 574
12. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
13. XenForo_FrontController->run() in /home/public_html/admin.php at line 13

 

[Joe Link]

No luck, here's the error.

An exception occurred: Elasticsearch indexing failed. See the server error log for more details. in /home/public_html/library/XenES/Search/SourceHandler/ElasticSearch.php on line 968

1. XenES_Search_SourceHandler_ElasticSearch->_triggerFailedIndexError() in XenES/Search/SourceHandler/ElasticSearch.php at line 76
2. XenES_Search_SourceHandler_ElasticSearch->finalizeRebuildSet() in XenForo/Search/Indexer.php at line 125
3. XenForo_Search_Indexer->finalizeRebuildSet() in XenForo/Deferred/SearchIndex.php at line 74
4. XenForo_Deferred_SearchIndex->execute() in XenForo/Model/Deferred.php at line 256
5. XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 390
6. XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 335
7. XenForo_Model_Deferred->run() in XenForo/ViewRenderer/Abstract.php at line 352
8. XenForo_ViewRenderer_Abstract::hasManualDeferredToRun() in XenForo/ViewRenderer/HtmlAdmin.php at line 130
9. XenForo_ViewRenderer_HtmlAdmin->renderContainer() in XenForo/FrontController.php at line 618
10. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
11. XenForo_FrontController->run() in /home/public_html/admin.php at line 13

 

[Joe Link]

Any ideas guys? I can't add new nodes now...

 

[Mike]

It's possible the add-on didn't change the data structure back as expected (changing the type of data stored in a default column is a really bad/dangerous idea...). If that's the case, then the mix of data types would still be in the DB.

In terms of the index though, because of this, you'd need to choose the option to empty the index before proceeding.

 

[Daniel Hood]

If you provide me ftp and mysql access, I'll fix the issue for you (or at the very least, try my best).