v2.3.17 quota-dict related sql errors

[Pascal Volk]

On 18/12/2021 20.56, Pascal Volk wrote:
> 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.
>> ...

Hi there,

I've upgraded Dovecot to v2.3.18 (9dd8408c18). The problem still exists:

	ERROR:  invalid input syntax for type bigint:
"user at localhost.localdomain.org"

An excerpt from the journal is attached.


Regards,
Pascal
-- 
The trapper recommends today: beeffeed.2203619 at localdomain.org
-------------- next part --------------
host conf.d # journalctl -f -u  dovecot.service 
Feb 05 19:38:48 host systemd[1]: Started Dovecot IMAP/POP3 email server.
Feb 05 19:38:54 host dovecot[635]: master: Dovecot v2.3.18 (9dd8408c18) starting up for lmtp, pop3, imap, sieve
Feb 05 19:42:00 host systemd[1]: Reloading Dovecot IMAP/POP3 email server...
Feb 05 19:42:00 host dovecot[635]: master: Warning: SIGHUP received - reloading configuration
Feb 05 19:42:00 host systemd[1]: Reloaded Dovecot IMAP/POP3 email server.
Feb 05 19:42:28 host dovecot[1137]: imap-login: Login: user=<user at localhost.localdomain.org>, method=PLAIN, rip=2001:db8:815:1337:1234:5678:9abc, lip=2001:db8::143, mpid=1150, TLS, session=<x>
Feb 05 19:42:28 host dovecot[1137]: imap(user at localhost.localdomain.org)<1150><x>: ID sent: name=Thunderbird, version=91.5.1
Feb 05 19:42:29 host dovecot[1137]: dict(1152): Warning: quota: dict(pgsql): sqlpool(pgsql): Query failed, retrying: ERROR:  invalid input syntax for type bigint: "user at localhost.localdomain.org"
Feb 05 19:42:29 host dovecot[1137]: dict: Error: LINE 1: SELECT bytes FROM userquota WHERE uid = 'user at localhost.loca...
Feb 05 19:42:29 host dovecot[1137]: dict: Error:                                                 ^
Feb 05 19:42:29 host dovecot[1137]: dict(1152): Error: quota: dict(pgsql): sqlpool(pgsql): Query failed, aborting: SELECT bytes FROM userquota WHERE uid = 'user at localhost.localdomain.org'
Feb 05 19:42:29 host dovecot[1137]: dict(1152): Error: quota: Lookup failed: ERROR:  invalid input syntax for type bigint: "user at localhost.localdomain.org"
Feb 05 19:42:29 host dovecot[1137]: dict: Error: LINE 1: SELECT bytes FROM userquota WHERE uid = 'user at localhost.loca...
Feb 05 19:42:29 host dovecot[1137]: dict: Error:                                                 ^
Feb 05 19:42:29 host dovecot[1137]: imap(user at localhost.localdomain.org)<1150><x>: Error: Failed to get quota resource STORAGE: quota-dict: dict_lookup(priv/quota/storage) failed: dict-server returned failure: ERROR:  invalid input syntax for type bigint: "user at localhost.localdomain.org"
Feb 05 19:42:29 host dovecot[1137]: imap: Error: LINE 1: SELECT bytes FROM userquota WHERE uid = 'user at localhost.loca...
Feb 05 19:42:29 host dovecot[1137]: imap: Error:                                                 ^ (reply took 0.099 secs (0.100 in dict wait, 0.000 in other ioloops, 0.000 in locks, async-id reply 0.010 secs ago, started on dict-server 0.029 secs ago, took 0.029 secs))