test/durability/redologs/exp.test002.ksh

   1 Server Started
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 ---------------------------------------------------------
  12         laks.f1 laks.f2
  13 ---------------------------------------------------------
  14         40      40
  15         50      50
  16
  17 EXECDIRECT SID:1 TID:56 STMT:CREATE TABLE laks(f1 int, f2 int);
  18 PREPARE: SID:2 INSERT INTO laks values (10, 10);
  19 EXEC SID:2 TID:16
  20 FREE SID:2
  21 PREPARE: SID:3 INSERT INTO laks values (20, 20);
  22 EXEC SID:3 TID:16
  23 FREE SID:3
  24 PREPARE: SID:4 INSERT INTO laks values (30, 30);
  25 EXEC SID:4 TID:16
  26 FREE SID:4
  27 PREPARE: SID:5 INSERT INTO laks values (40, 40);
  28 EXEC SID:5 TID:16
  29 FREE SID:5
  30 PREPARE: SID:6 INSERT INTO laks values (50, 50);
  31 EXEC SID:6 TID:16
  32 FREE SID:6
  33 PREPARE: SID:7 UPDATE laks set f2=60 where f1=30;
  34 EXEC SID:7 TID:16
  35 FREE SID:7
  36 PREPARE: SID:8 UPDATE laks set f2=70 where f1=30;
  37 EXEC SID:8 TID:16
  38 FREE SID:8
  39 PREPARE: SID:9 DELETE FROM laks where f1=20;
  40 EXEC SID:9 TID:16
  41 FREE SID:9
  42 Server Killed
  43
  44 Checking Durability
  45 Server Started