manticore.conf does not create Database tables when RT == 1 during initial startup

[Niklas Meyer]

Hi,

i just found out that it seems to be that the manticore.conf is not correctly creating the desired Tables for manticore inside the DB when you activate the RealTime Mode for indexing (RT) inside the manticore.conf.

‌

As you can see inside the manticore.conf Example (here: https://bitbucket.org/jsuto/piler/src/4f948d3d5c584d8fe3c848a56f1fc0021340872b/etc/manticore.conf.in#lines-25) the basic tables are created only when RT != 1.

Otherwise only the steps from Line 188 (https://bitbucket.org/jsuto/piler/src/4f948d3d5c584d8fe3c848a56f1fc0021340872b/etc/manticore.conf.in#lines-188) is adapted.

‌

I found this issue during the upgrade process on a dockerized instance.

I think it’s not a big issue to fix as it seems to be a logical issue or it is designed like this, which does not make any sense then as the official docs don’t say that you need to have it disabled for the initial manticore setup to work: https://www.mailpiler.org/manticore-search/

[Janos SUTO]

Hello, I’m confused. The mentioned tables are not required for real time index. Manticore should create a single table called piler1.

[Niklas Meyer]

Sorry for the confusion, let me tell you what i did so you can might relate to that better:

‌

1. I moved from a Piler 1.3.12 Instance to the latest 1.4.4 Version with docker so changed the image tag.
2. I copied the manticore.conf from this repo as there was none after upgrading to manticore as it would if you compile piler manually on your system (manticore.conf.dist)
3. I enabled RT (the real time index) inside the manticore.conf, piler.conf and config-site.php as discribed in your docs page: https://www.mailpiler.org/manticore-search/
4. I started the containers and analysed the logs. Which said: no table available in manticore.conf → Piler won’t boot up correctly.
5. I removed the RT option from the piler.conf and the manticore.conf (set it back to 0 instead 1) and restarted the piler container.
6. Manticore is now booting up correctly and the tables are created → Piler boots now normally and stays up.
7. I reenabled the RT option inside piler.conf and manticore.conf (set it to 1 instead 0) and restarted piler.
8. Piler was still booting normally but now with the Real time index.

So i think something might not be created correctly in case of tables for the general usage of Manticore as a Indexer when using RT instantly during the initiation of Manticore. Don’t know if this is a docker issue or else.

‌

Hope it is now clearer what i meant with that?

‌

[Janos SUTO]

OK, I see. I’ve just committed a fix to enable RT=1 support using docker, see https://bitbucket.org/jsuto/piler/commits/68fed34a5348446428a2a436110d77bcc3887d24

[Niklas Meyer]

Thanks a lot!