cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

JDBC: 9111 / move error

Go to solution
former_member192710
Participant

on ‎04-09-2014 2:18 PM

0 Kudos

Folks;


into trying to track down a particularly strange error appearing with our main MaxDB instance, and obviously only with this one (works well with testbed and local development systems):




com.sap.dbtech.jdbc.ConnectionSapDBFinalize@1514b420[T181].prepareStatement (/* OrderDAO.getAuftragsNummern */ SELECT AUFNR FROM AUFTRAG WHERE EMPFPPID IN (SELECT PPID FROM PPARTNER WHERE WEBUSER = ?) AND MEDIUM = 'PF' AND EINGDAT IS NULL)

=> com.sap.dbtech.jdbc.CallableStatementSapDBFinalize@42f659ce[T181][ParseID 08b5cf560000080154002c00]

com.sap.dbtech.jdbc.CallableStatementSapDBFinalize@42f659ce[T181][ParseID 08b5cf560000080154002c00].setString (1, DEMO_AKI-)

com.sap.dbtech.jdbc.CallableStatementSapDBFinalize@42f659ce[T181][ParseID 08b5cf560000080154002c00].execute ()

<-!

Timestamp: 2014-04-09 15:13:17.944com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [-9111]: ��V����  T��,��getA

    at com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:300)

    at com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:146)

    at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)

    at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:1096)

    at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:720)

    at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:562)

    at com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:454)

    at com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:319)

    at com.sap.dbtech.jdbc.trace.log.PreparedStatement.execute(PreparedStatement.java:303)

    at com.sap.dbtech.jdbc.trace.PreparedStatement.execute(PreparedStatement.java:153)


As far as I can tell the query itself is not too complex or strange, and I am a bit confused by the garbled response message all along with the 9111 error code. In the server log messages, there are -9111 Move errors. Could this be related? Any way of tracking down what happens here? All servers as well as the JDBC driver are 7.8 on top of 64bit Linux.

TIA and all the best,

Kristian

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎04-10-2014 7:55 AM
0 Kudos

Hi Kristian,

could you please your KnlMsg file for additional inforamtion about the -9111 error message.
Which database version are you using?
if your version is >= 7.8 please cnvert the KnlMsg as follows:
protconv -o knlsmg.txt KnlMsg

If you cannot find the error message in KnlMsg anymore because it is already overwritten, please convert the KnlMsgArchive as follows:

protconv -o knlmsg_err.txt KnlMsgArchive

If you are using MaxDb Version < 7.8 the files which contain more information about the error are knldiag and knldiag.err

Please copy the content of the file a little bit before and after the error message into this ticket.

Please copy the version string out of KnlMsg as well.

Regards, Christiane

Show replies
Show replies
former_member192710
Participant
‎04-10-2014 8:35 AM
0 Kudos

Hi Christiane;

and first off, thanks a bunch for taking care of this. Output from KnlMsg:

