SAP Knowledge Base Article - Preview

2088457 - An IQ secondary server gets unresponsive while running heavy DMLs and doing a checkpoint.

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

SAP IQ 16.0 ; SAP Sybase IQ 15.4

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.