IT38619: SQL0901N - UNEXPECTED ERROR AT CDE_INTERFACE.C:2561

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• An application may fail to execute a query or stored procedure,
  resulting in an error as follows:
  
  SQL0901N The SQL statement or command failed because of a
  database system
  error. (Reason "unexpected error at cde_interface.C:2561".)
  SQLSTATE=58004
  
  
  This will produce an FODC_AppErr folder in the DIAGPATH.    In
  the db2diag.log you should see an error like this as well:
  
  FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:2561
  MESSAGE : SQL0901N  The SQL statement or command failed because
  of a database
            system error. (Reason "".)
  DATA #1 : <preformatted>
  'mTableAccessorAllocator == __null' failed. Info:unexpected
  non-null mTableAccessorAllocator 0x00007ffc370c1790
  CALLSTCK: (Static functions may not be resolved correctly, as
  they are resolved to the nearest symbol)
    [0] 0x00007FFFEA3277ED pdLogPrintf + 0x8D
    [1] 0x00007FFFEAD82CE4
  _ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x7A4
    [2] 0x00007FFFEAD86283
  _ZN7ibm_cde8services24AssertionFailedException17constructAndThro
  wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x103
    [3] 0x00007FFFECEFD363
  _ZN12cdeInterface14runConstructorEP8sqlrr_cbP17sqlriCdeStatement
  + 0x6E3
    [4] 0x00007FFFF09BE1DB
  _Z19sqlriCdeOpenFastIUDP8sqlrr_cbjP17sqlriCdeStatement + 0x21B
    [5] 0x00007FFFF09BE4BC _Z18sqlriCdeFastUpdateP8sqlrr_cb +
  0x16C
    [6] 0x00007FFFF0A519D6
  _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x636
    [7] 0x00007FFFF046FA08
  _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xDF8
    [8] 0x00007FFFEDF49546
  /var/ibmdb2/nyqit476/sqllib/lib64/libdb2e.so.1 + 0x5615546
    [9] 0x00007FFFEDF47DE0 _Z21sqleProcessSubRequestP8sqeAgent +
  0x3E0
    [10] 0x00007FFFEDF7D057 _ZN8sqeAgent6RunEDUEv + 0x5D7
    [11] 0x00007FFFF18B6F5E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
    [12] 0x00007FFFEFDD4A6A sqloEDUEntry + 0x57A
    [13] 0x00007FFFF79C5EA5 /lib64/libpthread.so.0 + 0x7EA5
    [14] 0x00007FFFE73DC9FD clone + 0x6D
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.1.4.7                                          *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.1.4.7
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP