IBM Support

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

Fixes are available

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

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback