![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Mon, Jul 20 2015 9:48 AM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Recently I started to use this event (Session.OnRemoteReconect) with the following code:
Continue := False; StopAsking := True; I am not sure yet but some customers started to complain about "table is not active" and related errors. Doubts: When DBISAM fires this event the connection is already closed ? And what about the tables that were active ? Should I code something to quit the application ? When exactly this happen ? I am using RemotePing=30, MaxDeadSession=0 and DeadSessionRemoveInternal=10 Note: I started to use this event to try solving an error with "last session removal" from DBSRVR that I am still seeing to happen. And after this the problem disapeared. |
Mon, Jul 20 2015 5:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Eduardo,
<< I am not sure yet but some customers started to complain about "table is not active" and related errors. >> That makes sense. If you suppress the reconnect errors, then DBISAM will make it appear as everything is working fine, even though it isn't. In other words, it will suppress all connection exceptions that would normally be raised and stop something like a table open from occurring. << When DBISAM fires this event the connection is already closed ? >> Yes. << And what about the tables that were active ? >> Everything stays as-is. That's the whole point of the transparent reconnection process - it's to attempt a reconnect without the user knowing that the connection is experiencing a problem. << Should I code something to quit the application ? >> Only after a reconnect attempt fails a certain number of times (determined by you). In such a case, you can be pretty sure that there's something wrong with the connection and that you'll need to restart the application. << When exactly this happen ? I am using RemotePing=30, MaxDeadSession=0 and DeadSessionRemoveInternal=10 >> If you're asking what causes it, I can't answer that exactly. It can happen due to network issues, etc. The smallest setting for the server session timeout is 60 seconds, so that should be plenty of "wiggle room" in which the client pings can successfully occur. << Note: I started to use this event to try solving an error with "last session removal" from DBSRVR that I am still seeing to happen. And after this the problem disapeared. >> It's just a coincidence. The problem with the dead session removal needs to be examined using debug tools with the DBISAM Database Server. Did we try the debug tools already ? Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 22 2015 6:11 AM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Tim
I think I understand the whole process. The main idea is stopping the the "last session removal" error that is becoming very rare (after you changed the core of DBISAM) but unfortunatelly it still happens. << It's just a coincidence. The problem with the dead session removal needs to be examined using debug tools with the DBISAM Database Server. Did we try the debug tools already ? >> If you are saying if I can put a dbsrvr with debug tools at some customers the answer is yes. Thanks in advance José Eduardo Helminsky |
Wed, Jul 22 2015 9:06 AM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Tim
<< It's just a coincidence. The problem with the dead session removal needs to be examined using debug tools with the DBISAM Database Server. Did we try the debug tools already ? >> After I posted the answer I read the question again. And the answer is NO. We did not try the debug tools already and YES, we can do that. José Eduardo Helminsky |
Thu, Jul 23 2015 6:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Eduardo,
<< After I posted the answer I read the question again. And the answer is NO. We did not try the debug tools already and YES, we can do that. >> Actually, I went back and looked through our emails, and I *did* send you a debug version of the 4.37 DBISAM Database Server. You used it to send me .dmp files for the DBISAM Database Server when the error occurred. I'll send over a 4.41 debug server via email either today or tomorrow. Tim Young Elevate Software www.elevatesoft.com |
Thu, Aug 13 2015 4:50 PM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Tim
<< I'll send over a 4.41 debug server via email either today or tomorrow. >> Any news about it ? It (the "last" problems) starts to happen in my office and I think it will be easier to find the source of the problem. I just log every time the OnRemoteReconnect happens and althought you said this is a coincidence I think the problems are related. The OnReconnect is recorded every 30 or 45 seconds with just one user. So far so good if I replace his machine but during the day the Last problem we are dealing with happens with the IP from this user. My opinion is: The user is dropped from outside problems (NIC troubles for example) and the session become inactive and waiting for a process to remove it and therefore it is not dead yet. Then the user try to connect again and DBISAM try to use the same session. I am trying to figure out the source of the problems and sometimes I "travel" in my mind. Unfortunately I cannot reproduce the problems. The engine restruture you have made in DBISAM since 4.37 to 4.40 solved most of the problems related with this issue but not everyone (I THINK). If I install the debug version of server here in my office it could help to drive you (and me) to solve the problem. Some users are complaining because in some situations the "hang session" is inside a transaction and the dead session removal cannot remove it and the entire application fill the trouble and I have to disconnect all users, stop DBSRVR and start again. I am using 4.40 build 1 64 bits. If I have to pay some fees to you to help me, let me know about it. Thanks in advance Jose Eduardo Helminsky |
Fri, Aug 14 2015 12:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Eduardo,
<< Any news about it ? >> My apologies, I completely forgot about it. In the future, if you don't get a promised email from me, please send me an email and remind me. I normally make notes of all of things that I need to resolve, but sometimes I miss one. I'm doing the 64-bit debug build right now, so expect it soon via email. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |