NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: BradT on September 29, 2022, 12:50:12 PM

Title: NT Webserver Freezing
Post by: BradT on September 29, 2022, 12:50:12 PM

Clarion 11.1
NT 12.46

I have a NT webserver.  Just upgraded to C11.1 and NT 12.46. 

The webserver seems to work fine, except sometime in the night it will freeze. 
I've had to restart it each morning after forcing it to close.

Any thoughts on how to troubleshoot? 

Title: Re: NT Webserver Freezing
Post by: Jane on September 29, 2022, 05:16:08 PM

SQL or TPS?

Title: Re: NT Webserver Freezing
Post by: BradT on September 29, 2022, 07:09:22 PM

SQL

Title: Re: NT Webserver Freezing
Post by: Jane on September 29, 2022, 07:25:58 PM

If you've paid for the CIDC2020 content, the first thing I'd recommend would be to watch Rick Martin's session on Preventing SQL Disconnections and see whether his approach is something you'd want to try.

https://www.cidc2020.com/IndexPage

Title: Re: NT Webserver Freezing
Post by: Bruce on October 01, 2022, 01:04:21 AM

yes, you're almost certainly the victim of a SQL disconnect.
Perhaps issue a sometable{prop:logout} on the web server procedure itself, if traffic has been quiet for a while.
(If you like, in the user group webinar this thursday, I can show you how.)

Cheers
Bruce

Title: Re: NT Webserver Freezing
Post by: BradT on October 01, 2022, 07:19:20 PM

I had a call to an external API that was stuck in a loop with no timeout.  It apparently was a coincidence that the latest versions of Clarion and NetTalk were just loaded.   Thank you for the time.