minisap NPL doesn't come up anymore. Prepared Statement 'J1' doesn't exist

[supersache]

Hello everybody,

I'm using the famous minisap NPL system. It used to work just great, but for some time now the work processes stop right after starting. The only error I can find is the following in the developer traces.

C ERROR: -1 in function StartSelect (execute) [line 29944]
C (590) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Dynamic SQL error - Prepared s
C tatement 'J1' does not exist.
C
C sql statement is ==> SELECT /* Buffer Loading */ * FROM "TRLFW_OI_PHASE" ORDER BY "TRLFW_OI_PHASE" ."
C TYPE"
C /* R3::0 T:TRLFW_OI_PHASE M: */
C
C transaction aborted by server
B ***LOG BY4=> sql error 590 performing PRE on table TRLFW_OI_PHASE [dbdbslst 5137]
B ***LOG BY0=> [ASE Error SQL590][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Dynamic SQL error - Prepared statement 'J1' does not exist.
[dbdbslst 5137]
B dumping DbDbslStatement ...
B DBSL_SS( amode=DBSL_ACC_SL stmtid_ptr=7f9baaad6718 DBSL_STMTID( typ=14 mod="TRLFW_OI_PHASE " num=0 ts=20170116182238 ) stmt=7f9baaad68b8 nlcb_ptr=0 )
B DBSL_DA( lockType=DBSL_LOCK_RC inCnt=0 inMax=0 outCnt=4 outMax=4 bulk_cb=55d1491a8130 state=0 flags=00000000000000000000100000001010 priv_ptr=118 )
B OUT[ 0]: DBSL_TYPE( type=DBSL_DATA_SHORT_CHAR(11) len=64 maxlen=64 decs=0 nullable=false flags=00000000000000000000000000000000 str_cb=0 loc_cb=0 )
B ind=0 ptr=0
B OUT[ 1]: DBSL_TYPE( type=DBSL_DATA_INTEGER_4(4) len=4 maxlen=4 decs=0 nullable=false flags=00000000000000000000000000000000 str_cb=0 loc_cb=0 )
B ind=0 ptr=40
B OUT[ 2]: DBSL_TYPE( type=DBSL_DATA_DECIMAL(0) len=11 maxlen=11 decs=7 nullable=false flags=00000000000000000000000000000000 str_cb=0 loc_cb=0 )
B ind=0 ptr=44
B OUT[ 3]: DBSL_TYPE( type=DBSL_DATA_SHORT_CHAR(11) len=24 maxlen=24 decs=0 nullable=false flags=00000000000000000000000000000000 str_cb=0 loc_cb=0 )
B ind=0 ptr=50
B - FDA Params: Level: DbDbslFdaStatusSetByDbsl(1)
M SigIGenAction: caught signal SIGSEGV (pid=20638)
M SigIRegisterRoutine: handler for signal SIGALRM installed (DpSigAlrm, flag 0)
M si_code = 1
M Sending process ID = 3120
M Real user ID of sending process = 0
M Tue Oct 29 09:54:30:435 2024
M SEGV_MAPERR: Address not mapped to object
M c30 (Memory location which caused fault)
M SigIUnblock: signal SIGSEGV was in UNBLOCKED mode
M ------------------ C-STACK ----------------------
dw.sapNPL_D00[S](LinStackBacktrace+0xa9)[0x55d1473f0290,0x777290]
dw.sapNPL_D00[S](LinStack+0x4d)[0x55d1473f3281,0x77a281]
dw.sapNPL_D00[S](CTrcStack2+0x4b)[0x55d1473ef032,0x776032]
dw.sapNPL_D00[S](SigIGenAction+0x80b)[0x55d1495dca9b,0x2963a9b]
<signal handler called> [0x7f9bc60b3310,0x13310]
dw.sapNPL_D00[S](DbDbslStatement::handleDbslRc(DBSL_RETURN, char16_t const*)+0x92c)[0x55d1480c3cd8,0x144acd8]
dw.sapNPL_D00[S](DbDbslCursorMulti::doOpen()+0x341)[0x55d1491b4681,0x253b681]
dw.sapNPL_D00[S](DbDbslCursor::open()+0x84)[0x55d1491b3d64,0x253ad64]
dw.sapNPL_D00[S](DbDbslStatement::_executeQuery(dbi::base::Allocator&, DbExternalCursorKind, unsigned int, bool, bool)+0x4cb)[0x55d1491a14cb,0x25284cb]
dw.sapNPL_D00[S](DbCursor::_getDbslCursor(DbStmtScopeObject&, DbInputValues const&, DbOutputValues&, bool, DbslLongInputValue, DbslLongInputValue, unsigned int, DB_CON_DA*, dbi::base::Allocator&, DbExternalCursorKind, unsigned int, bool, bool, bool, bool, DbLoadBufferContext*, DbDbslStmtProperties*, DbslStmtFactoryContext const&)+0x37f)[0x55d14918e86f,0x251586f]
dw.sapNPL_D00[S](DbCursor::_getDbCursor(DbStmtScopeObject&, DbInputValues const&, DbOutputValues&, bool, DbslLongInputValue const&, DbslLongInputValue const&, unsigned int, DB_CON_DA*, dbi::base::Allocator*, DbCursor&, bool, bool, bool, bool, DbDbslStmtProperties*, DbLoadBufferContext*)+0xbaa)[0x55d14919347a,0x251a47a]
dw.sapNPL_D00[S](DbCursor::getLoadBufferCursor(DbStmtScopeObject&, DbInputValues const&, DbOutputValues&, DbCursor&, DbLoadBufferContext&)+0x81)[0x55d1491a8bf1,0x252fbf1]
dw.sapNPL_D00[S](void DbCursor::db_load_into_buffer<DbKeyInputValue>(unsigned int, dbi::catalog::Entity const&, dbi::base::UCString const*, TABH*, bool, DbKeyValues<DbKeyInputValue> const&, unsigned int*, unsigned int*, DBBUF_TYPE)+0x57e)[0x55d1494e445e,0x286b45e]
dw.sapNPL_D00[S](DbFullyBufferedTable::loadTable(dbi::catalog::Entity const&) const+0xeb)[0x55d1494cab2b,0x2851b2b]
dw.sapNPL_D00[S](DbFullyBufferedTable::DbFullyBufferedTable(DbBufXtypRefCntScope&, dbi::catalog::Entity const&, unsigned int, unsigned int)+0x2d)[0x55d1494cb38d,0x285238d]
dw.sapNPL_D00[S](DbBufferedTable const* DbBufferedTable::doLoadTable<DbKeyInputValueKernel>(dbi::catalog::Entity const&, DbBufferedTable const*, DbKeyValues<DbKeyInputValueKernel> const*, unsigned int, bool*)+0x28d)[0x55d1494cb99d,0x285299d]
dw.sapNPL_D00[S](DbBufferedTable const* DbBufferedTable::getBufferedTable<DbKeyInputValueKernel>(dbi::catalog::Entity const&, bool*, DbKeyValues<DbKeyInputValueKernel> const*)+0x23b)[0x55d14918715b,0x250e15b]
dw.sapNPL_D00[S](DbRsqlCursorExternal::getDbRsqlCursorExternal(char16_t const*, dbi::base::RawIdentifier<16u> const&, DbKeyValues<DbKeyInputValueKernel>&, void*, bool, bool (&)(int, void const*), bool, bool, bool, DbRsqlCursorExternal&)+0xa7e)[0x55d14919177e,0x251877e]
dw.sapNPL_D00[S](tbi_buf_read(rtCrtabCrsr_s*)+0x2be)[0x55d149126a1e,0x24ada1e]
dw.sapNPL_D00[S](buf_rtab_read(rtCrtabCrsr_s*)+0x5a)[0x55d14948617a,0x280d17a]
dw.sapNPL_D00[S](rtab_exec(rtCrtabCrsr_s*, RT_FUNCTIONCODE, RT_OUTBUFFERSPEC*)+0x45)[0x55d149486385,0x280d385]
dw.sapNPL_D00[S](db_rtab0+0x9d)[0x55d1494870ed,0x280e0ed]
dw.sapNPL_D00[S](rlfwGetOIPhase+0x222)[0x55d14751e36a,0x8a536a]
dw.sapNPL_D00[S](rlfwOIAllowServerStartup+0x33)[0x55d14751e3ed,0x8a53ed]
dw.sapNPL_D00[S](ThExclusiveStartUp()+0x2d2)[0x55d147380494,0x707494]
dw.sapNPL_D00[S](ThInit()+0x13af)[0x55d147278ad0,0x5ffad0]
dw.sapNPL_D00[S](ThStart()+0x33f)[0x55d147279bb3,0x600bb3]
dw.sapNPL_D00[S](DpMain+0x385)[0x55d1492c8125,0x264f125]
libc.so.6[S](__libc_start_main+0xea)[0x7f9bc5d093ea,0x243ea]
M ------------------ c-stack end -----------------

 Further down there is a message

M ThIErrHandle: handle 'ThSigHandler: Signal' for invalid T-1_M255 (step THINIT, thRc ERROR-CORE-ABORTED_BY_SIGNAL, action RETURN_FOR_DUMP)

In other workprocesses I can find the notorious

MtxOpen failed (7)

 about which note 3209438 - SAP startet nicht wegen \"ThrInitServInfo: MtxOpen failed (7)\" - SAP for Me says it is a follow up error of a database problem.

I don't know if the PreparedStatement problem in the first listing is the root cause but it is the best indicator I can find.

Can anybody help me how to further debug this? I have briefly looked for errors in the ASE logs (it is an ASE 16 DB), but to no avail.

Any help is appreciated.

Cheers,

Kai

[supersache · Accepted solution]

I replaced the libsybslib.so by the latest version and that fixed the problem.