v2.3.17 quota-dict related sql errors

[Pascal Volk]

On 2021-12-04 22.18, I wrote:
> Hi there,
> 
> I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b).
> Right after the update, dovecot begun flooding the mail.log and
> PostgreSQL's log.
> ...
just in case someone has missed `doveconf -n` output and SQL related
configuration files, they are attached now.

Let me know if you have any questions.


Regards,
Pascal
-- 
The trapper recommends today: face1e55.2135221 at localdomain.org
-------------- next part --------------
# 2.3.17 (e2aa53df5b): /usr/local/etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.17 (054dddfa)
# OS: Linux 5.15.0-2-amd64 x86_64 Debian bookworm/sid 
# Hostname: host.example.org
auth_mechanisms = plain login cram-md5
auth_verbose = yes
auth_verbose_passwords = plain
base_dir = /var/run/dovecot
debug_log_path = /var/log/dovecot_dbg.log
dict {
  quota = pgsql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
}
first_valid_gid = 70000
first_valid_uid = 70000
hostname = mail.example.org
import_environment = TZ CORE_OUTOFMEM=yeah CORE_ERROR=1
listen = 203.0.113.143, 127.0.0.1, ::1, 2001:db8::143
lmtp_save_to_detail_mailbox = yes
login_access_sockets = tcpwrap
mail_access_groups = dovemail
mail_location = mdbox:~/mdbox
mail_plugins = quota old_stats zlib
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext
namespace inbox {
  inbox = yes
  location = 
  mailbox Drafts {
    special_use = \Drafts
  }
  mailbox Junk {
    special_use = \Junk
  }
  mailbox Sent {
    special_use = \Sent
  }
  mailbox Trash {
    special_use = \Trash
  }
  mailbox name {
    special_use = \Drafts \Junk \Sent \Trash
  }
  prefix = 
  separator = /
}
passdb {
  args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
plugin {
  old_stats_refresh = 1min
  quota = dict:user:%{uid}:noenforcing:proxy::quota
  quota_rule = *:storage=2G:messages=0
  quota_rule2 = Trash:storage=+100M
  recipient_delimiter = +
  sieve = ~/.dovecot.sieve
  sieve_dir = ~/sieve
  zlib_save = bz2
  zlib_save_level = 6
}
postmaster_address = postmaster at example.org
protocols = lmtp pop3 imap sieve
service auth-worker {
  unix_listener auth-worker {
    group = $default_internal_user
    mode = 0660
    user = doveauth
  }
  user = doveauth
}
service auth {
  client_limit = 1425
  unix_listener /var/spool/postfix/private/dovecot-auth {
    group = postfix
    mode = 0600
    user = postfix
  }
  user = doveauth
}
service dict {
  idle_kill = 150 secs
  unix_listener dict {
    group = dovemail
    mode = 0660
  }
}
service imap-login {
  process_limit = 256
}
service imap {
  process_limit = 256
}
service lmtp {
  executable = lmtp -D
  inet_listener lmtp {
    address = ::1 127.0.0.1
    port = 24
  }
  unix_listener /var/spool/postfix/private/dovecot-lmtp {
    group = postfix
    mode = 0600
    user = postfix
  }
}
service old-stats {
  executable = old-stats
  fifo_listener old-stats-mail {
    mode = 0666
  }
  fifo_listener old-stats-user {
    mode = 0666
  }
  unix_listener old-stats {
    mode = 0666
  }
}
service tcpwrap {
  unix_listener login/tcpwrap {
    group = $default_login_user
    mode = 0600
    user = $default_login_user
  }
}
ssl = required
ssl_cert = </etc/ssl/certs/mail.example.org.crt
ssl_dh = # hidden, use -P to show it
ssl_key = # hidden, use -P to show it
ssl_prefer_server_ciphers = yes
state_dir = /var/lib/dovecot
userdb {
  args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
verbose_proctitle = yes
protocol lda {
  mail_plugins = quota old_stats zlib sieve
}
protocol imap {
  imap_client_workarounds = delay-newmail tb-extra-mailbox-sep tb-lsub-flags
  imap_id_log = *
  imap_id_send = name
  mail_plugins = quota old_stats zlib imap_quota imap_old_stats imap_zlib
}
protocol lmtp {
  mail_plugins = quota old_stats zlib sieve
}
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dovecot-dict-sql.conf.ext
Type: application/vnd.novadigm.ext
Size: 288 bytes
Desc: not available
URL: <https://dovecot.org/pipermail/dovecot/attachments/20211218/cbf6b0ca/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dovecot-sql.conf.ext
Type: application/vnd.novadigm.ext
Size: 465 bytes
Desc: not available
URL: <https://dovecot.org/pipermail/dovecot/attachments/20211218/cbf6b0ca/attachment-0001.bin>