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.