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

SAP Knowledge Base Article - Preview

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

Symptom

  • 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 ***************

.........


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.