Displaying 5 results from an estimated 5 matches for "sql_db_state_busy".
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/dovecot2.2/dict
done
I interprete H2-I1..-bang....
2012 Nov 28
2
backtrace from postgres dict
...base
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] ->
/usr/local/dovecot-2.1.10/lib/dovecot/li...
2012 Jun 24
2
dict Panic after upgrade to 2.1.7
...ing 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)
[0x7ffc7d8e57d6] ->
/usr/local/dovecot-2.1.7/lib/doveco...
2013 Jan 24
0
Again ACL Postgres dict trouble, no update and raw backtrace
...e
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] -> /usr/local/dovecot-2.1.13/lib/dovecot/libdoveco...
2014 Sep 03
0
Assertion failed in sql_transaction_commit with pgsql driver
...d in do_query function - i_assert(SQL_DB_IS_READY(&db->api))
} else {
/* multiple queries, use a transaction */
ctx->refcount++;
sql_query(_ctx->db, "BEGIN", transaction_begin_callback, ctx); <- first sql_query changes db state to SQL_DB_STATE_BUSY
while (_ctx->head != NULL) {
ctx->refcount++;
sql_query(_ctx->db, _ctx->head->query, <- second query cause assertion failed due to SQL_DB_IS_READY returns false
transaction_update_callback,...