test/system/lock/exp.test007a

   1 Table created
   2 Index created for f1
   3 Total Tuples inserted is 10
   4 Total Tuples updated is 10
   5 Before abort
   6 <LockTable>
   7 <Lock Node>
   8   <Tuple> 17e7a014 </Tuple>
   9   <NoOfReaders> -1 </NoOfReaders>
  10   <WaitReaders> 0 </WaitReaders>
  11   <WaitWriters> 0 </WaitWriters>
  12 </Lock Node>
  13   <LockBucket>
  14     <BucketNo> 20 </BucketNo>
  15     <TotalNodes> 1 </TotalNodes>
  16   <LockBucket>
  17 <Lock Node>
  18   <Tuple> 17e7a024 </Tuple>
  19   <NoOfReaders> -1 </NoOfReaders>
  20   <WaitReaders> 0 </WaitReaders>
  21   <WaitWriters> 0 </WaitWriters>
  22 </Lock Node>
  23   <LockBucket>
  24     <BucketNo> 36 </BucketNo>
  25     <TotalNodes> 1 </TotalNodes>
  26   <LockBucket>
  27 <Lock Node>
  28   <Tuple> 17e7a034 </Tuple>
  29   <NoOfReaders> -1 </NoOfReaders>
  30   <WaitReaders> 0 </WaitReaders>
  31   <WaitWriters> 0 </WaitWriters>
  32 </Lock Node>
  33   <LockBucket>
  34     <BucketNo> 52 </BucketNo>
  35     <TotalNodes> 1 </TotalNodes>
  36   <LockBucket>
  37 <Lock Node>
  38   <Tuple> 17e7a044 </Tuple>
  39   <NoOfReaders> -1 </NoOfReaders>
  40   <WaitReaders> 0 </WaitReaders>
  41   <WaitWriters> 0 </WaitWriters>
  42 </Lock Node>
  43   <LockBucket>
  44     <BucketNo> 68 </BucketNo>
  45     <TotalNodes> 1 </TotalNodes>
  46   <LockBucket>
  47 <Lock Node>
  48   <Tuple> 17e7a054 </Tuple>
  49   <NoOfReaders> -1 </NoOfReaders>
  50   <WaitReaders> 0 </WaitReaders>
  51   <WaitWriters> 0 </WaitWriters>
  52 </Lock Node>
  53   <LockBucket>
  54     <BucketNo> 84 </BucketNo>
  55     <TotalNodes> 1 </TotalNodes>
  56   <LockBucket>
  57 <Lock Node>
  58   <Tuple> 17e7a064 </Tuple>
  59   <NoOfReaders> -1 </NoOfReaders>
  60   <WaitReaders> 0 </WaitReaders>
  61   <WaitWriters> 0 </WaitWriters>
  62 </Lock Node>
  63   <LockBucket>
  64     <BucketNo> 100 </BucketNo>
  65     <TotalNodes> 1 </TotalNodes>
  66   <LockBucket>
  67 <Lock Node>
  68   <Tuple> 17e7a074 </Tuple>
  69   <NoOfReaders> -1 </NoOfReaders>
  70   <WaitReaders> 0 </WaitReaders>
  71   <WaitWriters> 0 </WaitWriters>
  72 </Lock Node>
  73   <LockBucket>
  74     <BucketNo> 116 </BucketNo>
  75     <TotalNodes> 1 </TotalNodes>
  76   <LockBucket>
  77 <Lock Node>
  78   <Tuple> 17e7a084 </Tuple>
  79   <NoOfReaders> -1 </NoOfReaders>
  80   <WaitReaders> 0 </WaitReaders>
  81   <WaitWriters> 0 </WaitWriters>
  82 </Lock Node>
  83   <LockBucket>
  84     <BucketNo> 132 </BucketNo>
  85     <TotalNodes> 1 </TotalNodes>
  86   <LockBucket>
  87 <Lock Node>
  88   <Tuple> 17e7a094 </Tuple>
  89   <NoOfReaders> -1 </NoOfReaders>
  90   <WaitReaders> 0 </WaitReaders>
  91   <WaitWriters> 0 </WaitWriters>
  92 </Lock Node>
  93   <LockBucket>
  94     <BucketNo> 148 </BucketNo>
  95     <TotalNodes> 1 </TotalNodes>
  96   <LockBucket>
  97 <Lock Node>
  98   <Tuple> 17e7a0a4 </Tuple>
  99   <NoOfReaders> -1 </NoOfReaders>
 100   <WaitReaders> 0 </WaitReaders>
 101   <WaitWriters> 0 </WaitWriters>
 102 </Lock Node>
 103   <LockBucket>
 104     <BucketNo> 164 </BucketNo>
 105     <TotalNodes> 1 </TotalNodes>
 106   <LockBucket>
 107   <TotalUsedBuckets> 10 </TotalUsedBuckets>
 108   <TotalPages> 1 </TotalPages>
 109 </LockTable>
 110 After abort
 111 <LockTable>
 112   <TotalUsedBuckets> 0 </TotalUsedBuckets>
 113   <TotalPages> 1 </TotalPages>
 114 </LockTable>
 115 Table Dropped