Skip to Content
0
Aug 02, 2019 at 04:30 PM

Cannot cancel an XSJOB HANA

115 Views

Dear Experts:

On Our HANA database I'm having the next issue on the indexserver_alert:

The open cursor possibly blocks the garbage collection of HANA database. Please close a cursor in application or kill the connection by "ALTER SYSTEM DISCONNECT SESSION '304142' "
[75471]{-1}[-1/-1] 2019-08-02 10:46:49.177158 e Statement mvcc_anti_ager.cc(01640) : MVCC Info HOST = p43sapdbbw:30003, NUM_VERSIONS = 310155, MIN_SNAPSHOT_TS = 1605559551, GLOBAL_TS = 1606088855, MIN_READ_TID = 534107856, NEXT_WRITE_TID = 537511603
[75471]{-1}[-1/-1] 2019-08-02 10:46:49.177191 e Statement mvcc_anti_ager.cc(01640) : MVCC Info HOST = p43sapdbbw:30007, NUM_VERSIONS = 0, MIN_SNAPSHOT_TS = 1605559551, GLOBAL_TS = 1606088855, MIN_READ_TID = 534107841, NEXT_WRITE_TID = 537510858
[75471]{-1}[-1/-1] 2019-08-02 10:46:49.177701 e Statement mvcc_anti_ager.cc(01007) : The Connection(304142) is disconnected forcefully because it is blocking garbage collection for too long period.

I Tryed to cancel with the next sql commands but the session is still active:

ALTER SYSTEM DISCONNECT SESSION '304142'
ALTER SYSTEM CANCEL SESSION '304142'

You can see that in the next image:

Also I cannot find this session:

How can I cancel this session ??

Please your help.