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.