Smart Search Indexer - MariaDB SQL Syntax Error

[smirre]

Hi.

I noticed that the Smart Search Indexer are failing and does stop always around 90%.

I attached the error message from the backend.
The error came up on both sides when i run the indexer: CLI and Backend

Maybe someone have the same problem or can help me here.

CONFIG:
server: cloudserver - Linux ubuntu 18 x64
server administration: runcloud
Database: 5.5.5-10.2.15-MariaDB-1:10.2.15+maria~bionic-log
PHP: 7.2.8
Webserver: Apache/2.4.34
Joomla: 3.8.12

[smirre]

i tested also to increase the memory size for this mysql entries, without luck:

Code: Select all

tmp_table_size = 64M
max_heap_table_size = 64M 

the error still exists:

Code: Select all

...
* Processed batch 92 in 5.166 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 12' at line 1

i also read this documentations, but I haven't found a workable solution:
https://docs.joomla.org/Smart_Search_co ... on_options
https://docs.joomla.org/Smart_Search_on_large_sites

[smirre]

anyone you can help me here?

[Webdongle]

https://issues.joomla.org/

[smirre]

hi Webdongle, thx for info.
i have published there my problem.
i think my post could deleted here know...