Hi All.



I'm running II 9.0.4 (a64.lnx/105)NPTL +p12707



Everynow and then the system stalls with a session being held in state:



cs_state: CS_EVENT_WAIT (LKEVENT(100000,0,22bea))



The session cannot be removed from the server. In IPM it shows in lock
state EWAIT and ESET.



The only way out has been to bounce the installation.



Does anyone know what the three numbers in the LKEVENT mean?



I suspect that the problem may be associated with a blob support table
slowly approaching the max page limit ... but I'm not sure of that.
There has been nothing of any use in the error log.



Martin Bowes

Hi Marty

Where does

cs_state: CS_EVENT_WAIT (LKEVENT(100000,0,22bea))

come from? Was it IPM, iimonitor, lockstat . . . ?

If you tell me where it's from I can give you the code references and
meanings.

Alex


--
hanal04

Hi Alex,

iimonitor

Marty

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Ingres Forums
Sent: 24 June 2009 09:45
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Interpreting LKEVENT()


Hi Marty

Where does

cs_state: CS_EVENT_WAIT (LKEVENT(100000,0,22bea))

come from? Was it IPM, iimonitor, lockstat . . . ?

If you tell me where it's from I can give you the code references and
meanings.

Alex


--
hanal04
------------------------------------------------------------------------
hanal04's Profile:
http://community.ingres.com/forum/member.php?userid=443
View this thread:
http://community.ingres.com/forum/sh...ad.php?t=10850

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres