2089307 - Server crashes at s_blockmap::GetPhysicalBlocks error Failure on privileged blockmap - SAP IQ | SAP Knowledge Base Article

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

Search for additional results

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