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)
-
repo owner -
reporter Latest version up to commit 7aec464.
-
reporter I narrowed down the error. When I use an older version of pilerpurge (before commit: https://bitbucket.org/jsuto/piler/commits/183162ac4a1191478dea13479e47c0ac7883ba12 ) then it works like a charm.
-
repo owner Thank you for the debugging. I’ll investigate this commit more carefully.
-
same on my database.
looks like it is the metadata table, i found the mentioned piler_ids there.The Piler_Id is a attachment
-
got the issue. Fixed it here:
https://bitbucket.org/jsuto/piler/pull-requests/28/feat-fix-pilerpurge-1226 -
repo owner - changed status to resolved
fix whitespace issue on pilerpurge fixes
#1226→ <<cset f544beab4c30>>
- Log in to comment
Which piler version?