oracle11g - Need help in identifying the deadlock cause in oracle based on trace available -


can please me in finding cause of deadlock , how analyze below trace file -

*** 2014-02-18 14:10:55.033 global blockers dump start:--------------------------------- dump local blocker/holder: block level 3 res [0x23000f][0xb3a3d],[tx][ext 0x2,0x0] ----------resource 0x8d9ba3348---------------------- resname       : [0x23000f][0xb3a3d],[tx][ext 0x2,0x0] hash mask     : x3 local inst    : 2 dir_inst      : 2 master_inst   : 2 hv idx        : 32 hv last r.inc : 2 current inc   : 2 hv status     : 0 hv master     : 1 open options  : dd  grant_bits    : kjusernl kjuserex  grant mode    : kjusernl  kjusercr  kjusercw  kjuserpr  kjuserpw  kjuserex count         : 1         0         0         0         0         1 val_state     : kjuservs_novalue valblk        : 0x50030000000000005038161909000000 pp8 access_inst   : 2 vbreq_state   : 0 state         : x0 resp          : 0x8d9ba3348 on scan_q?    : n total accesses: 32312 imm.  accesses: 29865 granted_locks : 1  cvting_locks  : 1  value_block:  50 03 00 00 00 00 00 00 50 38 16 19 09 00 00 00 granted_q : lp 0x8c296fd08 gl kjuserex rp 0x8d9ba3348 [0x23000f][0xb3a3d],[tx][ext 0x2,0x0]   master 2 gl owner 0x8d90b6d68 possible pid 30752 xid 159000-0002-000000f4 bast 0 rseq 2336 mseq 0 history 0x14951495   open opt kjuserdeadlock   convert_q:  lp 0x8c297cb28 gl kjusernl rl kjuserpr rp 0x8d9ba3348 [0x23000f][0xb3a3d],[tx][ext 0x2,0x0]   master 2 gl owner 0x8c112b1d8 possible pid 24175 xid 3b000-0002-00000b0d bast 0 rseq 2336 mseq 0 history 0x1495149a   convert opt kjusergetvalue   ----------enqueue 0x8c296fd08------------------------ lock version     : 1513 owner inst       : 2 grant_level      : kjuserex req_level        : kjuserex bast_level       : kjusernl notify_func      : (nil) resp             : 0x8d9ba3348 procp            : 0x8c18b5b70 pid              : 30752 proc version     : 153 oprocp           : (nil) opid             : 30752 group lock owner : 0x8d90b6d68 possible pid     : 30752 xid              : 159000-0002-000000f4 dd_time          : 0.0 secs dd_count         : 0 timeout          : 0.0 secs on_timer_q?      : n on_dd_q?         : n lock_state       : granted ast_flag         : 0x0 open options     : kjuserdeadlock  convert options  : kjusergetvalue kjusernoqueue kjusernodeadlockwait  history          : 0x14951495 msg_seq          : 0x0 res_seq          : 2336 valblk           : 0x00000000000000000000000000000000 . user session deadlock lock 0x8c296fd08   sid: 1157 ser: 42431 audsid: 16262658 user: 61/elms     flags: (0x8000045) usr/- flags_idl: (0x1) bsy/-/-/-/-/-     flags2: (0x40009) -/-/inc   pid: 345 o/s info: user: oracle, term: unknown, ospid: 30752     image: oracle@danprvb404   client details:     o/s info: user: elmsmnsv206$, term: elmsmnsv206, ospid: 2036:6332     machine: ad-ent\elmsmnsv206 program: w3wp.exe     application name: w3wp.exe, hash value=2799981571   current sql:   insert tbl_tmx_actlinkrel (activityfk, linkedactfk, linktype, refcount ) values ( :b3 , :b2 , :b1 , 1 ) dump local blocker: initiate state dump deadlock   possible owner[345.30752] on resource tx-0023000f-000b3a3d  *** 2014-02-18 14:10:55.044 submitting asynchronized dump request [28]. summary=[ges process stack dump (kjdglblkrdm1)]. dump local blocker/holder: block level 3 res [0x1b0018][0xdb83e],[tx][ext 0x2,0x0] ----------resource 0x8d9b702e8---------------------- resname       : [0x1b0018][0xdb83e],[tx][ext 0x2,0x0] hash mask     : x3 local inst    : 2 dir_inst      : 2 master_inst   : 2 hv idx        : 42 hv last r.inc : 2 current inc   : 2 hv status     : 0 hv master     : 1 open options  : dd  grant_bits    : kjusernl kjuserex  grant mode    : kjusernl  kjusercr  kjusercw  kjuserpr  kjuserpw  kjuserex count         : 1         0         0         0         0         1 val_state     : kjuservs_novalue valblk        : 0x9cd3ef080000000080c361ddff7f0000 .a access_inst   : 2 vbreq_state   : 0 state         : x0 resp          : 0x8d9b702e8 on scan_q?    : n total accesses: 9540 imm.  accesses: 7177 granted_locks : 1  cvting_locks  : 1  value_block:  9c d3 ef 08 00 00 00 00 80 c3 61 dd ff 7f 00 00 granted_q : lp 0x8c294b8e8 gl kjuserex rp 0x8d9b702e8 [0x1b0018][0xdb83e],[tx][ext 0x2,0x0]   master 2 gl owner 0x8c112b1d8 possible pid 24175 xid 3b000-0002-00000b0d bast 0 rseq 2258 mseq 0 history 0x14951495   open opt kjuserdeadlock   convert_q:  lp 0x8c2983150 gl kjusernl rl kjuserpr rp 0x8d9b702e8 [0x1b0018][0xdb83e],[tx][ext 0x2,0x0]   master 2 gl owner 0x8d90b6d68 possible pid 30752 xid 159000-0002-000000f4 bast 0 rseq 2258 mseq 0 history 0x1495149a   convert opt kjusergetvalue   ----------enqueue 0x8c294b8e8------------------------ lock version     : 1673761 owner inst       : 2 grant_level      : kjuserex req_level        : kjuserex bast_level       : kjusernl notify_func      : (nil) resp             : 0x8d9b702e8 procp            : 0x8c18d02a0 pid              : 24175 proc version     : 499 oprocp           : (nil) opid             : 24175 group lock owner : 0x8c112b1d8 possible pid     : 24175 xid              : 3b000-0002-00000b0d dd_time          : 0.0 secs dd_count         : 0 timeout          : 0.0 secs on_timer_q?      : n on_dd_q?         : n lock_state       : granted ast_flag         : 0x0 open options     : kjuserdeadlock  convert options  : kjusergetvalue kjusernoqueue kjusernodeadlockwait  history          : 0x14951495 msg_seq          : 0x0 res_seq          : 2258 valblk           : 0x40c861ddff7f000080c561ddff7f0000 @aa user session deadlock lock 0x8c294b8e8   sid: 1394 ser: 14175 audsid: 16262574 user: 61/elms     flags: (0x8000045) usr/- flags_idl: (0x1) bsy/-/-/-/-/-     flags2: (0x40009) -/-/inc   pid: 59 o/s info: user: oracle, term: unknown, ospid: 24175     image: oracle@danprvb404   client details:     o/s info: user: elmsmnsv201$, term: elmsmnsv201, ospid: 4032:5404     machine: ad-ent\elmsmnsv201 program: w3wp.exe     application name: w3wp.exe, hash value=2799981571   current sql:   delete tbl_tmx_activity activity_pk = :b1  dump local blocker: initiate state dump deadlock   possible owner[59.24175] on resource tx-001b0018-000db83e  *** 2014-02-18 14:10:55.045 submitting asynchronized dump request [28]. summary=[ges process stack dump (kjdglblkrdm1)]. global blockers dump end:----------------------------------- global wait-for-graph(wfg) @ ddts[0.4879] : blocked 0x8c297cb28 3 wq 2 cvtops x1 tx 0x23000f.0xb3a3d(ext 0x2,0x0)[3b000-0002-00000b0d] inst 2  blocker 0x8c296fd08 3 wq 1 cvtops x29 tx 0x23000f.0xb3a3d(ext 0x2,0x0)[159000-0002-000000f4] inst 2  blocked 0x8c2983150 3 wq 2 cvtops x1 tx 0x1b0018.0xdb83e(ext 0x2,0x0)[159000-0002-000000f4] inst 2  blocker 0x8c294b8e8 3 wq 1 cvtops x29 tx 0x1b0018.0xdb83e(ext 0x2,0x0)[3b000-0002-00000b0d] inst 2   *** 2014-02-18 14:10:55.875 * cancel deadlock victim lockp 0x8c297cb28

