- 论坛徽章:
- 0
|
一个DB2的问题,发现其中一个线程不动了,卡带着其他的线程不让他们拿到锁。\r\n用pdump抓线程信息,得到:\r\npvthread+0C7A00 3194 db2sysc STOP C7A0F9 03C 2049 0 \r\n \r\n(0)> th 3194 \r\n SLOT NAME STATE TID PRI RQ CPUID CL WCHAN \r\n \r\npvthread+0C7A00 3194 db2sysc STOP C7A0F9 03C 2049 0 \r\n \r\nNAME................ db2sysc \r\n.................tid :0000000000C7A0F9 ......tsleep :FFFFFFFFFFFFFFFF \r\n...............flags :00000000 ..............flags2 :00000000 \r\n...........pmcontext :00000000 \r\nDATA.........pvprocp :F100070F00036400 <pvproc+036400> \r\nLINKS.....prevthread :F100070F100C9300 <pvthread+0C9300> \r\n..........nextthread :F100070F1004E000 <pvthread+04E000> \r\nDISPATCH.......synch :FFFFFFFFFFFFFFFF \r\nSCHEDULER...affinity :00000008 .................pri :0000003C \r\n.............boosted :00000000 ...............wchan :0000000000000000 \r\n...............state :00000005 ...............wtype :00000000 \r\nMISC ..tv_eyec :7076746850524F43 (pvthPROC) \r\nCHECKPOINT......vtid :00000000 .............chkfile :0000000000000000 \r\nLOCK........ lock_d @ F100070F100C7A30 0000000000000000 \r\nPROCFS......procfsvn :0000000000000000 \r\nNUMA............rset :0000000000000000 \r\nPROFILING.....prbase :0000000000000000 ....prpinned :0000000000000000 \r\n.....prflags :00000000 ..........prbufcount :00000000 \r\nWLM........class/wlm :00/0000 \r\n.............wlm_tag : \r\nTHREAD.......threadp :F1000101019F0000 ........size :00000100 \r\n \r\nFLAGS............... SIGAVAIL PROCFS CDEFER SIGSLIH SIGINTR \r\n.................tid :0000000000C7A0F9 ......stackp :07000007AE7F6310 \r\n.................scp :0000000000000000 .......ulock :0000000000000000 \r\n...............uchan :0000000000000000 ....userdata :000000011D117800 \r\n..................cv :0000000000000000 .......flags :0000000000400084 \r\n..............atomic :0000000000000000 ......flags2 :0000000000000000 \r\nDATA...........procp :F1000100BC81B400 <F1000100BC81B400> \r\n...........pvthreadp :F100070F100C7A00 <pvthread+0C7A00> \r\n...............userp :F00000002FF47E80 <__ublock+000880> \r\n............uthreadp :F0000000318BF780 <F0000000318BF780> \r\nSLEEP/LOCK......usid :00000007FFFFFFFF ......wchan1 :0000000000000000 \r\n..............wchan2 :0000000000000000 ......swchan :0000000000000000 \r\n...........eventlist :0000000000000000 ......result :00000001 \r\n.............polevel :00000001 ..............pevent :0000000000000000 \r\n..............wevent :0000000000000000 .......slist :0000000000000000 \r\n...........wchan1sid :00000007FFFFFFFF wchan1offset :00000000 \r\n...........lockcount :00000000 ..........adsp_flags :0000 \r\nDISPATCH.......ticks :00000002 ...............prior :F1000101019F0000 \r\n................next :F1000101019F0000 ......dispct :000000000024FD8C \r\n...............fpuct :00000000000B1AA5 \r\n............pri_band :00 \r\n........allowed_cpus : FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF \r\n \r\n.......prefunnel_cpu :00000000 \r\n......threadcontrolp :0000000000000000 \r\nMISC........graphics :0000000000000000 .ulock_listp :0000000000000000 \r\n...........lockowner :0000000000000000 ..kthreadseg :0000001841785400 \r\n..........time_start :00001ADB9D6A0935 .......credp :0000000000000000 \r\n....spurr_time_start :00001ADB9CA420B9 \r\n..........wlm_charge :0 ..........wlm_evtcnt :00000000 \r\n..........t_ipc_data :0000000000000000 \r\n..............t_eyec :7468726450524F43 (thrdPROC) \r\nSIGNAL........sigproc:00000000 ..............cursig :00000000 \r\n......(pending) sig :[3] 0000000000000000 \r\n......................[2] 0000000000000000 \r\n......................[1] 0000000000000000 \r\n......................[0] 0000000020000000 \r\n...................... USR1 \r\n............sigmask :[3] 0000000000000000 \r\n......................[2] 0000000000000000 \r\n......................[1] 0000000000000000 \r\n......................[0] 0000000000080000 \r\n...................... CHLD \r\nSCHEDULER......cpuid :FFFFFFFF ..............scpuid :FFFFFFFF \r\n.........affinity_ts :00000000 ..............policy :00000000 \r\n.................cpu :00000000 .............lockpri :0000003E \r\n.............wakepri :000000FF \r\n.............ceiling :000000FF ................time :000000FF \r\n.............sav_pri :0000003C ..............t_nice :0000003C \r\n...........run_queue :F10001001029BA80 ......cpu_tb :000F1936 \r\n............ldispcpu :0009 .........homecpu :0000 ........homenode \r\n:0000 \r\n......... rs_attinfo :0000000000000000 \r\n.............suspend :00000000 .............fsflags :00000000 \r\n..........norun_secs :00000000 \r\nCHECKPOINT..chkerror :0000 ............chkblock :00000000 \r\nTIMERS...clock ticks :000129DA \r\nPROCFS.......whystop :00000001 ............whatstop :000000F1 \r\nPVTHREAD...pvthreadp :F100070F100C7A00 ........size :00000100 \r\n(0)> \r\n(0)> \r\n(0)> \r\n(0)> \r\n(0)> f 3194 \r\npvthread+0C7A00 STACK: \r\n[900000000341A74]pread64+000034 (0000000000004000, FFFFFFFFFFFFFFFF, \r\n FFFFFFFFFFFFFFFF, FFFFFFFFFFFFFFFF [??]) \r\n[900000008385920]sqloReadBlocks+0000FC (0000002400000300, \r\n0000000018100014, \r\n 00000000001021DE, 0000000000000001, 0000000E0000000E, \r\n0700000207030000, \r\n 0000000000000001) \r\n[90000000836B65C].sqlbReadBlocks__FP16SqlbOpenFileInfoPvlUlUiPUlP12SQLB \r\nGLOBALS_fdprpro_clone_2877+000050 (??, ??, ??, ??, ??, ??, ??) \r\n[90000000836B3EC].sqlbReadPage_fdprpro_clone_2833+0002F8 \r\n(090000000836B498, 00C1963E00C1963E, \r\n 0000000000000001, 0000000200000002, 000000000000000C) \r\n[90000000836B95C]090000000836B95C (??, ??) \r\n[900000008354EAC]sqlbfix__FP11SQLB_FIX_CB+0000A8 (??) \r\n[9000000082A4768]09000000082A4768 (??) \r\n[9000000082D29BC]09000000082D29BC (??, ??) \r\n[900000008499C84]sqli_proc_leaf__FP7SQLI_CBi+00030C (??, ??) \r\n[9000000084992B0]sqlischf__FP7SQLI_CBUsUi+0002AC (000000011B141520, \r\n0001000000000004, \r\n 007E094E007756E9) \r\n[900000008470E5C]sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB+000054 \r\n(??, ??) \r\n[900000008470914]0900000008470914 (??, ??, ??, ??, ??, ??, ??, ??) \r\n[9000000082DB5BC]sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID+000134 (??, ??) \r\n[9000000082DBAD0]09000000082DBAD0 (0000000000000000, 077000023791B480, \r\n 0000000000000002, 0000000000000007, 000000004AE2E600, \r\nFFFFFFFFFFFFFFFF, \r\n 0000000000000008, 077000024AE2ED00) \r\n[900000008298D8C]0900000008298D8C (??, ??, ??) \r\n[900000008284FB0]0900000008284FB0 (??) \r\n[900000008280F78]sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm+000014 (??, \r\n??) \r\n[90000000803E38C]sqlrr_process_fetch_request__FP14db2UCinterface+000188 \r\n(??) \r\n[90000000803E06C]sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo+000428 \r\n(??, ??) \r\n[900000007BB55E0]sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject+00 \r\n1510 (??, ??) \r\n[90000000810EFFC]sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjec \r\ntP14db2UCinterface+000004 (??, ??, ??) \r\n[90000000810EC7C]sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface+000F94 \r\n(??, ??) \r\n[900000007F8279C]sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb+000228 (??, \r\n??, ??) \r\n[900000007F81ADC]sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle+0000B0 \r\n(??, ??) \r\n[900000007F81944]sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb+0000E0 \r\n(??, ??) \r\n[900000007F81708]sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T+00013C (??) \r\n[900000007E44180]RunEDU__8sqeAgentFv+0000D0 (??) \r\n[900000007E46B28]EDUDriver__9sqzEDUObjFv+000084 (??) \r\n[900000007E46A64]sqlzRunEDU__FPcUi+00000C (??, ??) \r\n[900000007E50AEC]sqloEDUEntry+000220 (??) \r\n[9000000009AF4EC]_pthread_body+0000DC (??) \r\n \r\n\r\n其中的stack看起来完全没有问题,正在调用pread64读取数据,但是不知道为什么状态就是STOP....\r\n请达人出马帮忙给点思路,谢谢 |
|