Please see my "Too many open files" message as it related to 21277
On Tue, Oct 5, 2021 at 9:33 AM K Post <nntp.p...@gmail.com> wrote: > I have about 4million HMM records, startup was 2-3 minutes, but ASSP is on > Windows, in a VM, on a not so new (but new to the charity) host.... > Whatever SQL you simplified has it at a couple seconds now! Terrific. > > On the new SSL error/warnings, I'll open a thread to discuss in case it's > something more than just new warnings. I'm seeing bad file descriptor log > lines. > > > On Tue, Oct 5, 2021 at 2:03 AM Thomas Eckardt <thomas.ecka...@thockar.com> > wrote: > >> >my very slow startup with the rebuild spamdb worker >> >> MySQL was blocking for a long time, because of a unnecessary complex >> SQL-statement for hmmdb and spamdb. >> >> In my case the delay was ~25 seconds for ~10 million database records. >> >> >Is that part of the improved error handling for SSL SMTP sessions over >> port 25? >> >> yes. >> >> Thomas >> >> >> >> >> >> Von: "K Post" <nntp.p...@gmail.com> >> An: "ASSP development mailing list" < >> assp-test@lists.sourceforge.net> >> Datum: 05.10.2021 01:27 >> Betreff: Re: [Assp-test] fixes in assp 2.6.6 *SPAM-Evaporator* >> build 21277 >> ------------------------------ >> >> >> >> Thank you Thomas!!! >> This version solved my very slow startup with the rebuild spamdb worker. >> >> I am seeing some entries like: >> got an unexpected TLSv1_2 handshake Client-Helo-Frame of version (3.3) >> from IP '154.21.28.74' at local IP '(my ip here)' and Port '25' - this >> frame is ignored >> >> I don't believe I've seen those before this version. Is that part of the >> improved error handling for SSL SMTP sessions over port 25? >> >> >> >> On Mon, Oct 4, 2021 at 4:21 AM Thomas Eckardt < >> *thomas.ecka...@thockar.com* <thomas.ecka...@thockar.com>> wrote: >> Hi all, >> >> fixed in assp 2.6.6 *SPAM-Evaporator* build 21277: >> >> - If a relational DB engine was used for hmmDB and/or SpamDB, the start >> of the worker 10001 (rebuildspamdb worker) has taken much more time (under >> certain conditions) >> compared to the start time of all other workers >> >> - Improved error handling in case a client or server connects to the >> default SMTP-listener (25) using SSL. >> >> - The 'fakeAUTHsuccess' feature was not working like expected (caused by >> a fix for AUTH-error handling in assp 2.6.4 *SPAM-Evaporator* build 19284). >> >> >> added: >> >> - At the point in time the X-ASSP-.. headers were calculated, assp now >> calls '&CorrectASSPcfg::modMyHeader($Con{fh})' (if this sub is defined). >> This makes it possible to in place modify $Con{fh}->{myheader} to any >> special needs. >> Keep in mind: Modifying SMTP-headers in a wrong manner may prevent >> mails from beeing transported! >> >> Thomas >> >> DISCLAIMER: >> ******************************************************* >> This email and any files transmitted with it may be confidential, legally >> privileged and protected in law and are intended solely for the use of the >> individual to whom it is addressed. >> This email was multiple times scanned for viruses. There should be no >> known virus in this email! >> ******************************************************* >> >> _______________________________________________ >> Assp-test mailing list >> *Assp-test@lists.sourceforge.net* <Assp-test@lists.sourceforge.net> >> *https://lists.sourceforge.net/lists/listinfo/assp-test* >> <https://lists.sourceforge.net/lists/listinfo/assp-test> >> _______________________________________________ >> Assp-test mailing list >> Assp-test@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/assp-test >> >> >> >> >> DISCLAIMER: >> ******************************************************* >> This email and any files transmitted with it may be confidential, legally >> privileged and protected in law and are intended solely for the use of the >> individual to whom it is addressed. >> This email was multiple times scanned for viruses. There should be no >> known virus in this email! >> ******************************************************* >> >> _______________________________________________ >> Assp-test mailing list >> Assp-test@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/assp-test >> >
_______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test