SAP Knowledge Base Article - Preview

3149565 - After table restore, cannot create secondary index - SAP IQ

Symptom

After restoring table feature on target server, insert to that table causes informational stack trace if there is LF index.

Sample informational stack trace looks like this
-----------------

  insert into "foo" values( 5 )
 
 
**       Non-Fatal IQ Internal Error Detected
**       at slib/s_trycatch.cxx:3200 on thread 139766110316288 (TID 17)

**  Command status when error occurred:  CURSOR ACTIVE
**  Command text:
insert into "foo" values( 5 )
===== Thread Number 1xxxx (IQ connID: xxx) =====
s_buf::DumpOnBufmanError
s_buf::ReadBufAndVerify
s_buf::Read(s_bufman_errorInfo*, unsigned long long, unsigned int, int, short, unsigned long long, unsigned int, unsigned int, s_blockmap const*, s_bufmanCallerStats*)+308
...

[QMap] s_buf::ReadBufAndVerify(0x7f1da4009f80): Quarantine buffer due to IPHR
There was an s_buf::Read() error during s_bufman::Find().
The following exception is from GetBlockmapEntryInfo
Blockmap Member Variables for 0x7f1d70197ee8
From slib/s_lcidx.cxx:185
_nextPartitionForHelperFlush = 0
 IsEBufNoWait = 0
 IsProxyFreelist = 0
_OrigRootBlock = 1047941
...
main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb.




Read more...

Environment

SAP IQ 16.1 SP05 +

Product

SAP IQ all versions

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Known Error

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.