ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 为什么这样也能死锁?

为什么这样也能死锁?

原创 Linux操作系统 作者:howard_zhang 时间:2009-06-04 07:33:00 0 删除 编辑
sqshdb1_lmd0_10905.trc

user session for deadlock lock 3e7248910
  pid=49 serial=13 audsid=170909594 user: 67/FORUM
  O/S info: user: trs, term: unknown, ospid: 1234, machine: xhsqlt1
            program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=0
  Current SQL Statement:
  update BBSTHREAD set READCNT=READCNT+1 where ID=:1
user session for deadlock lock 42720b1c8
  pid=36 serial=4 audsid=170909580 user: 67/FORUM
  O/S info: user: trs, term: unknown, ospid: 1234, machine: xhsqlt1
            program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=0
  Current SQL Statement:
  update BBSTHREAD set READCNT=READCNT+1 where ID=:1
ENQUEUE DUMP REQUEST: from 1.13068 on [0xe000c][0x90e6e],[TX] for reason 3 mtype 0
DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0xe000c][0x90e6e],[TX]
----------resource 0x388d86688----------------------
resname       : [0xe000c][0x90e6e],[TX]
Local node    : 0
dir_node      : 1
master_node   : 1
hv idx        : 89
hv last r.inc : 18
current inc   : 28
hv status     : 0
hv master     : 1
open options  : dd
Held mode     : KJUSERNL
Cvt mode      : KJUSEREX
Next Cvt mode : KJUSERNL
msg_seq       : 1
res_seq       : 2
grant_bits    : KJUSERNL
grant mode    : KJUSERNL  KJUSERCR  KJUSERCW  KJUSERPR  KJUSERPW  KJUSEREX
count         : 11         0         0         0         0         0
val_state     : KJUSERVS_NOVALUE
valblk        : 0x00000000000000000000000000000000 .
access_node   : 1
vbreq_state   : 0
state         : x8
resp          : 388d86688
On Scan_q?    : N
Total accesses: 1235
Imm.  accesses: 1181
Granted_locks : 0
Cvting_locks  : 11
value_block:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
GRANTED_Q :
CONVERT_Q:
lp 42720b1c8 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 427107b90 possible pid 15072 xid 1002-0024-00000002 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e7248910 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70facb0 possible pid 15225 xid 1003-0031-00000005 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e72bafa0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70f9800 possible pid 15188 xid 1003-0033-00000004 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 42720b468 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 42710a4f0 possible pid 15268 xid 1001-001E-00000054 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e7336540 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70feac0 possible pid 15276 xid 1002-002F-0000000D bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e72bb240 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70fc160 possible pid 15345 xid 1002-002D-00000026 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e73367e0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70fd610 possible pid 15356 xid 1003-0035-00000008 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e7248bb0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70f8350 possible pid 15395 xid 1003-0037-00000008 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 4272f88a0 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 4271066e0 possible pid 15599 xid 1002-0022-0000001D bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 42727f820 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 42710b9a0 possible pid 16285 xid 1002-0020-00000017 bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  
lp 3e7336a80 gl KJUSERNL rl KJUSEREX rp 388d86688 [0xe000c][0x90e6e],[TX]
  master 1 gl owner 3e70f59f0 possible pid 4025 xid 1003-003B-000000AC bast 0 rseq 2 mseq 0 history 0x1495149a
  convert opt KJUSERGETVALUE  

谁见过类似的问题?

sqshdb1_lmd0_10905.rar
(2009-06-02 15:49:39, Size: 18 KB, Downloads: 2)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7882490/viewspace-605064/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-22

  • 博文量
    42
  • 访问量
    132569