• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Elasticsearch Indexing Failed

Joe Link

Well-known member
#1
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:

Joe Link

Well-known member
#3
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

XenForo developer
Staff member
#4
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.
 

Joe Link

Well-known member
#6
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

Well-known member
#7
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.
 

Joe Link

Well-known member
#9
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
 

Joe Link

Well-known member
#10
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?
 

Joe Link

Well-known member
#12
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

Well-known member
#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
 

Mike

XenForo developer
Staff member
#15
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.