IBM Support

PH06245: QUERIES ON HADOOP TABLES FAIL WITH SQL0083C A MEMORY ALLOCATION ERROR HAS OCCURRED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Queries that include a CASE statement with an IN predicate, and
    the column used in the IN predicate is also used in a local
    predicate (ie WHERE clause) may fail with a memory allocation
    error during precompilation.  For example:
    CREATE TABLE BIGSQL.TAB1(
        C01 VARCHAR(10) ,
        C02 VARCHAR(10) ,
        C03 VARCHAR(10)
    );
    SELECT
    CASE WHEN (C02 IN ('xxx','yyy') AND SUBSTRING(C03,1,1)!='0') OR
    (C02 IN ('zzz','qqq')) THEN 'www' ELSE C03 END AS C03
    FROM BIGSQL.TAB1 WHERE C02 = 'xxx';
    If the value in the WHERE clause is changed from 'xxx' to
    another value that is not in the first IN clause, then the query
    runs successfully.
    The following message is seen in the db2diag log:
    2018-11-30-18.05.40.543828-480 I577942E5196          LEVEL:
    Warning
    PID     : 8754                 TID : 140082119960320 PROC :
    db2sysc 0
    INSTANCE: bigsql               NODE : 000            DB   :
    BIGSQL
    APPHDL  : 0-187                APPID: *N0.bigsql.xxxxxxxxxxxx
    AUTHID  : BIGSQL               HOSTNAME: xxxxxxx.fyre.ibm.com
    EDUID   : 99                   EDUNAME: db2agent (BIGSQL) 0
    FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx,
    probe:1000
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid size"
              DIA8563C An invalid memory size was requested.
    DATA #1 : String, 43 bytes
    Memory management block allocation failure.
    DATA #2 : Codepath, 8 bytes
    2
    DATA #3 : Memory pool handle pointer,
    PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
    0x00007f6726570030
    DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    0
    DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8
    bytes
    0
    DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS,
    4 bytes
    0x00000000
    DATA #7 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 11 bytes
    sqlng_opr.C
    DATA #8 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
    25072
    DATA #9 : Resource binding pointer,
    PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
    0x0000000000000000
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00007F67888BEEB1 sqloGetMemoryBlockExtended + 0x3E1
      [1] 0x00007F6787693A04
    _Z23sqlngBuildInSetBinaryOpP9sqlng_blkPP12sqlri_opparmP9sqlnq_pi
    db + 0x174
      [2] 0x00007F678768D629
    _Z16sqlngBuildInListP9sqlng_blkPP12sqlri_opparmP9sqlnq_pid +
    0x99
      [3] 0x00007F67876B27C9
    _Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x659
      [4] 0x00007F67876B1C7B
    _Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x16B
      [5] 0x00007F67876B37C4
    _Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x1654
      [6] 0x00007F67876B1C7B
    _Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x16B
      [7] 0x00007F67876B14AB _Z19sqlng_walk_BF_chainP9sqlng_blk +
    0x92B
      [8] 0x00007F678762C0AB
    _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x125B
      [9] 0x00007F678767F2E2
    _Z19sqlng_build_CASE_opP9sqlng_blkP9sqlnq_pid + 0x442
      [10] 0x00007F67876B27F9
    _Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x689
      [11] 0x00007F67876B1C7B
    _Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x16B
      [12] 0x00007F67877B5047
    _ZN28sqlngScalarExpressionBuilder15buildExpressionEP9sqlnq_hxp +
    0x1A7
      [13] 0x00007F67877B46BA
    _ZN22sqlngExpressionBuilder15buildExpressionEP9sqlnq_exp + 0x3A
      [14] 0x00007F67876B5B09 _Z21sqlng_walk_EXPR_chainP9sqlng_blk +
    0x2B9
      [15] 0x00007F678762B377
    _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x527
      [16] 0x00007F678769B54D
    _Z21sqlng_process_mate_opP9sqlng_blkP19sqlno_plan_operator +
    0x59D
      [17] 0x00007F678763DFFD
    _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD
      [18] 0x00007F678769AAF1
    _Z21sqlng_process_pipe_opP9sqlng_blkP19sqlno_plan_operator +
    0x381
      [19] 0x00007F678763DFFD
    _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD
      [20] 0x00007F678762B2B2
    _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x462
      [21] 0x00007F678772B444
    _Z22sqlng_process_smptq_opP9sqlng_blkP19sqlno_plan_operator +
    0x424
      [22] 0x00007F678772CCE8
    _Z19sqlng_process_tq_opP9sqlng_blkP19sqlno_plan_operator + 0x8D8
      [23] 0x00007F678763DFFD
    _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD
      [24] 0x00007F678779FEC0
    _Z23sqlng_process_return_opP9sqlng_blkP19sqlno_plan_operator +
    0xAF0
      [25] 0x00007F678763DFFD
    _Z19sqlngProcessLolepopP9sqlng_blkP19sqlno_plan_operator + 0xBD
      [26] 0x00007F678762B5DF
    _Z18sqlng_build_threadP9sqlng_blkP14sqlng_thd_ctrl + 0x78F
      [27] 0x00007F6787641558 _Z10sqlng_mainP9sqlnq_qur + 0x32F8
      [28] 0x00007F67877D9159
    _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
    lrr_cmpl_enviiPP9sqlnq_qur + 0x5B09
      [29] 0x00007F67877D3641
    _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
    lrr_cmpl_env + 0x21
      [30] 0x00007F67891E16C4
    _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP
    _LOCK_INFOP16sqlra_cached_varPiS5_Pb + 0x10F4
      [31] 0x00007F67891FDECE
    _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj
    jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOC
    + 0x96E
      [32] 0x00007F678929F2D1 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ +
    0xF11
      [33] 0x00007F6788F2E922
    _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x452
      [34] 0x00007F6787104807
    _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x407
      [35] 0x00007F67870F459B
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0xEB
      [36] 0x00007F67870F5666
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x546
      [37] 0x00007F67870E84CA /home/bigsql/sqllib/lib64/libdb2e.so.1
    + 0x563A4CA
      [38] 0x00007F67870EEA93 /home/bigsql/sqllib/lib64/libdb2e.so.1
    + 0x5640A93
      [39] 0x00007F67870EF74F
    _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x11F
      [40] 0x00007F6786B2C814 _ZN8sqeAgent6RunEDUEv + 0xDE4
      [41] 0x00007F678A33CD66 _ZN9sqzEDUObj9EDUDriverEv + 0x116
      [42] 0x00007F678890BB18 sqloEDUEntry + 0x578
      [43] 0x00007F67901D9DD5 /lib64/libpthread.so.0 + 0x7DD5
      [44] 0x00007F6780574EAD clone + 0x6D
    

Local fix

Problem summary

  • Please see problem description.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH06245

  • Reported component name

    IBM BIG SQL

  • Reported component ID

    5737E7400

  • Reported release

    503

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-12-06

  • Closed date

    2020-09-09

  • Last modified date

    2020-09-09

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

    IT21240

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

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"503"}]

Document Information

Modified date:
10 September 2020