Re: failed to store index data

2023-03-19 Thread Jonathan Baecker
rieb Janos SUTO:

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 <http://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]:
5000641708f61c491c9c0069477d77cb:
hdr_len: 3130, offset: 3 Mär 19
14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb:
touch

2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f
OK

(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb:
stored
'5000641708f61c491c9c0069477d77cb.m'
39327/11168 bytes Mär 19 14:06:52
piler piler[567]:
5000641708f61c491c9c0069477d77cb:
updated meta reference for
'',
rc=0 Mär 19 14:06:52 piler
piler[567]:
5000641708f61c491c9c0069477d77cb:
    stored 1 recipients, rc=0 Mär 19
14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb
failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]:
ERROR:
5000641708f61c491c9c0069477d77cb:
rollback sql stmt=DELETE FROM
sph_index WHERE id=31270 Mär 19
14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb:
rollback sql stmt=DELETE FROM rcpt
WHERE id=31270 Mär 19 14:06:52
piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb:
rollback sql stmt=DELETE FROM
metadata WHERE id=31270 Mär 19
14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb:
rollback sql stmt=DELETE FROM
attachment WHERE

piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb:
unlinking

/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb:
stored metadata, rc=1 Mär 19
14:06:52 piler piler[567]:
1/E

Re: failed to store index data

2023-03-19 Thread Janos SUTO
; {
>>>>>     listen  = 127.0.0.1:9312
>>>>>     listen  = 127.0.0.1:9306:mysql41
>>>>>     log =
>/var/piler/manticore/manticore.log
>>>>>     binlog_max_log_size = 256M
>>>>>     binlog_path = /var/piler/manticore
>>>>>     binlog_flush    = 2
>>>>>     query_log   = /var/piler/manticore/query.log
>>>>>     network_timeout = 5
>>>>>     pid_file    = /var/run/piler/searchd.pid
>>>>>     seamless_rotate = 1
>>>>>     preopen_indexes = 1
>>>>>     unlink_old  = 1
>>>>>     thread_stack    = 512k
>>>>>     rt_flush_period = 300
>>>>>
>>>>> }
>>>>>
>>>>>
>>>>> Am 19.03.23 um 16:35 schrieb Janos SUTO:
>>>>>>
>>>>>>
>>>>>> 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]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
>>>>>>>>> Mär 19 14:06:52 piler piler[567]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: touch
>>>>>>>>>
>2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f
>>>>>>>>> OK
>>>>>>>>> (<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
>>>>>>>>> Mär 19 14:06:52 piler piler[567]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: stored
>>>>>>>>> '5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
>>>>>>>>> Mär 19 14:06:52 piler piler[567]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: updated meta reference
>for
>>>>>>>>> '', rc=0
>>>>>>>>> Mär 19 14:06:52 piler piler[567]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: stored 1 recipients,
>rc=0
>>>>>>>>> Mär 19 14:06:52 piler piler[567]: ERROR:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb failed to store index
>data
>>>>>>>>> for
>>>>>>>>> id=31270, errno=1064, append ret=0
>>>>>>>>> Mär 19 14:06:52 piler piler[567]: ERROR:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE
>
>>>>>>>>> FROM
>>>>>>>>> sph_index WHERE id=31270
>>>>>>>>> Mär 19 14:06:52 piler piler[567]: ERROR:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE
>
>>>>>>>>> FROM
>>>>>>>>> rcpt WHERE id=31270
>>>>>>>>> Mär 19 14:06:52 piler piler[567]: ERROR:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE
>
>>>>>>>>> FROM
>>>>>>>>> metadata WHERE id=31270
>>>>>>>>> Mär 19 14:06:52 piler piler[567]: ERROR:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE
>
>>>>>>>>> FROM
>>>>>>>>> attachment WHERE
>piler_id='5000641708f61c491c9c0069477d77cb'
>>>>>>>>> Mär 19 14:06:52 piler piler[567]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: unlinking
>>>>>>>>>
>/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
>>>>>>>>>
>>>>>>>>> Mär 19 14:06:52 piler piler[567]:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb: 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:
>>>>>>>>> 5000641708f61c491c9c0069477d77cb, size=39327/11168,
>>>>>>>>> attachments=0,
>>>>>>>>> reference=,
>>>>>>>>> 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
>>>>>>>>
>>>>>>
>>>>
>>


Re: failed to store index data

2023-03-19 Thread Jonathan Baecker
  min_word_len = 2
    min_prefix_len = 5
    charset_table  = 0..9, english, _, \
  U+C1->U+E1, U+C4->U+E4, U+C5->U+E5,
U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6,
U+D8->U+F8, \
  U+DA->U+FA, U+DC->U+FC,
U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6,
U+01E3->U+E6, U+01FC->U+E6, \
  U+01FD->U+E6, U+1D01->U+E6,
U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
  U+DF, U+E1, U+E4, U+E5, U+E6, U+E9,
U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
    rt_field = tag
    rt_attr_bigint = mid
    rt_attr_uint = uid
}

index note1
{
    type = rt
    path = /var/piler/manticore/note1
    rt_mem_limit = 16M
    stored_fields = note
    min_word_len = 2
    min_prefix_len = 5
    charset_table  = 0..9, english, _, \
  U+C1->U+E1, U+C4->U+E4, U+C5->U+E5,
U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6,
U+D8->U+F8, \
  U+DA->U+FA, U+DC->U+FC,
U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6,
U+01E3->U+E6, U+01FC->U+E6, \
  U+01FD->U+E6, U+1D01->U+E6,
U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
  U+DF, U+E1, U+E4, U+E5, U+E6, U+E9,
U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
    rt_field = note
    rt_attr_bigint = mid
    rt_attr_uint = uid
}

searchd
{
    listen  = 127.0.0.1:9312
    listen  = 127.0.0.1:9306:mysql41
    log = /var/piler/manticore/manticore.log
    binlog_max_log_size = 256M
    binlog_path = /var/piler/manticore
    binlog_flush    = 2
    query_log   = /var/piler/manticore/query.log
    network_timeout = 5
    pid_file    = /var/run/piler/searchd.pid
    seamless_rotate = 1
    preopen_indexes = 1
    unlink_old  = 1
    thread_stack    = 512k
    rt_flush_period = 300

}


Am 19.03.23 um 16:35 schrieb Janos SUTO:



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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f 
OK

(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data 
for

id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m 


Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, 
attachments=0,

reference=,
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













Re: failed to store index data

2023-03-19 Thread Janos SUTO
1->U+E1, U+C4->U+E4, U+C5->U+E5,
U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6,
U+D8->U+F8, \
  U+DA->U+FA, U+DC->U+FC,
U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6,
U+01E3->U+E6, U+01FC->U+E6, \
  U+01FD->U+E6, U+1D01->U+E6,
U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
  U+DF, U+E1, U+E4, U+E5, U+E6, U+E9,
U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
    rt_field = tag
    rt_attr_bigint = mid
    rt_attr_uint = uid
}

index note1
{
    type = rt
    path = /var/piler/manticore/note1
    rt_mem_limit = 16M
    stored_fields = note
    min_word_len = 2
    min_prefix_len = 5
    charset_table  = 0..9, english, _, \
  U+C1->U+E1, U+C4->U+E4, U+C5->U+E5,
U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6,
U+D8->U+F8, \
  U+DA->U+FA, U+DC->U+FC,
U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6,
U+01E3->U+E6, U+01FC->U+E6, \
  U+01FD->U+E6, U+1D01->U+E6,
U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
  U+DF, U+E1, U+E4, U+E5, U+E6, U+E9,
U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
    rt_field = note
    rt_attr_bigint = mid
    rt_attr_uint = uid
}

searchd
{
    listen  = 127.0.0.1:9312
    listen  = 127.0.0.1:9306:mysql41
    log = /var/piler/manticore/manticore.log
    binlog_max_log_size = 256M
    binlog_path = /var/piler/manticore
    binlog_flush    = 2
    query_log   = /var/piler/manticore/query.log
    network_timeout = 5
    pid_file    = /var/run/piler/searchd.pid
    seamless_rotate = 1
    preopen_indexes = 1
    unlink_old  = 1
    thread_stack    = 512k
    rt_flush_period = 300

}


Am 19.03.23 um 16:35 schrieb Janos SUTO:



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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f 
OK

(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data 
for

id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE 
FROM

attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, 
attachments=0,

reference=,
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










Re: failed to store index data

2023-03-19 Thread Jonathan Baecker
U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
  U+DF, U+E1, U+E4, U+E5, U+E6, U+E9,
U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
    rt_field = tag
    rt_attr_bigint = mid
    rt_attr_uint = uid
}

index note1
{
    type = rt
    path = /var/piler/manticore/note1
    rt_mem_limit = 16M
    stored_fields = note
    min_word_len = 2
    min_prefix_len = 5
    charset_table  = 0..9, english, _, \
  U+C1->U+E1, U+C4->U+E4, U+C5->U+E5,
U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6,
U+D8->U+F8, \
  U+DA->U+FA, U+DC->U+FC,
U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6,
U+01E3->U+E6, U+01FC->U+E6, \
  U+01FD->U+E6, U+1D01->U+E6,
U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
  U+DF, U+E1, U+E4, U+E5, U+E6, U+E9,
U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
    rt_field = note
    rt_attr_bigint = mid
    rt_attr_uint = uid
}

searchd
{
    listen  = 127.0.0.1:9312
    listen  = 127.0.0.1:9306:mysql41
    log = /var/piler/manticore/manticore.log
    binlog_max_log_size = 256M
    binlog_path = /var/piler/manticore
    binlog_flush    = 2
    query_log   = /var/piler/manticore/query.log
    network_timeout = 5
    pid_file    = /var/run/piler/searchd.pid
    seamless_rotate = 1
    preopen_indexes = 1
    unlink_old  = 1
    thread_stack    = 512k
    rt_flush_period = 300

}


Am 19.03.23 um 16:35 schrieb Janos SUTO:



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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK
(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, 
attachments=0,

reference=,
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











Re: failed to store index data

2023-03-19 Thread Janos SUTO
    rt_flush_period = 300

}


Am 19.03.23 um 16:35 schrieb Janos SUTO:



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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK
(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, 
attachments=0,

reference=,
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








Re: failed to store index data

2023-03-19 Thread Jonathan Baecker
c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, attachments=0,
reference=,
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









Re: failed to store index data

2023-03-19 Thread Janos SUTO




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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK
(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, 
attachments=0,

reference=,
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






Re: failed to store index data

2023-03-19 Thread Jonathan Baecker




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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK
(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, attachments=0,
reference=,
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







Re: failed to store index data

2023-03-19 Thread 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 :
> 
> 
> 
> 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:
> 
> 
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> hdr_len: 3130, offset: 3
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> touch 2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK 
> (<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> stored '5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> updated meta reference for '', rc=0
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> stored 1 recipients, rc=0
> Mr 19 14:06:52 piler piler[567]: ERROR: 
> 5000641708f61c491c9c0069477d77cb failed to store index data for id=31270, 
> errno=1064, append ret=0
> Mr 19 14:06:52 piler piler[567]: ERROR: 
> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM sph_index 
> WHERE id=31270
> Mr 19 14:06:52 piler piler[567]: ERROR: 
> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM rcpt 
> WHERE id=31270
> Mr 19 14:06:52 piler piler[567]: ERROR: 
> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM metadata 
> WHERE id=31270
> Mr 19 14:06:52 piler piler[567]: ERROR: 
> 5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM 
> attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> unlinking /var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
> Mr 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
> stored metadata, rc=1
> Mr 19 14:06:52 piler piler[567]: 1/E07M4E0192DW6TN0: moved to 
> /var/piler/error/E07M4E0192DW6TN0
> Mr 19 14:06:52 piler piler[567]: 1/E07M4E0192DW6TN0: 
> 5000641708f61c491c9c0069477d77cb, size=39327/11168, attachments=0, 
> reference=, 
> 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
> 
> 
> 


Re: failed to store index data

2023-03-19 Thread Janos SUTO




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]:
5000641708f61c491c9c0069477d77cb: hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: touch
2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f OK
(<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored
'5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: updated meta reference for
'', rc=0
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb failed to store index data for
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
rcpt WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR:
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: unlinking
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]:
5000641708f61c491c9c0069477d77cb: 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:
5000641708f61c491c9c0069477d77cb, size=39327/11168, attachments=0,
reference=,
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




failed to store index data

2023-03-19 Thread Jonathan Baecker




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]: 5000641708f61c491c9c0069477d77cb: 
hdr_len: 3130, offset: 3
Mär 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
touch 2e5fa096927b9a6ac6fe82ff2b81256acfa719eb32031ca68f0d86db45415d9f 
OK (<608c730b-8a9d-c4aa-4ebd-7f3dec012...@mail.de>)
Mär 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
stored '5000641708f61c491c9c0069477d77cb.m' 39327/11168 bytes
Mär 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
updated meta reference for '', rc=0
Mär 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
stored 1 recipients, rc=0
Mär 19 14:06:52 piler piler[567]: ERROR: 
5000641708f61c491c9c0069477d77cb failed to store index data for 
id=31270, errno=1064, append ret=0
Mär 19 14:06:52 piler piler[567]: ERROR: 
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM 
sph_index WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR: 
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM rcpt 
WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR: 
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM 
metadata WHERE id=31270
Mär 19 14:06:52 piler piler[567]: ERROR: 
5000641708f61c491c9c0069477d77cb: rollback sql stmt=DELETE FROM 
attachment WHERE piler_id='5000641708f61c491c9c0069477d77cb'
Mär 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
unlinking 
/var/piler/store/00/641/77/cb/5000641708f61c491c9c0069477d77cb.m
Mär 19 14:06:52 piler piler[567]: 5000641708f61c491c9c0069477d77cb: 
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: 
5000641708f61c491c9c0069477d77cb, size=39327/11168, attachments=0, 
reference=, 
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