SAP Knowledge Base Article - Preview

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

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.