SAP Knowledge Base Article - Preview

3168105 - IQ Server Crashed with "Cannot destroy locked logical buffer sbuf" - SAP IQ

Symptom

  • IQ server crashed with:
  •  Warning: Cannot destroy locked logical buffer sbuf:0x7f848e003530 a:774320100 b:17 bucket:115430
      
      
     **************************************************
     ***   SAP IQ Abort:
     ***      From:  slib/s_bufman.cxx:6604
     ***      PID: 38403
     ***      Message: Destroying Locked Logical Buffer
     ***      Thread: 140210971780864  (TID: 1445)
     **************************************************
      
     140210971780864 Stacktrace requested from slib/s_bufman.cxx:6604 on thread 140210971780864 (TID 1445) start stacktrace
         **  Error from IQ connection:  SA connHandle: 1000657678  SA connID: 31  IQ connID: 0001100960  User: DBA
         **  Time of error:  2021-02-14 01:18:12
         **  IQ Version:  SAP IQ/16.1.040/14760/P/SP04.08
        **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/******/#1 SMP Mon Nov 16 15:42:15 UTC 2020 (0306e79)/x86_64
         **  Command status when error occurred:  CURSOR ACTIVE
         **  Command text:  
    Statement text unavailable
         **  Dump all thread stacks at slib/s_bufman.cxx:6604 for PID: 38403
     
    ***************** This is the STACKTRACE ***************
     
    ===== Thread Number 140210971780864 (IQ connID: 0001100960) =====
     pc: 0x7f8c14a9f5a8 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x38
     pc: 0x7f8c14a9fe01 ucstkgentrace(int, int)+0x141
     pc: 0x7f8c14aa066f DumpAllThreads(char const*, unsigned int, int)+0x2cf
     pc: 0x7f8c1480a648 hos_ABORT(char const*, unsigned int, char const*, char*, char*, sigcontext*)+0x748
     pc: 0x7f8c14c80227 s_bufpartition::Destroy_TrackLineNo(s_connectionCacheStats*, s_buf*, s_blockmap*, char const*, unsigned int)+0x647
     pc: 0x7f8c14b6a7e3 s_blockmap::Destroy(s_buf*)+0x2e3
     pc: 0x7f8c1528d686 s_garrayBulkLoadCursor::Release()+0x66
     pc: 0x7f8c1529ad9f s_garrayBulkLoadCursor::~s_garrayBulkLoadCursor()+0x1f
     pc: 0x7f8c1529ae21 s_garrayBulkLoadCursor::~s_garrayBulkLoadCursor()+0x11
     pc: 0x7f8c154287cc hs_ohcInsert::SetupInsertCursors(void const*, int, int, int)+0x7c
     pc: 0x7f8c14606c5a dfo_HGIndexInsert::FetchOpus()+0x4ca
     pc: 0x7f8c144f699d df_CombinerFetchContext::Fetch()+0x5d
     pc: 0x7f8c154ce317 hc_dfrun::FillRun(unsigned int&, int, int)+0x37
     pc: 0x7f8c15624379 hc_dmfrun::InitNextWorkUnit(unsigned int, int, unsigned int)+0x9f3
     pc: 0x7f8c1562456c hc_dmfrun::ExecWork(int&, unsigned int)+0x2c
     pc: 0x7f8c14a6dc84 workAllocator::DoWork(unsigned int)+0xc4
     pc: 0x7f8c14a9542b hos_thread::Main()+0x23d
     pc: 0x7f8c149f920a hos_lwtask::Start(hos_lwtask*)+0x5a
     pc: 0x7f8fa722651e IQWorkerStarter(void*)+0x3e
     pc: 0x7f8fa792cf8e run_task_body+0x1e
     pc: 0x7f8fa74f23e1 UnixTask::pre_body(void*)+0x71
     pc: 0x7f8fa6aa46da <unknown>
     pc: 0x7f8fa5f1027d <unknown> 
  • LOAD TABLE crash during tier HG merge on 
    s_bufpartition::DestroyLogicalBuffer
    dfo_THGMerge::FetchOpus


Read more...

Environment

SAP IQ 16.1 SP04 PL08

Product

SAP IQ 16.0

Keywords

CR819840, CR#819840, 819840, Destroying, buffer, 824182, #824182 CR824182 824242 CR824242 , 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.