Forum Stats

  • 3,872,737 Users
  • 2,266,464 Discussions
  • 7,911,289 Comments

Discussions

Database hangs, ever increasing Lock Held

lsgroup
lsgroup Member Posts: 15
edited Jan 27, 2009 8:39AM in Berkeley DB XML
Hi,

We have Berkeley Dbxml instance running with concurrent access. Our dbxml instance will hang within 2 days. As long was we stop the program, db_recover the database files and restart the program every day, we avoid it hanging. We tink this is because the number of locks seem to grow. running db_deadlock every second does not help and it never reports removing any deadlocks. It hangs just the same eventually.

How do I manage locks? Is there a way I can detect and cancel these locks? I'm including 2 db_stat outputs, one from the morning and another at the end of the day when the database hung (stalled and became unresponsive to requests). I'm going to post the 2 db_stat outputs in 2 replies to this post because it causes this post to exceed the max length...

In the seond db_stat at the time the database stalled, I see that the "Number of current Lockers" equals "Maximum number of lockers at any one time", which was 214. However, the beginning of the output states that the "Maximum number of locks possible" = 295000 which is way more than 214.

Thank you in advance!
Tagged:

Answers

  • lsgroup
    lsgroup Member Posts: 15
    *============ DB_STAT BEGINNING OF DAY ============*
    Default locking region information:
    15846 Last allocated locker ID
    0x7fffffff Current maximum unused locker ID
    9 Number of lock modes
    295000 Maximum number of locks possible
    295000 Maximum number of lockers possible
    295000 Maximum number of lock objects possible
    22 Number of current locks
    153 Maximum number of locks at any one time
    179 Number of current lockers
    191 Maximum number of lockers at any one time
    12 Number of current lock objects
    39 Maximum number of lock objects at any one time
    312M Total number of locks requested (312652259)
    312M Total number of locks released (312652237)
    0 Total number of locks upgraded
    42866 Total number of locks downgraded
    6 Lock requests not available due to conflicts, for which we waited
    0 Lock requests not available due to conflicts, for which we did not wait
    0 Number of deadlocks
    0 Lock timeout value
    0 Number of locks that have timed out
    0 Transaction timeout value
    0 Number of transactions that have timed out
    136MB 936KB The size of the lock region
    1520000 The number of region locks that required waiting (0%)
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Lock REGINFO information:
    Lock Region type
    5 Region ID
    __db.005 Region name
    0x8b92d000 Original region address
    0x8b92d000 Region address
    0x8b92d044 Region primary address
    0 Region maximum allocation
    0 Region allocated
    Region allocations: 885005 allocations, 0 failures, 0 frees, 1 longest
    REGION_JOIN_OK Region flags
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Lock region parameters:
    131103 Lock region region mutex [1520000/519M 0% 19981/3086415552]
    393209 locker table size
    393209 object table size
    436 obj_off
    17301692 locker_off
    0 need_dd
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Lock conflict matrix:
    0 0 0 0 0 0 0 0 0
    0 0 1 0 1 0 1 0 1
    0 1 1 1 1 1 1 1 1
    0 0 0 0 0 0 0 0 0
    0 1 1 0 0 0 0 1 1
    0 0 1 0 0 0 0 0 1
    0 1 1 0 0 0 0 1 1
    0 0 1 0 1 0 1 0 0
    0 1 1 0 1 1 1 0 1
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Locks grouped by lockers:
    Locker Mode Count Status ----------------- Object ---------------
    1 dd=178 locks held 2 write locks 0 pid/thread 21280/3086961568
    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 2
    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    4 dd=177 locks held 0 write locks 0 pid/thread 21280/1590483872
    5 dd=176 locks held 2 write locks 0 pid/thread 21280/3086961568
    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 4
    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    8 dd=175 locks held 0 write locks 0 pid/thread 21280/1584397216
    9 dd=174 locks held 2 write locks 0 pid/thread 21280/3086961568
    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 6
    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    c dd=173 locks held 0 write locks 0 pid/thread 21280/3086961568
    d dd=172 locks held 2 write locks 0 pid/thread 21280/3086961568
    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 8
    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    10 dd=171 locks held 0 write locks 0 pid/thread 21280/1590483872
    11 dd=170 locks held 2 write locks 0 pid/thread 21280/3086961568
    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 10
    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    14 dd=169 locks held 0 write locks 0 pid/thread 21280/1590483872
    15 dd=168 locks held 2 write locks 0 pid/thread 21280/3086961568
    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 12
    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    18 dd=167 locks held 0 write locks 0 pid/thread 21280/1590483872
    19 dd=166 locks held 2 write locks 0 pid/thread 21280/3086961568
    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27489
    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    1c dd=165 locks held 0 write locks 0 pid/thread 21280/1580202912
    1d dd=164 locks held 2 write locks 0 pid/thread 21280/3086961568
    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27491
    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    20 dd=163 locks held 0 write locks 0 pid/thread 21280/1590483872
    21 dd=162 locks held 2 write locks 0 pid/thread 21280/3086961568
    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 14
    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    24 dd=161 locks held 0 write locks 0 pid/thread 21280/1590483872
    25 dd=160 locks held 2 write locks 0 pid/thread 21280/3086961568
    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 16
    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    28 dd=159 locks held 0 write locks 0 pid/thread 21280/1590483872
    56 dd=158 locks held 2 write locks 0 pid/thread 21280/3086961568
    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 18
    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    59 dd=157 locks held 0 write locks 0 pid/thread 21280/1590483872
    5a dd=156 locks held 0 write locks 0 pid/thread 21280/1590483872
    5b dd=155 locks held 0 write locks 0 pid/thread 21280/1590483872
    5c dd=154 locks held 0 write locks 0 pid/thread 21280/1590483872
    5d dd=153 locks held 0 write locks 0 pid/thread 21280/1580202912
    5e dd=152 locks held 0 write locks 0 pid/thread 21280/1590483872
    5f dd=151 locks held 0 write locks 0 pid/thread 21280/1590483872
    60 dd=150 locks held 0 write locks 0 pid/thread 21280/1588382624
    61 dd=149 locks held 0 write locks 0 pid/thread 21280/1592585120
    62 dd=148 locks held 0 write locks 0 pid/thread 21280/1580202912
    63 dd=147 locks held 0 write locks 0 pid/thread 21280/1590483872
    64 dd=146 locks held 0 write locks 0 pid/thread 21280/1590483872
    65 dd=145 locks held 0 write locks 0 pid/thread 21280/1580202912
    66 dd=144 locks held 0 write locks 0 pid/thread 21280/1590483872
    67 dd=143 locks held 0 write locks 0 pid/thread 21280/1590483872
    68 dd=142 locks held 0 write locks 0 pid/thread 21280/1580202912
    69 dd=141 locks held 0 write locks 0 pid/thread 21280/1580202912
    6a dd=140 locks held 0 write locks 0 pid/thread 21280/1580202912
    6b dd=139 locks held 0 write locks 0 pid/thread 21280/1590483872
    6c dd=138 locks held 0 write locks 0 pid/thread 21280/1580202912
    6d dd=137 locks held 0 write locks 0 pid/thread 21280/1580202912
    6e dd=136 locks held 0 write locks 0 pid/thread 21280/1580202912
    6f dd=135 locks held 0 write locks 0 pid/thread 21280/1592585120
    70 dd=134 locks held 0 write locks 0 pid/thread 21280/1580202912
    71 dd=133 locks held 0 write locks 0 pid/thread 21280/1592585120
    72 dd=132 locks held 0 write locks 0 pid/thread 21280/1592585120
    73 dd=131 locks held 0 write locks 0 pid/thread 21280/1590483872
    74 dd=130 locks held 0 write locks 0 pid/thread 21280/1590483872
    75 dd=129 locks held 0 write locks 0 pid/thread 21280/1592585120
    76 dd=128 locks held 0 write locks 0 pid/thread 21280/1592585120
    77 dd=127 locks held 0 write locks 0 pid/thread 21280/1590483872
    78 dd=126 locks held 0 write locks 0 pid/thread 21280/1592585120
    79 dd=125 locks held 0 write locks 0 pid/thread 21280/1590483872
    7a dd=124 locks held 0 write locks 0 pid/thread 21280/1590483872
    7b dd=123 locks held 0 write locks 0 pid/thread 21280/1590483872
    7c dd=122 locks held 0 write locks 0 pid/thread 21280/1590483872
    7d dd=121 locks held 0 write locks 0 pid/thread 21280/1590483872
    7e dd=120 locks held 0 write locks 0 pid/thread 21280/1590483872
    7f dd=119 locks held 0 write locks 0 pid/thread 21280/1590483872
    80 dd=118 locks held 0 write locks 0 pid/thread 21280/1590483872
    81 dd=117 locks held 0 write locks 0 pid/thread 21280/1590483872
    82 dd=116 locks held 0 write locks 0 pid/thread 21280/1590483872
    83 dd=115 locks held 0 write locks 0 pid/thread 21280/1590483872
    84 dd=114 locks held 0 write locks 0 pid/thread 21280/1590483872
    85 dd=113 locks held 0 write locks 0 pid/thread 21280/1592585120
    86 dd=112 locks held 0 write locks 0 pid/thread 21280/1580202912
    87 dd=111 locks held 0 write locks 0 pid/thread 21280/1590483872
    88 dd=110 locks held 0 write locks 0 pid/thread 21280/1590483872
    89 dd=109 locks held 0 write locks 0 pid/thread 21280/1590483872
    8a dd=108 locks held 0 write locks 0 pid/thread 21280/1590483872
    8b dd=107 locks held 0 write locks 0 pid/thread 21280/1580202912
    8c dd=106 locks held 0 write locks 0 pid/thread 21280/1592585120
    8d dd=105 locks held 0 write locks 0 pid/thread 21280/1590483872
    8e dd=104 locks held 0 write locks 0 pid/thread 21280/1590483872
    8f dd=103 locks held 0 write locks 0 pid/thread 21280/1590483872
    90 dd=102 locks held 0 write locks 0 pid/thread 21280/1580202912
    91 dd=101 locks held 0 write locks 0 pid/thread 21280/1590483872
    92 dd=100 locks held 0 write locks 0 pid/thread 21280/1590483872
    93 dd=99 locks held 0 write locks 0 pid/thread 21280/1580202912
    94 dd=98 locks held 0 write locks 0 pid/thread 21280/1580202912
    95 dd=97 locks held 0 write locks 0 pid/thread 21280/1580202912
    96 dd=96 locks held 0 write locks 0 pid/thread 21280/1592585120
    97 dd=95 locks held 0 write locks 0 pid/thread 21280/1590483872
    98 dd=94 locks held 0 write locks 0 pid/thread 21280/1590483872
    b4 dd=93 locks held 0 write locks 0 pid/thread 21280/1590483872
    2d1 dd=92 locks held 0 write locks 0 pid/thread 21280/1590483872
    8f8 dd=91 locks held 0 write locks 0 pid/thread 21280/1590483872
    965 dd=90 locks held 0 write locks 0 pid/thread 21280/1580202912
    966 dd=89 locks held 0 write locks 0 pid/thread 21280/1590483872
    967 dd=88 locks held 0 write locks 0 pid/thread 21280/1580202912
    968 dd=87 locks held 0 write locks 0 pid/thread 21280/1590483872
    969 dd=86 locks held 0 write locks 0 pid/thread 21280/1580202912
    96a dd=85 locks held 0 write locks 0 pid/thread 21280/1590483872
    96b dd=84 locks held 0 write locks 0 pid/thread 21280/1580202912
    96c dd=83 locks held 0 write locks 0 pid/thread 21280/1590483872
    96d dd=82 locks held 0 write locks 0 pid/thread 21280/1590483872
    96e dd=81 locks held 0 write locks 0 pid/thread 21280/1590483872
    96f dd=80 locks held 0 write locks 0 pid/thread 21280/1590483872
    970 dd=79 locks held 0 write locks 0 pid/thread 21280/1590483872
    971 dd=78 locks held 0 write locks 0 pid/thread 21280/1590483872
    972 dd=77 locks held 0 write locks 0 pid/thread 21280/1590483872
    973 dd=76 locks held 0 write locks 0 pid/thread 21280/1590483872
    974 dd=75 locks held 0 write locks 0 pid/thread 21280/1580202912
    975 dd=74 locks held 0 write locks 0 pid/thread 21280/1590483872
    976 dd=73 locks held 0 write locks 0 pid/thread 21280/1580202912
    977 dd=72 locks held 0 write locks 0 pid/thread 21280/1590483872
    978 dd=71 locks held 0 write locks 0 pid/thread 21280/1590483872
    979 dd=70 locks held 0 write locks 0 pid/thread 21280/1592585120
    97a dd=69 locks held 0 write locks 0 pid/thread 21280/1580202912
    97b dd=68 locks held 0 write locks 0 pid/thread 21280/1590483872
    97c dd=67 locks held 0 write locks 0 pid/thread 21280/1590483872
    97d dd=66 locks held 0 write locks 0 pid/thread 21280/1590483872
    97e dd=65 locks held 0 write locks 0 pid/thread 21280/1580202912
    97f dd=64 locks held 0 write locks 0 pid/thread 21280/1580202912
    980 dd=63 locks held 0 write locks 0 pid/thread 21280/1590483872
    981 dd=62 locks held 0 write locks 0 pid/thread 21280/1590483872
    982 dd=61 locks held 0 write locks 0 pid/thread 21280/1590483872
    983 dd=60 locks held 0 write locks 0 pid/thread 21280/1590483872
    984 dd=59 locks held 0 write locks 0 pid/thread 21280/1592585120
    985 dd=58 locks held 0 write locks 0 pid/thread 21280/1590483872
    986 dd=57 locks held 0 write locks 0 pid/thread 21280/1590483872
    987 dd=56 locks held 0 write locks 0 pid/thread 21280/1590483872
    988 dd=55 locks held 0 write locks 0 pid/thread 21280/1592585120
    989 dd=54 locks held 0 write locks 0 pid/thread 21280/1580202912
    98a dd=53 locks held 0 write locks 0 pid/thread 21280/1592585120
    98b dd=52 locks held 0 write locks 0 pid/thread 21280/1590483872
    98c dd=51 locks held 0 write locks 0 pid/thread 21280/1590483872
    98d dd=50 locks held 0 write locks 0 pid/thread 21280/1580202912
    98e dd=49 locks held 0 write locks 0 pid/thread 21280/1590483872
    98f dd=48 locks held 0 write locks 0 pid/thread 21280/1580202912
    990 dd=47 locks held 0 write locks 0 pid/thread 21280/1590483872
    991 dd=46 locks held 0 write locks 0 pid/thread 21280/1590483872
    992 dd=45 locks held 0 write locks 0 pid/thread 21280/1590483872
    993 dd=44 locks held 0 write locks 0 pid/thread 21280/1590483872
    994 dd=43 locks held 0 write locks 0 pid/thread 21280/1580202912
    995 dd=42 locks held 0 write locks 0 pid/thread 21280/1590483872
    996 dd=41 locks held 0 write locks 0 pid/thread 21280/1590483872
    997 dd=40 locks held 0 write locks 0 pid/thread 21280/1580202912
    998 dd=39 locks held 0 write locks 0 pid/thread 21280/1580202912
    999 dd=38 locks held 0 write locks 0 pid/thread 21280/1590483872
    99a dd=37 locks held 0 write locks 0 pid/thread 21280/1580202912
    99b dd=36 locks held 0 write locks 0 pid/thread 21280/1580202912
    99c dd=35 locks held 0 write locks 0 pid/thread 21280/1590483872
    99d dd=34 locks held 0 write locks 0 pid/thread 21280/1580202912
    99e dd=33 locks held 0 write locks 0 pid/thread 21280/1580202912
    99f dd=32 locks held 0 write locks 0 pid/thread 21280/1592585120
    9a0 dd=31 locks held 0 write locks 0 pid/thread 21280/1580202912
    9a1 dd=30 locks held 0 write locks 0 pid/thread 21280/1590483872
    9a2 dd=29 locks held 0 write locks 0 pid/thread 21280/1592585120
    9a3 dd=28 locks held 0 write locks 0 pid/thread 21280/1590483872
    9a4 dd=27 locks held 0 write locks 0 pid/thread 21280/1580202912
    9a5 dd=26 locks held 0 write locks 0 pid/thread 21280/1590483872
    9a6 dd=25 locks held 0 write locks 0 pid/thread 21280/1592585120
    9a7 dd=24 locks held 0 write locks 0 pid/thread 21280/1580202912
    9a8 dd=23 locks held 0 write locks 0 pid/thread 21280/1580202912
    9a9 dd=22 locks held 0 write locks 0 pid/thread 21280/1590483872
    9aa dd=21 locks held 0 write locks 0 pid/thread 21280/1590483872
    9ab dd=20 locks held 0 write locks 0 pid/thread 21280/1590483872
    9ac dd=19 locks held 0 write locks 0 pid/thread 21280/1580202912
    9ad dd=18 locks held 0 write locks 0 pid/thread 21280/1590483872
    9ae dd=17 locks held 0 write locks 0 pid/thread 21280/1590483872
    9af dd=16 locks held 0 write locks 0 pid/thread 21280/1590483872
    9b0 dd=15 locks held 0 write locks 0 pid/thread 21280/1590483872
    9b1 dd=14 locks held 0 write locks 0 pid/thread 21280/1580202912
    9b2 dd=13 locks held 0 write locks 0 pid/thread 21280/1592585120
    9b3 dd=12 locks held 0 write locks 0 pid/thread 21280/1590483872
    9b4 dd=11 locks held 0 write locks 0 pid/thread 21280/1580202912
    9b5 dd=10 locks held 0 write locks 0 pid/thread 21280/1590483872
    9b6 dd= 9 locks held 0 write locks 0 pid/thread 21280/1590483872
    9b7 dd= 8 locks held 0 write locks 0 pid/thread 21280/1590483872
    9b8 dd= 7 locks held 0 write locks 0 pid/thread 21280/1590483872
    bba dd= 6 locks held 0 write locks 0 pid/thread 21280/1588382624
    bbb dd= 5 locks held 0 write locks 0 pid/thread 21280/1590483872
    1d9f dd= 4 locks held 0 write locks 0 pid/thread 21280/1590483872
    1da0 dd= 3 locks held 0 write locks 0 pid/thread 21280/1590483872
    3c34 dd= 2 locks held 0 write locks 0 pid/thread 21280/1590483872
    3c86 dd= 1 locks held 0 write locks 0 pid/thread 21280/1590483872
    3d0e dd= 0 locks held 0 write locks 0 pid/thread 21280/1590483872
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Locks grouped by object:
    Locker Mode Count Status ----------------- Object ---------------
    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27489

    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27491

    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 4

    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 6

    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0

    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 2

    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 12

    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 14

    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 8

    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 10

    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 16

    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 18
  • lsgroup
    lsgroup Member Posts: 15
    ============ DB_STAT END OF DAY(WHEN DATABASE STALLED / HANG) ============
    Default locking region information:
    16934 Last allocated locker ID
    0x7fffffff Current maximum unused locker ID
    9 Number of lock modes
    295000 Maximum number of locks possible
    295000 Maximum number of lockers possible
    295000 Maximum number of lock objects possible
    65 Number of current locks
    153 Maximum number of locks at any one time
    214 Number of current lockers
    214 Maximum number of lockers at any one time
    14 Number of current lock objects
    40 Maximum number of lock objects at any one time
    427M Total number of locks requested (427588913)
    427M Total number of locks released (427588848)
    0 Total number of locks upgraded
    45752 Total number of locks downgraded
    32 Lock requests not available due to conflicts, for which we waited
    0 Lock requests not available due to conflicts, for which we did not wait
    0 Number of deadlocks
    0 Lock timeout value
    0 Number of locks that have timed out
    0 Transaction timeout value
    0 Number of transactions that have timed out
    136MB 936KB The size of the lock region
    2115829 The number of region locks that required waiting (0%)
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Lock REGINFO information:
    Lock Region type
    5 Region ID
    __db.005 Region name
    0x8b8bf000 Original region address
    0x8b8bf000 Region address
    0x8b8bf044 Region primary address
    0 Region maximum allocation
    0 Region allocated
    Region allocations: 885005 allocations, 0 failures, 0 frees, 1 longest
    REGION_JOIN_OK Region flags
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Lock region parameters:
    131103 Lock region region mutex [2115829/711M 0% 23123/3085964992]
    393209 locker table size
    393209 object table size
    436 obj_off
    17301692 locker_off
    0 need_dd
    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Lock conflict matrix:
    0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 1 0 0 0 0 0 1 0 1 1 0 0 0 0 1 1 0 0 1 0 1 0 1 0 0 0 1 1 0 1 1 1 0 1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Locks grouped by lockers:
    Locker Mode Count Status ----------------- Object ---------------
    1 dd=213 locks held 2 write locks 0 pid/thread 21280/3086961568 1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 2
    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    4 dd=212 locks held 0 write locks 0 pid/thread 21280/1517210528 5 dd=211 locks held 2 write locks 0 pid/thread 21280/3086961568 5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 4
    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    8 dd=210 locks held 0 write locks 0 pid/thread 21280/1584397216 9 dd=209 locks held 2 write locks 0 pid/thread 21280/3086961568 9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 6
    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    c dd=208 locks held 0 write locks 0 pid/thread 21280/3086961568 d dd=207 locks held 2 write locks 0 pid/thread 21280/3086961568 d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 8
    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    10 dd=206 locks held 0 write locks 0 pid/thread 21280/1517210528 11 dd=205 locks held 2 write locks 0 pid/thread 21280/3086961568 11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 10
    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    14 dd=204 locks held 0 write locks 0 pid/thread 21280/1523514272 15 dd=203 locks held 2 write locks 0 pid/thread 21280/3086961568 15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 12
    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    18 dd=202 locks held 0 write locks 0 pid/thread 21280/1529818016 19 dd=201 locks held 2 write locks 0 pid/thread 21280/3086961568 19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27489
    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    1c dd=200 locks held 0 write locks 0 pid/thread 21280/1584397216 1d dd=199 locks held 2 write locks 0 pid/thread 21280/3086961568 1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27491
    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    20 dd=198 locks held 0 write locks 0 pid/thread 21280/1584397216 21 dd=197 locks held 2 write locks 0 pid/thread 21280/3086961568 21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 14
    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    24 dd=196 locks held 0 write locks 0 pid/thread 21280/1540324256 25 dd=195 locks held 2 write locks 0 pid/thread 21280/3086961568 25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 16
    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    28 dd=194 locks held 0 write locks 0 pid/thread 21280/1517210528 56 dd=193 locks held 2 write locks 0 pid/thread 21280/3086961568 56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 18
    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    59 dd=192 locks held 0 write locks 0 pid/thread 21280/1584397216 5a dd=191 locks held 0 write locks 0 pid/thread 21280/1517210528 5b dd=190 locks held 1 write locks 0 pid/thread 21280/1584397216 5b WRITE 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    5b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 22866
    5c dd=189 locks held 1 write locks 0 pid/thread 21280/1594686368 5c READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    5c READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    5d dd=188 locks held 0 write locks 0 pid/thread 21280/1584397216 5e dd=187 locks held 0 write locks 0 pid/thread 21280/1517210528 5f dd=186 locks held 0 write locks 0 pid/thread 21280/1523514272 60 dd=185 locks held 0 write locks 0 pid/thread 21280/1588382624 61 dd=184 locks held 0 write locks 0 pid/thread 21280/1584397216 62 dd=183 locks held 0 write locks 0 pid/thread 21280/1584397216 63 dd=182 locks held 0 write locks 0 pid/thread 21280/1584397216 64 dd=181 locks held 0 write locks 0 pid/thread 21280/1584397216 65 dd=180 locks held 0 write locks 0 pid/thread 21280/1548729248 66 dd=179 locks held 0 write locks 0 pid/thread 21280/1584397216 67 dd=178 locks held 0 write locks 0 pid/thread 21280/1538223008 68 dd=177 locks held 0 write locks 0 pid/thread 21280/1584397216 69 dd=176 locks held 0 write locks 0 pid/thread 21280/1584397216 6a dd=175 locks held 0 write locks 0 pid/thread 21280/1538223008 6b dd=174 locks held 0 write locks 0 pid/thread 21280/1584397216 6c dd=173 locks held 0 write locks 0 pid/thread 21280/1584397216 6d dd=172 locks held 0 write locks 0 pid/thread 21280/1584397216 6e dd=171 locks held 0 write locks 0 pid/thread 21280/1584397216 6f dd=170 locks held 0 write locks 0 pid/thread 21280/1538223008 70 dd=169 locks held 0 write locks 0 pid/thread 21280/1584397216 71 dd=168 locks held 0 write locks 0 pid/thread 21280/1538223008 72 dd=167 locks held 0 write locks 0 pid/thread 21280/1584397216 73 dd=166 locks held 0 write locks 0 pid/thread 21280/1517210528 74 dd=165 locks held 0 write locks 0 pid/thread 21280/1523514272 75 dd=164 locks held 0 write locks 0 pid/thread 21280/1584397216 76 dd=163 locks held 0 write locks 0 pid/thread 21280/1584397216 77 dd=162 locks held 0 write locks 0 pid/thread 21280/1584397216 78 dd=161 locks held 0 write locks 0 pid/thread 21280/1584397216 79 dd=160 locks held 0 write locks 0 pid/thread 21280/1517210528 7a dd=159 locks held 1 write locks 0 pid/thread 21280/1592585120 7a READ 1 HELD (16c005 1603 eb773575 74d4 0) page 22866
    7b dd=158 locks held 1 write locks 0 pid/thread 21280/1592585120 7b READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    7b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    7c dd=157 locks held 0 write locks 0 pid/thread 21280/1517210528 7d dd=156 locks held 0 write locks 0 pid/thread 21280/1517210528 7e dd=155 locks held 0 write locks 0 pid/thread 21280/1517210528 7f dd=154 locks held 1 write locks 0 pid/thread 21280/1590483872 7f READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    7f READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    80 dd=153 locks held 0 write locks 0 pid/thread 21280/1529818016 81 dd=152 locks held 0 write locks 0 pid/thread 21280/1529818016 82 dd=151 locks held 0 write locks 0 pid/thread 21280/1584397216 83 dd=150 locks held 0 write locks 0 pid/thread 21280/1584397216 84 dd=149 locks held 0 write locks 0 pid/thread 21280/1584397216 85 dd=148 locks held 0 write locks 0 pid/thread 21280/1584397216 86 dd=147 locks held 0 write locks 0 pid/thread 21280/1584397216 87 dd=146 locks held 0 write locks 0 pid/thread 21280/1548729248 88 dd=145 locks held 0 write locks 0 pid/thread 21280/1584397216 89 dd=144 locks held 0 write locks 0 pid/thread 21280/1584397216 8a dd=143 locks held 0 write locks 0 pid/thread 21280/1538223008 8b dd=142 locks held 0 write locks 0 pid/thread 21280/1584397216 8c dd=141 locks held 0 write locks 0 pid/thread 21280/1544526752 8d dd=140 locks held 0 write locks 0 pid/thread 21280/1584397216 8e dd=139 locks held 0 write locks 0 pid/thread 21280/1584397216 8f dd=138 locks held 0 write locks 0 pid/thread 21280/1584397216 90 dd=137 locks held 0 write locks 0 pid/thread 21280/1584397216 91 dd=136 locks held 0 write locks 0 pid/thread 21280/1534020512 92 dd=135 locks held 0 write locks 0 pid/thread 21280/1584397216 93 dd=134 locks held 0 write locks 0 pid/thread 21280/1523514272 94 dd=133 locks held 0 write locks 0 pid/thread 21280/1584397216 95 dd=132 locks held 0 write locks 0 pid/thread 21280/1544526752 96 dd=131 locks held 0 write locks 0 pid/thread 21280/1584397216 97 dd=130 locks held 0 write locks 0 pid/thread 21280/1538223008 98 dd=129 locks held 0 write locks 0 pid/thread 21280/1519311776 b4 dd=128 locks held 0 write locks 0 pid/thread 21280/1584397216 2d1 dd=127 locks held 0 write locks 0 pid/thread 21280/1594686368 8f8 dd=126 locks held 0 write locks 0 pid/thread 21280/1517210528 965 dd=125 locks held 0 write locks 0 pid/thread 21280/1538223008 966 dd=124 locks held 0 write locks 0 pid/thread 21280/1584397216 967 dd=123 locks held 0 write locks 0 pid/thread 21280/1584397216 968 dd=122 locks held 0 write locks 0 pid/thread 21280/1584397216 969 dd=121 locks held 0 write locks 0 pid/thread 21280/1584397216 96a dd=120 locks held 0 write locks 0 pid/thread 21280/1584397216 96b dd=119 locks held 0 write locks 0 pid/thread 21280/1584397216 96c dd=118 locks held 0 write locks 0 pid/thread 21280/1538223008 96d dd=117 locks held 0 write locks 0 pid/thread 21280/1584397216 96e dd=116 locks held 0 write locks 0 pid/thread 21280/1584397216 96f dd=115 locks held 0 write locks 0 pid/thread 21280/1584397216 970 dd=114 locks held 0 write locks 0 pid/thread 21280/1584397216 971 dd=113 locks held 0 write locks 0 pid/thread 21280/1540324256 972 dd=112 locks held 0 write locks 0 pid/thread 21280/1538223008 973 dd=111 locks held 0 write locks 0 pid/thread 21280/1584397216 974 dd=110 locks held 0 write locks 0 pid/thread 21280/1538223008 975 dd=109 locks held 0 write locks 0 pid/thread 21280/1584397216 976 dd=108 locks held 0 write locks 0 pid/thread 21280/1584397216 977 dd=107 locks held 0 write locks 0 pid/thread 21280/1584397216 978 dd=106 locks held 0 write locks 0 pid/thread 21280/1584397216 979 dd=105 locks held 0 write locks 0 pid/thread 21280/1529818016 97a dd=104 locks held 0 write locks 0 pid/thread 21280/1544526752 97b dd=103 locks held 0 write locks 0 pid/thread 21280/1584397216 97c dd=102 locks held 0 write locks 0 pid/thread 21280/1534020512 97d dd=101 locks held 0 write locks 0 pid/thread 21280/1584397216 97e dd=100 locks held 0 write locks 0 pid/thread 21280/1538223008 97f dd=99 locks held 0 write locks 0 pid/thread 21280/1584397216 980 dd=98 locks held 0 write locks 0 pid/thread 21280/1548729248 981 dd=97 locks held 0 write locks 0 pid/thread 21280/1584397216 982 dd=96 locks held 0 write locks 0 pid/thread 21280/1584397216 983 dd=95 locks held 0 write locks 0 pid/thread 21280/1584397216 984 dd=94 locks held 0 write locks 0 pid/thread 21280/1584397216 985 dd=93 locks held 0 write locks 0 pid/thread 21280/1584397216 986 dd=92 locks held 0 write locks 0 pid/thread 21280/1584397216 987 dd=91 locks held 0 write locks 0 pid/thread 21280/1584397216 988 dd=90 locks held 0 write locks 0 pid/thread 21280/1584397216 989 dd=89 locks held 0 write locks 0 pid/thread 21280/1584397216 98a dd=88 locks held 0 write locks 0 pid/thread 21280/1584397216 98b dd=87 locks held 0 write locks 0 pid/thread 21280/1584397216 98c dd=86 locks held 0 write locks 0 pid/thread 21280/1584397216 98d dd=85 locks held 0 write locks 0 pid/thread 21280/1584397216 98e dd=84 locks held 0 write locks 0 pid/thread 21280/1584397216 98f dd=83 locks held 0 write locks 0 pid/thread 21280/1584397216 990 dd=82 locks held 0 write locks 0 pid/thread 21280/1584397216 991 dd=81 locks held 0 write locks 0 pid/thread 21280/1584397216 992 dd=80 locks held 0 write locks 0 pid/thread 21280/1584397216 993 dd=79 locks held 0 write locks 0 pid/thread 21280/1536121760 994 dd=78 locks held 0 write locks 0 pid/thread 21280/1534020512 995 dd=77 locks held 0 write locks 0 pid/thread 21280/1584397216 996 dd=76 locks held 0 write locks 0 pid/thread 21280/1584397216 997 dd=75 locks held 0 write locks 0 pid/thread 21280/1584397216 998 dd=74 locks held 0 write locks 0 pid/thread 21280/1584397216 999 dd=73 locks held 0 write locks 0 pid/thread 21280/1584397216 99a dd=72 locks held 0 write locks 0 pid/thread 21280/1584397216 99b dd=71 locks held 0 write locks 0 pid/thread 21280/1584397216 99c dd=70 locks held 0 write locks 0 pid/thread 21280/1538223008 99d dd=69 locks held 0 write locks 0 pid/thread 21280/1584397216 99e dd=68 locks held 0 write locks 0 pid/thread 21280/1538223008 99f dd=67 locks held 0 write locks 0 pid/thread 21280/1584397216 9a0 dd=66 locks held 0 write locks 0 pid/thread 21280/1584397216 9a1 dd=65 locks held 0 write locks 0 pid/thread 21280/1540324256 9a2 dd=64 locks held 0 write locks 0 pid/thread 21280/1584397216 9a3 dd=63 locks held 0 write locks 0 pid/thread 21280/1580202912 9a4 dd=62 locks held 0 write locks 0 pid/thread 21280/1529818016 9a5 dd=61 locks held 0 write locks 0 pid/thread 21280/1584397216 9a6 dd=60 locks held 0 write locks 0 pid/thread 21280/1584397216 9a7 dd=59 locks held 0 write locks 0 pid/thread 21280/1538223008 9a8 dd=58 locks held 0 write locks 0 pid/thread 21280/1584397216 9a9 dd=57 locks held 0 write locks 0 pid/thread 21280/1584397216 9aa dd=56 locks held 0 write locks 0 pid/thread 21280/1584397216 9ab dd=55 locks held 0 write locks 0 pid/thread 21280/1538223008 9ac dd=54 locks held 0 write locks 0 pid/thread 21280/1584397216 9ad dd=53 locks held 0 write locks 0 pid/thread 21280/1584397216 9ae dd=52 locks held 0 write locks 0 pid/thread 21280/1584397216 9af dd=51 locks held 0 write locks 0 pid/thread 21280/1584397216 9b0 dd=50 locks held 0 write locks 0 pid/thread 21280/1584397216 9b1 dd=49 locks held 0 write locks 0 pid/thread 21280/1584397216 9b2 dd=48 locks held 0 write locks 0 pid/thread 21280/1584397216 9b3 dd=47 locks held 0 write locks 0 pid/thread 21280/1584397216 9b4 dd=46 locks held 0 write locks 0 pid/thread 21280/1584397216 9b5 dd=45 locks held 0 write locks 0 pid/thread 21280/1590483872 9b6 dd=44 locks held 0 write locks 0 pid/thread 21280/1584397216 9b7 dd=43 locks held 0 write locks 0 pid/thread 21280/1538223008 9b8 dd=42 locks held 0 write locks 0 pid/thread 21280/1529818016 bba dd=41 locks held 0 write locks 0 pid/thread 21280/1588382624 bbb dd=40 locks held 0 write locks 0 pid/thread 21280/1584397216 1d9f dd=39 locks held 0 write locks 0 pid/thread 21280/1592585120 1da0 dd=38 locks held 0 write locks 0 pid/thread 21280/1584397216 3c34 dd=37 locks held 0 write locks 0 pid/thread 21280/1529818016 3c86 dd=36 locks held 0 write locks 0 pid/thread 21280/1517210528 3d0e dd=35 locks held 0 write locks 0 pid/thread 21280/1517210528 4204 dd=34 locks held 0 write locks 0 pid/thread 21280/1590483872 4205 dd=33 locks held 1 write locks 0 pid/thread 21280/1548729248 4205 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4205 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4206 dd=32 locks held 0 write locks 0 pid/thread 21280/1548729248 4207 dd=31 locks held 1 write locks 0 pid/thread 21280/1546628000 4207 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4207 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4208 dd=30 locks held 0 write locks 0 pid/thread 21280/1546628000 4209 dd=29 locks held 1 write locks 0 pid/thread 21280/1580202912 4209 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4209 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    420a dd=28 locks held 0 write locks 0 pid/thread 21280/1580202912 420b dd=27 locks held 1 write locks 0 pid/thread 21280/1544526752 420b READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    420b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    420c dd=26 locks held 0 write locks 0 pid/thread 21280/1544526752 420d dd=25 locks held 1 write locks 0 pid/thread 21280/1542425504 420d READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    420d READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    420e dd=24 locks held 0 write locks 0 pid/thread 21280/1542425504 420f dd=23 locks held 1 write locks 0 pid/thread 21280/1540324256 420f READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    420f READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4210 dd=22 locks held 0 write locks 0 pid/thread 21280/1540324256 4211 dd=21 locks held 1 write locks 0 pid/thread 21280/1538223008 4211 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4211 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4212 dd=20 locks held 0 write locks 0 pid/thread 21280/1538223008 4213 dd=19 locks held 1 write locks 0 pid/thread 21280/1536121760 4213 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4213 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4214 dd=18 locks held 0 write locks 0 pid/thread 21280/1536121760 4215 dd=17 locks held 1 write locks 0 pid/thread 21280/1534020512 4215 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4215 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4216 dd=16 locks held 0 write locks 0 pid/thread 21280/1534020512 4217 dd=15 locks held 1 write locks 0 pid/thread 21280/1531919264 4217 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4217 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4218 dd=14 locks held 0 write locks 0 pid/thread 21280/1531919264 4219 dd=13 locks held 1 write locks 0 pid/thread 21280/1527716768 4219 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4219 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    421a dd=12 locks held 0 write locks 0 pid/thread 21280/1527716768 421b dd=11 locks held 1 write locks 0 pid/thread 21280/1529818016 421b READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    421b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    421c dd=10 locks held 0 write locks 0 pid/thread 21280/1529818016 421d dd= 9 locks held 1 write locks 0 pid/thread 21280/1525615520 421d READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    421d READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    421e dd= 8 locks held 0 write locks 0 pid/thread 21280/1525615520 421f dd= 7 locks held 1 write locks 0 pid/thread 21280/1523514272 421f READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    421f READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4220 dd= 6 locks held 0 write locks 0 pid/thread 21280/1523514272 4221 dd= 5 locks held 1 write locks 0 pid/thread 21280/1521413024 4221 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4221 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4222 dd= 4 locks held 0 write locks 0 pid/thread 21280/1521413024 4223 dd= 3 locks held 1 write locks 0 pid/thread 21280/1519311776 4223 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4223 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4224 dd= 2 locks held 0 write locks 0 pid/thread 21280/1519311776 4225 dd= 1 locks held 1 write locks 0 pid/thread 21280/1517210528 4225 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4225 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4226 dd= 0 locks held 0 write locks 0 pid/thread 21280/1517210528 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
    Locks grouped by object:
    Locker Mode Count Status ----------------- Object ---------------
    5b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 22866
    7a READ 1 HELD (16c005 1603 eb773575 74d4 0) page 22866
    5b WRITE 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    7b READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    5c READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    7f READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4205 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4207 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4209 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    420b READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    420d READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    420f READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4211 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4213 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4215 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4217 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4219 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    421b READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    421d READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    421f READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4221 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4223 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866
    4225 READ 1 WAIT (16c005 1603 eb773575 74d4 0) page 22866

    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27489

    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 27491

    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 4

    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 6

    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    5 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    9 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    19 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    1d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0
    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 0

    1 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 2

    15 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 12

    21 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 14

    d READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 8

    11 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 10

    25 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 16

    7b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    5c READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    7f READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4205 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4207 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4209 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    420b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    420d READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    420f READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4211 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4213 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4215 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4217 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4219 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    421b READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    421d READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    421f READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4221 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4223 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19
    4225 READ 1 HELD (16c005 1603 eb773575 74d4 0) page 19

    56 READ 1 HELD (16c005 1603 eb773575 74d4 0) handle 18
  • lsgroup
    lsgroup Member Posts: 15
    Some more info about my environment:
    OS: Linux keelung 2.6.9-67.ELsmp #1 SMP Fri Nov 16 12:48:03 EST 2007 i686 athlon i386 GNU/Linux
    Oracle: Berkeley DB XML 2.4.16: (October 21, 2008)
    Berkeley DB 4.6.21: (September 27, 2007)

    Here's my java code when I initialize environment and open container:

    envConf = new EnvironmentConfig();
    envConf.setAllowCreate(true); // If the environment does not exits, create it.
    envConf.setInitializeCache(true); // Turn on the shared memory region.
    envConf.setInitializeLocking(true); // Turn on the locking subsystem.
    envConf.setInitializeLogging(true); // Turn on the logging subsystem.
    envConf.setCacheSize( dbCacheSize );
    envConf.setLockDetectMode(LockDetectMode.DEFAULT);
    envConf.setErrorStream(System.err);
    envConf.setMaxLockers(dbMaxLockers);
    envConf.setMaxLocks(dbLockMaxLocks);
    envConf.setMaxLockObjects(dbLockMaxObjects);
    envConf.setTransactional(false); // Turn on the transactional subsystem.
    envConf.setThreaded(true);
    //envConf.setRunRecovery(true);

    File containerdir = new File(dbxmlpath);
    File envdir = new File(dbenvpath);
    System.out.println(containerdir);
    env = new Environment(envdir, envConf);

    managerconfig = new XmlManagerConfig();
    managerconfig.setAdoptEnvironment(true);
    managerconfig.setAllowAutoOpen(true);
    managerconfig.setAllowExternalAccess(true);

    manager = new XmlManager(env, managerconfig);
    container = manager.openContainer(cname);

    Thanks!
  • lsgroup
    lsgroup Member Posts: 15
    Hi, anyone have any ideas on how I might start to figure out what is causing the hanging?

    Thanks!
  • Gmfeinberg-Oracle
    Gmfeinberg-Oracle Posts: 1,333 Employee
    Hi,

    You need to configure transactions in your EnvironmentConfig and when you create/open your containers. E.g.:
    envConf.setTransactional(true);
    ...
    container = manager.openContainer(cname, new XmlContainerConfig.setTransactional(true));

    Then you need to use explicit transactions in your application and be prepared to receive and handle deadlock exceptions (handle them via retrying the operation, after aborting the transaction).

    Regards,
    George
This discussion has been closed.