Loading...
 

Tikiwiki-devel (mailman list mirror)


Search without searching !

posts: 228

Does someone have an idea about this one?
https://dev.tiki.org/item6864-MariaDB-MySQL-Unified-Index-doesn-t-permit-same-reports-as-Elasticsearch-No-results-for-query

Otherwise, I need to re-activate Elasticsearch




On Fri, Oct 12, 2018 at 8:10 AM, Marc Laporte <marc@marclaporte.com> wrote:
> Yes, I think we need time of the right people to go the root of the problem.
>
> At the moment, these "right people" are focussing on 19.x blockers to make
> sure we can release on time.
>
> We can figure this out later.
>
> Thanks!
>
>
>
> On Friday, October 12, 2018, luciash <luci@tiki.org> wrote:
>>
>> Yeah,
>>
>> thanks Marc!
>>
>> luci
>>
>> PS: I would have thought the solution might be upping the server resources
>> again as it seemed to work in the beginning when the CPU cores and RAM were
>> more generous there but it must be more complicated than that I guess...
>>
>>
>> On 12.10.2018 4:21, Marc Laporte wrote:
>>>
>>> I rebooted.
>>>
>>> I deleted all the indexes from Elasticsearch
>>>
>>> I am reverting all sites to MariaDB full-text search
>>>
>>>
>>> We'll lose Federated search and facets but it will be more stable. We
>>> can re-activate when we have a solution.
>>>
>>>
>>>
>>>
>>> On Thu, Oct 11, 2018 at 3:55 AM, luciash <luci@tiki.org> wrote:
>>>>
>>>> Thank you Maude,
>>>>
>>>> seems ElasticSearch went down again because we have some memory issues
>>>> on
>>>> the server. @Marc?
>>>>
>>>> luci
>>>>
>>>>
>>>> On 11.10.2018 5:13, Polyna-Maude R.-Summerside wrote:
>>>>
>>>> Hi guys...
>>>>
>>>> Just logged in the dev.tiki.org server...
>>>>
>>>> Just did a normal login and without doing nothing, I received some error
>>>> messages...
>>>>
>>>> Look at the screenshot...
>>>>
>>>> Error
>>>>
>>>> Malformed search query
>>>>
>>>> Error
>>>>
>>>> Indexing failed while processing "6757" (type trackeritem) with the
>>>> error
>>>> "Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>> unable to connect to localhost:9200 (Connection refused)"
>>>>
>>>> Error
>>>>
>>>> Indexing failed while processing "17177" (type activity) with the error
>>>> "Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>> unable to connect to localhost:9200 (Connection refused)"
>>>>
>>>> Error
>>>>
>>>> Indexing failed while processing "6608" (type comment) with the error
>>>> "Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>> unable to connect to localhost:9200 (Connection refused)"
>>>>
>>>> Error
>>>>
>>>> The search index could not be updated. The site is misconfigured.
>>>> Contact an
>>>> administrator.
>>>> Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>> unable to connect to localhost:9200 (Connection refused)
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ___
>>>> TikiWiki-devel mailing list
>>>> TikiWiki-devel at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>
>>>>
>>>>
>>>>
>>>> ___
>>>> TikiWiki-devel mailing list
>>>> TikiWiki-devel at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>
>>>
>>>
>>
>>
>>
>> ___
>> TikiWiki-devel mailing list
>> TikiWiki-devel at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>
>
>
> --
> Marc Laporte
>
> http://WikiSuite.org
> http://PluginProblems.com
> http://Avan.Tech



--
Marc Laporte

http://WikiSuite.org
http://PluginProblems.com
http://Avan.Tech


___
TikiWiki-devel mailing list
TikiWiki-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

I think that's the reason:

https://mariadb.com/kb/en/library/full-text-index-stopwords/

new is a stopword and you filter by resolution status - one of which is
New. Mysql index uses fulltext search on that column which ignores the
New keyword.

On 10/12/2018 06:09 PM, Marc Laporte wrote:
> Does someone have an idea about this one?
> https://dev.tiki.org/item6864-MariaDB-MySQL-Unified-Index-doesn-t-permit-same-reports-as-Elasticsearch-No-results-for-query
>
> Otherwise, I need to re-activate Elasticsearch
>
>
>
>
> On Fri, Oct 12, 2018 at 8:10 AM, Marc Laporte <marc@marclaporte.com> wrote:
>> Yes, I think we need time of the right people to go the root of the problem.
>>
>> At the moment, these "right people" are focussing on 19.x blockers to make
>> sure we can release on time.
>>
>> We can figure this out later.
>>
>> Thanks!
>>
>>
>>
>> On Friday, October 12, 2018, luciash <luci@tiki.org> wrote:
>>> Yeah,
>>>
>>> thanks Marc!
>>>
>>> luci
>>>
>>> PS: I would have thought the solution might be upping the server resources
>>> again as it seemed to work in the beginning when the CPU cores and RAM were
>>> more generous there but it must be more complicated than that I guess...
>>>
>>>
>>> On 12.10.2018 4:21, Marc Laporte wrote:
>>>> I rebooted.
>>>>
>>>> I deleted all the indexes from Elasticsearch
>>>>
>>>> I am reverting all sites to MariaDB full-text search
>>>>
>>>>
>>>> We'll lose Federated search and facets but it will be more stable. We
>>>> can re-activate when we have a solution.
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Oct 11, 2018 at 3:55 AM, luciash <luci@tiki.org> wrote:
>>>>> Thank you Maude,
>>>>>
>>>>> seems ElasticSearch went down again because we have some memory issues
>>>>> on
>>>>> the server. @Marc?
>>>>>
>>>>> luci
>>>>>
>>>>>
>>>>> On 11.10.2018 5:13, Polyna-Maude R.-Summerside wrote:
>>>>>
>>>>> Hi guys...
>>>>>
>>>>> Just logged in the dev.tiki.org server...
>>>>>
>>>>> Just did a normal login and without doing nothing, I received some error
>>>>> messages...
>>>>>
>>>>> Look at the screenshot...
>>>>>
>>>>> Error
>>>>>
>>>>> Malformed search query
>>>>>
>>>>> Error
>>>>>
>>>>> Indexing failed while processing "6757" (type trackeritem) with the
>>>>> error
>>>>> "Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>>> unable to connect to localhost:9200 (Connection refused)"
>>>>>
>>>>> Error
>>>>>
>>>>> Indexing failed while processing "17177" (type activity) with the error
>>>>> "Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>>> unable to connect to localhost:9200 (Connection refused)"
>>>>>
>>>>> Error
>>>>>
>>>>> Indexing failed while processing "6608" (type comment) with the error
>>>>> "Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>>> unable to connect to localhost:9200 (Connection refused)"
>>>>>
>>>>> Error
>>>>>
>>>>> The search index could not be updated. The site is misconfigured.
>>>>> Contact an
>>>>> administrator.
>>>>> Unable to connect to localhost:9200 . Error #0: stream_socket_client():
>>>>> unable to connect to localhost:9200 (Connection refused)
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> TikiWiki-devel mailing list
>>>>> TikiWiki-devel at lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> TikiWiki-devel mailing list
>>>>> TikiWiki-devel at lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>>>>
>>>>
>>>
>>>
>>> ___
>>> TikiWiki-devel mailing list
>>> TikiWiki-devel at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>
>>
>> --
>> Marc Laporte
>>
>> http://WikiSuite.org
>> http://PluginProblems.com
>> http://Avan.Tech
>
>



___
TikiWiki-devel mailing list
TikiWiki-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel


Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.