SAP Knowledge Base Article - Preview

2586633 - When enable RLV, backup database hang - SAP IQ 16.1

Symptom

  • Upgraded to SAP IQ 16.1 SP 02.
  • When the backup starts, IQ stops responding and there no messages in the logs related to backups. 
  • pstack output show the thread with these functions:


    Thread 2285 (Thread 0x7effe2af1700 (LWP 182076)):
    #0  0x00007eff8f53675e in rv_RidSeqChunk::NewChunkAtOffset(unsigned long long, unsigned long long, int) const () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #1  0x00007eff8f52ad43 in rv_RidSeq::SplitNode(rv_RidSeqNode*, unsigned long long, unsigned long long, int) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #2  0x00007eff8f52d74c in rv_RidSeq::Insert(unsigned long long, unsigned long long, rv_RidSeqNode*, rv_RidSeqNode**) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #3  0x00007eff8f5041b0 in rv_LogStream::CalcFullFlushedRVBlocks(rv_ImBm*) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #4  0x00007eff8f520133 in rv_Mgr::CalcFullRLVBlocksToBackup(s_bm*) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #5  0x00007eff8de32f1c in s_iqstore::CalcOnlyFlushedBackupBM(s_bm*) const () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #6  0x00007eff8de373f4 in s_iqstore::CalcFullBackupBM(s_bm*) const () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #7  0x00007eff8e37d555 in db_backupMgr::CalcBackupBlocksIfNecessary(int&) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #8  0x00007eff8e25ac3d in st_database::CheckpointComplete() () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #9  0x00007eff8f639ab4 in st_txnMgr::Checkpoint(st_database*, unsigned long long*) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #10 0x00007eff8e45dea7 in db_Checkpoint::Execute() () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #11 0x00007eff8e21f8a0 in st_command::DoCmdThroughResourceGate() () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #12 0x00007eff8e2773a8 in st_iqtxn::Checkpoint(UIDatabase*, unsigned long long*, unsigned long long) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #13 0x00007eff8cf8de90 in UIQTxn_Checkpoint () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #14 0x00007eff8e27c736 in st_SAIQInterfaceInfo::callFunction() () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #15 0x00007eff8e2e7a84 in st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #16 0x00007eff8e27d20d in st_SAIQInterface::Execute(int, void*, unsigned int (*)(void*, void*), void*, unsigned int) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #17 0x00007eff8d754dc2 in saint_iqthresholdtxn::Checkpoint(IDatabase*, unsigned long long*, unsigned long long) () from  /iq/IQ-16_1/bin64/../lib64/libiq16.so
    #18 0x00007f01c0f4f587 in CheckpointBegin(Database*, unsigned int, unsigned int, unsigned int) () from  /iq/IQ/lib64/libiqserv16_r.so
    #19 0x00007f01c0f4fc9b in DB_PreBackupCheckpointBegin(Database*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #20 0x00007f01c099abb2 in BackupStart(Connection*, unsigned int, unsigned int*, unsigned int, a_backup_preserve_flag, void*, backupCommand*, a_disk_page*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #21 0x00007f01c094a440 in ArchiveBackup(backupCommand*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #22 0x00007f01c094cfd4 in dbi_backup_database(Connection*, a_statement*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #23 0x00007f01c09a4aec in DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int, unsigned int) () from  /iq/IQ/lib64/libiqserv16_r.so
    #24 0x00007f01c09a5acd in db__execute_any_imm(Connection*, an_sqlpres_receive*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #25 0x00007f01c09c5430 in do_request(Worker*, an_sqlpres_receive*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #26 0x00007f01c09c328e in RequestProcedure::call() () from  /iq/IQ/lib64/libiqserv16_r.so
    #27 0x00007f01c074e025 in Worker::spawn(Procedure*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #28 0x00007f01c09c1309 in EngStream::handle_ind(unsigned char, unsigned int) () from  /iq/IQ/lib64/libiqserv16_r.so
    #29 0x00007f01c09c4a3f in EngStream::execute() () from  /iq/IQ/lib64/libiqserv16_r.so
    #30 0x00007f01c09c4e3d in RQConnItem::do_request() () from  /iq/IQ/lib64/libiqserv16_r.so
    #31 0x00007f01c09bca8d in RQBaseItem::do_work(Worker*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #32 0x00007f01c0a18f87 in RequestQueue::worker_body() () from  /iq/IQ/lib64/libiqserv16_r.so
    #33 0x00007f01c09bd7da in request_task(void*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #34 0x00007f01c0f413fd in run_task_body () from  /iq/IQ/lib64/libiqserv16_r.so
    #35 0x00007f01c0a19fe6 in UnixTask::pre_body(void*) () from  /iq/IQ/lib64/libiqserv16_r.so
    #36 0x00007f01bffd3e25 in start_thread () from /lib64/libpthread.so.0
    #37 0x00007f01bf4f334d in clone () from /lib64/libc.so.6


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

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.