my sql file is not under the /var/log/dspam did you make changes my stuff is under /var/lib/dspam
Remo > On Aug 7, 2020, at 2:44 PM, Diego Piñon Conde <diegopi...@gmail.com> wrote: > > More timeout from /var/log/maillog > > [00]Aug 7 18:14:42 pegasus dspam[3671]: query error: Lock wait timeout > exceeded; try restarting transaction: see sql.errors > for more details > [00]Aug 7 18:14:42 pegasus dspam[3671]: Unable to open file for writing: > /var/log/dspam/sql.errors: Permission denied > [00]Aug 7 18:14:42 pegasus dspam[3671]: bailing on error -2 > [00]Aug 7 18:14:42 pegasus dspam[3671]: received invalid result (!DSR_ISSPAM > && !DSR_ISINNOCENT): -2 > [00]Aug 7 18:14:43 pegasus dspam[3671]: process_message returned error -5. > delivering. > > [00]Aug 7 18:20:26 pegasus dspam[4166]: Unable to open file for writing: > /var/log/dspam/sql.errors: Permission denied > [00]Aug 7 18:20:26 pegasus dspam[4166]: bailing on error -2 > [00]Aug 7 18:20:29 pegasus dspam[4166]: received invalid result (!DSR_ISSPAM > && !DSR_ISINNOCENT): -2 > [00]Aug 7 18:20:33 pegasus dspam[4166]: process_message returned error -5. > delivering. > > [00]Aug 7 18:29:26 pegasus dspam[4579]: received invalid result (!DSR_ISSPAM > && !DSR_ISINNOCENT): -2 > [00]Aug 7 18:29:27 pegasus dspam[4568]: received invalid result (!DSR_ISSPAM > && !DSR_ISINNOCENT): -2 > [00]Aug 7 18:29:27 pegasus dspam[4579]: process_message returned error -5. > delivering. > [00]Aug 7 18:29:28 pegasus dspam[4568]: process_message returned error -5. > delivering. > [00]Aug 7 18:30:09 pegasus dspam[4802]: query error: Lock wait timeout > exceeded; try restarting transaction: see sql.errors > for more details > [00]Aug 7 18:30:09 pegasus dspam[4802]: Unable to open file for writing: > /var/log/dspam/sql.errors: Permission denied > [00]Aug 7 18:30:10 pegasus dspam[4802]: bailing on error -2 > [00]Aug 7 18:30:13 pegasus dspam[4802]: received invalid result (!DSR_ISSPAM > && !DSR_ISINNOCENT): -2 > [00]Aug 7 18:30:14 pegasus dspam[4802]: process_message returned error -5. > delivering. > > [00]Aug 7 18:30:09 pegasus dspam[4802]: Unable to open file for writing: > /var/log/dspam/sql.errors: Permission denied > [00]Aug 7 18:30:10 pegasus dspam[4802]: bailing on error -2 > [00]Aug 7 18:30:13 pegasus dspam[4802]: received invalid result (!DSR_ISSPAM > && !DSR_ISINNOCENT): -2 > [00]Aug 7 18:30:14 pegasus dspam[4802]: process_message returned error -5. > delivering. > > El vie., 7 ago. 2020 a las 17:06, Philip Nix Guru (<phi...@ows.ch > <mailto:phi...@ows.ch>>) escribió: > Hello > > a bit hard to debug without checking system > > if you got multitail > > create a file with : > > multitail -Z red,black,inverse -T -S -x "%m %u@%h %f (%t) [%l]" \ > -m 0 -n 49 -cS qmail-send -l "qmlog -f send" \ > -m 0 -n 49 -cS qmail-smtp3 -em "policy_check" -em "CHKUSER" -em "simscan" > -em "spamdyke" -em "qmail-smtpd: " -l "qmlog -f smtp" \ > -m 0 -n 49 -cS qmtspamassassin -ev "prefork" -ev "(connection from > localhost)" -l "tail -f /var/log/maillog" \ > # -m 0 -n 49 -cS qmail-smtp -em "policy_check" -em "CHKUSER" -em "simscan" > -em "spamdyke" -em "qmail-smtpd: " -em "spf-reject" -l "qmlog -f submission" > \ > # -m 0 -n 49 -cS qmtspamassassin -ev "prefork" -ev "(connection from > localhost)" -l "tail -f /var/log/maillog" > > and just sh it, and check if you see anything weird/strange, delay ... > > in the mail transaction > >> The amount of messages in the local queue is still descending but I don't >> know why so slow! >> >> >> >> >> El vie., 7 ago. 2020 a las 15:48, Philip Nix Guru (<phi...@ows.ch >> <mailto:phi...@ows.ch>>) escribió: >> Hello >> >> But the mail does get delivered just with a very long delay ? >> >> and you disabled clamd but it still running ? >> >> >> >> Check a delivered mail, look at the headers, make sure clamd is really not >> running >> >> anything suspicous in /var/log/clamd/clamd.log ? >> >> >> >> qmHandle -s shows what ? >> >> >> >> On 8/7/20 8:34 PM, Diego Piñon Conde wrote: >>> 2 hs has passed and the local queue has 3530 msg (it was 3700 at some >>> point). Beside clamd that it is still running and time to time take 100% >>> cpu usage (I don't understand why because qmailtoaster it's supoust that >>> not use it anymore), cpu usage is normally below 20% and memory is the >>> same. So why does it take so long to deliver local msg! >>> >>> I'm in UTC -3, so probably all of you are snoring. I will keep working til >>> qmailtoaster works normally, I hope when you wake up you can give me a hand. >>> >>> I will really appreciate that. Thanks in advance! >>> >>> El vie., 7 ago. 2020 a las 12:29, Philip Nix Guru (<phi...@ows.ch >>> <mailto:phi...@ows.ch>>) escribió: >>> Hello >>> >>> what you could start by doing is disabling >>> >>> idle-timeout-secs=xx in /etc/spamdyke/spamdyke.conf >>> >>> just comment the line >>> >>> check in a few hours if your TIMEOUT drastically decreased >>> >>> then you can adapt the idle-timeout delay >>> >>> >>> >>> If not then, we can check other things >>> >>> >>> >>> Cheers >>> >>> >>> >>> On 8/7/20 4:40 PM, Diego Piñon Conde wrote: >>>> Hi Philip >>>> this is the tail of /var/log/maillog >>>> >>>> Aug 7 11:31:01 pegasus spamdyke[2968]: TIMEOUT from: >>>> sciottilili...@gmail.com <mailto:sciottilili...@gmail.com> to: >>>> filibe...@tarjetacliper.com <mailto:filibe...@tarjetacliper.com> >>>> origin_ip: 209.85.215.175 origin_rdns: mail-pg1-f175.google.com >>>> <http://mail-pg1-f175.google.com/> auth: (unknown) encryption: TLS reason: >>>> TIMEOUT >>>> Aug 7 11:31:03 pegasus spamdyke[2970]: TIMEOUT from: >>>> nore...@messages.sonicwall.com <mailto:nore...@messages.sonicwall.com> to: >>>> pi...@tarjetacliper.com <mailto:pi...@tarjetacliper.com> origin_ip: >>>> 209.167.231.144 origin_rdns: mail01.messages.sonicwall.com >>>> <http://mail01.messages.sonicwall.com/> auth: (unknown) encryption: TLS >>>> reason: TIMEOUT >>>> Aug 7 11:31:03 pegasus spamdyke[2969]: TIMEOUT from: >>>> v-cjcdika_pmnlhikcme_gmicmlkp_gmicmlk...@bounce.info.bancopatagonia.com.ar >>>> <mailto:v-cjcdika_pmnlhikcme_gmicmlkp_gmicmlk...@bounce.info.bancopatagonia.com.ar> >>>> to: scio...@tarjetacliper.com <mailto:scio...@tarjetacliper.com> >>>> origin_ip: 192.156.219.80 origin_rdns: mail7756.info.bancopatagonia.com.ar >>>> <http://mail7756.info.bancopatagonia.com.ar/> auth: (unknown) encryption: >>>> TLS reason: TIMEOUT >>>> Aug 7 11:31:06 pegasus spamdyke[2974]: TIMEOUT from: >>>> bounce-10710_html-121882056-2177875-6399888-...@bounce.mail.bbva.com.ar >>>> <mailto:bounce-10710_html-121882056-2177875-6399888-...@bounce.mail.bbva.com.ar> >>>> to: bondo...@tarjetacliper.com <mailto:bondo...@tarjetacliper.com> >>>> origin_ip: 13.111.6.12 origin_rdns: mta.mail.bbva.com.ar >>>> <http://mta.mail.bbva.com.ar/> auth: (unknown) encryption: TLS reason: >>>> TIMEOUT >>>> Aug 7 11:31:24 pegasus vpopmail[3225]: vchkpw-submission: (PLAIN) login >>>> success rose...@tarjetacliper.com:10.10.10.8 >>>> <mailto:rose...@tarjetacliper.com:10.10.10.8> >>>> Aug 7 11:31:27 pegasus spamdyke[3004]: TIMEOUT from: >>>> www...@xpressus.emsmtp.com <mailto:www...@xpressus.emsmtp.com> to: >>>> crisgar...@tarjetacliper.com <mailto:crisgar...@tarjetacliper.com> >>>> origin_ip: 91.211.241.9 origin_rdns: pmta41009.emsmtp.com >>>> <http://pmta41009.emsmtp.com/> auth: (unknown) encryption: TLS reason: >>>> TIMEOUT >>>> Aug 7 11:31:32 pegasus spamdyke[3006]: TIMEOUT from: >>>> sd...@meridionalseguros.com.ar <mailto:sd...@meridionalseguros.com.ar> to: >>>> segu...@tarjetacliper.com <mailto:segu...@tarjetacliper.com> origin_ip: >>>> 40.107.76.91 origin_rdns: >>>> mail-eopbgr760091.outbound.protection.outlook.com >>>> <http://mail-eopbgr760091.outbound.protection.outlook.com/> auth: >>>> (unknown) encryption: TLS reason: TIMEOUT >>>> Aug 7 11:31:34 pegasus spamdyke[3050]: TIMEOUT from: >>>> antonel...@pseguros.com.ar <mailto:antonel...@pseguros.com.ar> to: >>>> segu...@tarjetacliper.com <mailto:segu...@tarjetacliper.com> origin_ip: >>>> 190.210.19.10 origin_rdns: webmail.provinciaseguros.com >>>> <http://webmail.provinciaseguros.com/> auth: (unknown) encryption: TLS >>>> reason: TIMEOUT >>>> Aug 7 11:31:38 pegasus spamdyke[3074]: TIMEOUT from: >>>> sebastian.sa...@osde.com.ar <mailto:sebastian.sa...@osde.com.ar> to: >>>> rfernan...@tarjetacliper.com <mailto:rfernan...@tarjetacliper.com> >>>> origin_ip: 209.85.210.45 origin_rdns: mail-ot1-f45.google.com >>>> <http://mail-ot1-f45.google.com/> auth: (unknown) encryption: TLS reason: >>>> TIMEOUT >>>> Aug 7 11:31:42 pegasus spamdyke[3158]: TIMEOUT from: >>>> dpinmue...@mardelplata.gob.ar <mailto:dpinmue...@mardelplata.gob.ar> to: >>>> diu...@tarjetacliper.com <mailto:diu...@tarjetacliper.com> origin_ip: >>>> 200.41.224.100 origin_rdns: mail.mardelplata.gov.ar >>>> <http://mail.mardelplata.gov.ar/> auth: (unknown) encryption: (none) >>>> reason: TIMEOUT >>>> >>>> I've checked scan.conf and logverbose = yes >>>> >>>> >>>> El vie., 7 ago. 2020 a las 11:27, Philip Nix Guru (<phi...@ows.ch >>>> <mailto:phi...@ows.ch>>) escribió: >>>> Hello >>>> >>>> can you check if you got any >>>> >>>> TIMEOUT in /var/log/maillog log file >>>> >>>> since you did your update >>>> >>>> >>>> >>>> Check also your scan.conf file >>>> >>>> /etc/clamd.d/scan.conf >>>> >>>> Enable Log (verbose) , >>>> >>>> LogVerbose yes >>>> >>>> >>>> >>>> >>>> >>>> On 8/7/20 4:12 PM, Diego Piñon Conde wrote: >>>>> Hi all >>>>> >>>>> I'm running qmail toaster on CentOS 7. >>>>> >>>>> Because I had problems with freshclam (terrible slow db update), >>>>> yesterday I changed clamAV to Epel version. >>>>> >>>>> I don't know if it's relevant, but after that local delivery was too slow. >>>>> >>>>> Local queue was increasing in size and every email received by clients >>>>> was received 5 or 6 times. >>>>> >>>>> I thinked maybe clamd it's the culprit, so I've changed clamd=no in >>>>> simcontrol and did qmailctl cdb but nothing has changed. >>>>> >>>>> My knowledge is limited and I will appreciate any help