Your message dated Fri, 15 Sep 2017 12:11:17 +0300
with message-id <20170915091116.ci6efftf6etwh...@marvin.dmesg.gr>
and subject line Re: Bug#740017: dict: Panic: file driver-pgsql.c when using
shared folders
has caused the Debian Bug report #740017,
regarding dict: Panic: file driver-pgsql.c when using shared folders
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
740017: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=740017
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: dovecot-core
Version: 1:2.1.7-7
Severity: important
Dear Maintainer,
I get the following errors in /var/log/mail.log when using shared folders with
a PostgreSQL backend:
Feb 20 16:00:58 mail2 dovecot: dict: Panic: file driver-pgsql.c: line 84
(driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY ||
db->cur_result == NULL)
Feb 20 16:00:58 mail2 dovecot: dict: Error: Raw backtrace:
/usr/lib/dovecot/libdovecot.so.0(+0x4414a) [0x7f22ec4b814a] ->
/usr/lib/dovecot/libdovecot.so.0(+0x4418e) [0x7f22ec4b818e] ->
/usr/lib/dovecot/libdovecot.so.0(i_fatal+0) [0x7f22ec48f82a] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x2fc6) [0x7f22eb8bdfc6] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x3021) [0x7f22eb8be021] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x3e83) [0x7f22eb8bee83] ->
dovecot/dict(+0x91c4) [0x7f22ec92e1c4] ->
dovecot/dict(sql_db_cache_deinit+0x1d) [0x7f22ec92d95d] ->
dovecot/dict(main+0x145) [0x7f22ec9296a5] ->
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7f22ec108ead] ->
dovecot/dict(+0x4725) [0x7f22ec929725]
Feb 20 16:00:58 mail2 dovecot: dict: Fatal: master: service(dict): child 6192
killed with signal 6 (core dumps disabled)
...
...
Feb 20 16:03:01 mail2 dovecot: dict: Panic: file driver-pgsql.c: line 84
(driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY ||
db->cur_result == NULL)
Feb 20 16:03:01 mail2 dovecot: dict: Error: Raw backtrace:
/usr/lib/dovecot/libdovecot.so.0(+0x4414a) [0x7f4e50f6714a] ->
/usr/lib/dovecot/libdovecot.so.0(+0x4418e) [0x7f4e50f6718e] ->
/usr/lib/dovecot/libdovecot.so.0(i_fatal+0) [0x7f4e50f3e82a] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x2fc6) [0x7f4e5036cfc6] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x3021) [0x7f4e5036d021] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x3e83) [0x7f4e5036de83] ->
dovecot/dict(+0x91c4) [0x7f4e513dd1c4] ->
dovecot/dict(sql_db_cache_deinit+0x1d) [0x7f4e513dc95d] ->
dovecot/dict(main+0x145) [0x7f4e513d86a5] ->
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7f4e50bb7ead] ->
dovecot/dict(+0x4725) [0x7f4e513d8725]
Feb 20 16:03:01 mail2 dovecot: dict: Fatal: master: service(dict): child 6276
killed with signal 6 (core dumps disabled)
...
...
Feb 20 16:05:07 mail2 dovecot: dict: Panic: file driver-pgsql.c: line 84
(driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY ||
db->cur_result == NULL)
Feb 20 16:05:07 mail2 dovecot: dict: Error: Raw backtrace:
/usr/lib/dovecot/libdovecot.so.0(+0x4414a) [0x7fb7af89d14a] ->
/usr/lib/dovecot/libdovecot.so.0(+0x4418e) [0x7fb7af89d18e] ->
/usr/lib/dovecot/libdovecot.so.0(i_fatal+0) [0x7fb7af87482a] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x2fc6) [0x7fb7aeca2fc6] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x3021) [0x7fb7aeca3021] ->
/usr/lib/dovecot/modules/dict/libdriver_pgsql.so(+0x3e83) [0x7fb7aeca3e83] ->
dovecot/dict(+0x91c4) [0x7fb7afd131c4] ->
dovecot/dict(sql_db_cache_deinit+0x1d) [0x7fb7afd1295d] ->
dovecot/dict(main+0x145) [0x7fb7afd0e6a5] ->
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd) [0x7fb7af4edead] ->
dovecot/dict(+0x4725) [0x7fb7afd0e725]
Feb 20 16:05:07 mail2 dovecot: dict: Fatal: master: service(dict): child 6430
killed with signal 6 (core dumps disabled)
Installing the backport version 2.2.9-1~bpo70+1 seems to have resolved the
issue. Is there a chace the fix will be ackported in to the stable branch?
-- Package-specific info:
dovecot configuration
---------------------
# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.2.0-4-amd64 x86_64 Debian 7.4 ext3
auth_mechanisms = plain login
auth_verbose = yes
dict {
acl = pgsql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
mail_location = maildir:/var/vmail/%d/%n/Maildir
mail_plugins = acl
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 ihave
namespace {
list = children
location =
maildir:/var/vmail/%%d/%%n/Maildir:INDEX=/var/vmail/%d/%n/Maildir/shared/%%u
prefix = shared/%%u/
separator = /
subscriptions = no
type = shared
}
namespace inbox {
inbox = yes
location =
mailbox Drafts {
auto = subscribe
special_use = \Drafts
}
mailbox Junk {
auto = subscribe
special_use = \Junk
}
mailbox Sent {
auto = subscribe
special_use = \Sent
}
mailbox Trash {
auto = subscribe
special_use = \Trash
}
prefix =
separator = /
type = private
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
acl = vfile
acl_shared_dict = proxy::acl
sieve = /var/vmail/%d/%n/.dovecot.sieve
sieve_dir = /var/vmail/%d/%n/sieve
}
protocols = " imap sieve"
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
}
}
service dict {
unix_listener dict {
mode = 0600
user = vmail
}
}
ssl_cert = </etc/ssl/certs/mail.hostremoved.de.chained.pem
ssl_key = </etc/ssl/private/hostremoved.de.pem
userdb {
args = uid=vmail gid=vmail home=/var/vmail/%d/%n
driver = static
}
protocol lda {
mail_plugins = acl sieve
}
protocol imap {
mail_max_userip_connections = 50
mail_plugins = acl imap_acl
}
-- System Information:
Debian Release: 7.4
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-4-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages dovecot-core depends on:
ii adduser 3.113+nmu3
ii libbz2-1.0 1.0.6-4
ii libc6 2.13-38+deb7u1
ii libpam-runtime 1.1.3-7.1
ii libpam0g 1.1.3-7.1
ii libssl1.0.0 1.0.1e-2+deb7u4
ii openssl 1.0.1e-2+deb7u4
ii ucf 3.0025+nmu3
ii zlib1g 1:1.2.7.dfsg-13
dovecot-core recommends no packages.
Versions of packages dovecot-core suggests:
pn dovecot-gssapi <none>
ii dovecot-imapd 1:2.1.7-7
pn dovecot-ldap <none>
pn dovecot-lmtpd <none>
ii dovecot-managesieved 1:2.1.7-7
pn dovecot-mysql <none>
ii dovecot-pgsql 1:2.1.7-7
pn dovecot-pop3d <none>
ii dovecot-sieve 1:2.1.7-7
pn dovecot-solr <none>
pn dovecot-sqlite <none>
ii ntp 1:4.2.6.p5+dfsg-2
Versions of packages dovecot-core is related to:
ii dovecot-core [dovecot-common] 1:2.1.7-7
pn dovecot-dbg <none>
pn dovecot-dev <none>
pn dovecot-gssapi <none>
ii dovecot-imapd 1:2.1.7-7
pn dovecot-ldap <none>
pn dovecot-lmtpd <none>
ii dovecot-managesieved 1:2.1.7-7
pn dovecot-mysql <none>
ii dovecot-pgsql 1:2.1.7-7
pn dovecot-pop3d <none>
ii dovecot-sieve 1:2.1.7-7
pn dovecot-sqlite <none>
-- debconf information:
dovecot-core/ssl-cert-exists:
dovecot-core/create-ssl-cert: false
dovecot-core/ssl-cert-name: localhost
--- End Message ---
--- Begin Message ---
Source: dovecot
Version: 1:2.2.5-1
On 00:32 Tue 25 Feb , Andrej wrote:
> I get the following errors in /var/log/mail.log when using shared
> folders with a PostgreSQL backend:
>
> Feb 20 16:00:58 mail2 dovecot: dict: Panic: file driver-pgsql.c: line 84
> (driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY ||
> db->cur_result == NULL)
This has been fixed in 2.2:
commit 9d12bcb7967abd3a05c04425c1d8a3ddd21c3497
Author: Timo Sirainen <t...@iki.fi>
Date: Fri Feb 22 12:12:26 2013 +0200
dict-sql: Iterating with multiple SQL queries didn't free all the queries.
See https://dovecot.org/list/dovecot/2013-February/088430.html.
Regards,
Apollon
--- End Message ---