Loading...
 

Tikiwiki-devel (mailman list mirror)


Search without searching !

posts: 228

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

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.