DB2 - Problem description
Problem IT03320 | Status: Closed |
DB2 LOOP IN SQLEML_UTL_TCP_READ_LINE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
System experienced a loop in sqleml_utl_tcp_read_line when called by a trigger using UTL_SMTP. The following Stack Trace was collected at the time of the problem: <StackTrace> ##### Object: /lib/sparcv9/libc.so.1 _so_recv(0xfffffffe9f880998,0xfffffffe007d6a40,0xfffffffe9f8809b 8,0xfffffffe9f888970,0xfffffffe007daa38,0xfffffffe007d6a38) + 0xc ##### Object: /opt/IBM/db2/V9.7/bin/routine/db2modlib sqleml_utl_tcp_read_line(0xfffffffe9f880998,0xfffffffe007d6a40,0 xfffffffe9f8809b8,0xfffffffe9f888970,0xfffffffe007daa38,0xffffff fe007d6a38) + 0x31c ##### Object: /opt/IBM/db2/V9.7/lib64/libdb2e.so.1 sqloInvokeFnArgs(0xffffffff13c25610,0xfffffffe9f8801a4,0xfffffff e9f888a08,0x0,0x0,0xffffffff6968e6e7) + 0x118 __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff6968e3c0,0xfffffffe007dcfa4,0x9,0xfffffffeb24245 a8,0xfffffffe9e21b940,0xfffffffeb24245a8)+ 0x92c __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff6968e3c0,0 x108305c,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x1728,0x 0,0x0,0xffffffff7c91dfa0) + 0x524 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff6968ec18,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff695f3880,0xfffffffe9e21b940,0xf60,0xd) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff eb1c10090,0xfffffffeb1c12cd0,0x1,0xfffffffeb1c12cd0,0x0,0xffffff ff695f3880) + 0x454 __1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007dea3 0,0xfffffffebc300638,0x2000,0xfffffffe007dea40,0x0,0x0) + 0x64c __1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007de730,0xffffffff7c91dfa0 ,0xfffffffffffffe51,0x0,0x1) + 0xe74 pvm_entry(0x4,0x4000,0xfffffffe007de730,0x0,0xfffffffebc300638,0 xffffffff7b5286a8) + 0x488 sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007e05d0,0x2,0 x4,0xffffffff7b8aa6e6) + 0x5c __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff694e5830,0xfffffffe007e10a4,0xfffffffda5580080,0 xfffffffeb1c1b7e0,0xfffffffe9e21b940,0xfffffffeb1c1b7e0) + 0xf74 __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff694e5830,0 x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 8000000,0x0,0xffffffff7c91dfa0) + 0x524 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff694e5f48,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff695f3520,0xfffffffe9e21b940,0xf60,0xd) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff eb2350090,0xfffffffeb2352cd0,0x1,0xfffffffeb2352cd0,0x0,0xffffff ff695f3520) + 0x454 __1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007e2b3 0,0xfffffffeb049f078,0x2000,0xfffffffe007e2b40,0x0,0x0) + 0x64c __1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007e2830,0xffffffff7c91dfa0 ,0xfffffffffffffe51,0x0,0x1) + 0xe74 pvm_entry(0x4,0x4000,0xfffffffe007e2830,0x0,0xfffffffeb049f078,0 xffffffff7b5286a8) + 0x488 sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007e46d0,0x4,0 x4,0xffffffff7b8aa6e6) + 0x5c __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff694fe7a0,0xfffffffe007e51a4,0xffffffff345fce20,0 xfffffffeb235b7e0,0xfffffffe9e21b940,0xfffffffeb235b7e0) + 0xf74 __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff694fe7a0,0 x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 8000000,0x0,0xffffffff7c91dfa0) + 0x524 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff694fefc0,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff695f2b00,0xfffffffe9e21b940,0xf60,0xd) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff eb1ec0090,0xfffffffeb1ec2cd0,0x1,0xfffffffeb1ec2cd0,0x0,0xffffff ff695f2b00) + 0x454 __1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007e6c3 0,0xfffffffeb04edc38,0x2000,0xfffffffe007e6c40,0x0,0x0) + 0x64c __1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007e6930,0xffffffff7c91dfa0 ,0xfffffffffffffe51,0x0,0x1) + 0xe74 pvm_entry(0x4,0x4000,0xfffffffe007e6930,0x0,0xfffffffeb04edc38,0 xffffffff7b5286a8) + 0x488 sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007e87d0,0x4,0 x4,0xffffffff7b8aa6e6) + 0x5c __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff6825a9b0,0xfffffffe007e92a4,0xffffffff344e33a0,0 xfffffffeb1ecb7e0,0xfffffffe9e21b940,0xfffffffeb1ecb7e0) + 0xf74 __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff6825a9b0,0 x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 8000000,0x0,0xffffffff7c91dfa0) + 0x524 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff6825b018,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff695f2220,0xfffffffe9e21b940,0xf60,0xd) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff eb2040090,0xfffffffeb2042cd0,0x1,0xfffffffeb2042cd0,0x0,0xffffff ff695f2220) + 0x454 __1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007ead3 0,0xfffffffe9fca8ff8,0x2000,0xfffffffe007ead40,0x0,0x0) + 0x64c __1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007eaa30,0xffffffff7c91dfa0 ,0xfffffffffffffe51,0x0,0x1) + 0xe74 pvm_entry(0x4,0x4000,0xfffffffe007eaa30,0x0,0xfffffffe9fca8ff8,0 xffffffff7b5286a8) + 0x488 sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007ec8d0,0x4,0 x4,0xffffffff7b8aa6e6) + 0x5c __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff62922ac8,0xfffffffe007ed3a4,0xffffffff342c0a40,0 xfffffffeb204b7e0,0xfffffffe9e21b940,0xfffffffeb204b7e0) + 0xf74 __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff62922ac8,0 x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 8000000,0x0,0xffffffff7c91dfa0) + 0x524 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff62923188,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff6818eba0,0xfffffffe9e21b940,0xf60,0xd) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff e9ee0baa0,0xfffffffe9ee0e6e0,0x1,0xfffffffe9ee0e6e0,0x0,0xffffff ff6818eba0) + 0x454 __1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007eee3 0,0xfffffffeb04eae18,0x2000,0xfffffffe007eee40,0x0,0x0) + 0x64c __1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007eeb30,0xffffffff7c91dfa0 ,0xfffffffffffffe51,0x0,0x1) + 0xe74 pvm_entry(0x4,0x0,0xfffffffe007eeb30,0x0,0xfffffffeb04eae18,0xff ffffff7b5286a8) + 0x488 sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007f09d0,0x4,0 x4,0xffffffff7b8aa6e6) + 0x5c __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff69670730,0xfffffffe007f14a4,0xffffffff341c6f80,0 xfffffffe9ee171f0,0xfffffffe9e21b940,0xfffffffe9ee171f0) + 0xf74 __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff69670730,0 x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 8000000,0x0,0xffffffff7c91dfa0) + 0x524 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff69670f50,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff6818b760,0xfffffffe9e21b940,0xf60,0xd) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff e9ee001d8,0xfffffffe9ee02e18,0x1,0xfffffffe9ee02e18,0x0,0xffffff ff6818b760) + 0x454 __1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007f2f3 0,0xfffffffe9fc60638,0x2000,0xfffffffe007f2f40,0x0,0x0) + 0x64c __1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007f2c30,0xffffffff7c91dfa0 ,0xfffffffffffffe51,0x0,0x1) + 0xe74 pvm_entry(0x4,0x1400,0xfffffffe007f2c30,0x0,0xfffffffe9fc60638,0 xffffffff7b5286a8) + 0x488 sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007f4ad0,0x4,0 x0,0xc6400) + 0x5c __1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf _b_i_(0xffffffff6854aa40,0xfffffffe007f55a4,0xfffffffda5b35348,0 xfffffffe9ee0b928,0xfffffffe9e21b940,0xfffffffe9ee0b928) + 0xf74 __1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff6854aa40,0 x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 __1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x0,0x800 0000,0x0,0xffffffff7c91dfa0) + 0x524 __1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff fffe9e21b940,0xffffffff6854b260,0x2,0xfffffffe9e21d0d8,0x0,0xfff ffffe9e21d0c8) + 0x2c __1cIsqlricse6FpnIsqlrr_cb__i_(0x1778,0xfffffffe9e21b940,0xfffff fff6854a990,0xffffffff6854a9c0,0x1788,0x9c00) + 0x1f4 __1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff fffe9e21b940,0xffffffff6854a940,0xfffffffda5b357d8,0xfffffffe9e2 1d0d8,0xffffffff6854b4e0,0xfffffffe9e21d0c8) + 0x2c __1cIsqlrival6FpnIsqlrr_cb__i_(0x1778,0xfffffffe9e21b940,0x1788, 0xffffffff68547e20,0x9c00,0xffffffff7e7d4ad0) + 0x1d4 __1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff fffe9e21b940,0xffffffff6854a918,0x1778,0xfffffffe9e21d0d8,0xffff ffff6854b5f8,0xfffffffe9e21d0c8) + 0x2c __1cIsqlriftr6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0xffffffff6854 a7d0,0x1788,0xc6300,0xffffffff6854a778,0x1400) + 0x1a4 __1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff fffe9e21b940,0xffffffff6854a778,0xfffffffe9e21d0c8,0xfffffffe9e2 1d0d8,0xffffffff6854bad8,0xfffffffe9e21d0c8) + 0x2c __1cIsqlrievl6FpnIsqlrr_cb__i_(0x3f4910,0xfffffffe9e21b940,0x0,0 x1400,0xffffffff6854b878,0xffffffff6854a320) + 0xfdc __1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff fffe9e21b940,0xffffffff6854b840,0x3,0xfffffffe9e21d0d8,0xfffffff f6854bc18,0xfffffffe9e21d0c8) + 0x2c __1cIsqlricse6FpnIsqlrr_cb__i_(0x1778,0xfffffffe9e21b940,0xfffff fff68548a40,0xffffffff68548a70,0x1788,0x9c00) + 0x1f4 __1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff fffe9e21b940,0xffffffff685489f0,0x1778,0xfffffffe9e21d0d8,0xffff ffff6854bd10,0xfffffffe9e21d0c8) + 0x2c __1cIsqlriftr6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0xffffffff6854 89f0,0x1788,0xc6300,0xffffffff685489c0,0x1400) + 0x1a4 __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff ffff685489c0,0xfffffffe9e21b940,0x1788,0x1798,0x1400) + 0x6cc __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 81823e4,0x1400,0xffffffff6818a9a0,0xfffffffe9e21b940,0xe7c,0x4) + 0x2ec4 __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff e9f65af20,0x0,0x0,0x0,0x0,0xffffffff6818a9a0) + 0x454 __1cTsqljs_ddm_excsqlstt6FpnOdb2UCinterface_pnNsqljDDMObject__i_ (0xfffffffe9f65af20,0xfffffffeb2c207c8,0xffffffff7d57fce8,0x0,0x 1,0xfffffffeb2c20080) + 0x884 __1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pn Odb2UCinterface__i_(0xfffffffeb2c20080,0xfffffffe007f7598,0xffff fffe9f65af20,0x200b,0x2000,0x0) + 0x280 __1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_pnIsqeAgent_ b_i_(0xfffffffeb2c20e08,0xfffffffe9f65af20,0x2028561a0,0xfffffff eb2c20e08,0x202859e68,0xfffffffeb2c20080)+ 0x71c __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_ b_i_(0xfffffffe9f65af20,0x2028561a0,0xffffffff7d4f00c8,0xfffffff e007fff30,0xfffffffeb2c20080,0x0) + 0x81c __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_ b_i_(0x2028561a0,0xfffffffe9fc576a0,0x1400,0xfffffffe9f65af20,0x 0,0xfffffffeb2c20080) + 0x1d2c __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x20120f580, 0xfffffffe007fff30,0x1,0x8300000000000000,0xfffffffe9fc576a0,0xf fffffff7c91dfa0) + 0xe20 __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x20120f580, 0xffffffffffffffff,0x5800,0xfffffffe9fc57220,0xfffffffe9fc57220, 0xfffffffe007fff30) + 0x1c0 __1cIsqeAgentGRunEDU6M_v_(0x2028561a0,0x1400,0xffffffff7b59285f, 0x18280400,0xffffffff7c91dfa0,0xffffffff7e3bb6d8) + 0x860 __1cKsqlzRunEDU6FpcI_v_(0xfffffffe007fdd20,0xffffffff781439b8,0x 1bef9ec,0x18d00000,0x0,0xffffffff7c91dfa0) + 0xd4 sqloEDUEntry(0xffffffff5affaf90,0xfffffffe007fff30,0x8,0xfffffff f7e3bb750,0x18780000,0x0) + 0x3d4##### Object: /lib/sparcv9/libc.so.1 _thr_slot_offset(0x0,0x0,0x0,0x0,0x0,0x0) + 0x488 </StackTrace> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW 10.1 Fix Pack 5 * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 LUW 10.1 Fix Pack 5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.07.2014 13.07.2015 13.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |