Re: failed to store index data
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 <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
Re: failed to store index data
t; 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
16M stored_fields = tag 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
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
gt;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
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
: 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
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
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
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: > > > 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
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
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