1. Christian Breu
  2. as Valentina DB Server
  3. Wednesday, June 12 2019, 11:06 AM
  4.  Subscribe via email
Need to talk about the client idle timeout of VServer.
How can the value of this property got read from the server?
Is there a way to recognize when the connection to the server got killed?
What actually is the status of the V-Objects like VConnection after that?
Where to find some information about that topic?
Comment
There are no comments made yet.
Christian Breu Accepted Answer
Thank you for reply Ivan.

Point 1 might be my fault, I will see later.
Point 2 I did restart the server – more than once. Maybe it is related to point 1.
Point 3 It feels very slow and the VServer does not respond at all, cannot handle anything else. This could be a problem. Btw. it also takes time to open only 40'000 records in the editor.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Ivan Smahin Accepted Answer
It really feels buggy guys – while opening a table containing 4.1 mio records wiht VStudio I cannot even login from my application to the VServer!?
I have to wait until VStudio is showing the editor. Should it be like that?


Is it "table's data editor"? Yes, sounds bad (obviously vStudio tries to get all that millions records at once), but
1. It's better to start dedicated threads for questions not related to the current topic;
2. I guess, you need some record range to see/edit in vStudio. It would be better to use SQL Panel, and narrowing down your selection with SQL query.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
Ivan Smahin Accepted Answer
Another thing is, that I cannot set the client idle time to any other value. Even I set the timeout to 2 (I also get 2 as a result when I ask VServer as you explained above), I always face problems after 20 mins!?


It seems you have change it but forget to restart vServer. Most of the vServer properties changes requires restart vServer to be applied.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 3
Ivan Smahin Accepted Answer
I can see the info in the log file: "Client has been suddenly disconnected" – but the reaction of my application is not the same as when I kill the connection by VStudio or close the connection from inside my application! When I check the state of the VConnection in the XOJO debugger, the connection is still true!?


VConnection was "suddenly" disconnected. It means that vServer see closed TCP socket, but active VConnection companion. In turn, it means that vClient either finished/crashed without properly closing connection or simply no network connection anymore (probably it is your case). Anyway, vClient may still think that it is connected (suddenly means vClient do nothing for closing connection and therefore still think that it is connected)..
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 4
Christian Breu Accepted Answer
It really feels buggy guys – while opening a table containing 4.1 mio records wiht VStudio I cannot even login from my application to the VServer!?
I have to wait until VStudio is showing the editor. Should it be like that?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 5
Christian Breu Accepted Answer
Thank you Ivan.

I face some strange things again here...
I can see the info in the log file: "Client has been suddenly disconnected" – but the reaction of my application is not the same as when I kill the connection by VStudio or close the connection from inside my application! When I check the state of the VConnection in the XOJO debugger, the connection is still true!?

Another thing is, that I cannot set the client idle time to any other value. Even I set the timeout to 2 (I also get 2 as a result when I ask VServer as you explained above), I always face problems after 20 mins!?

can you reproduce this or do you have any idea about a possible cause for this problem?

It is a VServer 9.2 on Mac OS 10.10.5
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 6
Ivan Smahin Accepted Answer
How can the value of this property got read from the server?

GET property MAXIDLECLIENTTIMEOUT of SERVER

Is there a way to recognize when the connection to the server got killed?

For the "idle timeout reached" reason?
You should get an "ERR_CONNECTION_TIMED_OUT" error code.

What actually is the status of the V-Objects like VConnection after that?

Invalid. Most of attempts to use them will lead to different errors, most likely you will get something like "Client is not connected".
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories