Worker threads are getting stuck

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
10 messages Options
vj
Reply | Threaded
Open this post in threaded view
|

Worker threads are getting stuck

vj
seeing assp worker thread getting stuck often and the service is getting
stopped frequently, switched to 16280 still same.

performance is set to very high

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

Colin
Turn it off. As I found you shouldn't enable the high performance setting
unless you have a very good reason.

If you want to see the troubleshooting that led to it just look back at my
posts over the past week!

On 8 Oct 2016 13:51, "Vaibhav Jaiman" <[hidden email]> wrote:

> seeing assp worker thread getting stuck often and the service is getting
> stopped frequently, switched to 16280 still same.
>
> performance is set to very high
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

Thomas Eckardt/eck
> performance is set to very high

Making this selection requires multiple additionally tweeks in the
assp.cfg - after a deep inspection of the system, system setup, assp setup
and workload.
I've changed the 'EnableHighPerformance' GUI text to:

If set, the SMTP-Worker-Threads will get new pending connections faster -
using less wait states. The speed to interrupt the workers by the
MainThread is increased. Using this feature will increase the CPU usage of
the system! An too high setting, may lead in to stuck workers, or in worth
case, in to a much lower perfomance.
  <AN IN RED>
If there is any doubt about this setting, leave this feature off!

I hope this makes everything clear!

Thomas





Von:    cw <[hidden email]>
An:     ASSP development mailing list <[hidden email]>
Datum:  08.10.2016 16:39
Betreff:        Re: [Assp-test] Worker threads are getting stuck



Turn it off. As I found you shouldn't enable the high performance setting
unless you have a very good reason.

If you want to see the troubleshooting that led to it just look back at my
posts over the past week!

On 8 Oct 2016 13:51, "Vaibhav Jaiman" <[hidden email]> wrote:

> seeing assp worker thread getting stuck often and the service is getting
> stopped frequently, switched to 16280 still same.
>
> performance is set to very high
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
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!
*******************************************************


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
vj
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

vj
In reply to this post by vj
ASSP keeps dying every one or two hour, verbose logs just before the crash

- also noticed there are mysql error of duplicate entry for primary key (whitelistdb)

switched to 16282 and assp started crashing every 5-10 min , switched back to 16177 but assp is crashing evry hour or then.

Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size: 164.84 kByte - sent DATA size: 165.48 kByte
Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4 125.18.107.12 - command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9 SocketCalls - processing time 16 seconds - damped 0 seconds
Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection request
Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best Worker for new connection - 8
Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30 s) for the answer of Worker_1 which handles 0 sockets
Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from MainThread - 8/8
Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle Worker_1 in 0.003 seconds - got (ok)
Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at 127.0.0.1:125
Oct-09-16 13:54:51 [Worker_1] Info: connected to server at 127.0.0.1:125
Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC 209.8.217.17:33467 > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname ESMTP MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC 3.51 Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for key 'PRIMARY' (SQL-23000)
Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1: 0.0282409191131592
Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250 AUTH=LOGIN
Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <user@gmail.com> info: found message size announcement: 23.72 MByte
Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <user@gmail.com> SC-Time Worker_1: 0.0878159999847412
Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <user@gmail.com> [SMTP Reply] 250 Requested mail action okay, completed
Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection request
Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best Worker for new connection - 8
Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30 s) for the answer of Worker_3 which handles 0 sockets
Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from MainThread - 8/8
Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle Worker_3 in 0.003 seconds - got (ok)
Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at 127.0.0.1:125
Oct-09-16 13:56:56 [Worker_4] Info: connected to server at 127.0.0.1:125
Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 > 127.0.0.1:125 , 32-33
Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220 hostname ESMTP MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

Colin
There's not much to go on there - looks like you're on Windows. What is
dying? Anything in the event logs? Perl core dumps? Have you been through
the usual make sure everything is up to date and checked your settings for
anything that may have been fiddled with?

On Sun, Oct 9, 2016 at 3:20 PM, vj <[hidden email]> wrote:

> ASSP keeps dying every one or two hour, verbose logs just before the crash
>
> - also noticed there are mysql error of duplicate entry for primary key
> (whitelistdb)
>
> switched to 16282 and assp started crashing every 5-10 min , switched back
> to 16177 but assp is crashing evry hour or then.
>
> Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
> Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size: 164.84
> kByte - sent DATA size: 165.48 kByte
> Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4 125.18.107.12 -
> command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9 SocketCalls -
> processing time 16 seconds - damped 0 seconds
> Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
> Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection request
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best Worker
> for new connection - 8
> Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30 s) for
> the answer of Worker_1 which handles 0 sockets
> Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from MainThread
> - 8/8
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle Worker_1
> in
> 0.003 seconds - got (ok)
> Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
> Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at
> 127.0.0.1:125
> Oct-09-16 13:54:51 [Worker_1] Info: connected to server at 127.0.0.1:125
> Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC
> 209.8.217.17:33467
> > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
> Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname ESMTP
> MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
> Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
> Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC 3.51
> Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for key
> 'PRIMARY' (SQL-23000)
> Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1:
> 0.0282409191131592
> Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250 AUTH=LOGIN
> Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
> Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden email]>
> info: found message size announcement: 23.72 MByte
> Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden email]>
> SC-Time Worker_1: 0.0878159999847412
> Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden email]>
> [SMTP Reply] 250 Requested mail action okay, completed
> Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection request
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best Worker
> for new connection - 8
> Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30 s) for
> the answer of Worker_3 which handles 0 sockets
> Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from MainThread
> - 8/8
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle Worker_3
> in
> 0.003 seconds - got (ok)
> Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
> Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at
> 127.0.0.1:125
> Oct-09-16 13:56:56 [Worker_4] Info: connected to server at 127.0.0.1:125
> Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC
> 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 > 127.0.0.1:125 ,
> 32-33
> Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220 hostname
> ESMTP
> MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
> Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
>
>
>
>
> --
> View this message in context: http://anti-spam-smtp-proxy-
> server.996265.n3.nabble.com/Worker-threads-are-getting-
> stuck-tp41793p41797.html
> Sent from the assp-test mailing list archive at Nabble.com.
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
vj
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

vj
yes running it on windows2k12r2
- perl version perl_5.20.2__4-assp.zip(sf)
- assp build 16280

there is no module load error in assp version.

any suggestion.. cant find any details for the crash...

On Mon, Oct 10, 2016 at 3:20 AM, cw [via Anti-Spam SMTP Proxy Server] <[hidden email]> wrote:
There's not much to go on there - looks like you're on Windows. What is
dying? Anything in the event logs? Perl core dumps? Have you been through
the usual make sure everything is up to date and checked your settings for
anything that may have been fiddled with?

On Sun, Oct 9, 2016 at 3:20 PM, vj <[hidden email]> wrote:

> ASSP keeps dying every one or two hour, verbose logs just before the crash
>
> - also noticed there are mysql error of duplicate entry for primary key
> (whitelistdb)
>
> switched to 16282 and assp started crashing every 5-10 min , switched back
> to 16177 but assp is crashing evry hour or then.
>
> Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
> Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size: 164.84
> kByte - sent DATA size: 165.48 kByte
> Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4 125.18.107.12 -
> command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9 SocketCalls -
> processing time 16 seconds - damped 0 seconds
> Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
> Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection request
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best Worker
> for new connection - 8
> Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30 s) for
> the answer of Worker_1 which handles 0 sockets
> Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from MainThread
> - 8/8
> Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle Worker_1
> in
> 0.003 seconds - got (ok)
> Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
> Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at
> 127.0.0.1:125
> Oct-09-16 13:54:51 [Worker_1] Info: connected to server at 127.0.0.1:125
> Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC
> 209.8.217.17:33467
> > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
> Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname ESMTP
> MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
> Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
> Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC 3.51
> Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for key
> 'PRIMARY' (SQL-23000)
> Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1:
> 0.0282409191131592
> Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250 AUTH=LOGIN
> Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
> Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden email]>
> info: found message size announcement: 23.72 MByte
> Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden email]>
> SC-Time Worker_1: 0.0878159999847412
> Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden email]>
> [SMTP Reply] 250 Requested mail action okay, completed
> Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection request
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best Worker
> for new connection - 8
> Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30 s) for
> the answer of Worker_3 which handles 0 sockets
> Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from MainThread
> - 8/8
> Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle Worker_3
> in
> 0.003 seconds - got (ok)
> Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
> Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at
> 127.0.0.1:125
> Oct-09-16 13:56:56 [Worker_4] Info: connected to server at 127.0.0.1:125
> Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC
> 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 > 127.0.0.1:125 ,
> 32-33
> Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220 hostname
> ESMTP
> MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
> Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
>
>
>
>
> --
> View this message in context: http://anti-spam-smtp-proxy-
> server.996265.n3.nabble.com/Worker-threads-are-getting-
> stuck-tp41793p41797.html
> Sent from the assp-test mailing list archive at Nabble.com.
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test



If you reply to this email, your message will be added to the discussion below:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41799.html
To unsubscribe from Worker threads are getting stuck, click here.
NAML



--
Regards,

Vaibhav Jaiman
MCP,MCTS 
09462085652
Windows Administrator
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

Thomas Eckardt/eck
> > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> 3.51
> > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
key
> > 'PRIMARY' (SQL-23000)

solve this

Thomas





Von:    vj <[hidden email]>
An:     [hidden email]
Datum:  10.10.2016 12:33
Betreff:        Re: [Assp-test] Worker threads are getting stuck



yes running it on windows2k12r2
- perl version perl_5.20.2__4-assp.zip
<
https://sourceforge.net/projects/assp/files/ASSP%20V2%20multithreading/ASSP%20V2%20module%20installation/perl_5.20.2__4-assp.zip/download
>
(sf)
- assp build 16280

there is no module load error in assp version.

any suggestion.. cant find any details for the crash...

On Mon, Oct 10, 2016 at 3:20 AM, cw [via Anti-Spam SMTP Proxy Server] <
[hidden email]> wrote:

> There's not much to go on there - looks like you're on Windows. What is
> dying? Anything in the event logs? Perl core dumps? Have you been
through
> the usual make sure everything is up to date and checked your settings
for
> anything that may have been fiddled with?
>
> On Sun, Oct 9, 2016 at 3:20 PM, vj <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41799&i=0>> wrote:
>
> > ASSP keeps dying every one or two hour, verbose logs just before the
> crash
> >
> > - also noticed there are mysql error of duplicate entry for primary
key

> > (whitelistdb)
> >
> > switched to 16282 and assp started crashing every 5-10 min , switched
> back
> > to 16177 but assp is crashing evry hour or then.
> >
> > Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
> > Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size:
> 164.84
> > kByte - sent DATA size: 165.48 kByte
> > Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4
> 125.18.107.12 -
> > command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9
SocketCalls

> -
> > processing time 16 seconds - damped 0 seconds
> > Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
> > Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection
> request
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best
> Worker
> > for new connection - 8
> > Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30
s)

> for
> > the answer of Worker_1 which handles 0 sockets
> > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from
> MainThread
> > - 8/8
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle
> Worker_1
> > in
> > 0.003 seconds - got (ok)
> > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
> > Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at
> > 127.0.0.1:125
> > Oct-09-16 13:54:51 [Worker_1] Info: connected to server at
127.0.0.1:125

> > Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC
> > 209.8.217.17:33467
> > > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
> > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname
> ESMTP
> > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
> > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
> > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> 3.51
> > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
key

> > 'PRIMARY' (SQL-23000)
> > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1:
> > 0.0282409191131592
> > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250 AUTH=LOGIN
> > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
> > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=41799&i=1>>
> > info: found message size announcement: 23.72 MByte
> > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=41799&i=2>>
> > SC-Time Worker_1: 0.0878159999847412
> > Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=41799&i=3>>
> > [SMTP Reply] 250 Requested mail action okay, completed
> > Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection
> request
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best
> Worker
> > for new connection - 8
> > Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30
s)

> for
> > the answer of Worker_3 which handles 0 sockets
> > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from
> MainThread
> > - 8/8
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle
> Worker_3
> > in
> > 0.003 seconds - got (ok)
> > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
> > Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at
> > 127.0.0.1:125
> > Oct-09-16 13:56:56 [Worker_4] Info: connected to server at
127.0.0.1:125

> > Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC
> > 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 > 127.0.0.1:125
> ,
> > 32-33
> > Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220 hostname
> > ESMTP
> > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
> > Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
> >
> >
> >
> >
> > --
> > View this message in context: http://anti-spam-smtp-proxy-
> > server.996265.n3.nabble.com/Worker-threads-are-getting-
> > stuck-tp41793p41797.html
> > Sent from the assp-test mailing list archive at Nabble.com.
> >
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Assp-test mailing list
> > [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=4>
> > https://lists.sourceforge.net/lists/listinfo/assp-test
> >
>
>
------------------------------------------------------------------------------

>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=5>
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> Worker-threads-are-getting-stuck-tp41793p41799.html
> To unsubscribe from Worker threads are getting stuck, click here
> <

> .
> NAML
> <
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
>
>



--
Regards,

Vaibhav Jaiman
MCP,MCTS
09462085652
Windows Administrator




--
View this message in context:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41803.html

Sent from the assp-test mailing list archive at
Nabble.com.------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
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!
*******************************************************


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
vj
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

vj
any suggestion on fixing this ?

On Mon, Oct 10, 2016 at 9:45 PM, Thomas Eckardt/eck [via Anti-Spam SMTP Proxy Server] <[hidden email]> wrote:
> > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> 3.51
> > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
key
> > 'PRIMARY' (SQL-23000)

solve this

Thomas





Von:    vj <[hidden email]>
An:     [hidden email]
Datum:  10.10.2016 12:33
Betreff:        Re: [Assp-test] Worker threads are getting stuck



yes running it on windows2k12r2
- perl version perl_5.20.2__4-assp.zip
<
https://sourceforge.net/projects/assp/files/ASSP%20V2%20multithreading/ASSP%20V2%20module%20installation/perl_5.20.2__4-assp.zip/download
>
(sf)
- assp build 16280

there is no module load error in assp version.

any suggestion.. cant find any details for the crash...

On Mon, Oct 10, 2016 at 3:20 AM, cw [via Anti-Spam SMTP Proxy Server] <
[hidden email]> wrote:

> There's not much to go on there - looks like you're on Windows. What is
> dying? Anything in the event logs? Perl core dumps? Have you been
through
> the usual make sure everything is up to date and checked your settings
for
> anything that may have been fiddled with?
>
> On Sun, Oct 9, 2016 at 3:20 PM, vj <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41799&i=0>> wrote:
>
> > ASSP keeps dying every one or two hour, verbose logs just before the
> crash
> >
> > - also noticed there are mysql error of duplicate entry for primary
key

> > (whitelistdb)
> >
> > switched to 16282 and assp started crashing every 5-10 min , switched
> back
> > to 16177 but assp is crashing evry hour or then.
> >
> > Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
> > Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size:
> 164.84
> > kByte - sent DATA size: 165.48 kByte
> > Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4
> 125.18.107.12 -
> > command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9
SocketCalls

> -
> > processing time 16 seconds - damped 0 seconds
> > Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
> > Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection
> request
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best
> Worker
> > for new connection - 8
> > Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30
s)

> for
> > the answer of Worker_1 which handles 0 sockets
> > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from
> MainThread
> > - 8/8
> > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle
> Worker_1
> > in
> > 0.003 seconds - got (ok)
> > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
> > Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at
> > 127.0.0.1:125
> > Oct-09-16 13:54:51 [Worker_1] Info: connected to server at
127.0.0.1:125

> > Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC
> > 209.8.217.17:33467
> > > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
> > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname
> ESMTP
> > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
> > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
> > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> 3.51
> > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
key

> > 'PRIMARY' (SQL-23000)
> > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1:
> > 0.0282409191131592
> > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250 AUTH=LOGIN
> > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
> > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=41799&i=1>>
> > info: found message size announcement: 23.72 MByte
> > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=41799&i=2>>
> > SC-Time Worker_1: 0.0878159999847412
> > Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=41799&i=3>>
> > [SMTP Reply] 250 Requested mail action okay, completed

> > Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection
> request
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best
> Worker
> > for new connection - 8
> > Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30
s)

> for
> > the answer of Worker_3 which handles 0 sockets
> > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from
> MainThread
> > - 8/8
> > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle
> Worker_3
> > in
> > 0.003 seconds - got (ok)
> > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
> > Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at
> > 127.0.0.1:125
> > Oct-09-16 13:56:56 [Worker_4] Info: connected to server at
127.0.0.1:125

> > Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC
> > 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 > 127.0.0.1:125
> ,
> > 32-33
> > Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220 hostname
> > ESMTP
> > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
> > Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
> >
> >
> >
> >
> > --
> > View this message in context: http://anti-spam-smtp-proxy-
> > server.996265.n3.nabble.com/Worker-threads-are-getting-
> > stuck-tp41793p41797.html
> > Sent from the assp-test mailing list archive at Nabble.com.
> >
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Assp-test mailing list
> > [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=4>
> > https://lists.sourceforge.net/lists/listinfo/assp-test
> >
>
>
------------------------------------------------------------------------------

>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=5>
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion

> below:
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> Worker-threads-are-getting-stuck-tp41793p41799.html
> To unsubscribe from Worker threads are getting stuck, click here
> <

> .
> NAML
> <
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
>
>



--
Regards,

Vaibhav Jaiman
MCP,MCTS
09462085652
Windows Administrator




--
View this message in context:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41803.html

Sent from the assp-test mailing list archive at
Nabble.com.------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
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!
*******************************************************


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test



If you reply to this email, your message will be added to the discussion below:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41805.html
To unsubscribe from Worker threads are getting stuck, click here.
NAML



--
Regards,

Vaibhav Jaiman
MCP,MCTS 
09462085652
Windows Administrator
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

Thomas Eckardt/eck
Don't use ODBC, instead use the native MySQL driver DBD::mysql

Thomas





Von:    vj <[hidden email]>
An:     [hidden email]
Datum:  10.10.2016 19:46
Betreff:        Re: [Assp-test] Worker threads are getting stuck



any suggestion on fixing this ?

On Mon, Oct 10, 2016 at 9:45 PM, Thomas Eckardt/eck [via Anti-Spam SMTP
Proxy Server] <[hidden email]> wrote:

> > > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> > 3.51
> > > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
> key
> > > 'PRIMARY' (SQL-23000)
>
> solve this
>
> Thomas
>
>
>
>
>
> Von:    vj <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41805&i=0>>
> An:     [hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41805&i=1>
> Datum:  10.10.2016 12:33
> Betreff:        Re: [Assp-test] Worker threads are getting stuck
>
>
>
> yes running it on windows2k12r2
> - perl version perl_5.20.2__4-assp.zip
> <
> <a href="https://sourceforge.net/projects/assp/files/ASSP%20V2%">https://sourceforge.net/projects/assp/files/ASSP%20V2%
> 20multithreading/ASSP%20V2%20module%20installation/perl_
> 5.20.2__4-assp.zip/download
> >
> (sf)
> - assp build 16280
>
> there is no module load error in assp version.
>
> any suggestion.. cant find any details for the crash...
>
> On Mon, Oct 10, 2016 at 3:20 AM, cw [via Anti-Spam SMTP Proxy Server] <
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41805&i=2>>
> wrote:
>
> > There's not much to go on there - looks like you're on Windows. What
is

> > dying? Anything in the event logs? Perl core dumps? Have you been
> through
> > the usual make sure everything is up to date and checked your settings
> for
> > anything that may have been fiddled with?
> >
> > On Sun, Oct 9, 2016 at 3:20 PM, vj <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=41799&i=0>> wrote:
> >
> > > ASSP keeps dying every one or two hour, verbose logs just before the
> > crash
> > >
> > > - also noticed there are mysql error of duplicate entry for primary
> key
>
> > > (whitelistdb)
> > >
> > > switched to 16282 and assp started crashing every 5-10 min ,
switched

> > back
> > > to 16177 but assp is crashing evry hour or then.
> > >
> > > Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
> > > Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size:
> > 164.84
> > > kByte - sent DATA size: 165.48 kByte
> > > Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4
> > 125.18.107.12 -
> > > command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9
> SocketCalls
>
> > -
> > > processing time 16 seconds - damped 0 seconds
> > > Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
> > > Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection
> > request
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best
> > Worker
> > > for new connection - 8
> > > Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30
> s)
>
> > for
> > > the answer of Worker_1 which handles 0 sockets
> > > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from
> > MainThread
> > > - 8/8
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle
> > Worker_1
> > > in
> > > 0.003 seconds - got (ok)
> > > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
> > > Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at
> > > 127.0.0.1:125
> > > Oct-09-16 13:54:51 [Worker_1] Info: connected to server at
> 127.0.0.1:125
>
> > > Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC
> > > 209.8.217.17:33467
> > > > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
> > > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname
> > ESMTP
> > > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
> > > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
> > > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> > 3.51
> > > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
> key
>
> > > 'PRIMARY' (SQL-23000)
> > > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1:
> > > 0.0282409191131592
> > > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250
AUTH=LOGIN

> > > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
> > > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> > email] <http:///user/SendEmail.jtp?type=node&node=41799&i=1>>
> > > info: found message size announcement: 23.72 MByte
> > > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> > email] <http:///user/SendEmail.jtp?type=node&node=41799&i=2>>
> > > SC-Time Worker_1: 0.0878159999847412
> > > Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> > email] <http:///user/SendEmail.jtp?type=node&node=41799&i=3>>
> > > [SMTP Reply] 250 Requested mail action okay, completed
> > > Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection
> > request
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best
> > Worker
> > > for new connection - 8
> > > Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30
> s)
>
> > for
> > > the answer of Worker_3 which handles 0 sockets
> > > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from
> > MainThread
> > > - 8/8
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle
> > Worker_3
> > > in
> > > 0.003 seconds - got (ok)
> > > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
> > > Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at
> > > 127.0.0.1:125
> > > Oct-09-16 13:56:56 [Worker_4] Info: connected to server at
> 127.0.0.1:125
>
> > > Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC
> > > 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 >
127.0.0.1:125
> > ,
> > > 32-33
> > > Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220
hostname

> > > ESMTP
> > > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
> > > Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
> > >
> > >
> > >
> > >
> > > --
> > > View this message in context: http://anti-spam-smtp-proxy-
> > > server.996265.n3.nabble.com/Worker-threads-are-getting-
> > > stuck-tp41793p41797.html
> > > Sent from the assp-test mailing list archive at Nabble.com.
> > >
> > > ------------------------------------------------------------
> > > ------------------
> > > Check out the vibrant tech community on one of the world's most
> > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > > _______________________________________________
> > > Assp-test mailing list
> > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=4>
> > > https://lists.sourceforge.net/lists/listinfo/assp-test
> > >
> >
> >
>
------------------------------------------------------------------------------

>
>
> >
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Assp-test mailing list
> > [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=5>
> > https://lists.sourceforge.net/lists/listinfo/assp-test
> >
> >
> > ------------------------------
> > If you reply to this email, your message will be added to the
discussion

> > below:
> > http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> > Worker-threads-are-getting-stuck-tp41793p41799.html
> > To unsubscribe from Worker threads are getting stuck, click here
> > <
>
> > .
> > NAML
> > <
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> template/NamlServlet.jtp?macro=macro_viewer&id=instant_
> html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.
> BasicNamespace-nabble.view.web.template.NabbleNamespace-
> nabble.view.web.template.NodeNamespace&breadcrumbs=
> notify_subscribers%21nabble%3Aemail.naml-instant_emails%
> 21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> >
> >
>
>
>
> --
> Regards,
>
> Vaibhav Jaiman
> MCP,MCTS
> 09462085652
> Windows Administrator
>
>
>
>
> --
> View this message in context:
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> Worker-threads-are-getting-stuck-tp41793p41803.html
>
> Sent from the assp-test mailing list archive at
>
Nabble.com.------------------------------------------------------------------------------

>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41805&i=3>
> 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!
> *******************************************************
>
>
>
------------------------------------------------------------------------------

>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41805&i=4>
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> Worker-threads-are-getting-stuck-tp41793p41805.html
> To unsubscribe from Worker threads are getting stuck, click here
> <

> .
> NAML
> <
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
>
>



--
Regards,

Vaibhav Jaiman
MCP,MCTS
09462085652
Windows Administrator




--
View this message in context:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41806.html

Sent from the assp-test mailing list archive at
Nabble.com.------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
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!
*******************************************************


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test
vj
Reply | Threaded
Open this post in threaded view
|

Re: Worker threads are getting stuck

vj

On Tue, Oct 11, 2016 at 11:29 AM, Thomas Eckardt/eck [via Anti-Spam SMTP Proxy Server] <[hidden email]> wrote:
Don't use ODBC, instead use the native MySQL driver DBD::mysql

Thomas
Isn't that just because of the record with given key already exist ? how driver wll solve this case.. 





Von:    vj <[hidden email]>
An:     [hidden email]
Datum:  10.10.2016 19:46
Betreff:        Re: [Assp-test] Worker threads are getting stuck



any suggestion on fixing this ?

On Mon, Oct 10, 2016 at 9:45 PM, Thomas Eckardt/eck [via Anti-Spam SMTP
Proxy Server] <[hidden email]> wrote:

> > > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> > 3.51
> > > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
> key
> > > 'PRIMARY' (SQL-23000)
>
> solve this
>
> Thomas
>
>
>
>
>
> Von:    vj <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41805&i=0>>
> An:     [hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41805&i=1>
> Datum:  10.10.2016 12:33
> Betreff:        Re: [Assp-test] Worker threads are getting stuck
>
>
>
> yes running it on windows2k12r2
> - perl version perl_5.20.2__4-assp.zip
> <
> <a href="<a href="https://sourceforge.net/projects/assp/files/ASSP%20V2%" target="_blank">https://sourceforge.net/projects/assp/files/ASSP%20V2%"><a href="https://sourceforge.net/projects/assp/files/ASSP%20V2%" target="_blank">https://sourceforge.net/projects/assp/files/ASSP%20V2%
> 20multithreading/ASSP%20V2%20module%20installation/perl_
> 5.20.2__4-assp.zip/download
> >
> (sf)
> - assp build 16280
>
> there is no module load error in assp version.
>
> any suggestion.. cant find any details for the crash...
>
> On Mon, Oct 10, 2016 at 3:20 AM, cw [via Anti-Spam SMTP Proxy Server] <
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41805&i=2>>
> wrote:

>
> > There's not much to go on there - looks like you're on Windows. What
is

> > dying? Anything in the event logs? Perl core dumps? Have you been
> through
> > the usual make sure everything is up to date and checked your settings
> for
> > anything that may have been fiddled with?
> >
> > On Sun, Oct 9, 2016 at 3:20 PM, vj <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=41799&i=0>> wrote:
> >
> > > ASSP keeps dying every one or two hour, verbose logs just before the
> > crash
> > >
> > > - also noticed there are mysql error of duplicate entry for primary
> key
>
> > > (whitelistdb)
> > >
> > > switched to 16282 and assp started crashing every 5-10 min ,
switched

> > back
> > > to 16177 but assp is crashing evry hour or then.
> > >
> > > Oct-09-16 13:54:48 [Worker_1] SC-Time Worker_1: 0.00104808807373047
> > > Oct-09-16 13:54:48 [Worker_1] Finished message - received DATA size:
> > 164.84
> > > kByte - sent DATA size: 165.48 kByte
> > > Oct-09-16 13:54:48 [Worker_1] Disconnected: session:F5F96A4
> > 125.18.107.12 -
> > > command list was 'EHLO,MAIL FROM,RCPT TO,DATA,QUIT' - used 9
> SocketCalls
>
> > -
> > > processing time 16 seconds - damped 0 seconds
> > > Oct-09-16 13:54:48 [Worker_1] Worker_1 prepare to sleep
> > > Oct-09-16 13:54:48 [Worker_1] Worker_1 will sleep now
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread got connection
> > request
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread looks up the best
> > Worker
> > > for new connection - 8
> > > Oct-09-16 13:54:51 [Worker_1] Worker_1 wakes up
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread will wait (max 30
> s)
>
> > for
> > > the answer of Worker_1 which handles 0 sockets
> > > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 got connection from
> > MainThread
> > > - 8/8
> > > Oct-09-16 13:54:51 [Main_Thread] Info: Main_Thread freed by idle
> > Worker_1
> > > in
> > > 0.003 seconds - got (ok)
> > > Oct-09-16 13:54:51 [Worker_1] Info: Worker_1 freed Main_Thread - 82
> > > Oct-09-16 13:54:51 [Worker_1] Info: try to connect to server at
> > > 127.0.0.1:125
> > > Oct-09-16 13:54:51 [Worker_1] Info: connected to server at
> 127.0.0.1:125
>
> > > Oct-09-16 13:54:51 [Worker_1] Connected: session:5AB10EEC
> > > 209.8.217.17:33467
> > > > 10.21.5.16:25 > 127.0.0.1:50724 > 127.0.0.1:125 , 82-86
> > > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 220 hostname
> > ESMTP
> > > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:54:51
> > > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.000944137573242188
> > > Oct-09-16 13:54:51 [Worker_1] Error: Insert (PTRCache): [MySQL][ODBC
> > 3.51
> > > Driver][mysqld-5.1.73-community]Duplicate entry '125.18.107.12' for
> key
>
> > > 'PRIMARY' (SQL-23000)
> > > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 SC-Time Worker_1:
> > > 0.0282409191131592
> > > Oct-09-16 13:54:51 [Worker_1] 209.8.217.17 [SMTP Reply] 250
AUTH=LOGIN

> > > Oct-09-16 13:54:51 [Worker_1] SC-Time Worker_1: 0.00165295600891113
> > > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> > email] <http:///user/SendEmail.jtp?type=node&node=41799&i=1>>
> > > info: found message size announcement: 23.72 MByte
> > > Oct-09-16 13:54:51 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> > email] <http:///user/SendEmail.jtp?type=node&node=41799&i=2>>
> > > SC-Time Worker_1: 0.0878159999847412
> > > Oct-09-16 13:54:52 m1-17691-01472 [Worker_1] 209.8.217.17 <[hidden
> > email] <http:///user/SendEmail.jtp?type=node&node=41799&i=3>>
> > > [SMTP Reply] 250 Requested mail action okay, completed
> > > Oct-09-16 13:54:52 [Worker_1] SC-Time Worker_1: 0.00100898742675781
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread got connection
> > request
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread looks up the best
> > Worker
> > > for new connection - 8
> > > Oct-09-16 13:54:52 [Worker_3] Worker_3 wakes up
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread will wait (max 30
> s)
>
> > for
> > > the answer of Worker_3 which handles 0 sockets
> > > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 got connection from
> > MainThread
> > > - 8/8
> > > Oct-09-16 13:54:52 [Main_Thread] Info: Main_Thread freed by idle
> > Worker_3
> > > in
> > > 0.003 seconds - got (ok)
> > > Oct-09-16 13:54:52 [Worker_3] Info: Worker_3 freed Main_Thread - 97
> > > Oct-09-16 13:54:52 [Worker_3] Info: try to connect to server at
> > > 127.0.0.1:125
> > > Oct-09-16 13:56:56 [Worker_4] Info: connected to server at
> 127.0.0.1:125
>
> > > Oct-09-16 13:56:56 [Worker_4] Connected: session:55A613CC
> > > 218.92.147.100:51078 > 10.21.5.16:25 > 127.0.0.1:50817 >
127.0.0.1:125
> > ,
> > > 32-33
> > > Oct-09-16 13:56:56 [Worker_4] 218.92.147.100 [SMTP Reply] 220
hostname

> > > ESMTP
> > > MailEnable Service, Version: 9.16-- ready at 10/09/16 13:56:56
> > > Oct-09-16 13:56:56 [Worker_4] SC-Time Worker_4: 0.0266239643096924
> > >
> > >
> > >
> > >
> > > --
> > > View this message in context: http://anti-spam-smtp-proxy-
> > > server.996265.n3.nabble.com/Worker-threads-are-getting-
> > > stuck-tp41793p41797.html
> > > Sent from the assp-test mailing list archive at Nabble.com.
> > >
> > > ------------------------------------------------------------
> > > ------------------
> > > Check out the vibrant tech community on one of the world's most
> > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > > _______________________________________________
> > > Assp-test mailing list
> > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=4>
> > > https://lists.sourceforge.net/lists/listinfo/assp-test
> > >
> >
> >
>
------------------------------------------------------------------------------

>
>
> >
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Assp-test mailing list
> > [hidden email] <http:///user/SendEmail.jtp?type=node&node=41799&i=5>
> > https://lists.sourceforge.net/lists/listinfo/assp-test
> >
> >
> > ------------------------------
> > If you reply to this email, your message will be added to the
discussion

> > below:
> > http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> > Worker-threads-are-getting-stuck-tp41793p41799.html
> > To unsubscribe from Worker threads are getting stuck, click here
> > <
>
> > .
> > NAML
> > <
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> template/NamlServlet.jtp?macro=macro_viewer&id=instant_
> html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.
> BasicNamespace-nabble.view.web.template.NabbleNamespace-
> nabble.view.web.template.NodeNamespace&breadcrumbs=
> notify_subscribers%21nabble%3Aemail.naml-instant_emails%
> 21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> >
> >
>
>
>
> --
> Regards,
>
> Vaibhav Jaiman
> MCP,MCTS
> 09462085652
> Windows Administrator
>
>
>
>
> --
> View this message in context:
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> Worker-threads-are-getting-stuck-tp41793p41803.html
>
> Sent from the assp-test mailing list archive at
>
Nabble.com.------------------------------------------------------------------------------

>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41805&i=3>
> 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!
> *******************************************************
>
>
>
------------------------------------------------------------------------------

>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Assp-test mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=41805&i=4>
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/
> Worker-threads-are-getting-stuck-tp41793p41805.html
> To unsubscribe from Worker threads are getting stuck, click here
> <

> .
> NAML
> <
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
>
>



--
Regards,

Vaibhav Jaiman
MCP,MCTS
09462085652
Windows Administrator




--
View this message in context:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41806.html


Sent from the assp-test mailing list archive at
Nabble.com.------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
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!
*******************************************************


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Assp-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-test



If you reply to this email, your message will be added to the discussion below:
http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/Worker-threads-are-getting-stuck-tp41793p41808.html
To unsubscribe from Worker threads are getting stuck, click here.
NAML



--
Regards,

Vaibhav Jaiman
MCP,MCTS 
09462085652
Windows Administrator