SAP Knowledge Base Article - Preview

3394150 - MPX version pile up, all MPX servers needed to restart - SAP IQ

Symptom

  • A connection on the coordinator causes versions pile up and user dbspace full and cannot be dropped.
  • All the 3 Multiplex (MPX) servers need to be shutdown to clear the versions.

Excerpt of coordinator's IQMSG

Allocation failed. Dbspace IQ_USER_MAIN is  OUT OF SPACE
Allocation failed. Dbspace IQ_USER_MAIN is  OUT OF SPACE
   -- Dbspace IQ_USER_MAIN full (due to versions pile up )

   -- then the coordinator is "kill -15"  and restarted

IQ OpenDatabase, checkpointblock: 907292204, recover: 1

  • The coordinator is shutdown several times.
  • In the meantime, the 2 secondary nodes continue loading tables.
  • Then, node 2 also hit "out of space" error.

As the coordinator is shutdown several times and this doesn't clear the old versions, 
the secondary node 2 needs to be shutdown with kill -9
the secondary node 3 can be shutdown gracefully with stop_iq


Read more...

Environment

SAP IQ 16.1 SP04

Product

SAP IQ 16.1

Keywords

828579, CR828579, CR#828579 , 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.