Cannot index plain table with latest manticore

General Discussions - English
1

Hello teams,

I cannot index manticore plain table with latest manticore version (may 2025).
Here the errors :

listening on 127.0.0.1:9312 for sphinx and http(s)
listening on 127.0.0.1:9306 for mysql
listening on 127.0.0.1:9308 for sphinx and http(s)
precaching table ‘idx_baz’
Index header format is not json, will try it as binary…
WARNING: Unable to load header… Error failed to open /var/lib/manticore/data/idx_baz.sph: No such file or directory
WARNING: table ‘idx_baz’: prealloc: failed to open /var/lib/manticore/data/idx_baz.sph: No such file or directory - NOT SERVING
precaching table ‘idx_baz_news’

I have used that installation process :
wget https://repo.manticoresearch.com/manticore-repo.noarch.deb
sudo dpkg -i manticore-repo.noarch.deb
sudo apt update
sudo apt install manticore manticore-columnar-lib
sudo systemctl start manticore

Any clues ?

2

seems idx_baz table missed. If you use plain mode you need to index your data first with indexter

1 Like
3

Thanks, i have used “indexer --rotate idx_baz”, i have error “ERROR: table ‘idx_baz’: can not redefine auto-defined ‘id’ attribute.” , in select query i have "SELECT NUM_ID as id "

4

Thanks, i have found a solution, not need to redeclare “sql_attr_bigint = id” in new version of manticore !