I meant to execute /etc/piler/manticore.conf (yes, it's executable).

Janos

On 2023-03-19 16:06, Jonathan Baecker wrote:
Am 19.03.23 um 14:27 schrieb Janos SUTO:
Hello Jonathan,

Hello Jano, thank you for you quick response!

please tell me more about your setup. Show me the output of

pilerconf |grep -E '(sph|rtindex)'

Output is:

rtindex=1
sphxdb=piler1
sphxhost=127.0.0.1
sphxport=9306


and

/etc/piler/manticore.conf

Content is:

define('RT', 1);


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


Reply via email to