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)