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.