Hello Jonathan, please tell me more about your setup. Show me the output of pilerconf |grep -E '(sph|rtindex)' and /etc/piler/manticore.conf Be sure to redact any passwords. Janos On 2023-03-19 14:11, Jonathan Baecker wrote:
Hello, I just update piler from 1.3.9 to 1.4.3 and I also switched to manticore. But now piler can not receive new mails. when I check piler service, I get this error: Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3 Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: touch 2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK (<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>) Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: stored '50000000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: updated meta reference for '<FxXfleYASv2VKckQYZ7mWg@geopod-ismtpd-36>', rc=0 Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0 Mär 19 14:06:52 piler piler[567]: ERROR: 50000000641708f61c491c9c0069477d77cb failed to store index data for id=31270, errno=1064, append ret=0 Mär 19 14:06:52 piler piler[567]: ERROR: 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM sph_index WHERE id=31270 Mär 19 14:06:52 piler piler[567]: ERROR: 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM rcpt WHERE id=31270 Mär 19 14:06:52 piler piler[567]: ERROR: 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM metadata WHERE id=31270 Mär 19 14:06:52 piler piler[567]: ERROR: 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM attachment WHERE piler_id='50000000641708f61c491c9c0069477d77cb' Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: unlinking /var/piler/store/00/641/77/cb/50000000641708f61c491c9c0069477d77cb.m Mär 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: stored metadata, rc=1 Mär 19 14:06:52 piler piler[567]: 1/E07M4E0192DW6TN0: moved to /var/piler/error/E07M4E0192DW6TN0 Mär 19 14:06:52 piler piler[567]: 1/E07M4E0192DW6TN0: 50000000641708f61c491c9c0069477d77cb, size=39327/11168, attachments=0, reference=<FxXfleYASv2VKckQYZ7mWg@geopod-ismtpd-36>, message-id=<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>, retention=2557, folder=0, delay=0.1183, status=error After Update I run mysql piler < ./util/db-upgrade.sql But I think it had done nothing. Do you have any idea, how to fix this? Have a good day! jb
