I seem to have a lot of old sessions on my EDB server version 2.28 build 4.
Is it normal to have over 150 old sessions. I see all the sessions only have a option to remove them not disconnect.
If I try to highlight a session and click remove nothing happens the session stays.

In all my programs I close the session when finish using the database.

I do have KeepConnections set to True in the TEDBSession, is that why I see all old sessions?

This server also have the EWB  Server and it have several modules.
Do I have to close the session in each module after it finish responding to a request?

Thanks for any help.
Kim

Kim,

<< I seem to have a lot of old sessions on my EDB server version 2.28 build 4.  Is it normal to have over 150 old sessions. I see all the sessions only have a option to remove them not disconnect.  If I try to highlight a session and click remove nothing happens the session stays. >>

No, that's not normal.  Please check the logged events for the EDB Server and make sure that there aren't any weird errors in there:

SELECT * FROM Configuration.LogEvents WHERE Category='Error'

If you *do* see some weird errors in there, please export the result set in the EDB Manager (bottom toolbar under the result set) and send me the resultant .csv file and I'll take a look.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<No, that's not normal.  Please check the logged events for the EDB Server and make sure that there aren't any weird errors in there:

SELECT * FROM Configuration.LogEvents WHERE Category='Error'

If you *do* see some weird errors in there, please export the result set in the EDB Manager (bottom toolbar under the result set) and send me the resultant .csv file and I'll take a look.>>

I had just restarted everything when I saw your messaged. I will check again Monday.

Kim

<<Tim Young [Elevate Software] wrote:

SELECT * FROM Configuration.LogEvents WHERE Category='Error'

If you *do* see some weird errors in there, please export the result set in the EDB Manager (bottom toolbar under the result set) and send me the resultant .csv file and I'll take a look.>>

No errors, I restarted it Friday and today I have 265 connect sessions.
In my modules for the EWB I do not close the session, that is the only place I can think of.

Thanks,
Kim

Kim,

<< No errors, I restarted it Friday and today I have 265 connect sessions.  In my modules for the EWB I do not close the session, that is the only place I can think of. >>

Do the session counts increase, without decreasing, when you access your EWB module(s) ?

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<Do the session counts increase, without decreasing, when you access your EWB module(s) ?>>

Yes they did. I added MySession.Close to the end of EWBModuleExecute in all my modules and it looks like I only have two Sessions now.

I have one web application where each login have a different database the databases are identical. In the ewbide.ini where all database are listed should each of those database have a different SessionName ?

Right now they are all the same.

All the EWB modules have AutoSessionName set to true;

Thanks,
Kim

Kim,

<< Yes they did. I added MySession.Close to the end of EWBModuleExecute in all my modules and it looks like I only have two Sessions now. >>

Were these EDB session instances added to the EWB web server module's design-time surface, or were they created in code ? If the former, then you shouldn't need to do anything, but if the latter, then you'll need to both make sure that the EDB session instance is closed and that it is freed.

<< I have one web application where each login have a different database the databases are identical. In the ewbide.ini where all database are listed should each of those database have a different SessionName ? >>

No, that's not how the EWB web server modules work.  If you want to discuss this further, please start a new thread on the EWB forums.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<Were these EDB session instances added to the EWB web server module's design-time surface, or were they created in code ? If the former, then you shouldn't need to do anything, but if the latter, then you'll need to both make sure that the EDB session instance is closed and that it is freed.>>

I create the modules in Delphi dropping the EDBSessions, EDBDatabase  and the EDBTable on the modules main page and then I add them to the EWB Server ewbide.ini like this:

[Module_SMSModule]
FileName=C:\MyDir\SMSModule.dll

The EDBServer have now been running for six days and I have four Sessions all with the same name AppUSER:3 when I click them there is no option to do anything. Could this be me having a bug in the modules where it exit (Crash) and therefore is not closing the Session or is this just because I have a module where I forgot to free the session?

Thanks,
Kim

Kim,

<< I create the modules in Delphi dropping the EDBSessions, EDBDatabase  and the EDBTable on the modules main page and then I add them to the EWB Server ewbide.ini like this:

[Module_SMSModule]
FileName=C:\MyDir\SMSModule.dll

The EDBServer have now been running for six days and I have four Sessions all with the same name AppUSER:3 when I click them there is no option to do anything. Could this be me having a bug in the modules where it exit (Crash) and therefore is not closing the Session or is this just because I have a module where I forgot to free the session? >>

Check the logged events for the EDB Server - I suspect that you've got a fatal error in there somewhere because your EWB Web Server module isn't thread-safe and it's causing an AV or something similar that is preventing the sessions from getting cleaned up.

If you want me to look at the module source code and tell you if you have a threading problem, just email it to me at support@elevatesoft.com

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<Check the logged events for the EDB Server - I suspect that you've got a fatal error in there somewhere because your EWB Web Server module isn't thread-safe and it's causing an AV or something similar that is preventing the sessions from getting cleaned up.

If you want me to look at the module source code and tell you if you have a threading problem, just email it to me at support@elevatesoft.com>>

Thanks, I will.
Where do I find the logged events for the EDB server, because this week I got another error saying something like "SessionManger had an error Session ID:1' , but that happen in a program I have on the same server. It checks every minutes if there was new records add to the database and then send Email and text to the manager. I have the Sessions set to automatic.

Regards,
Kim