Symptom
After using restore table feature on target server, further insert causes informational stack trace if there is LF index.
Sample informational stack trace looks like this
-----------------
I. 02/10 14:12:52. 0000000120 insert into "foo" values( 5 )
I. 02/10 14:12:52. 0000000120
I. 02/10 14:12:52. 0000000120 ********************************************************
I. 02/10 14:12:52. 0000000120 **
I. 02/10 14:12:52. 0000000120 ** Non-Fatal IQ Internal Error Detected
I. 02/10 14:12:52. 0000000120 ** at slib/s_trycatch.cxx:3200 on thread 139766110316288 (TID 17)
I. 02/10 14:12:52. 0000000120 **
I. 02/10 14:12:52. 0000000120 ** Please report this to SAP IQ support
I. 02/10 14:12:52. 0000000120 ** with the following diagnostic information,
I. 02/10 14:12:52. 0000000120 ** and, if possible, with the user's command.
I. 02/10 14:12:52. 0000000120 **
I. 02/10 14:12:52. 0000000120 ** Error from IQ connection: SA connHandle: 1 SA connID: 27 IQ connID: 0000000120 User: dba
I. 02/10 14:12:52. 0000000120 ** Time of error: 2022-02-10 14:12:52
I. 02/10 14:12:52. 0000000120 ** IQ Version: SAP IQ/16.1.050/10820/P/SP05.01
I. 02/10 14:12:52. 0000000120 ** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/../3.10.0-1160.45.1.el7.x86_64/#1 SMP Fri Sep 24 10:17:16 UTC 2021/x86_64
I. 02/10 14:12:52. 0000000120 ** Command status when error occurred: CURSOR ACTIVE
I. 02/10 14:12:52. 0000000120 ** Command text:
insert into "foo" values( 5 )
===== Thread Number 139766110316288 (IQ connID: 0000000120) =====
I. 02/10 14:12:52. 0000000120 pc: 0x400e81 <unknown>
I. 02/10 14:12:52. 0000000120 pc: 0x7f1d54698a04 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
I. 02/10 14:12:52. 0000000120 pc: 0x7f1d546991a1 ucstkgentrace(int, int)+191
I. 02/10 14:12:52. 0000000120 pc: 0x7f1d5469a248 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+2f8
I. 02/10 14:12:52. 0000000120 pc: 0x7f1d5484368a s_buf::DumpOnBufmanError(s_bufman_error, char const*, int, short, unsigned long long, unsigned int, unsigned int, unsigned long long, unsigned int, int, s_diskblockheader const*)+18da
I. 02/10 14:12:52. 0000000120 pc: 0x7f1d5524dc69 s_buf::ReadBufAndVerify(s_bufman_errorInfo*, s_diskblockheader*, unsigned long long, unsigned int, unsigned int, int, short, unsigned long long, unsigned int, int, s_bufmanCallerStats*)+865
I. 02/10 14:12:52. 0000000120 pc: 0x7f1d548465c8 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
...
I. 02/10 14:12:52. 0000000120 [QMap] s_buf::ReadBufAndVerify(0x7f1da4009f80): Quarantine buffer due to IPHR
I. 02/10 14:12:52. 0000000120 There was an s_buf::Read() error during s_bufman::Find().
I. 02/10 14:12:52. 0000000120 The following exception is from GetBlockmapEntryInfo
I. 02/10 14:12:52. 0000000120 Blockmap Member Variables for 0x7f1d70197ee8
I. 02/10 14:12:52. 0000000120 From slib/s_lcidx.cxx:185
I. 02/10 14:12:52. 0000000120 _nextPartitionForHelperFlush = 0
I. 02/10 14:12:52. 0000000120 IsEBufNoWait = 0
I. 02/10 14:12:52. 0000000120 IsProxyFreelist = 0
I. 02/10 14:12:52. 0000000120 _OrigRootBlock = 1047941
I. 02/10 14:12:52. 0000000120 _Bio = 0x7f1dbc14a328
I. 02/10 14:12:52. 0000000120 _tempSpace = 0
I. 02/10 14:12:52. 0000000120 _Bufman = 0x7f1dbc04f2b8 main Bufman
I. 02/10 14:12:52. 0000000120 _ownerObjectName = dba.foo.foo_LF
I. 02/10 14:12:52. 0000000120 I. 02/10 14:12:52. Exception Thrown from slib/s_blockmap.cxx:7431, Err# 0, tid 17 origtid 17
I. 02/10 14:12:52. 0000000120 O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
I. 02/10 14:12:52. 0000000120 [20060]: 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 +
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.