IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021