test/tools/Durability/exp.test011.ksh

   1 Durablity = TRUE
   2 Server Started
   3 CREATING TABLE
   4 echo CREATE TABLE T1(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
   5 Statement Executed
   6 echo CREATE TABLE T2(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
   7 Statement Executed
   8 echo CREATE TABLE T3(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
   9 Statement Executed
  10 echo CREATE TABLE T4(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  11 Statement Executed
  12 echo CREATE TABLE T5(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  13 Statement Executed
  14 echo CREATE TABLE T6(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  15 Statement Executed
  16 echo CREATE TABLE T7(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  17 Statement Executed
  18 echo CREATE TABLE T8(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  19 Statement Executed
  20 echo CREATE TABLE T9(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  21 Statement Executed
  22 echo CREATE TABLE T10(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10));
  23 Statement Executed
  24 Server Killed
  25 count=1
  26 Durablity = TRUE
  27 Checking Durability
  28 Server Started
  29 Durability Works Fine
  30 INSERTING INTO TABLE
  31 echo CREATE INDEX idx1 ON T1(f2,f1) UNIQUE;
  32 Statement Executed
  33 echo CREATE INDEX idx2 ON T2(f2,f1) UNIQUE;
  34 Statement Executed
  35 echo CREATE INDEX idx3 ON T3(f2,f1) UNIQUE;
  36 Statement Executed
  37 echo CREATE INDEX idx4 ON T4(f2,f1) UNIQUE;
  38 Statement Executed
  39 echo CREATE INDEX idx5 ON T5(f2,f1) UNIQUE;
  40 Statement Executed
  41 echo CREATE INDEX idx6 ON T6(f2,f1) UNIQUE;
  42 Statement Executed
  43 echo CREATE INDEX idx7 ON T7(f2,f1) UNIQUE;
  44 Statement Executed
  45 echo CREATE INDEX idx8 ON T8(f2,f1) UNIQUE;
  46 Statement Executed
  47 echo CREATE INDEX idx9 ON T9(f2,f1) UNIQUE;
  48 Statement Executed
  49 echo CREATE INDEX idx10 ON T10(f2,f1) UNIQUE;
  50 Statement Executed
  51 Server Killed
  52 count=2
  53 Durablity = TRUE
  54 Checking Durability
  55 Server Started
  56 Durability Works Fine
  57 INSERTING INTO TABLE
  58 echo INSERT INTO T1 VALUES(1, 10, 101, 101.101, 'Lakshya');
  59 Statement Executed: Rows Affected = 1
  60 echo INSERT INTO T1 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  61 Statement Executed: Rows Affected = 1
  62 echo INSERT INTO T1 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  63 Statement execute failed with error -21
  64 echo INSERT INTO T1 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  65 Statement execute failed with error -21
  66 echo INSERT INTO T1 VALUES(2, 20, 201, 101.101, 'Lakshya');
  67 Statement Executed: Rows Affected = 1
  68 echo INSERT INTO T1 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  69 Statement Executed: Rows Affected = 1
  70 echo INSERT INTO T1 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
  71 Statement execute failed with error -21
  72 echo INSERT INTO T1 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  73 Statement execute failed with error -21
  74 echo INSERT INTO T2 VALUES(1, 10, 101, 101.101, 'Lakshya');
  75 Statement Executed: Rows Affected = 1
  76 echo INSERT INTO T2 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  77 Statement Executed: Rows Affected = 1
  78 echo INSERT INTO T2 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  79 Statement execute failed with error -21
  80 echo INSERT INTO T2 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  81 Statement execute failed with error -21
  82 echo INSERT INTO T2 VALUES(2, 20, 201, 101.101, 'Lakshya');
  83 Statement Executed: Rows Affected = 1
  84 echo INSERT INTO T2 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  85 Statement Executed: Rows Affected = 1
  86 echo INSERT INTO T2 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
  87 Statement execute failed with error -21
  88 echo INSERT INTO T2 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  89 Statement execute failed with error -21
  90 echo INSERT INTO T3 VALUES(1, 10, 101, 101.101, 'Lakshya');
  91 Statement Executed: Rows Affected = 1
  92 echo INSERT INTO T3 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  93 Statement Executed: Rows Affected = 1
  94 echo INSERT INTO T3 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  95 Statement execute failed with error -21
  96 echo INSERT INTO T3 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  97 Statement execute failed with error -21
  98 echo INSERT INTO T3 VALUES(2, 20, 201, 101.101, 'Lakshya');
  99 Statement Executed: Rows Affected = 1
 100 echo INSERT INTO T3 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 101 Statement Executed: Rows Affected = 1
 102 echo INSERT INTO T3 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 103 Statement execute failed with error -21
 104 echo INSERT INTO T3 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 105 Statement execute failed with error -21
 106 echo INSERT INTO T4 VALUES(1, 10, 101, 101.101, 'Lakshya');
 107 Statement Executed: Rows Affected = 1
 108 echo INSERT INTO T4 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 109 Statement Executed: Rows Affected = 1
 110 echo INSERT INTO T4 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 111 Statement execute failed with error -21
 112 echo INSERT INTO T4 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 113 Statement execute failed with error -21
 114 echo INSERT INTO T4 VALUES(2, 20, 201, 101.101, 'Lakshya');
 115 Statement Executed: Rows Affected = 1
 116 echo INSERT INTO T4 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 117 Statement Executed: Rows Affected = 1
 118 echo INSERT INTO T4 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 119 Statement execute failed with error -21
 120 echo INSERT INTO T4 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 121 Statement execute failed with error -21
 122 echo INSERT INTO T5 VALUES(1, 10, 101, 101.101, 'Lakshya');
 123 Statement Executed: Rows Affected = 1
 124 echo INSERT INTO T5 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 125 Statement Executed: Rows Affected = 1
 126 echo INSERT INTO T5 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 127 Statement execute failed with error -21
 128 echo INSERT INTO T5 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 129 Statement execute failed with error -21
 130 echo INSERT INTO T5 VALUES(2, 20, 201, 101.101, 'Lakshya');
 131 Statement Executed: Rows Affected = 1
 132 echo INSERT INTO T5 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 133 Statement Executed: Rows Affected = 1
 134 echo INSERT INTO T5 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 135 Statement execute failed with error -21
 136 echo INSERT INTO T5 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 137 Statement execute failed with error -21
 138 echo INSERT INTO T6 VALUES(1, 10, 101, 101.101, 'Lakshya');
 139 Statement Executed: Rows Affected = 1
 140 echo INSERT INTO T6 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 141 Statement Executed: Rows Affected = 1
 142 echo INSERT INTO T6 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 143 Statement execute failed with error -21
 144 echo INSERT INTO T6 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 145 Statement execute failed with error -21
 146 echo INSERT INTO T6 VALUES(2, 20, 201, 101.101, 'Lakshya');
 147 Statement Executed: Rows Affected = 1
 148 echo INSERT INTO T6 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 149 Statement Executed: Rows Affected = 1
 150 echo INSERT INTO T6 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 151 Statement execute failed with error -21
 152 echo INSERT INTO T6 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 153 Statement execute failed with error -21
 154 echo INSERT INTO T7 VALUES(1, 10, 101, 101.101, 'Lakshya');
 155 Statement Executed: Rows Affected = 1
 156 echo INSERT INTO T7 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 157 Statement Executed: Rows Affected = 1
 158 echo INSERT INTO T7 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 159 Statement execute failed with error -21
 160 echo INSERT INTO T7 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 161 Statement execute failed with error -21
 162 echo INSERT INTO T7 VALUES(2, 20, 201, 101.101, 'Lakshya');
 163 Statement Executed: Rows Affected = 1
 164 echo INSERT INTO T7 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 165 Statement Executed: Rows Affected = 1
 166 echo INSERT INTO T7 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 167 Statement execute failed with error -21
 168 echo INSERT INTO T7 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 169 Statement execute failed with error -21
 170 echo INSERT INTO T8 VALUES(1, 10, 101, 101.101, 'Lakshya');
 171 Statement Executed: Rows Affected = 1
 172 echo INSERT INTO T8 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 173 Statement Executed: Rows Affected = 1
 174 echo INSERT INTO T8 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 175 Statement execute failed with error -21
 176 echo INSERT INTO T8 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 177 Statement execute failed with error -21
 178 echo INSERT INTO T8 VALUES(2, 20, 201, 101.101, 'Lakshya');
 179 Statement Executed: Rows Affected = 1
 180 echo INSERT INTO T8 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 181 Statement Executed: Rows Affected = 1
 182 echo INSERT INTO T8 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 183 Statement execute failed with error -21
 184 echo INSERT INTO T8 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 185 Statement execute failed with error -21
 186 echo INSERT INTO T9 VALUES(1, 10, 101, 101.101, 'Lakshya');
 187 Statement Executed: Rows Affected = 1
 188 echo INSERT INTO T9 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 189 Statement Executed: Rows Affected = 1
 190 echo INSERT INTO T9 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 191 Statement execute failed with error -21
 192 echo INSERT INTO T9 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 193 Statement execute failed with error -21
 194 echo INSERT INTO T9 VALUES(2, 20, 201, 101.101, 'Lakshya');
 195 Statement Executed: Rows Affected = 1
 196 echo INSERT INTO T9 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 197 Statement Executed: Rows Affected = 1
 198 echo INSERT INTO T9 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 199 Statement execute failed with error -21
 200 echo INSERT INTO T9 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 201 Statement execute failed with error -21
 202 echo INSERT INTO T10 VALUES(1, 10, 101, 101.101, 'Lakshya');
 203 Statement Executed: Rows Affected = 1
 204 echo INSERT INTO T10 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 205 Statement Executed: Rows Affected = 1
 206 echo INSERT INTO T10 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 207 Statement execute failed with error -21
 208 echo INSERT INTO T10 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 209 Statement execute failed with error -21
 210 echo INSERT INTO T10 VALUES(2, 20, 201, 101.101, 'Lakshya');
 211 Statement Executed: Rows Affected = 1
 212 echo INSERT INTO T10 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 213 Statement Executed: Rows Affected = 1
 214 echo INSERT INTO T10 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 215 Statement execute failed with error -21
 216 echo INSERT INTO T10 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 217 Statement execute failed with error -21
 218 Server Killed
 219 count=3
 220 Durablity = TRUE
 221 Checking Durability
 222 Server Started
 223 Durability Works Fine
 224 UPDATING RECORDS IN TABLE
 225 echo UPDATE T1 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 226 Statement Executed: Rows Affected = 2
 227 echo UPDATE T1 SET f1=3 WHERE f1=2;
 228 Statement prepare failed with error -21
 229 echo UPDATE T2 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 230 Statement Executed: Rows Affected = 2
 231 echo UPDATE T2 SET f1=3 WHERE f1=2;
 232 Statement prepare failed with error -21
 233 echo UPDATE T3 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 234 Statement Executed: Rows Affected = 2
 235 echo UPDATE T3 SET f1=3 WHERE f1=2;
 236 Statement prepare failed with error -21
 237 echo UPDATE T4 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 238 Statement Executed: Rows Affected = 2
 239 echo UPDATE T4 SET f1=3 WHERE f1=2;
 240 Statement prepare failed with error -21
 241 echo UPDATE T5 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 242 Statement Executed: Rows Affected = 2
 243 echo UPDATE T5 SET f1=3 WHERE f1=2;
 244 Statement prepare failed with error -21
 245 echo UPDATE T6 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 246 Statement Executed: Rows Affected = 2
 247 echo UPDATE T6 SET f1=3 WHERE f1=2;
 248 Statement prepare failed with error -21
 249 echo UPDATE T7 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 250 Statement Executed: Rows Affected = 2
 251 echo UPDATE T7 SET f1=3 WHERE f1=2;
 252 Statement prepare failed with error -21
 253 echo UPDATE T8 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 254 Statement Executed: Rows Affected = 2
 255 echo UPDATE T8 SET f1=3 WHERE f1=2;
 256 Statement prepare failed with error -21
 257 echo UPDATE T9 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 258 Statement Executed: Rows Affected = 2
 259 echo UPDATE T9 SET f1=3 WHERE f1=2;
 260 Statement prepare failed with error -21
 261 echo UPDATE T10 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 262 Statement Executed: Rows Affected = 2
 263 echo UPDATE T10 SET f1=3 WHERE f1=2;
 264 Statement prepare failed with error -21
 265 Server Killed
 266 count=4
 267 Durablity = TRUE
 268 Checking Durability
 269 Server Started
 270 Durability Works Fine
 271 DELETING RECORDS FROM TABLE
 272 echo DELETE FROM T1 WHERE f1 = 1;
 273 Statement Executed: Rows Affected = 2
 274 echo DELETE FROM T2 WHERE f1 = 1;
 275 Statement Executed: Rows Affected = 2
 276 echo DELETE FROM T3 WHERE f1 = 1;
 277 Statement Executed: Rows Affected = 2
 278 echo DELETE FROM T4 WHERE f1 = 1;
 279 Statement Executed: Rows Affected = 2
 280 echo DELETE FROM T5 WHERE f1 = 1;
 281 Statement Executed: Rows Affected = 2
 282 echo DELETE FROM T6 WHERE f1 = 1;
 283 Statement Executed: Rows Affected = 2
 284 echo DELETE FROM T7 WHERE f1 = 1;
 285 Statement Executed: Rows Affected = 2
 286 echo DELETE FROM T8 WHERE f1 = 1;
 287 Statement Executed: Rows Affected = 2
 288 echo DELETE FROM T9 WHERE f1 = 1;
 289 Statement Executed: Rows Affected = 2
 290 echo DELETE FROM T10 WHERE f1 = 1;
 291 Statement Executed: Rows Affected = 2
 292 Server Killed
 293 count=5
 294 Durablity = TRUE
 295 Checking Durability
 296 Server Started
 297 Durability Works Fine
 298 DROPPING TABLE
 299 echo DROP TABLE T1;
 300 Statement Executed
 301 echo DROP TABLE T2;
 302 Statement Executed
 303 echo DROP TABLE T3;
 304 Statement Executed
 305 echo DROP TABLE T4;
 306 Statement Executed
 307 echo DROP TABLE T5;
 308 Statement Executed
 309 echo DROP TABLE T6;
 310 Statement Executed
 311 echo DROP TABLE T7;
 312 Statement Executed
 313 echo DROP TABLE T8;
 314 Statement Executed
 315 echo DROP TABLE T9;
 316 Statement Executed
 317 echo DROP TABLE T10;
 318 Statement Executed