piler-webui[5473]: unknown local index 'main1' in search request

I recently upgraded Piler to version 1.3.12, build 1001, as well as sphinx to version 3.3.1.

After upgrading I reindex’ed everything successfuly, and run delta-index.sh scripts. The problem is - after upgrading to version 1.3.10 or 1.3.11 I ended up with 1.3.12. In every version I had the same problem with webUI, where there were no emails like shown on attached screenshot:

I really hoped that upgrading sphinx to 3.3.1 and reindexing everything will solve the issue but I still struggled with the same problem.

After searching for logs I found this in /var/log/maillog:

Apr 28 18:45:09 archive piler-webui[5473]: unknown local index 'main1' in search request
Apr 28 18:45:09 archive piler-webui[5473]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE        MATCH('') ORDER BY `sent` DESC LIMIT 0,50 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found

After that I restarted searchd and piler services, but this still did not fix my problems. The sphinx directory (/var/piler/sphinx) has all the required files with piler:piler permissions. I checked database by connecting to it via

mysql -P9306 --protocol=tcp --prompt='sphinxQL> ' -u piler

but I could not view databases or tables - it was visible when connecting to standard mariadb instance which directory expanded after using “reindex -a”

Any help would be greatly appreciated

‌

Comments (2)