Hello,
This may be covered somewhere but recently I enabled the metadata plugin to work with sieve as part of some updates I did a while back and I hadn't checked my logs for any issues with it and so far they're not completely taking my system down.
Right now, upon trying to delete a folder I noticed the following in my logs... what am I missing? I see the broken SQL query, but I don't know enough about the dict system or the metadata plugin to know how to add the missing information or fix it otherwise.
Regards, Elisamuel Resto
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ? Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Error: Raw backtrace: /usr/lib/dovecot/libdovecot.so.0(backtrace_append+0x43) [0x7f449789d073] -> /usr/lib/dovecot/libdovecot.so.0(backtrace_get+0x20) [0x7f449789d190] -> /usr/lib/dovecot/libdovecot.so.0(+0xfaf1f) [0x7f44978a9f1f] -> /usr/lib/dovecot/libdovecot.so.0(+0xfafb1) [0x7f44978a9fb1] -> /usr/lib/dovecot/libdovecot.so.0(+0x4cd20) [0x7f44977fbd20] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7775a] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7f262] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7c97f] -> /usr/lib/dovecot/libdovecot.so.0(dict_iterate_values+0x25) [0x7f4497868615] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d79929] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a224] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a381] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a579] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d785b8] -> /usr/lib/dovecot/libdovecot.so.0(connection_input_default+0x15e) [0x7f44978a16ce] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_call_io+0x6b) [0x7f44978bfebb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run_internal+0x13b) [0x7f44978c15cb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run+0x51) [0x7f44978bff61] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_run+0x41) [0x7f44978c0131] -> /usr/lib/dovecot/libdovecot.so.0(master_service_run+0x14) [0x7f4497831f74] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d78139] -> /usr/lib/libc.so.6(__libc_start_main+0xd5) [0x7f44972cfb25] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7819e] Nov 15 12:19:19 wyvern dovecot[461]: imap(sam@samresto.dev)<51449><+BGq2NfQM/7Pisr9>: Error: Mailbox Trash/Processed: dict_iterate(priv/c841ad0291c27461ac670100a07d9965/) failed: Connection closed (reply took 0.204 secs (0.204 in dict wait, 0.000 in other ioloops, 0.000 in locks)) Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Fatal: master: service(dict): child 51438 killed with signal 6 (core dumped)
Hello
You have a missing argument variable in your prepared statement:
SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ?
should be
SELECT meta_key FROM metadata WHERE meta_key LIKE ? AND username = ?
Kind regards, Christian Mack
Am 15.11.21 um 19:27 schrieb Elisamuel Resto:
Hello,
This may be covered somewhere but recently I enabled the metadata plugin to work with sieve as part of some updates I did a while back and I hadn't checked my logs for any issues with it and so far they're not completely taking my system down.
Right now, upon trying to delete a folder I noticed the following in my logs... what am I missing? I see the broken SQL query, but I don't know enough about the dict system or the metadata plugin to know how to add the missing information or fix it otherwise.
Regards, Elisamuel Resto
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ? Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Error: Raw backtrace: /usr/lib/dovecot/libdovecot.so.0(backtrace_append+0x43) [0x7f449789d073] -> /usr/lib/dovecot/libdovecot.so.0(backtrace_get+0x20) [0x7f449789d190] -> /usr/lib/dovecot/libdovecot.so.0(+0xfaf1f) [0x7f44978a9f1f] -> /usr/lib/dovecot/libdovecot.so.0(+0xfafb1) [0x7f44978a9fb1] -> /usr/lib/dovecot/libdovecot.so.0(+0x4cd20) [0x7f44977fbd20] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7775a] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7f262] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7c97f] -> /usr/lib/dovecot/libdovecot.so.0(dict_iterate_values+0x25) [0x7f4497868615] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d79929] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a224] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a381] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a579] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d785b8] -> /usr/lib/dovecot/libdovecot.so.0(connection_input_default+0x15e) [0x7f44978a16ce] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_call_io+0x6b) [0x7f44978bfebb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run_internal+0x13b) [0x7f44978c15cb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run+0x51) [0x7f44978bff61] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_run+0x41) [0x7f44978c0131] -> /usr/lib/dovecot/libdovecot.so.0(master_service_run+0x14) [0x7f4497831f74] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d78139] -> /usr/lib/libc.so.6(__libc_start_main+0xd5) [0x7f44972cfb25] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7819e] Nov 15 12:19:19 wyvern dovecot[461]: imap(sam@samresto.dev)<51449><+BGq2NfQM/7Pisr9>: Error: Mailbox Trash/Processed: dict_iterate(priv/c841ad0291c27461ac670100a07d9965/) failed: Connection closed (reply took 0.204 secs (0.204 in dict wait, 0.000 in other ioloops, 0.000 in locks)) Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Fatal: master: service(dict): child 51438 killed with signal 6 (core dumped)
-- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre 78457 Konstanz +49 7531 88-4416
I have gone through my configuration and even found a configuration example by Aki and that confirms how I configured it… still getting that error.
Possibly a issue with the code? Any suggestions as to how to enable debugging to try and find the issue?
Regards, Elisamuel Resto
On Nov 15, 2021, at 12:37 PM, Elisamuel Resto sam@samresto.dev wrote:
Hello,
This may be covered somewhere but recently I enabled the metadata plugin to work with sieve as part of some updates I did a while back and I hadn't checked my logs for any issues with it and so far they're not completely taking my system down.
Right now, upon trying to delete a folder I noticed the following in my logs... what am I missing? I see the broken SQL query, but I don't know enough about the dict system or the metadata plugin to know how to add the missing information or fix it otherwise.
Regards, Elisamuel Resto
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ? Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Error: Raw backtrace: /usr/lib/dovecot/libdovecot.so.0(backtrace_append+0x43) [0x7f449789d073] -> /usr/lib/dovecot/libdovecot.so.0(backtrace_get+0x20) [0x7f449789d190] -> /usr/lib/dovecot/libdovecot.so.0(+0xfaf1f) [0x7f44978a9f1f] -> /usr/lib/dovecot/libdovecot.so.0(+0xfafb1) [0x7f44978a9fb1] -> /usr/lib/dovecot/libdovecot.so.0(+0x4cd20) [0x7f44977fbd20] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7775a] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7f262] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7c97f] -> /usr/lib/dovecot/libdovecot.so.0(dict_iterate_values+0x25) [0x7f4497868615] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d79929] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a224] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a381] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a579] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d785b8] -> /usr/lib/dovecot/libdovecot.so.0(connection_input_default+0x15e) [0x7f44978a16ce] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_call_io+0x6b) [0x7f44978bfebb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run_internal+0x13b) [0x7f44978c15cb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run+0x51) [0x7f44978bff61] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_run+0x41) [0x7f44978c0131] -> /usr/lib/dovecot/libdovecot.so.0(master_service_run+0x14) [0x7f4497831f74] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d78139] -> /usr/lib/libc.so.6(__libc_start_main+0xd5) [0x7f44972cfb25] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7819e] Nov 15 12:19:19 wyvern dovecot[461]: imap(sam@samresto.dev)<51449><+BGq2NfQM/7Pisr9>: Error: Mailbox Trash/Processed: dict_iterate(priv/c841ad0291c27461ac670100a07d9965/) failed: Connection closed (reply took 0.204 secs (0.204 in dict wait, 0.000 in other ioloops, 0.000 in locks)) Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Fatal: master: service(dict): child 51438 killed with signal 6 (core dumped)
On 11-21-2021 1:15 pm, Elisamuel Resto wrote: I have gone through my configuration and even found a configuration example by Aki and that confirms how I configured it… still getting that error.
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ?
You fixed the query syntax to make sure that is not the issue? "WHERE meta_key LIKE AND username = ?" is not valid syntax.
On 21/11/2021 22:40 dovecot@ptld.com wrote:
On 11-21-2021 1:15 pm, Elisamuel Resto wrote: I have gone through my configuration and even found a configuration example by Aki and that confirms how I configured it… still getting that error.
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ?
You fixed the query syntax to make sure that is not the issue? "WHERE meta_key LIKE AND username = ?" is not valid syntax.
It's not possible to fix the SQL syntax manually with dict driver. Sam, can you post your dict config, without passwords. Also which version of Dovecot & Pigeonhole is this?
Aki
Aki,
# 2.3.16 (7e2e900c1a): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.16 (09c29328) # OS: Linux 5.14.16-arch1-1 x86_64 ext4
Regards, Elisamuel Resto
On Nov 22, 2021, at 12:36 AM, Aki Tuomi aki.tuomi@open-xchange.com wrote:
On 21/11/2021 22:40 dovecot@ptld.com wrote:
On 11-21-2021 1:15 pm, Elisamuel Resto wrote: I have gone through my configuration and even found a configuration example by Aki and that confirms how I configured it… still getting that error.
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ?
You fixed the query syntax to make sure that is not the issue? "WHERE meta_key LIKE AND username = ?" is not valid syntax.
It's not possible to fix the SQL syntax manually with dict driver. Sam, can you post your dict config, without passwords. Also which version of Dovecot & Pigeonhole is this?
Aki
Hi, I wanted to see /etc/dovecot/dovecot-dict-sql.conf.ext
Aki
On 22 November 2021 11.08.01 UTC, Elisamuel Resto sam@samresto.dev wrote:
Aki,
# 2.3.16 (7e2e900c1a): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.16 (09c29328) # OS: Linux 5.14.16-arch1-1 x86_64 ext4
Aki,
My apologies, I thought that it was included in the output of "dovecot -n". I don't have just one, but I concatenated them for ease. See attached.
Thanks! -Sam
*From:* Aki Tuomi [mailto:aki.tuomi@open-xchange.com] *Sent:* Monday, November 22, 2021, 5:13 AM *To:* dovecot@dovecot.org, Elisamuel Resto *Cc:* dovecot@ptld.com *Subject:* imap_metadata plugin panic
Hi, I wanted to see /etc/dovecot/dovecot-dict-sql.conf.ext
Aki
On 22 November 2021 11.08.01 UTC, Elisamuel Resto sam@samresto.dev wrote:
Aki, # 2.3.16 (7e2e900c1a): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.16 (09c29328) # OS: Linux 5.14.16-arch1-1 x86_64 ext4
It's probably not a good idea to put all the patterns in same dict. I would first try if it still happens if you make a dedicated mysql dict with only the metadata patterns.
Aki
On 22/11/2021 18:52 Elisamuel Resto sam@samresto.dev wrote:
Aki,
My apologies, I thought that it was included in the output of "dovecot -n". I don't have just one, but I concatenated them for ease. See attached.
Thanks! -Sam
*From:* Aki Tuomi [mailto:aki.tuomi@open-xchange.com] *Sent:* Monday, November 22, 2021, 5:13 AM *To:* dovecot@dovecot.org, Elisamuel Resto *Cc:* dovecot@ptld.com *Subject:* imap_metadata plugin panic
Hi, I wanted to see /etc/dovecot/dovecot-dict-sql.conf.ext
Aki
On 22 November 2021 11.08.01 UTC, Elisamuel Resto sam@samresto.dev wrote:
Aki, # 2.3.16 (7e2e900c1a): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.16 (09c29328) # OS: Linux 5.14.16-arch1-1 x86_64 ext4
Aki,
Since the original email, dicts are now on their own. For the metadata I have tried the two dicts (shared/$key, priv/$key), just the priv dict db schema with "pattern = $key" per one of your emails to the ML, and just the "priv/$key" pattern. All of those combinations produce the same issue. In summary, I've tried several things but result is still that I can create folders but deletion causes a panic.
As of last email sending the dict, here is what dovecot knows about the dicts: dict { quota_clone = mysql:/etc/dovecot/dovecot-quota-dict.conf.ext lastlogin = mysql:/etc/dovecot/dovecot-lastlogin-dict.conf.ext metadata = mysql:/etc/dovecot/dovecot-metadata-dict.conf.ext }
And the dovecot-metadata-dict.conf.ext: map { pattern = shared/$key table = metadata_shared username_field = username value_field = meta_value
fields { meta_key = $key } }
map { pattern = priv/$key table = metadata_priv username_field = username value_field = meta_value
fields { meta_key = $key } }
I've attached the current dovecot.conf.
-Sam
*From:* Aki Tuomi [mailto:aki.tuomi@open-xchange.com] *Sent:* Wednesday, December 1, 2021, 2:23 AM *To:* Elisamuel Resto; dovecot@dovecot.org *Subject:* imap_metadata plugin panic
It's probably not a good idea to put all the patterns in same dict. I would first try if it still happens if you make a dedicated mysql dict with only the metadata patterns.
Aki
On 22/11/2021 18:52 Elisamuel Resto sam@samresto.dev wrote:
Aki,
My apologies, I thought that it was included in the output of "dovecot -n". I don't have just one, but I concatenated them for ease. See attached.
Thanks! -Sam
*From:* Aki Tuomi [mailto:aki.tuomi@open-xchange.com] *Sent:* Monday, November 22, 2021, 5:13 AM *To:* dovecot@dovecot.org, Elisamuel Resto *Cc:* dovecot@ptld.com *Subject:* imap_metadata plugin panic
Hi, I wanted to see /etc/dovecot/dovecot-dict-sql.conf.ext
Aki
On 22 November 2021 11.08.01 UTC, Elisamuel Resto sam@samresto.dev wrote:
Aki, # 2.3.16 (7e2e900c1a): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.16 (09c29328) # OS: Linux 5.14.16-arch1-1 x86_64 ext4
Any other suggestions? I’m stuck between a rock and a hard place. Had to enable to get the fts module working and now I can’t get rid of this problem.
Just seems like the user is not being passed to the query builder at some point. I’ve taken a look at code pertaining the metadata module and I can’t quite tell where it would be, though my skills are limited.
Regards, Elisamuel Resto
On Dec 1, 2021, at 7:01 AM, Elisamuel Resto sam@samresto.dev wrote:
Aki,
Since the original email, dicts are now on their own. For the metadata I have tried the two dicts (shared/$key, priv/$key), just the priv dict db schema with "pattern = $key" per one of your emails to the ML, and just the "priv/$key" pattern. All of those combinations produce the same issue. In summary, I've tried several things but result is still that I can create folders but deletion causes a panic.
As of last email sending the dict, here is what dovecot knows about the dicts: dict { quota_clone = mysql:/etc/dovecot/dovecot-quota-dict.conf.ext lastlogin = mysql:/etc/dovecot/dovecot-lastlogin-dict.conf.ext metadata = mysql:/etc/dovecot/dovecot-metadata-dict.conf.ext }
And the dovecot-metadata-dict.conf.ext: map { pattern = shared/$key table = metadata_shared username_field = username value_field = meta_value
fields { meta_key = $key }}
map { pattern = priv/$key table = metadata_priv username_field = username value_field = meta_value
fields { meta_key = $key }}
I've attached the current dovecot.conf.
-Sam
*From:* Aki Tuomi [mailto:aki.tuomi@open-xchange.com] *Sent:* Wednesday, December 1, 2021, 2:23 AM *To:* Elisamuel Resto; dovecot@dovecot.org *Subject:* imap_metadata plugin panic
It's probably not a good idea to put all the patterns in same dict. I would first try if it still happens if you make a dedicated mysql dict with only the metadata patterns.
Aki
On 22/11/2021 18:52 Elisamuel Resto sam@samresto.dev wrote:
Aki,
My apologies, I thought that it was included in the output of "dovecot -n". I don't have just one, but I concatenated them for ease. See attached.
Thanks! -Sam
*From:* Aki Tuomi [mailto:aki.tuomi@open-xchange.com] *Sent:* Monday, November 22, 2021, 5:13 AM *To:* dovecot@dovecot.org, Elisamuel Resto *Cc:* dovecot@ptld.com *Subject:* imap_metadata plugin panic
Hi, I wanted to see /etc/dovecot/dovecot-dict-sql.conf.ext
Aki
On 22 November 2021 11.08.01 UTC, Elisamuel Resto sam@samresto.dev wrote:
Aki, # 2.3.16 (7e2e900c1a): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.16 (09c29328) # OS: Linux 5.14.16-arch1-1 x86_64 ext4
I can’t fix a query that is built by dovecot. The code itself builds the query based on my dict configuration… so I can’t do that. I know the query is broken and why it’s failing, but I can’t fix it myself unless I find the code or what I did wrong in the configuration… but thanks for the reply anyway
Regards, Elisamuel Resto
On Nov 21, 2021, at 2:41 PM, dovecot@ptld.com wrote:
On 11-21-2021 1:15 pm, Elisamuel Resto wrote: I have gone through my configuration and even found a configuration example by Aki and that confirms how I configured it… still getting that error.
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ?
You fixed the query syntax to make sure that is not the issue? "WHERE meta_key LIKE AND username = ?" is not valid syntax.
Hi,
So I have waited to see what comes in updates and while it hasn't been fixed on my end, it at least doesn't panic anymore and properly errors out. This error has only happened when deleting folders. No other action I do from day to day has triggered this in the logs that I can see.
Mar 23 07:13:57 wyvern dovecot[148148]: dict(454663): Error: metadata: dict_iterate() failed: sql dict iterate failed for priv/90da1903dab0c2614f0d0100a07d9965/: Key continues past the matched pattern priv/$ Mar 23 07:13:57 wyvern dovecot[148148]: imap(sam@samresto.dev)<453545><TYbKeteaFu0gAQRwHxEChGW9kEtbStsB>: Error: Mailbox Trash/2009: dict_iterate(priv/90da1903dab0c2614f0d0100a07d9965/) failed: dict-server returned failure: sql dict iterate failed for priv/90da1903dab0c2614f0d0100a07d9965/: Key continues past the matched pattern priv/$ (reply took 0.035 secs (0.036 in dict wait, 0.000 in other ioloops, 0.000 in locks, async-id reply 0.000 secs ago, started on dict-server 0.009 secs ago, took 0.009 secs))
The configurations have not changed much (if at all), but I have attached them for reference. I would love to be able to delete folders again.
Regards, Elisamuel Resto
On 11/15/2021 12:27 PM, Elisamuel Resto wrote:
Hello,
This may be covered somewhere but recently I enabled the metadata plugin to work with sieve as part of some updates I did a while back and I hadn't checked my logs for any issues with it and so far they're not completely taking my system down.
Right now, upon trying to delete a folder I noticed the following in my logs... what am I missing? I see the broken SQL query, but I don't know enough about the dict system or the metadata plugin to know how to add the missing information or fix it otherwise.
Regards, Elisamuel Resto
Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Panic: lib-sql: Too many bind args (2) for statement: SELECT meta_key FROM metadata WHERE meta_key LIKE AND username = ? Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Error: Raw backtrace: /usr/lib/dovecot/libdovecot.so.0(backtrace_append+0x43) [0x7f449789d073] -> /usr/lib/dovecot/libdovecot.so.0(backtrace_get+0x20) [0x7f449789d190] -> /usr/lib/dovecot/libdovecot.so.0(+0xfaf1f) [0x7f44978a9f1f] -> /usr/lib/dovecot/libdovecot.so.0(+0xfafb1) [0x7f44978a9fb1] -> /usr/lib/dovecot/libdovecot.so.0(+0x4cd20) [0x7f44977fbd20] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7775a] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7f262] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7c97f] -> /usr/lib/dovecot/libdovecot.so.0(dict_iterate_values+0x25) [0x7f4497868615] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d79929] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a224] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a381] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7a579] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d785b8] -> /usr/lib/dovecot/libdovecot.so.0(connection_input_default+0x15e) [0x7f44978a16ce] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_call_io+0x6b) [0x7f44978bfebb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run_internal+0x13b) [0x7f44978c15cb] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_handler_run+0x51) [0x7f44978bff61] -> /usr/lib/dovecot/libdovecot.so.0(io_loop_run+0x41) [0x7f44978c0131] -> /usr/lib/dovecot/libdovecot.so.0(master_service_run+0x14) [0x7f4497831f74] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d78139] -> /usr/lib/libc.so.6(__libc_start_main+0xd5) [0x7f44972cfb25] -> dovecot/dict 0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0 [0x555e60d7819e] Nov 15 12:19:19 wyvern dovecot[461]: imap(sam@samresto.dev)<51449><+BGq2NfQM/7Pisr9>: Error: Mailbox Trash/Processed: dict_iterate(priv/c841ad0291c27461ac670100a07d9965/) failed: Connection closed (reply took 0.204 secs (0.204 in dict wait, 0.000 in other ioloops, 0.000 in locks)) Nov 15 12:19:19 wyvern dovecot[461]: dict(51438): Fatal: master: service(dict): child 51438 killed with signal 6 (core dumped)
participants (4)
-
Aki Tuomi
-
Christian Mack
-
dovecot＠ptld.com
-
Elisamuel Resto