i have searched this, finding information on trace file deadlock graph in it... did not find on how analyze trace file wait-for-graph.


Comments

Post a Comment

Popular posts from this blog

javascript - jquery or ashx not working -

i using ajax file upload control. it creating html: <form action="/pages/handlers/asyncfileuploadhandler.ashx" method="post" enctype="multipart/form-data" target="ajaxuploader-iframe-1397144545"> <input type="hidden" name="type" value="mindvoice"> <input type="file" id="imagefile" style="display: block; width: 80%; margin-right: auto; margin-left: auto;"> </form> and target is: <iframe width="0" height="0" style="display:none;" name="ajaxuploader-iframe-1397144545" id="ajaxuploader-iframe-1397144545"></iframe> the form submitted using .submit() . my ashx handler: <%@ webhandler language="c#" class="asyncfileuploadhandler" %> using system; using system.web; using nettpals.core; public class asyncfileuploadhandler : ihttphandler { public void processre...
Read more

opencv - DataType<cv::detail::deriv_type>::depth what is it used for -

i wondering why line used in lucas kanade tracker in opencv: datatype<cv::detail::deriv_type>::depth can explain me? in opencv, depth of mat refers type of data contained in mat 's data buffer. represented integer values correspond given data type. these integers commonly abstracted appropriate macro definition (e.g. uchar data represented macro cv_8u ). cv::datatype type-traits class provides method obtain corresponding integer value without having memorize macro means data type. there few cases user code needs use datatype::depth . more common datatype::type . a simple example shows 1 possible use of datatype::depth : cv::mat uchar_data = cv::mat::ones(3, 3, cv_8uc1); cv::mat float_data; uchar_data.convertto(float_data, cv::datatype<float>::depth); // ^^ equivalently replaced // cv_32f macro float_data.at<float>(0,1) += 0.5f; std::cout << float_data << std::endl;...
Read more

python 3.x - Mapping specific letters onto a list of words -

can please suggest approach write piece of codes automatically maps letter in letter_str onto dic_key (a dict key string type contains dashes match length of words in word_lst)? so, mapping occurs if letter appears in every words in list @ same position no matter how many words in list. if no letter appears @ position words in word list new_dic_key '----'. please see examples below thanks word_lst = ['ague', 'bute', 'byre', 'came', 'case', 'doze'] dic_key = '----' letters_str ='abcdefghijklmnopqrstuvwxyz' new_dic_key = '---e' if word_list = ['bute', 'byre'] new_dic_key = 'b--e' or word_list = ['drek', 'drew', 'dyes'] new_dic_key = 'd-e-' if words in word_list of same length code give want: word_list = ['drek', 'drew', 'dyes'] cols = [] in range(len(word_list[0])): cols.append([]) word in ...
Read more