1Parsed test spec with 2 sessions 2 3starting permutation: rx1 wy1 c1 rx2 ry2 wx2 c2 4step rx1: SELECT i FROM a WHERE i = 1; 5i 6- 71 8(1 row) 9 10step wy1: INSERT INTO b VALUES (1); 11step c1: COMMIT; 12step rx2: SELECT i FROM a WHERE i = 1; 13i 14- 151 16(1 row) 17 18step ry2: SELECT a_id FROM b WHERE a_id = 1; 19a_id 20---- 21 1 22(1 row) 23 24step wx2: DELETE FROM a WHERE i = 1; 25step c2: COMMIT; 26 27starting permutation: rx1 wy1 rx2 c1 ry2 wx2 c2 28step rx1: SELECT i FROM a WHERE i = 1; 29i 30- 311 32(1 row) 33 34step wy1: INSERT INTO b VALUES (1); 35step rx2: SELECT i FROM a WHERE i = 1; 36i 37- 381 39(1 row) 40 41step c1: COMMIT; 42step ry2: SELECT a_id FROM b WHERE a_id = 1; 43a_id 44---- 45(0 rows) 46 47step wx2: DELETE FROM a WHERE i = 1; 48ERROR: could not serialize access due to read/write dependencies among transactions 49step c2: COMMIT; 50 51starting permutation: rx1 wy1 rx2 ry2 c1 wx2 c2 52step rx1: SELECT i FROM a WHERE i = 1; 53i 54- 551 56(1 row) 57 58step wy1: INSERT INTO b VALUES (1); 59step rx2: SELECT i FROM a WHERE i = 1; 60i 61- 621 63(1 row) 64 65step ry2: SELECT a_id FROM b WHERE a_id = 1; 66a_id 67---- 68(0 rows) 69 70step c1: COMMIT; 71step wx2: DELETE FROM a WHERE i = 1; 72ERROR: could not serialize access due to read/write dependencies among transactions 73step c2: COMMIT; 74 75starting permutation: rx1 wy1 rx2 ry2 wx2 c1 c2 76step rx1: SELECT i FROM a WHERE i = 1; 77i 78- 791 80(1 row) 81 82step wy1: INSERT INTO b VALUES (1); 83step rx2: SELECT i FROM a WHERE i = 1; 84i 85- 861 87(1 row) 88 89step ry2: SELECT a_id FROM b WHERE a_id = 1; 90a_id 91---- 92(0 rows) 93 94step wx2: DELETE FROM a WHERE i = 1; 95step c1: COMMIT; 96step c2: COMMIT; 97ERROR: could not serialize access due to read/write dependencies among transactions 98 99starting permutation: rx1 wy1 rx2 ry2 wx2 c2 c1 100step rx1: SELECT i FROM a WHERE i = 1; 101i 102- 1031 104(1 row) 105 106step wy1: INSERT INTO b VALUES (1); 107step rx2: SELECT i FROM a WHERE i = 1; 108i 109- 1101 111(1 row) 112 113step ry2: SELECT a_id FROM b WHERE a_id = 1; 114a_id 115---- 116(0 rows) 117 118step wx2: DELETE FROM a WHERE i = 1; 119step c2: COMMIT; 120step c1: COMMIT; 121ERROR: could not serialize access due to read/write dependencies among transactions 122 123starting permutation: rx1 rx2 wy1 c1 ry2 wx2 c2 124step rx1: SELECT i FROM a WHERE i = 1; 125i 126- 1271 128(1 row) 129 130step rx2: SELECT i FROM a WHERE i = 1; 131i 132- 1331 134(1 row) 135 136step wy1: INSERT INTO b VALUES (1); 137step c1: COMMIT; 138step ry2: SELECT a_id FROM b WHERE a_id = 1; 139a_id 140---- 141(0 rows) 142 143step wx2: DELETE FROM a WHERE i = 1; 144ERROR: could not serialize access due to read/write dependencies among transactions 145step c2: COMMIT; 146 147starting permutation: rx1 rx2 wy1 ry2 c1 wx2 c2 148step rx1: SELECT i FROM a WHERE i = 1; 149i 150- 1511 152(1 row) 153 154step rx2: SELECT i FROM a WHERE i = 1; 155i 156- 1571 158(1 row) 159 160step wy1: INSERT INTO b VALUES (1); 161step ry2: SELECT a_id FROM b WHERE a_id = 1; 162a_id 163---- 164(0 rows) 165 166step c1: COMMIT; 167step wx2: DELETE FROM a WHERE i = 1; 168ERROR: could not serialize access due to read/write dependencies among transactions 169step c2: COMMIT; 170 171starting permutation: rx1 rx2 wy1 ry2 wx2 c1 c2 172step rx1: SELECT i FROM a WHERE i = 1; 173i 174- 1751 176(1 row) 177 178step rx2: SELECT i FROM a WHERE i = 1; 179i 180- 1811 182(1 row) 183 184step wy1: INSERT INTO b VALUES (1); 185step ry2: SELECT a_id FROM b WHERE a_id = 1; 186a_id 187---- 188(0 rows) 189 190step wx2: DELETE FROM a WHERE i = 1; 191step c1: COMMIT; 192step c2: COMMIT; 193ERROR: could not serialize access due to read/write dependencies among transactions 194 195starting permutation: rx1 rx2 wy1 ry2 wx2 c2 c1 196step rx1: SELECT i FROM a WHERE i = 1; 197i 198- 1991 200(1 row) 201 202step rx2: SELECT i FROM a WHERE i = 1; 203i 204- 2051 206(1 row) 207 208step wy1: INSERT INTO b VALUES (1); 209step ry2: SELECT a_id FROM b WHERE a_id = 1; 210a_id 211---- 212(0 rows) 213 214step wx2: DELETE FROM a WHERE i = 1; 215step c2: COMMIT; 216step c1: COMMIT; 217ERROR: could not serialize access due to read/write dependencies among transactions 218 219starting permutation: rx1 rx2 ry2 wy1 c1 wx2 c2 220step rx1: SELECT i FROM a WHERE i = 1; 221i 222- 2231 224(1 row) 225 226step rx2: SELECT i FROM a WHERE i = 1; 227i 228- 2291 230(1 row) 231 232step ry2: SELECT a_id FROM b WHERE a_id = 1; 233a_id 234---- 235(0 rows) 236 237step wy1: INSERT INTO b VALUES (1); 238step c1: COMMIT; 239step wx2: DELETE FROM a WHERE i = 1; 240ERROR: could not serialize access due to read/write dependencies among transactions 241step c2: COMMIT; 242 243starting permutation: rx1 rx2 ry2 wy1 wx2 c1 c2 244step rx1: SELECT i FROM a WHERE i = 1; 245i 246- 2471 248(1 row) 249 250step rx2: SELECT i FROM a WHERE i = 1; 251i 252- 2531 254(1 row) 255 256step ry2: SELECT a_id FROM b WHERE a_id = 1; 257a_id 258---- 259(0 rows) 260 261step wy1: INSERT INTO b VALUES (1); 262step wx2: DELETE FROM a WHERE i = 1; 263step c1: COMMIT; 264step c2: COMMIT; 265ERROR: could not serialize access due to read/write dependencies among transactions 266 267starting permutation: rx1 rx2 ry2 wy1 wx2 c2 c1 268step rx1: SELECT i FROM a WHERE i = 1; 269i 270- 2711 272(1 row) 273 274step rx2: SELECT i FROM a WHERE i = 1; 275i 276- 2771 278(1 row) 279 280step ry2: SELECT a_id FROM b WHERE a_id = 1; 281a_id 282---- 283(0 rows) 284 285step wy1: INSERT INTO b VALUES (1); 286step wx2: DELETE FROM a WHERE i = 1; 287step c2: COMMIT; 288step c1: COMMIT; 289ERROR: could not serialize access due to read/write dependencies among transactions 290 291starting permutation: rx1 rx2 ry2 wx2 wy1 c1 c2 292step rx1: SELECT i FROM a WHERE i = 1; 293i 294- 2951 296(1 row) 297 298step rx2: SELECT i FROM a WHERE i = 1; 299i 300- 3011 302(1 row) 303 304step ry2: SELECT a_id FROM b WHERE a_id = 1; 305a_id 306---- 307(0 rows) 308 309step wx2: DELETE FROM a WHERE i = 1; 310step wy1: INSERT INTO b VALUES (1); 311step c1: COMMIT; 312step c2: COMMIT; 313ERROR: could not serialize access due to read/write dependencies among transactions 314 315starting permutation: rx1 rx2 ry2 wx2 wy1 c2 c1 316step rx1: SELECT i FROM a WHERE i = 1; 317i 318- 3191 320(1 row) 321 322step rx2: SELECT i FROM a WHERE i = 1; 323i 324- 3251 326(1 row) 327 328step ry2: SELECT a_id FROM b WHERE a_id = 1; 329a_id 330---- 331(0 rows) 332 333step wx2: DELETE FROM a WHERE i = 1; 334step wy1: INSERT INTO b VALUES (1); 335step c2: COMMIT; 336step c1: COMMIT; 337ERROR: could not serialize access due to read/write dependencies among transactions 338 339starting permutation: rx1 rx2 ry2 wx2 c2 wy1 c1 340step rx1: SELECT i FROM a WHERE i = 1; 341i 342- 3431 344(1 row) 345 346step rx2: SELECT i FROM a WHERE i = 1; 347i 348- 3491 350(1 row) 351 352step ry2: SELECT a_id FROM b WHERE a_id = 1; 353a_id 354---- 355(0 rows) 356 357step wx2: DELETE FROM a WHERE i = 1; 358step c2: COMMIT; 359step wy1: INSERT INTO b VALUES (1); 360ERROR: could not serialize access due to read/write dependencies among transactions 361step c1: COMMIT; 362 363starting permutation: rx2 rx1 wy1 c1 ry2 wx2 c2 364step rx2: SELECT i FROM a WHERE i = 1; 365i 366- 3671 368(1 row) 369 370step rx1: SELECT i FROM a WHERE i = 1; 371i 372- 3731 374(1 row) 375 376step wy1: INSERT INTO b VALUES (1); 377step c1: COMMIT; 378step ry2: SELECT a_id FROM b WHERE a_id = 1; 379a_id 380---- 381(0 rows) 382 383step wx2: DELETE FROM a WHERE i = 1; 384ERROR: could not serialize access due to read/write dependencies among transactions 385step c2: COMMIT; 386 387starting permutation: rx2 rx1 wy1 ry2 c1 wx2 c2 388step rx2: SELECT i FROM a WHERE i = 1; 389i 390- 3911 392(1 row) 393 394step rx1: SELECT i FROM a WHERE i = 1; 395i 396- 3971 398(1 row) 399 400step wy1: INSERT INTO b VALUES (1); 401step ry2: SELECT a_id FROM b WHERE a_id = 1; 402a_id 403---- 404(0 rows) 405 406step c1: COMMIT; 407step wx2: DELETE FROM a WHERE i = 1; 408ERROR: could not serialize access due to read/write dependencies among transactions 409step c2: COMMIT; 410 411starting permutation: rx2 rx1 wy1 ry2 wx2 c1 c2 412step rx2: SELECT i FROM a WHERE i = 1; 413i 414- 4151 416(1 row) 417 418step rx1: SELECT i FROM a WHERE i = 1; 419i 420- 4211 422(1 row) 423 424step wy1: INSERT INTO b VALUES (1); 425step ry2: SELECT a_id FROM b WHERE a_id = 1; 426a_id 427---- 428(0 rows) 429 430step wx2: DELETE FROM a WHERE i = 1; 431step c1: COMMIT; 432step c2: COMMIT; 433ERROR: could not serialize access due to read/write dependencies among transactions 434 435starting permutation: rx2 rx1 wy1 ry2 wx2 c2 c1 436step rx2: SELECT i FROM a WHERE i = 1; 437i 438- 4391 440(1 row) 441 442step rx1: SELECT i FROM a WHERE i = 1; 443i 444- 4451 446(1 row) 447 448step wy1: INSERT INTO b VALUES (1); 449step ry2: SELECT a_id FROM b WHERE a_id = 1; 450a_id 451---- 452(0 rows) 453 454step wx2: DELETE FROM a WHERE i = 1; 455step c2: COMMIT; 456step c1: COMMIT; 457ERROR: could not serialize access due to read/write dependencies among transactions 458 459starting permutation: rx2 rx1 ry2 wy1 c1 wx2 c2 460step rx2: SELECT i FROM a WHERE i = 1; 461i 462- 4631 464(1 row) 465 466step rx1: SELECT i FROM a WHERE i = 1; 467i 468- 4691 470(1 row) 471 472step ry2: SELECT a_id FROM b WHERE a_id = 1; 473a_id 474---- 475(0 rows) 476 477step wy1: INSERT INTO b VALUES (1); 478step c1: COMMIT; 479step wx2: DELETE FROM a WHERE i = 1; 480ERROR: could not serialize access due to read/write dependencies among transactions 481step c2: COMMIT; 482 483starting permutation: rx2 rx1 ry2 wy1 wx2 c1 c2 484step rx2: SELECT i FROM a WHERE i = 1; 485i 486- 4871 488(1 row) 489 490step rx1: SELECT i FROM a WHERE i = 1; 491i 492- 4931 494(1 row) 495 496step ry2: SELECT a_id FROM b WHERE a_id = 1; 497a_id 498---- 499(0 rows) 500 501step wy1: INSERT INTO b VALUES (1); 502step wx2: DELETE FROM a WHERE i = 1; 503step c1: COMMIT; 504step c2: COMMIT; 505ERROR: could not serialize access due to read/write dependencies among transactions 506 507starting permutation: rx2 rx1 ry2 wy1 wx2 c2 c1 508step rx2: SELECT i FROM a WHERE i = 1; 509i 510- 5111 512(1 row) 513 514step rx1: SELECT i FROM a WHERE i = 1; 515i 516- 5171 518(1 row) 519 520step ry2: SELECT a_id FROM b WHERE a_id = 1; 521a_id 522---- 523(0 rows) 524 525step wy1: INSERT INTO b VALUES (1); 526step wx2: DELETE FROM a WHERE i = 1; 527step c2: COMMIT; 528step c1: COMMIT; 529ERROR: could not serialize access due to read/write dependencies among transactions 530 531starting permutation: rx2 rx1 ry2 wx2 wy1 c1 c2 532step rx2: SELECT i FROM a WHERE i = 1; 533i 534- 5351 536(1 row) 537 538step rx1: SELECT i FROM a WHERE i = 1; 539i 540- 5411 542(1 row) 543 544step ry2: SELECT a_id FROM b WHERE a_id = 1; 545a_id 546---- 547(0 rows) 548 549step wx2: DELETE FROM a WHERE i = 1; 550step wy1: INSERT INTO b VALUES (1); 551step c1: COMMIT; 552step c2: COMMIT; 553ERROR: could not serialize access due to read/write dependencies among transactions 554 555starting permutation: rx2 rx1 ry2 wx2 wy1 c2 c1 556step rx2: SELECT i FROM a WHERE i = 1; 557i 558- 5591 560(1 row) 561 562step rx1: SELECT i FROM a WHERE i = 1; 563i 564- 5651 566(1 row) 567 568step ry2: SELECT a_id FROM b WHERE a_id = 1; 569a_id 570---- 571(0 rows) 572 573step wx2: DELETE FROM a WHERE i = 1; 574step wy1: INSERT INTO b VALUES (1); 575step c2: COMMIT; 576step c1: COMMIT; 577ERROR: could not serialize access due to read/write dependencies among transactions 578 579starting permutation: rx2 rx1 ry2 wx2 c2 wy1 c1 580step rx2: SELECT i FROM a WHERE i = 1; 581i 582- 5831 584(1 row) 585 586step rx1: SELECT i FROM a WHERE i = 1; 587i 588- 5891 590(1 row) 591 592step ry2: SELECT a_id FROM b WHERE a_id = 1; 593a_id 594---- 595(0 rows) 596 597step wx2: DELETE FROM a WHERE i = 1; 598step c2: COMMIT; 599step wy1: INSERT INTO b VALUES (1); 600ERROR: could not serialize access due to read/write dependencies among transactions 601step c1: COMMIT; 602 603starting permutation: rx2 ry2 rx1 wy1 c1 wx2 c2 604step rx2: SELECT i FROM a WHERE i = 1; 605i 606- 6071 608(1 row) 609 610step ry2: SELECT a_id FROM b WHERE a_id = 1; 611a_id 612---- 613(0 rows) 614 615step rx1: SELECT i FROM a WHERE i = 1; 616i 617- 6181 619(1 row) 620 621step wy1: INSERT INTO b VALUES (1); 622step c1: COMMIT; 623step wx2: DELETE FROM a WHERE i = 1; 624ERROR: could not serialize access due to read/write dependencies among transactions 625step c2: COMMIT; 626 627starting permutation: rx2 ry2 rx1 wy1 wx2 c1 c2 628step rx2: SELECT i FROM a WHERE i = 1; 629i 630- 6311 632(1 row) 633 634step ry2: SELECT a_id FROM b WHERE a_id = 1; 635a_id 636---- 637(0 rows) 638 639step rx1: SELECT i FROM a WHERE i = 1; 640i 641- 6421 643(1 row) 644 645step wy1: INSERT INTO b VALUES (1); 646step wx2: DELETE FROM a WHERE i = 1; 647step c1: COMMIT; 648step c2: COMMIT; 649ERROR: could not serialize access due to read/write dependencies among transactions 650 651starting permutation: rx2 ry2 rx1 wy1 wx2 c2 c1 652step rx2: SELECT i FROM a WHERE i = 1; 653i 654- 6551 656(1 row) 657 658step ry2: SELECT a_id FROM b WHERE a_id = 1; 659a_id 660---- 661(0 rows) 662 663step rx1: SELECT i FROM a WHERE i = 1; 664i 665- 6661 667(1 row) 668 669step wy1: INSERT INTO b VALUES (1); 670step wx2: DELETE FROM a WHERE i = 1; 671step c2: COMMIT; 672step c1: COMMIT; 673ERROR: could not serialize access due to read/write dependencies among transactions 674 675starting permutation: rx2 ry2 rx1 wx2 wy1 c1 c2 676step rx2: SELECT i FROM a WHERE i = 1; 677i 678- 6791 680(1 row) 681 682step ry2: SELECT a_id FROM b WHERE a_id = 1; 683a_id 684---- 685(0 rows) 686 687step rx1: SELECT i FROM a WHERE i = 1; 688i 689- 6901 691(1 row) 692 693step wx2: DELETE FROM a WHERE i = 1; 694step wy1: INSERT INTO b VALUES (1); 695step c1: COMMIT; 696step c2: COMMIT; 697ERROR: could not serialize access due to read/write dependencies among transactions 698 699starting permutation: rx2 ry2 rx1 wx2 wy1 c2 c1 700step rx2: SELECT i FROM a WHERE i = 1; 701i 702- 7031 704(1 row) 705 706step ry2: SELECT a_id FROM b WHERE a_id = 1; 707a_id 708---- 709(0 rows) 710 711step rx1: SELECT i FROM a WHERE i = 1; 712i 713- 7141 715(1 row) 716 717step wx2: DELETE FROM a WHERE i = 1; 718step wy1: INSERT INTO b VALUES (1); 719step c2: COMMIT; 720step c1: COMMIT; 721ERROR: could not serialize access due to read/write dependencies among transactions 722 723starting permutation: rx2 ry2 rx1 wx2 c2 wy1 c1 724step rx2: SELECT i FROM a WHERE i = 1; 725i 726- 7271 728(1 row) 729 730step ry2: SELECT a_id FROM b WHERE a_id = 1; 731a_id 732---- 733(0 rows) 734 735step rx1: SELECT i FROM a WHERE i = 1; 736i 737- 7381 739(1 row) 740 741step wx2: DELETE FROM a WHERE i = 1; 742step c2: COMMIT; 743step wy1: INSERT INTO b VALUES (1); 744ERROR: could not serialize access due to read/write dependencies among transactions 745step c1: COMMIT; 746 747starting permutation: rx2 ry2 wx2 rx1 wy1 c1 c2 748step rx2: SELECT i FROM a WHERE i = 1; 749i 750- 7511 752(1 row) 753 754step ry2: SELECT a_id FROM b WHERE a_id = 1; 755a_id 756---- 757(0 rows) 758 759step wx2: DELETE FROM a WHERE i = 1; 760step rx1: SELECT i FROM a WHERE i = 1; 761i 762- 7631 764(1 row) 765 766step wy1: INSERT INTO b VALUES (1); 767step c1: COMMIT; 768step c2: COMMIT; 769ERROR: could not serialize access due to read/write dependencies among transactions 770 771starting permutation: rx2 ry2 wx2 rx1 wy1 c2 c1 772step rx2: SELECT i FROM a WHERE i = 1; 773i 774- 7751 776(1 row) 777 778step ry2: SELECT a_id FROM b WHERE a_id = 1; 779a_id 780---- 781(0 rows) 782 783step wx2: DELETE FROM a WHERE i = 1; 784step rx1: SELECT i FROM a WHERE i = 1; 785i 786- 7871 788(1 row) 789 790step wy1: INSERT INTO b VALUES (1); 791step c2: COMMIT; 792step c1: COMMIT; 793ERROR: could not serialize access due to read/write dependencies among transactions 794 795starting permutation: rx2 ry2 wx2 rx1 c2 wy1 c1 796step rx2: SELECT i FROM a WHERE i = 1; 797i 798- 7991 800(1 row) 801 802step ry2: SELECT a_id FROM b WHERE a_id = 1; 803a_id 804---- 805(0 rows) 806 807step wx2: DELETE FROM a WHERE i = 1; 808step rx1: SELECT i FROM a WHERE i = 1; 809i 810- 8111 812(1 row) 813 814step c2: COMMIT; 815step wy1: INSERT INTO b VALUES (1); 816ERROR: could not serialize access due to read/write dependencies among transactions 817step c1: COMMIT; 818 819starting permutation: rx2 ry2 wx2 c2 rx1 wy1 c1 820step rx2: SELECT i FROM a WHERE i = 1; 821i 822- 8231 824(1 row) 825 826step ry2: SELECT a_id FROM b WHERE a_id = 1; 827a_id 828---- 829(0 rows) 830 831step wx2: DELETE FROM a WHERE i = 1; 832step c2: COMMIT; 833step rx1: SELECT i FROM a WHERE i = 1; 834i 835- 836(0 rows) 837 838step wy1: INSERT INTO b VALUES (1); 839step c1: COMMIT; 840