Symptom
An IQ secondary server gets unresponsive while running heavy DMLs and doing a checkpoint operation in a multiplex environment.
[IQ message log]
I. 10/30 08:17:35. 0000025428 ev_begintxn started
I. 10/30 08:17:35. 0000025428 Cmt 1299623828
I. 10/30 08:17:35. 0000025428 PostCmt 1275115957
I. 10/30 08:17:35. 0000025428 Txn 1299623829 0 1275115957
I. 10/30 08:17:35. 0000025428 Cmt 1299623830
I. 10/30 08:17:35. 0000025428 PostCmt 0
I. 10/30 08:17:35. 0000025428 TxnWt 1299623831 0 1275115957
I. 10/30 08:17:35. 0000025428 Cmt 1299623832
I. 10/30 08:17:35. 0000025428 PostCmt 0
I. 10/30 08:17:35. 0000025428 Txn 1299623833 0 1275115957
I. 10/30 08:17:35. 0000025428 Cmt 1299623834
I. 10/30 08:17:35. 0000025428 PostCmt 0
I. 10/30 08:17:35. 0000025428 TxnWt 1299623835 0 1275115957
I. 10/30 08:17:35. 0000025428 Chk
I. 10/30 08:17:42. 0000000000 Allocation failed. Dbspace iq_main is NOT ACCESSIBLE OVER INC
I. 10/30 08:34:24. 0000000000 Cancellation request received: SA connHandle: 1720 SA connID: 73 IQ connID: 0000025352 User: user001
I. 10/30 08:34:24. 0000000000 Cancellation request received: SA connHandle: 1717 SA connID: 46 IQ connID: 0000025332 User: user001
Read more...
Environment
SAP SYBASE IQ 15.4, IQ 16.0
Product
Keywords
CR 770406, InquireFreelist, IsGlobalOutOfSpace, IQ server hang, unresponsive, checkpoint , 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.
SAP Knowledge Base Article - Preview