RE: Connection is broken, cannot receive request reply
Hi David, We've seen something similar in recent weeks. Merged Server database running under Windows 2012 Server, problem seen with both 4D v16R3 and v16R4 Periodically, once every 18-36 hours the ten or more 4D Remote clients connected to the server lose contact with the server application. IN some cases there may be idle issues, but at least half a dozen of the users are using the database reasonably heavily on a continual basis throughout the day. If the users quit the 4D Remote and then attempt to connect to the server again, they cannot make the connection. It appears that the 4D Server is no longer broadcasting its availability. Interestingly enough the Web Server is still working perfectly well, even for brand new connections. No spike in processes, cpu usage, or anything that even resembles a rouge / infinite process. Only option is to quit the Server app and restart. Customer is starting to get a bit grumpy about this and we're struggling to work out a solution to the problem. :-( Allan Udy David Ringsmuth wrote: Date: Wed, 15 Nov 2017 11:46:01 -0600 Subject: RE: Connection is broken, cannot receive request reply Alan, SET DATABASE PARAMETER(54;4) This is for testing, wanted to make sure 4D closed the connection, not any network resource. But alas something is closing it and 4D Remote is crashing because of it. The crash occurs both after a long time of idle, and when the users are actively interacting in the application. The SET DATABASE PARAMETER(14;1) AND SET DATABASE PARAMETER(13;1) seem to have made the idle error occur after a longer delay on our test network. But the error continues to occur both on our network, and on our client’s network. We have not solved this problem. We plan to open a tech support case… Thanks! David Ringsmuth Cheers, Allan Udy Golden Micro Solutions Ltd, Blenheim, New Zealand http://www.golden.co.nz<http://www.golden.co.nz> ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connection is broken, cannot receive request reply
Alan, SET DATABASE PARAMETER(54;4) This is for testing, wanted to make sure 4D closed the connection, not any network resource. But alas something is closing it and 4D Remote is crashing because of it. The crash occurs both after a long time of idle, and when the users are actively interacting in the application. The SET DATABASE PARAMETER(14;1) AND SET DATABASE PARAMETER(13;1) seem to have made the idle error occur after a longer delay on our test network. But the error continues to occur both on our network, and on our client’s network. We have not solved this problem. We plan to open a tech support case… Thanks! David Ringsmuth From: Alan Chan via 4D_Tech Sent: Tuesday, November 14, 2017 8:59 PM To: 4d_tech@lists.4d.com Cc: Alan Chan Subject: Re: Connection is broken, cannot receive request reply Just curious, 4 seconds for idle connections timeout? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >SET DATABASE PARAMETER(54;4)// Idle connections timeout ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Connection is broken, cannot receive request reply
Just curious, 4 seconds for idle connections timeout? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >SET DATABASE PARAMETER(54;4)// Idle connections timeout ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connection is broken, cannot receive request reply
Tim, Our current test for the error still going at 3h+, and there is no error. It was the SET DATABASE PAREMETER(14;1) that kept it going without an error. I think the problem is solved! THANKS! David Ringsmuth From: Timothy Penner via 4D_Tech Sent: Tuesday, November 14, 2017 11:18 AM To: 4D iNug Technical Cc: Timothy Penner Subject: RE: Connection is broken, cannot receive request reply > On our client network we do have a managed switch, but on our test network we > don’t. > The same error happens on both networks. Have you found a network where the error does NOT occur? If you have reproducible sample that causes the issue on multiple networks then then it sounds like the hard part is already done. I would suggest opening a case and submitting the sample for further assistance. -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connection is broken, cannot receive request reply
> On our client network we do have a managed switch, but on our test network we > don’t. > The same error happens on both networks. Have you found a network where the error does NOT occur? If you have reproducible sample that causes the issue on multiple networks then then it sounds like the hard part is already done. I would suggest opening a case and submitting the sample for further assistance. -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connection is broken, cannot receive request reply
Lahav, On our client network we do have a managed switch, but on our test network we don’t. The same error happens on both networks. David Ringsmuth From: lists via 4D_Tech Sent: Monday, November 13, 2017 11:48 PM To: David Ringsmuth via 4D_Tech Cc: lists Subject: RE: Connection is broken, cannot receive request reply Hi David, Do you have a managed switch on this network?, it is possible for a switch to close a connection with no traffic, which could also result in this message. The usual wisdom dictate having the timeout set to less than the switch/router timeout to prevent the port closing without the application knowing this. Cheers, Lahav -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David Ringsmuth via 4D_Tech Sent: Monday, November 13, 2017 8:46 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: David Ringsmuth Subject: Connection is broken, cannot receive request reply It seems like something is closing the network connection. I searched 4D Tech on gmane, read the docs on keeping the connection open, but after about 15 minutes of idle time, with no user activity, we get this error message (above and below). A network semaphore with a 300 ms timeout is crashing. When we remove the network semaphore, we crash on a QUERY in a different method. This exact same error occurs on our client’s network. I need help fixing this one. A serious error occurred while a request was being sent to the server. You should quit or restart the database as soon as possible. OSX 10.12.6 Sierra (both remote and server boxes) 4D Remote v15.5 built app 4D Server v15.5 built server SET DATABASE PARAMETER(13;1)// 4D Server timeout SET DATABASE PARAMETER(54;4)// Idle connections timeout Prevent App Nap (checked on both 4D Server and 4D Remote Wake on WiFi in energy settings Thanks! David Ringsmuth ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connection is broken, cannot receive request reply
Hi David, Do you have a managed switch on this network?, it is possible for a switch to close a connection with no traffic, which could also result in this message. The usual wisdom dictate having the timeout set to less than the switch/router timeout to prevent the port closing without the application knowing this. Cheers, Lahav -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David Ringsmuth via 4D_Tech Sent: Monday, November 13, 2017 8:46 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: David Ringsmuth Subject: Connection is broken, cannot receive request reply It seems like something is closing the network connection. I searched 4D Tech on gmane, read the docs on keeping the connection open, but after about 15 minutes of idle time, with no user activity, we get this error message (above and below). A network semaphore with a 300 ms timeout is crashing. When we remove the network semaphore, we crash on a QUERY in a different method. This exact same error occurs on our client’s network. I need help fixing this one. A serious error occurred while a request was being sent to the server. You should quit or restart the database as soon as possible. OSX 10.12.6 Sierra (both remote and server boxes) 4D Remote v15.5 built app 4D Server v15.5 built server SET DATABASE PARAMETER(13;1)// 4D Server timeout SET DATABASE PARAMETER(54;4)// Idle connections timeout Prevent App Nap (checked on both 4D Server and 4D Remote Wake on WiFi in energy settings Thanks! David Ringsmuth ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Connection is broken, cannot receive request reply
Keisuke, I will add keep-alive-timeout to client #13 in the morning. Thanks! David Ringsmuth From: Keisuke Miyako via 4D_Tech Sent: Monday, November 13, 2017 9:56 PM To: 4D iNug Technical Cc: Keisuke Miyako Subject: Re: Connection is broken, cannot receive request reply - do you set #54 (19814 tcp keep-alive timeout) on both client and server? - do you set #14 (19813 tcp keep-alive timeout for old network layer) for the client in addition to #13 (ditto for server)? deferred crash on query makes one think of 19814 being shut on the client side, but I can not say for sure. > 2017/11/14 12:45、David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com> のメール: > SET DATABASE PARAMETER(13;1)// 4D Server timeout > SET DATABASE PARAMETER(54;4)// Idle connections timeout ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Connection is broken, cannot receive request reply
sleep detection is a feature of 15R and the new network layer, I don't think the old network layer can close the socket and stores session context in response to system notification. once the computer goes to sleep and wakes up again, open sockets are no longer valid. http://www.4d.com/products/r-release/new-in-4d-v15-r5.html > 2017/11/14 12:45、David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com> のメール: > Wake on WiFi in energy settings ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Connection is broken, cannot receive request reply
- do you set #54 (19814 tcp keep-alive timeout) on both client and server? - do you set #14 (19813 tcp keep-alive timeout for old network layer) for the client in addition to #13 (ditto for server)? deferred crash on query makes one think of 19814 being shut on the client side, but I can not say for sure. > 2017/11/14 12:45、David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com> のメール: > SET DATABASE PARAMETER(13;1)// 4D Server timeout > SET DATABASE PARAMETER(54;4)// Idle connections timeout ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Connection is broken, cannot receive request reply
It seems like something is closing the network connection. I searched 4D Tech on gmane, read the docs on keeping the connection open, but after about 15 minutes of idle time, with no user activity, we get this error message (above and below). A network semaphore with a 300 ms timeout is crashing. When we remove the network semaphore, we crash on a QUERY in a different method. This exact same error occurs on our client’s network. I need help fixing this one. A serious error occurred while a request was being sent to the server. You should quit or restart the database as soon as possible. OSX 10.12.6 Sierra (both remote and server boxes) 4D Remote v15.5 built app 4D Server v15.5 built server SET DATABASE PARAMETER(13;1)// 4D Server timeout SET DATABASE PARAMETER(54;4)// Idle connections timeout Prevent App Nap (checked on both 4D Server and 4D Remote Wake on WiFi in energy settings Thanks! David Ringsmuth ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **