Re: failed to store index data

[postfach]

Hi,

are you using manticore 6.0.4?
If yes revert back to manticore 6.0.0 and it shoud work.
As far as i know piler only supports manticore 6.0.0.

Regards
BKH

> Am 19.03.2023 um 14:11 schrieb Jonathan Baecker <jonba...@gmail.com>:
> 
> 
> 
> 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&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> hdr_len: 3130, offset: 3
> M&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> touch 2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK 
> (<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
> M&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> stored '50000000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
> M&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> updated meta reference for '<FxXfleYASv2VKckQYZ7mWg@geopod-ismtpd-36>', rc=0
> M&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> stored 1 recipients, rc=0
> M&auml;r 19 14:06:52 piler piler[567]: ERROR: 
> 50000000641708f61c491c9c0069477d77cb failed to store index data for id=31270, 
> errno=1064, append ret=0
> M&auml;r 19 14:06:52 piler piler[567]: ERROR: 
> 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM sph_index 
> WHERE id=31270
> M&auml;r 19 14:06:52 piler piler[567]: ERROR: 
> 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM rcpt 
> WHERE id=31270
> M&auml;r 19 14:06:52 piler piler[567]: ERROR: 
> 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM metadata 
> WHERE id=31270
> M&auml;r 19 14:06:52 piler piler[567]: ERROR: 
> 50000000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM 
> attachment WHERE piler_id='50000000641708f61c491c9c0069477d77cb'
> M&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> unlinking /var/piler/store/00/641/77/cb/50000000641708f61c491c9c0069477d77cb.m
> M&auml;r 19 14:06:52 piler piler[567]: 50000000641708f61c491c9c0069477d77cb: 
> stored metadata, rc=1
> M&auml;r 19 14:06:52 piler piler[567]: 1/E07M4E0192DW6TN0: moved to 
> /var/piler/error/E07M4E0192DW6TN0
> M&auml;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
> 
> 
>