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

Search for additional results

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