2545252 - How to restart IQ after an abort on RLV using info from IQMSG - SAP IQ

• IQ could hit a non-fatal stack trace on Row Level Versioning (RLV), followed by a fatal abort.
• IQ could be unable to restart.
  
  
  

Excerpt of IQMSG

I. 10/06 10:40:26. 0000000003 140734303831808 Creating forward scan of log stream 3, table 1708
I. 10/06 10:40:26. 0000000003 140734303831808 RLV LogScanner Prefetch Enabled
...........

I. 10/06 10:55:47. 0000000003
I. 10/06 10:55:47. 0000000003 ********************************************************
I. 10/06 10:55:47. 0000000003 **
I. 10/06 10:55:47. 0000000003 ** Non-Fatal IQ Internal Error Detected
I. 10/06 10:55:47. 0000000003 ** at /remote/rip/iqbuild/views/links/r16.1.0_sp02_nbld_gcc4_linux_64/gitsrc/cm/iqa/include/s_dpidx.h:188 on thread 140734303831808 (TID 673)
I. 10/06 10:55:47. 0000000003 **
I. 10/06 10:55:47. 0000000003 ** Please report this to SAP IQ support
I. 10/06 10:55:47. 0000000003 ** with the following diagnostic information,
I. 10/06 10:55:47. 0000000003 ** and, if possible, with the user's command.

***************** This is the STACKTRACE ***************

/* You can see RLV function such as the follwing: */

rv_LogrecInsert::Deserialize
rv_LogRecoverySession::RedoInsert
rv_LogRecoverySession
rv_LogRecoveryIter::ExecWork
..........

I. 10/06 10:55:49. 0000000003 ******************* End of STACKTRACE ******************
I. 10/06 10:55:49. 0000000003 **
I. 10/06 10:55:49. 0000000003 ** End of stack trace from Non-Fatal IQ Internal Error /remote/rip/iqbuild/views/links/r16.1.0_sp02_nbld_gcc4_linux_64/gitsrc/cm/iqa/include/s_dpidx.h:188
I. 10/06 10:55:49. 0000000003 **
I. 10/06 10:55:49. 0000000003 ********************************************************
..........

I. 10/06 10:55:49. 0000000003 140734303831808 Error: RLV Recovery encountered a throw before recovery commit!
I. 10/06 10:55:49. 0000000003
I. 10/06 10:55:49. 0000000003
I. 10/06 10:55:49. 0000000003 **************************************************
I. 10/06 10:55:49. 0000000003 *** SAP IQ Abort:
I. 10/06 10:55:49. 0000000003 *** From: /remote/rip/iqbuild/views/links/r16.1.0_sp02_nbld_gcc4_linux_64/gitsrc/cm/iqa/include/rv_LogRecoveryMgr.h:107
I. 10/06 10:55:49. 0000000003 *** Rethrown from: oslib/hos_throw.cxx:313
I. 10/06 10:55:49. 0000000003 *** PID: 10146
I. 10/06 10:55:49. 0000000003 *** Exception Location: 0x0x7fff422fef30
I. 10/06 10:55:49. 0000000003 *** Error ID: 533, Exception Type: hos_assertexception
I. 10/06 10:55:49. 0000000003 *** Thread: 140734303831808 (TID: 673, Original TID: 673)
I. 10/06 10:55:49. 0000000003 *** Error #: 3, O/S Error #: 0
I. 10/06 10:55:49. 0000000003 *** Argument:
-- (/remote/rip/iqbuild/views/links/r16.1.0_sp02_nbld_gcc4_linux_64/gitsrc/cm/iqa/include/rv_LogRecoveryMgr.h 107)
I. 10/06 10:55:49. 0000000003 **************************************************

***************** This is the STACKTRACE ***************

.........

• SAP IQ 16.0
• SAP IQ 16.1

-iqrvrec_bypass ; crash ; disable RLV ; , KBA , BC-SYB-IQ , Sybase IQ , How To