Hi Bruce,
I've receiving this error message in the WebHandler.DeleteSession method which is causing my WebServer to crash all the time. There is code in the DeleteSession embed to cleanup some In-Memory tables and update the UserLogin MS SQL table:
debug('Clean Up IMDD Files by SessionID')
start(CleanupIMDD, 25000, clip(p_web.SessionID), 'ALL') ! This just loops through each In-Memory table, finds records that are related to the SessionID, adds the record ID's to a queue, loops through the queue and deletes the In-Memory rows that match
debug('Update User Login Record for log off')
p_web.OpenFile(UserLogin)
ULG:SessionID = p_web.GSV('ULG_SessionID')
p_web.SetSqlTimeout(UserLogin,net:on)
If not access:UserLogin.tryfetch(ULG:KeySessionID)
p_web.SetSqlTimeout(UserLogin,net:off)
ULG:EndDate = today()
ULG:EndTime = clock()
ULG:EndMethod = 'Logoff'
p_web.SetSqlTimeout(UserLogin,net:on)
access:UserLogin.update()
p_web.SetSqlTimeout(UserLogin,net:off)
ELSE
p_web.SetSqlTimeout(UserLogin,net:off)
end!if
USR:SysID = p_web.GSV('UserID')
p_web.SetSqlTimeout(User,net:on)
If not access:User.tryfetch(USR:KeySysID)
p_web.SetSqlTimeout(User,net:off)
USR:SessionID = 0
USR:ComputerName = ''
USR:SessionDate = 0
USR:SessionTime = 0
p_web.SetSqlTimeout(User,net:on)
access:User.update()
p_web.SetSqlTimeout(User,net:off)
ELSE
p_web.SetSqlTimeout(User,net:off)
end!if
p_web.CloseFile(UserLogin)
In the debug I see something like this:
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = wpZUvNmXJ9fW0ZGjN2SBWfmKRvxdPH has expired.
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = XVe404gW8qMsdqxA9rm3TPHSVwNPps has expired.
[1672] [Net] [1] NetWebServer._GarbageCollector - SessionID = NEW0ZvHhFgrWejFF0rnxDwlfHKExDG has expired.
[1672] [Net] [3] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [3] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [4] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [4] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [5] _NetAll._LoggingSetup - Initialisation
[1672] [Net] [5] _NetAll._LoggingSetup - Initialisation
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
[1672] [KLWS] 10:44:20 Update User Login Record for log off
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
[1672] [KLWS] 10:44:20 Clean Up IMDD Files by SessionID
And then the crash happens. I don't see the debug that is in the 'CleanupIMDD' procedure at all.
Do you have any ideas why this is happening?
Regards,
Trent