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 at 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](+0x875a)
[0x555e60d7775a] -> dovecot/dict [0 clients, 0 lookups:0/0/0/0, 0
iters:0/0/0/0, 0 commits:0/0/0/0](sql_statement_query+0x42) [0x555e60d7f262]
-> dovecot/dict [0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0
commits:0/0/0/0](+0xd97f) [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](+0xa929) [0x555e60d79929] -> dovecot/dict [0 clients, 0
lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0](+0xb224) [0x555e60d7a224]
-> dovecot/dict [0 clients, 0 lookups:0/0/0/0, 0 iters:0/0/0/0, 0
commits:0/0/0/0](+0xb381) [0x555e60d7a381] -> dovecot/dict [0 clients, 0
lookups:0/0/0/0, 0 iters:0/0/0/0, 0 commits:0/0/0/0](dict_command_input+0xd9)
[0x555e60d7a579] -> dovecot/dict [0 clients, 0 lookups:0/0/0/0, 0
iters:0/0/0/0, 0 commits:0/0/0/0](+0x95b8) [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](main+0x189) [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](_start+0x2e)
[0x555e60d7819e]
> Nov 15 12:19:19 wyvern dovecot[461]: imap(sam at
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)
>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dovecot-conf.txt
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20211121/8c015d4f/attachment.txt>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0xD2D5FB6118615F19.asc
Type: application/octet-stream
Size: 7941 bytes
Desc: not available
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20211121/8c015d4f/attachment.obj>