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
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.
SAP Knowledge Base Article - Preview