SAP Knowledge Base Article - Preview

3217811 - RELEASESAVEPOINT potentially holding locks on table & gets stuck. - SAP IQ

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.