IBM Support

PI84241: FORCE APPLICATION IN BIGSQL HANG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Force application on a query running insert in BigSQL hangs.
    
    The stack for the DB2 Agent shows:
    
    0x00007FBB1F71AB1D
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0465
      0x00007FBB1F71B373 ossDumpStackTraceV98 + 0x0071
      0x00007FBB1F71702B _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x02a5
      0x00007FBB267BAE5D sqlo_trce + 0x03ed
      0x00007FBB2690E9C9 sqloDumpDiagInfoHandler + 0x0249
      0x00007FBB2CB8C370 __waitpid + 0x0020
      0x00007FBB2CB8BBDD __nanosleep + 0x002d
      0x00007FBB24E9EF0C
    _ZN11sqerCommMgr14mReceiveRecordEP18sqerRecordEndpoint + 0x0e0c
      0x00007FBB24E9CCA1
    _ZN11sqerCommMgr15beginReadRecordEP18sqerRecordEndpointRP10sqerR
    ecordh + 0x0041
      0x00007FBB24E9B31B _ZN11sqerCommMgr17purgeConversationEv +
    0x005b
      0x00007FBB24EE280E
    _ZN13sqerFmpClient16mInterruptServerEP8sqeAgent + 0x078e
      0x00007FBB24EDFD38
    _ZN13sqerFmpClient27commonPostRequestProcessingEP8sqeAgenti +
    0x0288
      0x00007FBB24EED398
    _Z27sqlerExtTableCompleteInsertP8sqeAgentP18sqerExtTableHandleP1
    7sqerExtTableSerDe + 0x00d8
      0x00007FBB24EECA85
    _Z21sqlerExtTableCloseIUDP8sqeAgentP18sqerExtTableHandleP17sqerE
    xtTableSerDe + 0x0285
      0x00007FBB27542646 _Z19sqlriHadoopIUDCloseP8sqlrr_cb + 0x00a6
      0x00007FBB274F6575
    _Z20sqlriExecCloseThreadP8sqlrr_cbP12sqlri_opparm + 0x0025
      0x00007FBB274EB48F _Z16sqlricls_complexP8sqlrr_cbilll + 0x028f
      0x00007FBB26E7FE9C _Z16sqlrr_dss_routerP8sqlrr_cb + 0x05fc
      0x00007FBB26E7C603
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0733
      0x00007FBB24B748C2 _Z20sqleSubRequestRouterP8sqeAgentPjPm +
    0x0a32
      0x00007FBB24B732F1 _Z21sqleProcessSubRequestP8sqeAgent +
    0x0401
      0x00007FBB24BA9FD1 _ZN8sqeAgent6RunEDUEv + 0x05c1
      0x00007FBB280CC4CA _ZN9sqzEDUObj9EDUDriverEv + 0x010a
      0x00007FBB2690BCD5 sqloEDUEntry + 0x05c5
      0x00007FBB2CB84DC5 _L_lock_3599 + 0x0013
      0x00007FBB1E99E73D clone + 0x006d
    
    The fmp stack shows:
    
    
    Thread 9 (Thread 0x7f2e8eafd700 (LWP 1074)):
    #0  0x00007f3e480cd6d5 in pthread_cond_wait@@GLIBC_2.3.2 ()
    from /lib64/libpthread.so.0
    #1  0x00007f3e49c002c4 in sqloAppWaitOnSync () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #2  0x00007f3e497e9df9 in
    sqlerExtTableRevokeAccessToBuffers(sqlerExternalTableRequest*,
    bool) () from /home/bigsql/sqllib/lib64/libdb2.so.1
    #3  0x00007f3e497e99e7 in sqlerExtTableCompleteRequest () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #4  0x00007f3e41b61481 in
    sqlejExtTableCompleteRequest(db2ExtTableInterface*,
    sqlo_jvm_private*, JNIEnv_*, db2ExtTableRC) () from
    /home/bigsql/sqllib/lib64/libdb2jext.so
    #5  0x00007f3e41b61d7d in sqlejExtTableInsertRows () from
    /home/bigsql/sqllib/lib64/libdb2jext.so
    #6  0x00007f3e497ecc6b in
    sqlerExtTableInsertRowsRequest(sqlerFmpExternalRequest*) ()
    from /home/bigsql/sqllib/lib64/libdb2.so.1
    #7  0x00007f3e497ea8e2 in
    sqlerExtTableNextRequestState(sqlerFmpExternalRequest*) () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #8  0x00007f3e497ef56e in sqlerExtTableHandleRequest () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #9  0x00007f3e497e1ef3 in
    sqlerFmpWorkerHandleRequest(sqlerFmpProcThread*,
    sqlerFmpExternalRequest*) () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #10 0x00007f3e497e1fff in
    sqlerDispatchFmpExternalRequest(sqlerFmpProcThread*,
    sqlerFmpExternalRequest*, sqlerFmpRqstHdr*) () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #11 0x00007f3e497e2723 in
    sqlerFmpWorkerListener(sqlerFmpProcThread*) () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #12 0x00007f3e497e2a26 in
    sqlerFmpWorkerThreadEntry(SQLCC_INITSTRUCT_T*, unsigned long,
    sqlerSharedCommMgrData*, sqlerFmpProcThread*) () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #13 0x00007f3e497cb986 in sqlerWorkerThreadEntry(void*) () from
    /home/bigsql/sqllib/lib64/libdb2.so.1
    #14 0x00007f3e480c9dc5 in start_thread () from
    /lib64/libpthread.so.0
    #15 0x00007f3e475d773d in clone () from /lib64/libc.so.6
    

Local fix

  • No workaround available.
    

Problem summary

  • See error description
    

Problem conclusion

  • The problem is fixed in Version 5.0.0.0 and later fix packs
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI84241

  • Reported component name

    INFO BIGINSIGHT

  • Reported component ID

    5725C0900

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-10

  • Closed date

    2018-03-01

  • Last modified date

    2018-03-01

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

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

Modules/Macros

  • Unknown
    

Fix information

  • Fixed component name

    INFO BIGINSIGHT

  • Fixed component ID

    5725C0900

Applicable component levels

  • R425 PSY

       UP

[{"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":"410","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 August 2020