Hello, I found that in my archive purged messages not removed from main1 index. Here are the query examples:
# Get data from sphinx # mysql -h 127.0.0.1 -P 9306 mysql> show tables; +-------------+-------+ | Index | Type | +-------------+-------+ | dailydelta1 | local | | delta1 | local | | main1 | local | | main2 | local | | main3 | local | | main4 | local | | note1 | local | | tag1 | local | +-------------+-------+ 8 rows in set (0.00 sec) mysql> select * from main1 where id = 11; +------+------------+------------+------+-----------+--------+-------------+ | id | arrived | sent | size | direction | folder | attachments | +------+------------+------------+------+-----------+--------+-------------+ | 11 | 1383038432 | 1352945411 | 0 | 3 | 0 | 1 | +------+------------+------------+------+-----------+--------+-------------+ 1 row in set (0.00 sec) # Get data from Mysql server select `id`, arrived, retained, deleted from metadata where id = 11 Output id arrived retained deleted 11 1383038432 1387159811 1 So the same id still available in sphinx... sphinxsearch version is 2.0.4-1.1 sql_query_killlist is enabled at sphinx.conf, indexer.*sh scripts active in piler cron. Do you know if there any problems / known bugs with this sphinx version? Thank you. -- *This message was delivered using 100% recycled electrons*.
