search for: sqlpool

...e 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.log.gz (logged with v2.1) so, that each time the ACL dict is iterated, driver_sqlpool_query_s() is executed two times, once for user_shares and once for anyone_shares. I guess that the user_shares one is never finished, so that the sqlpool keeps that slot in "busy" state until timeout. The information about the slots of the log lines 0x9886d0 1. state=3 to_recon=(nil) re...

...Error: ==3053== Invalid read of size 8 Dec 4 12:09:40 dovecot: auth-worker: Error: ==3057== Invalid read of size 8 Dec 4 12:09:40 dovecot: auth-worker: Error: ==3057== at 0x6E8767F: mysql_close (mariadb_lib.c:1916) Dec 4 12:09:40 dovecot: auth-worker: Error: ==3057== by 0x14768B: driver_sqlpool_disconnect (driver-sqlpool.c:590) Dec 4 12:09:40 dovecot: auth-worker: Error: ==3057== by 0x13D0B4: db_sql_unref (db-sql.c:128) Dec 4 12:09:40 dovecot: auth-worker: Error: ==3057== by 0x1359D8: userdb_deinit (userdb.c:191) Dec 4 12:09:40 dovecot: auth-worker: Error: ==3057== by 0x119...

On 2 Dec 2018, at 22.22, Guillaume via dovecot <dovecot at dovecot.org> wrote: > > I also have this kind of segfault since the update : > > Dec 2 21:12:11 xxxxxxx dovecot: auth-worker: Error: *** Error in `dovecot/auth': double free or corruption (fasttop): 0x000055573bb99f70 Is this easy to reproduce? Can you try with valgrind? It will slow down the logins a bit though.

Hi, yesterday lib-sql got driver-sqlpool with some changes in Makefile.am, but these changes in makefile works only for --with-sql=yes. When --with-sql=plugin is used build fails with: libtool --tag=CC --mode=link gcc -std=gnu99 -O2 -g -pipe -Wall -Wp,- D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 - m6...

...up for sieve...? # sievec -u voytek dovecot.sieve sievec(voytek)<9667><>: Error: user voytek: Auth USER lookup failed sievec(root): Fatal: Internal error occurred. Refer to server log for more information. # grep sievec /var/log/dovecot.log Jun 01 08:32:26 auth-worker(9621): Warning: sqlpool(mysql): Query failed, retrying: Unknown column 'mailbox.enablesievec' in 'where clause' Jun 01 08:32:26 auth-worker(9621): Error: sql(voytek): User query failed: Unknown column 'mailbox.enablesievec' in 'where clause' # sievec -u voytek at sbt.net.au dovecot.sieve...

...disabled) Mar 03 11:30:09 config: Warning: please set ssl_dh=</etc/dovecot/dh.pem Mar 03 11:30:09 config: Warning: You can generate it with: dd if=/var/lib/dovecot/ssl-parameters.dat bs=1 skip=88 | openssl dhparam -inform der > /etc/dovecot/dh.pem Mar 03 11:30:12 auth-worker(32307): Warning: sqlpool(mysql): Query failed, retrying: Unknown column 'mailbox.enableimaptls' in 'where clause' Mar 03 11:30:12 auth-worker(32307): Error: sql(voytek at sbt.net.au,110.175.246.167,<jZs3viWDz7xur/an>): User query failed: Unknown column 'mailbox.enableimaptls' in 'where cla...

...fwd = <optimized out> errstr = <optimized out> locked = <optimized out> __func__ = "_int_free" #5 0x00007fdb923e978f in mysql_close (mysql=0x562c3662f9b0) at ./libmariadb/libmariadb/mariadb_lib.c:1939 No locals. #6 0x0000562c3457868c in driver_sqlpool_disconnect (_db=0x562c3662ea80) at driver-sqlpool.c:590 conn__foreach_end = 0x562c3662f160 db = 0x562c3662ea80 conn = 0x562c3662f150 #7 0x0000562c3456e0b5 in db_sql_unref (_conn=0x562c36624ff0) at db-sql.c:128 conn = 0x562c3662e6b8 #8 0x0000562c345669d9 in userdb_d...

On 19 Jun 2019, at 00:42, Aki Tuomi via dovecot <dovecot at dovecot.org> wrote: > Your userdb does not support listing, check dovecot logs, the error will > not be reported by doveadm. sqlpool(mysql): Query failed, retrying: Table 'postfix.users' doesn't exist Well, that is true, there is no users table, the table is ?mailbox? and the field is ?username' Any way yo tell doveadm what to look for? -- *** AgentSmith sets mode: +m

...shallow look at the code reveals that NULL module->conn in passdb-sql.c is being erroneously dereferenced while trying to clean up after a failed connection attempt: (gdb) bt #0 0x0806240e in sql_query_callback (result=0x8076c40, sql_request=0x808ff90) at passdb-sql.c:70 #1 0x08069b66 in sqlpool_request_abort (_request=<value optimized out>) at driver-sqlpool.c:114 #2 0x0806ab2a in driver_sqlpool_deinit (_db=0x808b970) at driver-sqlpool.c:448 #3 0x0806970a in sql_deinit (_db=0x808b5bc) at sql-api.c:87 #4 0x0805a3ac in db_sql_unref (_conn=0x807fc60) at db-sql.c:119 #5 0x08062b...

...voytek dovecot.sieve > sievec(voytek)<9667><>: Error: user voytek: Auth USER lookup failed > sievec(root): Fatal: Internal error occurred. Refer to server log for more > information. > > # grep sievec /var/log/dovecot.log > Jun 01 08:32:26 auth-worker(9621): Warning: sqlpool(mysql): Query failed, > retrying: Unknown column 'mailbox.enablesievec' in 'where clause' > Jun 01 08:32:26 auth-worker(9621): Error: sql(voytek): User query failed: > Unknown column 'mailbox.enablesievec' in 'where clause' > > > # sievec -u voytek...

since moving/upgrading system I've noticed I no longer get sieve script compiled, there is no dovecot.svbin created in /var/vmail/vmail1/sbt.net.au/voytek at tld.au/sieve what am I missing, how to check ? also, looking at sieve.log, I see a lot of May 31 06:32:50 lda(voytek at sbt.net.au)<1234><c4aVBfI98FzSBAAAyLbbsQ>: Error: sieve: Failed to initialize script execution: Invalid

...ut> module = <optimized out> passdb_result = PASSDB_RESULT_INTERNAL_FAILURE password = 0x0 scheme = <optimized out> ret = <optimized out> __FUNCTION__ = "sql_query_callback" #2 0x00007fb891c3c940 in driver_sqlpool_query_callback (result=0x7fb891e82f60, request=0x7fb891e82e50) at driver-sqlpool.c:635 db = 0x7fb891e66540 conn = 0x0 conndb = 0x7fb891e66910 #3 0x00007fb891c3dbe0 in driver_mysql_query (db=<optimized out>, query=<optimized out>, callback=0x7fb891c3c8c0 <driver_sql...

> 11:30:12 auth-worker(32307): Warning: sqlpool(mysql): Query failed, > retrying: Unknown column 'mailbox.enableimaptls' in 'where clause' > Mar 03 11:30:12 auth-worker(32307): Error: > sql(voytek at sbt.net.au,110.175.246.167,<xBk6viWDzrRur/an>): User query > failed: Unknown column 'mailbox.enableimaptls...

...lt;/a>> wrote: </div> <blockquote type="cite"> <div> Your userdb does not support listing, check dovecot logs, the error will </div> <div> not be reported by doveadm. </div> </blockquote> <div> sqlpool(mysql): Query failed, retrying: Table 'postfix.users' doesn't exist </div> <div> <br> </div> <div> Well, that is true, there is no users table, the table is ‘mailbox’ and the field is ‘username' </div> <div> &lt...

...ed: (%s)") at failures.c:275 #5 0x00007f26249240b6 in sql_dict_transaction_has_nonexistent (ctx=0x7f2625e7bca0) at dict-sql.c:720 #6 0x00007f26249240f3 in sql_dict_transaction_commit_callback (error=<optimized out>, ctx=0x7f2625e7bca0) at dict-sql.c:734 #7 0x00007f262492844f in driver_sqlpool_commit_callback (error=<optimized out>, ctx=0x7f2625e726a0) at driver-sqlpool.c:720 #8 0x00007f262492a60f in transaction_commit_callback (result=0x7f2625e7b6a0, ctx=0x7f2625e66dd0) at driver-pgsql.c:880 #9 0x00007f2624929e8e in result_finish (result=0x7f2625e7b6a0) at driver-pgsql.c:388 #10...

...> /usr/src/debug/mariadb-10.3.12/libmariadb/libmariadb/mariadb_lib.c:1940 > p = <optimized out> > #6 mysql_close (mysql=0x5592728448e0) at > /usr/src/debug/mariadb-10.3.12/libmariadb/libmariadb/mariadb_lib.c:1913 > p = <optimized out> > #7 0x00005592724e2dac in driver_sqlpool_disconnect (_db=0x559272843be0) > at driver-sqlpool.c:590 > conn__foreach_end = 0x559272844090 > db = 0x559272843be0 > conn = 0x559272844080 > #8 0x00005592724d78fc in db_sql_unref (_conn=0x55927283b5e8) at > db-sql.c:128 > conn = 0x559272843818 > #9 0x00005592724cf89c in us...

...48e0) at /usr/src/debug/mariadb-10.3.12/libmariadb/libmariadb/mariadb_lib.c:1940 p = <optimized out> #6 mysql_close (mysql=0x5592728448e0) at /usr/src/debug/mariadb-10.3.12/libmariadb/libmariadb/mariadb_lib.c:1913 p = <optimized out> #7 0x00005592724e2dac in driver_sqlpool_disconnect (_db=0x559272843be0) at driver-sqlpool.c:590 conn__foreach_end = 0x559272844090 db = 0x559272843be0 conn = 0x559272844080 #8 0x00005592724d78fc in db_sql_unref (_conn=0x55927283b5e8) at db-sql.c:128 conn = 0x559272843818 #9 0x00005592724cf89c in us...

....so.6 No symbol table info available. #4 0x00007f497389fcb4 in free () from /lib64/libc.so.6 No symbol table info available. #5 0x00007f4974e2c7bd in mysql_close (mysql=0x55c7d97dd860) at /usr/src/mariadb-10.3.11/libmariadb/libmariadb/mariadb_lib.c:1939 No locals. #6 0x000055c7d7b15f4c in driver_sqlpool_disconnect (_db=0x55c7d97dca10) at driver-sqlpool.c:590 conn__foreach_end = 0x55c7d97dd010 db = 0x55c7d97dca10 conn = 0x55c7d97dd000 #7 0x000055c7d7b07cd5 in db_sql_unref (_conn=0x55c7d97d4678) at db-sql.c:128 conn = 0x55c7d97dbe28 #8 0x000055c7d7afefa9 in user...

First, I archive the old messages in the INBOX on my list account # doveadm -Dv move -u kremels at kreme.com Archive mailbox INBOX BEFORE 90d Debug: Loading modules from directory: /usr/local/lib/dovecot/doveadm Debug: Skipping module doveadm_acl_plugin, because dlopen() failed: