On Tue, Oct 11, 2016 at 11:29 AM, Thomas Eckardt/eck [via Anti-Spam SMTP
Proxy Server] <ml-node+s996265n41808...@n3.nabble.com> 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]
> <http:///user/SendEmail.jtp?type=node&node=41808&i=0>>
> An: [hidden email]
> <http:///user/SendEmail.jtp?type=node&node=41808&i=1>
> 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]
> <http:///user/SendEmail.jtp?type=node&node=41808&i=2>> 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] <http:///user/SendEmail.jtp?type=node&node=41808&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=41808&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-tp41793p41808.html
> To unsubscribe from Worker threads are getting stuck, click here
> <http://anti-spam-smtp-proxy-server.996265.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=41793&code=dmFpYmhhdmphaW1hbkBnbWFpbC5jb218NDE3OTN8LTE5NzE3NzA3NzQ=>
> .
> 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-tp41793p41809.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
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
