on 08-02-2019 5:30 PM
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.
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.