Displaying 4 results from an estimated 4 matches for "driver_pgsql_set_state".
2013 Feb 20
1
Connection leak in sqlpool for ACL Dict Postgres in v2.1.15 (14907:b96df105ec55) and v2.2.beta1 (15857:07dfd4391d22)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I'm using a postgres dict for ACL, when when use deleteacl or setacl I get
a "not connected" error and (v2.2)
Panic: file driver-pgsql.c: line 84 (driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY || db->cur_result == NULL)
and a rawdump eventually.
You can trigger the error with the "dict" socket easily:
while true; do
( echo -en "H2\t0\t0\t\tacl\nI1\tshared/shared-boxes/\n"
sleep 1
) | socat - unix:/var/run/...
2012 Nov 28
2
backtrace from postgres dict
...03:39 dict: Info: pgsql(localhost): Connected to database
dovecot
2012-11-28 10:03:39 dict: Info: pgsql(localhost): Connected to database
dovecot
2012-11-28 10:03:58 IMAP(user) [22922]: Info: Disconnected: Logged out
in=23 out=763
2012-11-28 10:04:41 dict: Panic: file driver-pgsql.c: line 84
(driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY ||
db->cur_result == NULL)
2012-11-28 10:04:41 dict: Error: Raw backtrace:
/usr/local/dovecot-2.1.10/lib/dovecot/libdovecot.so.0(+0x4857a)
[0x7f91f511157a] ->
/usr/local/dovecot-2.1.10/lib/dovecot/libdovecot.so.0(+0x485c6)
[0x7f91f51115c6]...
2012 Jun 24
2
dict Panic after upgrade to 2.1.7
...roperly. something went wrong in dict service connecting the postgres
backend. that happens not on every connection. the db connection data are
correct, no difference connecting via tcp or linux socket.
dovecot log entries:
Jun 23 23:19:10 mx dovecot: dict: Panic: file driver-pgsql.c: line 84
(driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY || db-
>cur_result == NULL)
Jun 23 23:19:10 mx dovecot: dict: Error: Raw backtrace:
/usr/local/dovecot-2.1.7/lib/dovecot/libdovecot.so.0(+0x4478a)
[0x7ffc7d8e578a] ->
/usr/local/dovecot-2.1.7/lib/dovecot/libdovecot.so.0(+0x447d6)
[0x7ffc7d8e...
2013 Jan 24
0
Again ACL Postgres dict trouble, no update and raw backtrace
...or: dict sql iterate failed: Not connected to database
2013-01-24 11:09:59 IMAP(dvtest6) [22740]: Error: acl: dict iteration failed, can't update dict
2013-01-24 11:10:02 IMAP(dvtest6) [22740]: Info: Connection closed in=159 out=572
2013-01-24 11:11:00 dict: Panic: file driver-pgsql.c: line 84 (driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY || db->cur_result == NULL)
2013-01-24 11:11:00 dict: Error: Raw backtrace: /usr/local/dovecot-2.1.13/lib/dovecot/libdovecot.so.0(+0x4881a) [0x7f465693181a] -> /usr/local/dovecot-2.1.13/lib/dovecot/libdovecot.so.0(+0x48866) [0x7f4656931866] ->...