pilerpurge.py -> Error 1064 You have an error in your SQL syntax

Hi Janos, hope you are doing well!

I have an issue with pilerpurge.py in your latest branch:

/usr/local/libexec/piler/pilerpurge.py -d

The output looks fine:

/var/piler/store/00/61e/86/c8/5000000061e04b79082388c40080e0a586c8.m
/var/piler/store/00/61e/31/5c/5000000061e04cf4397e8f2c001b5a46315c.m
/var/piler/store/00/61e/69/c4/5000000061e04d4711132d7c000e54fa69c4.m
...
/var/piler/store/00/61e/24/43/5000000061e07f5a323f1efc001b37892443.a1
/var/piler/store/00/61e/b3/e2/5000000061e080453a94fc8400342308b3e2.a1
[105430, 107671, 108147, 108674, 110586, 130045, 131255, 134945, 143116, 143633, 143960, 147508, 152676, 153559, 162918, 183531, 183661, 184728, 186114]

But when I try execute it without the -d:

/usr/local/libexec/piler/pilerpurge.py

I get the following error message:

Error (1064, "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 'IN ('5000000061e04b79082388c40080e0a586c8', '5000000061e04cf4397e8f2c001b5a46...' at line 1")

Unfortunately, the (deleted) mails are still present in the webui. The following messages appear in the syslog:

pilerpurge.py[163027]: Purged 19 messages, 0 files, 120584/0 bytes
piler: INDEXER INFO: indexing delta1 started
piler: INDEXER INFO: indexing delta1 finished
piler: INDEXER INFO: merging delta to dailydelta started
piler: INDEXER INFO: merging delta to dailydelta finished
pilerget[163164]: /var/piler/store/00/61e/b3/e2/5000000061e080453a94fc8400342308b3e2.m: cannot open()
pilerget[163166]: /var/piler/store/00/61e/b3/e2/5000000061e080453a94fc8400342308b3e2.m: cannot open()
...
pilerget[163264]: /var/piler/store/00/61e/86/c8/5000000061e04b79082388c40080e0a586c8.m: cannot open()
pilerget[163266]: /var/piler/store/00/61e/86/c8/5000000061e04b79082388c40080e0a586c8.m: cannot open()

Do you have any idea what could causing this?

Many thanks and best regards,

Valerio

Comments (7)