IBM Support

IT31970: SQL0901N ERROR WITH REASON "UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP:151

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You may see the following error in db2diag.log.
    
    2019-01-08-09.43.13.469383+540 I3905E3265           LEVEL: Error
    PID     : 75484                TID : 17698574496096 PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001           DB   : BLUDB
    APPHDL  : 0-58383              APPID: *N0.db2inst1.190108003109
    UOWID   : 2                    ACTID: 1
    AUTHID  :    ADMIN             HOSTNAME: host
    EDUID   : 2171                 EDUNAME: db2agntcol (BLUDB) 1
    FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:151
    DATA #1 : String, 279 bytes
    AssertionFailedException: An assertion
    'mSizeOfEncodedFKeyInBytes ==
    mJoinHashTableInfo->getSizeOfEncodedKeyInBytes() || 0 ==
    mJoinHashTableInfo->getSizeOfEncodedKeyInBytes()' failed.
    Additional info: encoded key size mismatch   272 56
    Thrown at GetJoinPayloadEvaluator.cpp : 151
    DATA #2 : Function name in Library, 23 bytes
    GetJoinPayloadEvaluator
    DATA #3 : File name, 27 bytes
    GetJoinPayloadEvaluator.cpp
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x0000100003638A38 pdLog + 0x648
      [1] 0x00001000048BF084
    _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
    mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
    + 0x974
      [2] 0x0000100004815690
    _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
    nentIDEPKc + 0x220
      [3] 0x000010000480989C
    _ZN7ibm_cde8services24AssertionFailedException17constructAndThro
    wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xFC
      [4] 0x000010000AA84080
    _ZN7ibm_cde5query23GetJoinPayloadEvaluatorC1EPNS0_5QueueENS0_9Ev
    aluator9InputInfoES5_jPKNS0_10SyntaxTreeEP13SQLO_MEM_POOLPNS0_1
    + 0x1D90
      [5] 0x000010000692C5B0
    _ZN7ibm_cde5query17EvaluationRoutine29formEvaluationRoutineInter
    nalEPKNS0_10SyntaxTreeERKNS0_14QueryResourcesERNS_4data22TableA
    + 0x255C0
      [6] 0x0000100006904D20
    _ZN7ibm_cde5query17EvaluationRoutine21formEvaluationRoutineEsRNS
    _4data22TableAccessorAllocatorERKNS0_19QueryResultInfoListERNS0
    + 0xB50
      [7] 0x00001000078DA9C0
    _ZN7ibm_cde5query9Scheduler19genSingleTableQueryEPNS0_10SyntaxTr
    eeEPNS0_18NLJoinControlBlockE + 0x270
      [8] 0x00001000078D4C00
    _ZN7ibm_cde5query9Scheduler19runSingleTableQueryEv + 0x670
      [9] 0x00001000078D4434
    _ZN7ibm_cde5query9Scheduler17runCompositeQueryEv + 0x464
      [10] 0x00001000078D7494
    _ZN7ibm_cde5query9Scheduler15runMasterThreadEPvPi + 0x144
      [11] 0x00001000078E7D2C
    _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0xBC
      [12] 0x0000100008BF1D6C
    _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0xEC
      [13] 0x000010000F598F14 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x64
      [14] 0x000010000F3BAB10
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x400
      [15] 0x000010000EBC58A4 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x1B4
      [16] 0x000010000EBC21C4
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xF54
      [17] 0x000010000B2A4780
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xAF34780
      [18] 0x000010000B29EF18 _Z21sqleProcessSubRequestP8sqeAgent +
    0x22C8
      [19] 0x000010000B31FE28 _ZN8sqeAgent6RunEDUEv + 0x9D8
      [20] 0x000010001082686C _ZN9sqzEDUObj9EDUDriverEv + 0x25C
      [21] 0x00001000108265EC _Z10sqlzRunEDUPcj + 0x1C
      [22] 0x000010000E26CA08 sqloEDUEntry + 0x9C8
      [23] 0x0000100000088AF4 /lib64/libpthread.so.0 + 0x8AF4
      [24] 0x0000100016CC8814 clone + 0xE4
    
    2019-01-08-09.43.13.485044+540 I7171E3037           LEVEL:
    Severe (Origin)
    PID     : 75484                TID : 17698574496096 PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001           DB   : BLUDB
    APPHDL  : 0-58383              APPID: *N0.db2inst1.190108003109
    UOWID   : 2                    ACTID: 1
    AUTHID  :    ADMIN             HOSTNAME: host
    EDUID   : 2171                 EDUNAME: db2agntcol (BLUDB) 1
    FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:151
    MESSAGE : SQL0901N  The SQL statement or command failed because
    of a database
              system error. (Reason "".)
    DATA #1 : <preformatted>
    'mSizeOfEncodedFKeyInBytes ==
    mJoinHashTableInfo->getSizeOfEncodedKeyInBytes() || 0 ==
    mJoinHashTableInfo->getSizeOfEncodedKeyInBytes()' failed. Info:
    encoded key size mismatch   272 56
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x000010000363D5BC pdLogVPrintf + 0x5CC
      [1] 0x000010000363D91C pdLogPrintf + 0x3C
      [2] 0x0000100004808AB0
    _ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x4C0
      [3] 0x00001000048098A8
    _ZN7ibm_cde8services24AssertionFailedException17constructAndThro
    wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x108
      [4] 0x000010000AA84080
    _ZN7ibm_cde5query23GetJoinPayloadEvaluatorC1EPNS0_5QueueENS0_9Ev
    aluator9InputInfoES5_jPKNS0_10SyntaxTreeEP13SQLO_MEM_POOLPNS0_1
    + 0x1D90
      [5] 0x000010000692C5B0
    _ZN7ibm_cde5query17EvaluationRoutine29formEvaluationRoutineInter
    nalEPKNS0_10SyntaxTreeERKNS0_14QueryResourcesERNS_4data22TableA
    + 0x255C0
      [6] 0x0000100006904D20
    _ZN7ibm_cde5query17EvaluationRoutine21formEvaluationRoutineEsRNS
    _4data22TableAccessorAllocatorERKNS0_19QueryResultInfoListERNS0
    + 0xB50
      [7] 0x00001000078DA9C0
    _ZN7ibm_cde5query9Scheduler19genSingleTableQueryEPNS0_10SyntaxTr
    eeEPNS0_18NLJoinControlBlockE + 0x270
      [8] 0x00001000078D4C00
    _ZN7ibm_cde5query9Scheduler19runSingleTableQueryEv + 0x670
      [9] 0x00001000078D4434
    _ZN7ibm_cde5query9Scheduler17runCompositeQueryEv + 0x464
      [10] 0x00001000078D7494
    _ZN7ibm_cde5query9Scheduler15runMasterThreadEPvPi + 0x144
      [11] 0x00001000078E7D2C
    _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0xBC
      [12] 0x0000100008BF1D6C
    _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0xEC
      [13] 0x000010000F598F14 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x64
      [14] 0x000010000F3BAB10
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x400
      [15] 0x000010000EBC58A4 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x1B4
      [16] 0x000010000EBC21C4
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xF54
      [17] 0x000010000B2A4780
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xAF34780
      [18] 0x000010000B29EF18 _Z21sqleProcessSubRequestP8sqeAgent +
    0x22C8
      [19] 0x000010000B31FE28 _ZN8sqeAgent6RunEDUEv + 0x9D8
      [20] 0x000010001082686C _ZN9sqzEDUObj9EDUDriverEv + 0x25C
      [21] 0x00001000108265EC _Z10sqlzRunEDUPcj + 0x1C
      [22] 0x000010000E26CA08 sqloEDUEntry + 0x9C8
      [23] 0x0000100000088AF4 /lib64/libpthread.so.0 + 0x8AF4
      [24] 0x0000100016CC8814 clone + 0xE4
    

Local fix

  • explicitly cast the output of the TO_CHAR function.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who use TO_CHAR function                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to Db2 v11.1 m4fp6 or later.                  *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in Db2 v11.1 m4fp6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31970

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-25

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

    IT31941

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

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022