Symptom
- RELEASESAVEPOINT potentially holding locks on table Some_Table & gets stuck.
- That causes connection/transaction which acquired locks on Some_Table getting stuck
- In turn the table cannot be dropped till IQ is rebooted.
- This is happening on a regular basis.
- Here is relevant information showing the problem and the pattern
--------------------------------------------------------------------------------
Connection information:
==========================================================================================
102718 SQL_DBC_116c880 spg_av 20XX-03-10 07:35:21.925 53 EXEC RELEASESAVEPOINT Mar 10 20XX 8:07:23.000000AM 0 NONE 0
1818806050 Mar 10 20XX 3:01:42.000000AM 0 25658918 26915 167583 TCPIP 54 X.X.X.X 1077 NULL NULL
=========================================================================================
Lock information:
==========================================================================================
SQL_DBC_116c880 102718 spg_av BASE spg_av Some_Table NULL Table Transaction Write NULL NULL
SQL_DBC_116c880 102718 spg_av BASE spg_av Some_Table NULL Schema Transaction Shared NULL NULL
==========================================================================================
Sequence of events on problem tables are:
7:35 - ReleaseSavepoint started as per sp_iqconnection.
7:45 - Connection which acquired locks on Some_Table experiences informational stack trace, but completes insert later
-----
I. 03/10 07:45:04. 0000258918 pc: 0x7ffff6504aa1 _fini+0x38a290bd
I. 03/10 07:45:04. 0000258918 pc: 0x7ffff5ac3c4d _fini+0x37fe8269
I. 03/10 08:06:29. 0000258918 [20896]: Insert for 'Some_Table' completed in 1899 seconds. 26770 rows inserted
-----
8:06 - Connection releases locks, but the process does not go away.
There is no record of commit for 0000258918
17:50 - 17:56 - DumpAllThreads triggered. It shows stuck releasesavepoint
-----
grep -i s_bufman::ReleaseSavepoint PSTACK.*
PSTACK.28140.175014.1.log:#5 0x00007ffbbbcc5c69 in s_bufman::ReleaseSavepoint(unsigned long long, s_blockmaps_hashtb::txnIdType, unsigned int, unsigned long long) () from /IQSERVER/IQHKIRISP05/sapiqserver-16.0.110.sp11.25/IQ-16_0/lib64/libiq16.so
PSTACK.28140.175217.2.log:#5 0x00007ffbbbcc5c69 in s_bufman::ReleaseSavepoint(unsigned long long, s_blockmaps_hashtb::txnIdType, unsigned int, unsigned long long) () from /IQSERVER/IQHKIRISP05/sapiqserver-16.0.110.sp11.25/IQ-16_0/lib64/libiq16.so
PSTACK.28140.175420.3.log:#5 0x00007ffbbbcc5c69 in s_bufman::ReleaseSavepoint(unsigned long long, s_blockmaps_hashtb::txnIdType, unsigned int, unsigned long long) () from /IQSERVER/IQHKIRISP05/sapiqserver-16.0.110.sp11.25/IQ-16_0/lib64/libiq16.so
PSTACK.28140.175623.4.log:#5 0x00007ffbbbcc5c69 in s_bufman::ReleaseSavepoint(unsigned long long, s_blockmaps_hashtb::txnIdType, unsigned int, unsigned long long) () from /IQSERVER/IQHKIRISP05/sapiqserver-16.0.110.sp11.25/IQ-16_0/lib64/libiq16.so
-----
Read more...
Environment
- SAP IQ 16.0 SP11 PL25
- SAP IQ 16.1
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
s_bufman::ReleaseSavepoint , drop connection , KBA , BC-SYB-IQ , Sybase IQ , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview