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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.