>depending on your config this could be much too less. There are 10 workers running. I will reduce it down to 5.
>The MySQL server should never drop inactive assp connections before 5 minutes. connect_timeout is set to 10 seconds. Should I increase this variable upto 300? Marco -----Ursprüngliche Nachricht----- Von: Thomas Eckardt [mailto:[email protected]] Gesendet: Donnerstag, 24. November 2011 15:42 An: ASSP development mailing list Betreff: [Assp-test] Antwort: Exception: MySQL server has gone away >(max_connections=250) depending on your config this could be much too less. The MySQL server should never drop inactive assp connections before 5 minutes. Thomas Von: spambox <[email protected]> An: <[email protected]> Datum: 24.11.2011 15:33 Betreff: [Assp-test] Exception: MySQL server has gone away Hello, once a day assp stops working. The debug information shows the following Exception: "MySQL server has gone away". This Exception will loop for an internal mail client delivering mails from inside our org till I restart assp. Ist possible to established a connection to the mysql server without a problem at the same time. ->Client tries to deliver several times, assp throws Exceptions, connect to mysql is possible between exception and restart At the same time assp does not answer with plaintext promt at port 25. Connect is possible, there is a cursor, but there is no promt to write something down at windows cmd telnet. I've got to restart assp to get back the connection to mysql (max_connections=250) I think this is a assp issue. These are the logs of worker 2 and main thread only: Nov-24-11 13:58:12 [Worker_2] Worker_2 wakes up Nov-24-11 13:58:12 [Worker_2] Info: Worker_2 got connection from MainThread - 19/19 Nov-24-11 13:58:12 [Main_Thread] Info: Main_Thread will wait (max 30 s) for the answer of Worker_2 which handles 0 sockets Nov-24-11 13:58:43 [Main_Thread] Info: Worker_2 handles 0 sockets and does not answer - will try other worker Nov-24-11 14:01:06 [Worker_2] Info: Worker_2 freed Main_Thread - 32 Nov-24-11 14:01:06 [Worker_2] Connected: 192.168.2.60:63827 > 192.168.3.1:587 > 127.0.0.1:24031 > 127.0.0.1:425 , 32-33 Nov-24-11 14:01:06 [Worker_2] [SSL-in] 192.168.2.60 [SMTP Reply] 220 someserver.tld Microsoft ESMTP MAIL Service ready at Thu, 24 Nov 2011 14:01:05 +0100 Nov-24-11 14:01:06 [Worker_2] [SSL-out] SC-Time Worker_2: 0.00410103797912598 Nov-24-11 14:01:06 [Worker_2] Info: cleaned up garbage from closed connections Nov-24-11 14:01:06 [Worker_2] Info: cleaned 2 kbyte of memory from 1 closed connections Nov-24-11 14:01:06 [Worker_2] [SSL-in] 192.168.2.60 SC-Time Worker_2: 0.00353097915649414 Nov-24-11 14:01:06 [Worker_2] [SSL-in] 192.168.2.60 [SMTP Reply] 250 XSHADOW Nov-24-11 14:01:06 [Worker_2] [SSL-out] SC-Time Worker_2: 0.0199530124664307 Nov-24-11 14:01:06 [Worker_2] [SSL-in] 192.168.2.60 info: authentication - login is used Nov-24-11 14:01:06 [Worker_2] [SSL-in] 192.168.2.60 SC-Time Worker_2: 0.00315690040588379 Nov-24-11 14:01:07 [Worker_2] [SSL-in] 192.168.2.60 [SMTP Reply] 334 xxxxxxxx Nov-24-11 14:01:07 [Worker_2] [SSL-out] SC-Time Worker_2: 0.00306391716003418 Nov-24-11 14:01:07 [Worker_2] [SSL-in] 192.168.2.60 SC-Time Worker_2: 0.00263714790344238 Nov-24-11 14:01:07 [Worker_2] [SSL-in] 192.168.2.60 [SMTP Reply] 334 xxxxxxxx Nov-24-11 14:01:07 [Worker_2] [SSL-out] SC-Time Worker_2: 0.00319290161132813 Nov-24-11 14:01:07 [Worker_2] [SSL-in] 192.168.2.60 SC-Time Worker_2: 0.00253796577453613 Nov-24-11 14:01:07 [Worker_2] [SSL-in] 192.168.2.60 authenticated Nov-24-11 14:01:07 [Worker_2] [SSL-in] 192.168.2.60 [SMTP Reply] 235 2.7.0 Authentication successful Nov-24-11 14:01:07 [Worker_2] [SSL-out] SC-Time Worker_2: 0.00397801399230957 Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> info: found message size announcement: 2.08 kByte Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> SC-Time Worker_2: 0.00435900688171387 Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> [SMTP Reply] 250 2.1.0 Sender OK Nov-24-11 14:01:07 [Worker_2] [SSL-out] SC-Time Worker_2: 0.00321197509765625 Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> to: [email protected] recipient accepted without delaying: [email protected] Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> to: [email protected] SC-Time Worker_2: 0.0128738880157471 Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> to: [email protected] [SMTP Reply] 250 2.1.5 Recipient OK Nov-24-11 14:01:07 [Worker_2] [SSL-out] SC-Time Worker_2: 0.00368404388427734 Nov-24-11 14:01:07 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> to: [email protected] SC-Time Worker_2: 0.0036170482635498 Nov-24-11 14:01:08 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> to: [email protected] [SMTP Reply] 354 Start mail input; end with <CRLF>.<CRLF> Nov-24-11 14:01:08 [Worker_2] [SSL-out] SC-Time Worker_2: 0.0038139820098877 Nov-24-11 14:01:08 [Worker_2] Error: Worker_2: Database select statement failed: MySQL server has gone away at sub main::pbWhiteFind line 11 thread 4 Nov-24-11 14:01:08 [Worker_2] Info: auto restart died worker Worker_2 Nov-24-11 14:01:08 [Worker_2] [SSL-out] info: wrote all current available connection data to file c:/assp/debug/con229.txt Nov-24-11 14:01:08 m-39667-11783 [Worker_2] [SSL-in] 192.168.2.60 <[email protected]> to: [email protected] info: wrote all current available connection data to file c:/assp/debug/con230.txt Nov-24-11 14:01:08 [Worker_2] AdminUpdate: warning count of URIBLServiceProvider not >= URIBLmaxreplies - possibly ok if weigths are used Nov-24-11 14:01:11 [Worker_10000] Info: MainThread has retured to normal state after stuck Nov-24-11 14:01:15 [Worker_2] AdminUpdate: warning count of URIBLServiceProvider not >= URIBLmaxreplies - possibly ok if weigths are used Nov-24-11 14:01:15 [Worker_2] Worker_2 started Nov-24-11 14:01:15 [Worker_2] Worker_2 prepair to sleep Nov-24-11 14:01:15 [Worker_2] Worker_2 will sleep now Con229.txt ---------- ASSP version: 2.03 Worker 2 - Connection Data ---- exception detected : Database select statement failed: MySQL server has gone away at sub main::pbWhiteFind line 11 thread 4 last debug step was: Error: Database select statement failed: MySQL server has gone away at sub main::pbWhiteFind line 11 thread 4 last sigoff was : last sigoff in main, sub main::SMTPTraffic, 11, main::sigoffTry, 1, , , at 11-24-10 14:18 1322139668.15673 - 11 last sigon was : last sigon in main, sub main::SMTPTraffic, 13, main::sigonTry, 1, , , at 11-24-10 14:18 1322139668.15716 - 13 [.] Con230.txt ---------- ASSP version: 2.03 Worker 2 - Connection Data ---- exception detected : Database select statement failed: MySQL server has gone away at sub main::pbWhiteFind line 11 thread 4 last debug step was: Error: Database select statement failed: MySQL server has gone away at sub main::pbWhiteFind line 11 thread 4 last sigoff was : last sigoff in main, sub main::SMTPTraffic, 11, main::sigoffTry, 1, , , at 11-24-10 14:18 1322139668.15673 - 11 last sigon was : last sigon in main, sub main::SMTPTraffic, 13, main::sigonTry, 1, , , at 11-24-10 14:18 1322139668.15716 - 13 [.] Do you need further information? Regards, Marco ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Assp-test mailing list [email protected] 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! ******************************************************* ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
