test/system/lock/exp.test002a

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