Thread     0x3E94 Task    188  2014-04-09 14:47:07 ERR SYSERROR   51080:  -9111 Move error

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR SYSERROR   54111:  INCONSISTENT STRATEGY: 6

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:  ----> Symbolic stack backtrace <----

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    0: _ZN17RTEDiag_CallStack18TraceStackSymbolicEPK19RTEDiag_RegisterSet + 0x42

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000013f7dd2 (0x00000000013f7d90+0x42)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    1: _Z12gg04onevalueR16SQLMan_MessBlocksbbsR10tgg00_Lkey + 0x36c

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000000000b4b77c (0x0000000000b4b410+0x36c)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    2: _Z19gg04one_limitinvkeyR16SQLMan_MessBlockRK17APO_StrInvInRangeR10tgg00_Lkeyssb + 0x116

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000000000b4cbc6 (0x0000000000b4cab0+0x116)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    3: _Z15g04limitinvkeysR16SQLMan_MessBlockRK17APO_StrInvInRangeR10tgg00_LkeyS5_ss + 0x51

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000000000b4cdb1 (0x0000000000b4cd60+0x51)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    4: _Z17kb73sec_key_buildR16SQLMan_MessBlockRK17APO_StrInvInRangeR10tgg00_LkeyS5_ssR14tsp00_SmallSetI21tgg00_BdInvRange_EnumLi3EERb + 0x4f

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000000000901eef (0x0000000000901ea0+0x4f)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    5: _Z15k73_index_rangeR16SQLMan_MessBlockR18tgg07_select_paramR23tgg00_SelectFieldsParamRK12APO_StrategyRb + 0x32a

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000009044da (0x00000000009041b0+0x32a)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    6: _Z11k720_selectR16SQLMan_MessBlockR18tgg07_select_param + 0x7b3

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000008fa493 (0x00000000008f9ce0+0x7b3)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    7: _Z18k720_single_selectR16SQLMan_MessBlock + 0x65

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000008fa595 (0x00000000008fa530+0x65)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    8: _Z12k05functionsR16SQLMan_MessBlock + 0xcb9

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000086caf9 (0x000000000086be40+0xcb9)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:    9: _Z17a06lsend_mess_bufR14SQLMan_ContextR16SQLMan_MessBlockbRsR20SAPDBErr_MessageList + 0x5dc

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000042489c (0x00000000004242c0+0x5dc)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   10: _Z20a06dml_send_mess_bufR14SQLMan_ContextR16SQLMan_MessBlockR26SQLMan_DMLStatementContextRs + 0x5d

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000042859d (0x0000000000428540+0x5d)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   11: _Z16a505most_executeR14SQLMan_ContextR26SQLMan_DMLStatementContextR16tak_changerecordR11tak_parskeyR12tak_exec_recR14tak_corr_infosSA_P16tak_systembufferb + 0x80d

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000059da2d (0x000000000059d220+0x80d)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   12: _Z21a505loop_most_executeR14SQLMan_ContextR26SQLMan_DMLStatementContextR16tak_changerecordR12tak_exec_recR11tak_parskeyP16tak_systembufferR14tak_corr_infosSC_b + 0x341

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000059fff1 (0x000000000059fcb0+0x341)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   13: _Z24a501exec_with_change_recR14SQLMan_ContextR26SQLMan_DMLStatementContextR11tak_parskeyR16tak_changerecordb + 0x8b1

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000058ed31 (0x000000000058e480+0x8b1)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   14: _Z21a502complex_executionR14SQLMan_ContextR26SQLMan_DMLStatementContextR16tak_changerecordR11tak_parskeyb + 0x61d

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000000000590edd (0x00000000005908c0+0x61d)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   15: _Z24a501exec_with_change_recR14SQLMan_ContextR26SQLMan_DMLStatementContextR11tak_parskeyR16tak_changerecordb + 0x37b

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000058e7fb (0x000000000058e480+0x37b)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   16: _Z11a501executeR14SQLMan_ContextR10tak_parsid + 0x29c

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000058f3fc (0x000000000058f160+0x29c)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   17: _Z17a92_mode_analyzerR14SQLMan_Context23tak_ddl_descriptor_Enumb + 0x138b

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000068390b (0x0000000000682580+0x138b)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   18: _Z15ak93one_commandR14SQLMan_ContextiRibRb + 0x77b

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000000000685adb (0x0000000000685360+0x77b)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   19: _Z17a93_user_commandsR14SQLMan_ContextRbS1_ + 0x60b

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000006879fb (0x00000000006873f0+0x60b)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   20: _Z7SQLTaskR14SQLMan_ContextP22Kernel_DatabaseContextR13RTETask_ITaskRbb + 0x71

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000011821d1 (0x0000000001182160+0x71)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   21: _Z11Kernel_MainR13RTETask_ITask + 0x1fa

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x000000000118262a (0x0000000001182430+0x1fa)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   22: _ZN12RTETask_Task14KernelTaskMainEv + 0x120

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000011ff540 (0x00000000011ff420+0x120)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   23: _ZN17RTEExec_Coroutine14StartCoroutineEPS_j + 0x42c

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x00000000013ea96c (0x00000000013ea540+0x42c)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /opt/maxdb/7606/pgm/kernel

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:       -----------------------------------------

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:   24: _dl_tls_get_addr_soft@@GLIBC_PRIVATE + 0x419c0

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           SFrame: IP: 0x0000003b4de419c0 (0x0000003b4de00000+0x419c0)

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR DIAG           0:           Module: /lib64/libc-2.5.so

Thread     0x3E93 Task    108  2014-04-09 14:47:15 ERR SYSERROR   51080:  -9111 Move error

Thread     0x3E93 Task    184  2014-04-09 14:47:54     CONNECT    12633:  Connect req. (BFLOWDB, T184, connection obj. 0x801e0d170, Node:'sqldb.planconnect.net', PID: 19841)

Thread     0x3E95 Task    143  2014-04-09 14:47:54     CONNECT    12633:  Connect req. (BFLOWDB, T143, connection obj. 0x801b9c1f0, Node:'sqldb.planconnect.net', PID: 19841)

Thread     0x3E95 Task    143  2014-04-09 14:47:54     CONNECT    12651:  Connection released (BFLOWDB, T143, connection obj. 801b9c1f0)

Thread     0x3E93 Task    184  2014-04-09 14:47:54     CONNECT    12651:  Connection released (BFLOWDB, T184, connection obj. 801e0d170)

Thread     0x3E95 Task    139  2014-04-09 14:49:01     CONNECT    12651:  Connection released (BFLOWDB, T139, connection obj. 8019ce778)

I snipped a bit more than that but, overally, there's not much more than these messages in our KnlMsg it seems. Version:

2014-03-14 11:33:27     RunTime       15:   KernelVersion=KERNEL    7.8.02   BUILD 028-121-245-008
2014-03-14 11:33:27     RunTime       15:   KERNELVERSION=KERNEL    7.8.02   BUILD 028-121-245-008

Does that make any sense to you?

Thanks in advance and all the best,

Kristian

Former Member
‎04-10-2014 8:47 AM
0 Kudos

Hi Kristian,

this is a known error which is not solved so far.

please check the parameer setting for kernel parameter -> UseStrategyCache

I assume it is set to value YES in this system.

You can set this parameter to NO to avoid such errors.


PTS: 1191337

Regards, Christiane

former_member192710
Participant
‎05-21-2014 8:29 PM
0 Kudos

Hi Christiane;

sorry for being late - somehow notification on your reply didn't work. Anyway, obviously you were right. After setting UseStrategyCache to NO and restarting the database, this issue is gone.

Thanks a  load and all the best,

Kristian

Answers (0)

Ask a Question