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:
"u...@localhost.localdomain.org"
An excerpt from the journal is attached.
Regards,
Pascal
--
The trapper recommends today: beeffeed.2203...@localdomain.orghost 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=<u...@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(u...@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: "u...@localhost.localdomain.org"
Feb 05 19:42:29 host dovecot[1137]: dict: Error: LINE 1: SELECT bytes FROM
userquota WHERE uid = 'u...@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 =
'u...@localhost.localdomain.org'
Feb 05 19:42:29 host dovecot[1137]: dict(1152): Error: quota: Lookup failed:
ERROR: invalid input syntax for type bigint: "u...@localhost.localdomain.org"
Feb 05 19:42:29 host dovecot[1137]: dict: Error: LINE 1: SELECT bytes FROM
userquota WHERE uid = 'u...@localhost.loca...
Feb 05 19:42:29 host dovecot[1137]: dict: Error:
^
Feb 05 19:42:29 host dovecot[1137]:
imap(u...@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:
"u...@localhost.localdomain.org"
Feb 05 19:42:29 host dovecot[1137]: imap: Error: LINE 1: SELECT bytes FROM
userquota WHERE uid = 'u...@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))
