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