Elasticsearch Indexing Failed

Joe Link

Well-known member
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
 
Last edited:
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) "********"
}
}
 
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.
 
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?
 
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.


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
 
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
 
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
 
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.
 
Back
Top Bottom