Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread OnRemoteReconnect event
Mon, Jul 20 2015 9:48 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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 AMPermanent 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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
Image