ElasticSearch Fehler 3.1 & 5.2

Darklord · Jan 30th 2020

Scheinbar hat die Suche mit ElasticSearch ein Problem, wenn keine Inhalte vorhanden sind, jedenfalls fiel es beim Update von einer 3.1 zu 5.2 Installation auf, was nach weiteren Tests in meiner Testumgebung zu folgenden Erkenntnissen führte.

Eine jeweils neu aufgesetzte Test Installation von einer 3.1 und 5.2, in beiden Fällen das ElasticSearch Plugin installiert, bei einer ersten Suche bekommt man sofort einen Fatal Error von ElasticSearch ausgeworfen, weil keine Artikel, Seiten oder Konversationen vorhanden sind.

Dieses Problem ist unter anderem auch in etwaigen Plugins vorhanden, in meinem Fall war es das Partner Plugin, wo der Fehler das erste Mal auftrat.

Anbei die Logauszüge aus der 3.1 Installation

Requested URL: /wsc3/index.php?search/

Referrer: https://testdomain.de/wsc3/

Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.

Type: wcf\system\search\elasticsearch\ElasticsearchException

File (Line): /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)

Stacktrace

/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (201): wcf\system\search\elasticsearch\ElasticsearchHandler->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (70): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->getInnerJoin(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/SearchEngine.class.php (102): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (286): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (60): wcf\form\SearchForm->validate(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (313): wcf\form\AbstractForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (113): wcf\form\SearchForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractCaptchaForm.class.php (67): wcf\form\AbstractForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (291): wcf\form\AbstractCaptchaForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (418): wcf\page\AbstractPage->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (114): wcf\form\SearchForm->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 30 Jan 2020 18:49:06 +0000
Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
PHP version: 7.3.14
WoltLab Suite version: 3.1.11
Request URI: /wsc3/index.php?search/
Referrer: https://testdomain.de/wsc3/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Peak Memory Usage: 2828072/268435456
======
Error Class: wcf\system\search\elasticsearch\ElasticsearchException
Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
Error Code: 0
File: /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":201,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchHandler","type":"->","args":["com_woltlab_wcf_conversation_message",["[redacted]","[redacted]","[redacted]"],[],2500,"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":70,"function":"getInnerJoin","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["com.woltlab.wcf.conversation.message","test*",0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder","time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/SearchEngine.class.php","line":102,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":286,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":60,"function":"validate","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":313,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":113,"function":"submit","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractCaptchaForm.class.php","line":67,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\form\\AbstractCaptchaForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":418,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]



elasticsearch error:

Array
(
    [root_cause] => Array
        (
            [0] => Array
                (
                    [type] => query_shard_exception
                    [reason] => No mapping found for [time] in order to sort on
                    [index_uuid] => 7TYgquyxRFaV-TjFYAyecg
                    [index] => wcf_test3_com_woltlab_wcf_article
                )

        )

    [type] => search_phase_execution_exception
    [reason] => all shards failed
    [phase] => query
    [grouped] => 1
    [failed_shards] => Array
        (
            [0] => Array
                (
                    [shard] => 0
                    [index] => wcf_test3_com_woltlab_wcf_article
                    [node] => w7JYbOnUS86KB-m8615ktg
                    [reason] => Array
                        (
                            [type] => query_shard_exception
                            [reason] => No mapping found for [time] in order to sort on
                            [index_uuid] => 7TYgquyxRFaV-TjFYAyecg
                            [index] => wcf_test3_com_woltlab_wcf_article
                        )

                )

        )

)

Requested URL: /wsc3/index.php?search/

Referrer: https://testdomain.de/wsc3/

Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.

Type: wcf\system\search\elasticsearch\ElasticsearchException

File (Line): /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)

Stacktrace

/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (201): wcf\system\search\elasticsearch\ElasticsearchHandler->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (70): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->getInnerJoin(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/SearchEngine.class.php (102): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (286): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (60): wcf\form\SearchForm->validate(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (313): wcf\form\AbstractForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (113): wcf\form\SearchForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractCaptchaForm.class.php (67): wcf\form\AbstractForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (291): wcf\form\AbstractCaptchaForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (418): wcf\page\AbstractPage->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (114): wcf\form\SearchForm->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 30 Jan 2020 18:47:59 +0000
Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
PHP version: 7.3.14
WoltLab Suite version: 3.1.11
Request URI: /wsc3/index.php?search/
Referrer: https://testdomain.de/wsc3/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Peak Memory Usage: 2546520/268435456
======
Error Class: wcf\system\search\elasticsearch\ElasticsearchException
Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
Error Code: 0
File: /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":201,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchHandler","type":"->","args":["com_woltlab_wcf_page",["[redacted]","[redacted]","[redacted]"],[],2500,"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":70,"function":"getInnerJoin","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["com.woltlab.wcf.page","test*",0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder","time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/SearchEngine.class.php","line":102,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":286,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":60,"function":"validate","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":313,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":113,"function":"submit","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractCaptchaForm.class.php","line":67,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\form\\AbstractCaptchaForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":418,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]



Array
(
    [root_cause] => Array
        (
            [0] => Array
                (
                    [type] => query_shard_exception
                    [reason] => No mapping found for [time] in order to sort on
                    [index_uuid] => PhEqc8G3TbOryNYC7QAdCA
                    [index] => wcf_test3_com_woltlab_wcf_page
                )

        )

    [type] => search_phase_execution_exception
    [reason] => all shards failed
    [phase] => query
    [grouped] => 1
    [failed_shards] => Array
        (
            [0] => Array
                (
                    [shard] => 0
                    [index] => wcf_test3_com_woltlab_wcf_page
                    [node] => w7JYbOnUS86KB-m8615ktg
                    [reason] => Array
                        (
                            [type] => query_shard_exception
                            [reason] => No mapping found for [time] in order to sort on
                            [index_uuid] => PhEqc8G3TbOryNYC7QAdCA
                            [index] => wcf_test3_com_woltlab_wcf_page
                        )

                )

        )

)

Requested URL: /wsc3/index.php?search/

Referrer: https://testdomain.de/wsc3/

Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.

Type: wcf\system\search\elasticsearch\ElasticsearchException

File (Line): /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)

Stacktrace

/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (201): wcf\system\search\elasticsearch\ElasticsearchHandler->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (70): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->getInnerJoin(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/SearchEngine.class.php (102): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (286): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (60): wcf\form\SearchForm->validate(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (313): wcf\form\AbstractForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (113): wcf\form\SearchForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractCaptchaForm.class.php (67): wcf\form\AbstractForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (291): wcf\form\AbstractCaptchaForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (418): wcf\page\AbstractPage->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (114): wcf\form\SearchForm->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 30 Jan 2020 18:46:17 +0000
Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
PHP version: 7.3.14
WoltLab Suite version: 3.1.11
Request URI: /wsc3/index.php?search/
Referrer: https://testdomain.de/wsc3/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Peak Memory Usage: 2894056/268435456
======
Error Class: wcf\system\search\elasticsearch\ElasticsearchException
Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
Error Code: 0
File: /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":201,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchHandler","type":"->","args":["com_woltlab_wcf_article",["[redacted]","[redacted]","[redacted]"],[],2500,"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":70,"function":"getInnerJoin","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["com.woltlab.wcf.article","test*",0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder","time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/SearchEngine.class.php","line":102,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":286,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":60,"function":"validate","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":313,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":113,"function":"submit","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractCaptchaForm.class.php","line":67,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\form\\AbstractCaptchaForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":418,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]



Array
(
    [root_cause] => Array
        (
            [0] => Array
                (
                    [type] => query_shard_exception
                    [reason] => No mapping found for [time] in order to sort on
                    [index_uuid] => r8krVZUMQ-K6P_MaUDFZhA
                    [index] => wcf_test3_com_woltlab_wcf_conversation_message
                )

        )

    [type] => search_phase_execution_exception
    [reason] => all shards failed
    [phase] => query
    [grouped] => 1
    [failed_shards] => Array
        (
            [0] => Array
                (
                    [shard] => 0
                    [index] => wcf_test3_com_woltlab_wcf_conversation_message
                    [node] => w7JYbOnUS86KB-m8615ktg
                    [reason] => Array
                        (
                            [type] => query_shard_exception
                            [reason] => No mapping found for [time] in order to sort on
                            [index_uuid] => r8krVZUMQ-K6P_MaUDFZhA
                            [index] => wcf_test3_com_woltlab_wcf_conversation_message
                        )

                )

        )

)

Ups, falsches Forum erwischt. Bitte verschieben.

**Alexander Ebert** · Jan 30th 2020

Nach der Aktivierung von Elasticsearch müssen unter "Anzeigen aktualisieren" die Aufgaben für Suchindizes ausgeführt werden. Auf diese Weise werden die Indizes sowie deren Mapping angelegt, andernfalls kommt es zu den genannten Meldungen.

Darklord · Jan 30th 2020

Hallo Alexander Ebert,

dies wurde in beiden Test Instanzen getan, ebenfalls nach dem Update von der 3.1 auf 5.2, der Fehler trat dennoch auf.

**Alexander Ebert** · Jan 30th 2020

Welche Version von Elasticsearch wird verwendet?

PS: Die reguläre Exception mit dem Verweis auf den separaten Log-File von Elasticsearch ist nicht wirklich nützlich

Darklord · Jan 30th 2020

Die Version 3.1.3 in der WSC 3.1 und die Version 5.2.0 in der WSC 5.2.

ElasticSearch Version: 6.6.1

Requested URL: /wsc3/index.php?search/

Referrer: https://testdomain.de/wsc3/

Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.

Type: wcf\system\search\elasticsearch\ElasticsearchException

File (Line): /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)

Stacktrace

/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (201): wcf\system\search\elasticsearch\ElasticsearchHandler->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchSearchEngine.class.php (70): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->getInnerJoin(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/SearchEngine.class.php (102): wcf\system\search\elasticsearch\ElasticsearchSearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (286): wcf\system\search\SearchEngine->search(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (60): wcf\form\SearchForm->validate(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (313): wcf\form\AbstractForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractForm.class.php (113): wcf\form\SearchForm->submit(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/AbstractCaptchaForm.class.php (67): wcf\form\AbstractForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (291): wcf\form\AbstractCaptchaForm->readData(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/form/SearchForm.class.php (418): wcf\page\AbstractPage->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/page/AbstractPage.class.php (114): wcf\form\SearchForm->show(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/vhosts/testdomain.de/httpdocs/wsc3/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 30 Jan 2020 20:17:22 +0000
Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
PHP version: 7.3.14
WoltLab Suite version: 3.1.11
Request URI: /wsc3/index.php?search/
Referrer: https://testdomain.de/wsc3/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Peak Memory Usage: 2547744/268435456
======
Error Class: wcf\system\search\elasticsearch\ElasticsearchException
Error Message: elasticsearch error, the message has been dumped to 'log/elasticsearch_2020-01-30.txt'.
Error Code: 0
File: /var/www/vhosts/testdomain.de/httpdocs/wsc3/lib/system/search/elasticsearch/ElasticsearchHandler.class.php (401)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":201,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchHandler","type":"->","args":["com_woltlab_wcf_conversation_message",["[redacted]","[redacted]","[redacted]"],[],2500,"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/elasticsearch\/ElasticsearchSearchEngine.class.php","line":70,"function":"getInnerJoin","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["com.woltlab.wcf.conversation.message","test*",0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder","time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/search\/SearchEngine.class.php","line":102,"function":"search","class":"wcf\\system\\search\\elasticsearch\\ElasticsearchSearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC",1000]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":286,"function":"search","class":"wcf\\system\\search\\SearchEngine","type":"->","args":["test",{"0":"[redacted]","1":"[redacted]","2":"[redacted]","3":"[redacted]","5":"[redacted]"},0,"wcf\\system\\database\\util\\ElasticsearchPreparedStatementConditionBuilder",{"com.woltlab.wcf.article":"[redacted]","com.woltlab.wcf.page":"[redacted]","com.woltlab.wcf.conversation.message":"[redacted]","com.woltlab.wbb.post":"[redacted]","com.kittmedia.wcf.partners.banner":"[redacted]"},"time DESC"]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":60,"function":"validate","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":313,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractForm.class.php","line":113,"function":"submit","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/AbstractCaptchaForm.class.php","line":67,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\form\\AbstractCaptchaForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/form\/SearchForm.class.php","line":418,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\form\\SearchForm","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/testdomain.de\/httpdocs\/wsc3\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Code: ElasticSearch Log

Thu, 30 Jan 2020 21:17:22 +0000
elasticsearch error:

Array
(
    [root_cause] => Array
        (
            [0] => Array
                (
                    [type] => query_shard_exception
                    [reason] => No mapping found for [time] in order to sort on
                    [index_uuid] => Xd6YN6ipQP2lhVRyf4e0rA
                    [index] => wcf_test3_com_woltlab_wcf_conversation_message
                )

        )

    [type] => search_phase_execution_exception
    [reason] => all shards failed
    [phase] => query
    [grouped] => 1
    [failed_shards] => Array
        (
            [0] => Array
                (
                    [shard] => 0
                    [index] => wcf_test3_com_woltlab_wcf_conversation_message
                    [node] => w7JYbOnUS86KB-m8615ktg
                    [reason] => Array
                        (
                            [type] => query_shard_exception
                            [reason] => No mapping found for [time] in order to sort on
                            [index_uuid] => Xd6YN6ipQP2lhVRyf4e0rA
                            [index] => wcf_test3_com_woltlab_wcf_conversation_message
                        )

                )

        )

)

<<<<

Display More

**Alexander Ebert** · Jan 30th 2020

Quote from Darklord

ElasticSearch Version: 6.6.1

Das ist eine ziemlich alte Version, selbst innerhalb der 6.6er Reihe ist diese nicht aktuell.

Mich würde konkret das Mapping des Index interessieren, offenbar stimmt dort etwas nicht:

Code

curl -X GET "localhost:9200/wcf_test3_com_woltlab_wcf_conversation_message/_mapping?pretty"

Falls Elasticsearch auf einem anderen Host oder Port läuft, sollte dies entsprechend angepasst werden.

Darklord · Jan 30th 2020

Code

 % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current   Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0100    84  100    84    0     0  11249      0 --:--:-- --:--:-- --:--:-- 12000
{
  "wcf_test3_com_woltlab_wcf_conversation_message" : {
    "mappings" : { }
  }
}

Quote from Alexander Ebert

Das ist eine ziemlich alte Version, selbst innerhalb der 6.6er Reihe ist diese nicht aktuell.

~~Wird in absehbarer Zeit noch Upgedatet, sobald ich die Zeit dazu finde.~~

Eben die Zeit noch genommen, Version "number" : "7.5.2",

Nach einem erneuten Anzeigen Aktualisieren scheint es nun zu klappen.

Code

% Total    % Received % Xferd  Average Speed   Time    Time     Time  Current  Dload  Upload   Total   Spent    Left  Speed
0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0100   647  100   647    0     0  97366      0 --:--:-- --:--:-- --:--:--  105k
{
  "wcf_test3_com_woltlab_wcf_conversation_message" : {
    "mappings" : {
      "_source" : {
        "enabled" : false
      },
      "properties" : {
        "languageID" : {
          "type" : "long"
        },
        "message" : {
          "type" : "text"
        },
        "metaData" : {
          "type" : "text"
        },
        "objectID" : {
          "type" : "long"
        },
        "subject" : {
          "type" : "text"
        },
        "time" : {
          "type" : "long"
        },
        "userID" : {
          "type" : "long"
        },
        "username" : {
          "type" : "text"
        }
      }
    }
  }
}

Display More

Lag wohl an der älteren Version, mich wundert nur, das es vorher nie Anzeichen oder Probleme gab.

ElasticSearch Fehler 3.1 & 5.2

Alexander Ebert Jan 30th 2020

Participate now!

Share

Similar Threads

Fehler beim Update von WSC 3.1 -> 5.2

[3.1+5.2] Typo

ElasticSearch in 3.1.3 verhindert Upgrade

ElasticSearch Fehler nach Update auf 3.1.2