SAP Knowledge Base Article - Preview

2089307 - Server crashes at s_blockmap::GetPhysicalBlocks error Failure on privileged blockmap - SAP IQ

Symptom

  • Crash occurs when temporary tables are addressed.
  • It is also possible that a query can crash intermittently or crash once, but then be able to run with no problem yet some other query will crash with THE SAME stacktrace.
  • An error in .iqmsg :

temp Bufman: Incorrect page header read;
buffer={btype=14,nlb=16,blk=131714,pbn=131714,npb=16,uid=2770527685,txn=971349017,sp=23,flgs=0x8408
page={btype=14,nlb=16,npb=16,ctr=131,cta=131,pbn=7449793,txn=971349017,sp=30,ver=1,pb=193,pus=59220}. s_trycatch.cxx:1951
There was an s_buf::Read() error during s_bufman::Find().
Failure on privileged blockmap ; _blockmap @ 0x7ffd7414c518
Blockmap Member Variables for 0x7ffd7414c518
From db_table.cxx:2747

  • Stacktrace may contain the following functions:

Throw
s_blockmap::ThrowError
s_blockmap::GetPhysicalBlocks
db_TableDef::VisitBlockmaps
db_Catalog::GetPhysicalBlocksForTemporaryTable
db_Catalog::DropTable
db_droptable::Execute

  • When server was started with -iqstart 5 switch, .iqmsg displays following records:

I. 11/02 03:02:18. 0000000000  TEMP|16385|       1|6553592|2012-12-13 13:08:22.107|/dev/XXXXX/iqtemp01
I. 11/02 03:02:18. 0000000000  TEMP|16385| 7318080|6553592|2013-04-18 15:25:25.000|/dev/XXXXX/iqtemp02


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

"s_blockmap::GetPhysicalBlocks", temp table, temp dbspace,  temp Bufman, temporary, "s_buf::Read()", "s_bufman::Find()", blockmap, s_trycatch.cxx, db_table.cxx, "Incorrect page header read" , 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.