*** /home/postgres/pgreleases/postgresql/src/test/regress/expected/tablespace.out 2013-04-05 19:01:06.000000000 -0500 --- /home/postgres/pgreleases/postgresql/src/test/regress/results/tablespace.out 2013-04-05 19:01:19.000000000 -0500 *************** *** 54,68 **** ALTER TABLE testschema.atable SET TABLESPACE testspace; ALTER INDEX testschema.anindex SET TABLESPACE testspace; INSERT INTO testschema.atable VALUES(3); -- ok INSERT INTO testschema.atable VALUES(1); -- fail (checks index) ! ERROR: duplicate key value violates unique constraint "anindex" ! DETAIL: Key (column1)=(1) already exists. SELECT COUNT(*) FROM testschema.atable; -- checks heap ! count ! ------- ! 3 ! (1 row) ! -- Will fail with bad path CREATE TABLESPACE badspace LOCATION '/no/such/location'; ERROR: directory "/no/such/location" does not exist --- 54,67 ---- ALTER TABLE testschema.atable SET TABLESPACE testspace; ALTER INDEX testschema.anindex SET TABLESPACE testspace; INSERT INTO testschema.atable VALUES(3); -- ok + WARNING: page verification failed, calculated checksum 24379 but expected 47546 + ERROR: invalid page in block 0 of relation pg_tblspc/16385/PG_9.3_201304051/16384/16401 INSERT INTO testschema.atable VALUES(1); -- fail (checks index) ! WARNING: page verification failed, calculated checksum 24379 but expected 47546 ! ERROR: invalid page in block 0 of relation pg_tblspc/16385/PG_9.3_201304051/16384/16401 SELECT COUNT(*) FROM testschema.atable; -- checks heap ! WARNING: page verification failed, calculated checksum 3350 but expected 53384 ! ERROR: invalid page in block 0 of relation pg_tblspc/16385/PG_9.3_201304051/16384/16402 -- Will fail with bad path CREATE TABLESPACE badspace LOCATION '/no/such/location'; ERROR: directory "/no/such/location" does not exist ====================================================================== *** /home/postgres/pgreleases/postgresql/src/test/regress/expected/vacuum.out 2013-04-04 11:20:41.000000000 -0500 --- /home/postgres/pgreleases/postgresql/src/test/regress/results/vacuum.out 2013-04-05 19:02:24.000000000 -0500 *************** *** 30,71 **** VACUUM FULL vactst; UPDATE vactst SET i = i + 1; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst VALUES (0); SELECT count(*) FROM vactst; ! count ! ------- ! 2049 ! (1 row) ! DELETE FROM vactst WHERE i != 0; VACUUM (FULL) vactst; DELETE FROM vactst; SELECT * FROM vactst; ! i ! --- ! (0 rows) ! VACUUM (FULL, FREEZE) vactst; VACUUM (ANALYZE, FULL) vactst; CREATE TABLE vaccluster (i INT PRIMARY KEY); ALTER TABLE vaccluster CLUSTER ON vaccluster_pkey; INSERT INTO vaccluster SELECT * FROM vactst; CLUSTER vaccluster; VACUUM FULL pg_am; VACUUM FULL pg_class; VACUUM FULL pg_database; VACUUM FULL vaccluster; VACUUM FULL vactst; DROP TABLE vaccluster; DROP TABLE vactst; --- 30,113 ---- VACUUM FULL vactst; UPDATE vactst SET i = i + 1; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 INSERT INTO vactst VALUES (0); + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 SELECT count(*) FROM vactst; ! WARNING: page verification failed, calculated checksum 9180 but expected 43354 ! ERROR: invalid page in block 0 of relation base/16384/28643 DELETE FROM vactst WHERE i != 0; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 VACUUM (FULL) vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 DELETE FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 SELECT * FROM vactst; ! WARNING: page verification failed, calculated checksum 9180 but expected 43354 ! ERROR: invalid page in block 0 of relation base/16384/28643 VACUUM (FULL, FREEZE) vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 VACUUM (ANALYZE, FULL) vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 CREATE TABLE vaccluster (i INT PRIMARY KEY); ALTER TABLE vaccluster CLUSTER ON vaccluster_pkey; INSERT INTO vaccluster SELECT * FROM vactst; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 CLUSTER vaccluster; VACUUM FULL pg_am; + WARNING: page verification failed, calculated checksum 37138 but expected 6194 + ERROR: invalid page in block 0 of relation base/16384/28664 VACUUM FULL pg_class; + WARNING: page verification failed, calculated checksum 12202 but expected 40441 + ERROR: invalid page in block 0 of relation base/16384/28667 VACUUM FULL pg_database; + ERROR: could not read block 4 in file "base/16384/28667": read only 0 of 8192 bytes VACUUM FULL vaccluster; + ERROR: could not read block 15 in file "base/16384/28667": read only 0 of 8192 bytes VACUUM FULL vactst; + ERROR: could not read block 15 in file "base/16384/28667": read only 0 of 8192 bytes DROP TABLE vaccluster; + ERROR: could not read block 15 in file "base/16384/28667": read only 0 of 8192 bytes DROP TABLE vactst; + ERROR: could not read block 15 in file "base/16384/28667": read only 0 of 8192 bytes ====================================================================== *** /home/postgres/pgreleases/postgresql/src/test/regress/expected/sanity_check.out 2013-04-04 11:20:41.000000000 -0500 --- /home/postgres/pgreleases/postgresql/src/test/regress/results/sanity_check.out 2013-04-05 19:02:30.000000000 -0500 *************** *** 1,4 **** --- 1,6 ---- VACUUM; + WARNING: page verification failed, calculated checksum 9180 but expected 43354 + ERROR: invalid page in block 0 of relation base/16384/28643 -- -- sanity check, if we don't have indices the test will take years to -- complete. But skip TOAST relations (since they will have varying *************** *** 165,172 **** timestamptz_tbl | f timetz_tbl | f tinterval_tbl | f varchar_tbl | f ! (155 rows) -- -- another sanity check: every system catalog that has OIDs should have --- 167,176 ---- timestamptz_tbl | f timetz_tbl | f tinterval_tbl | f + vaccluster | t + vactst | f varchar_tbl | f ! (157 rows) -- -- another sanity check: every system catalog that has OIDs should have ====================================================================== *** /home/postgres/pgreleases/postgresql/src/test/regress/expected/misc.out 2013-04-05 19:01:06.000000000 -0500 --- /home/postgres/pgreleases/postgresql/src/test/regress/results/misc.out 2013-04-05 19:02:55.000000000 -0500 *************** *** 694,702 **** tvv tvvm tvvmv varchar_tbl xacttest ! (118 rows) SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))); name --- 694,704 ---- tvv tvvm tvvmv + vaccluster + vactst varchar_tbl xacttest ! (120 rows) SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))); name ====================================================================== *** /home/postgres/pgreleases/postgresql/src/test/regress/expected/cluster.out 2013-04-04 11:20:41.000000000 -0500 --- /home/postgres/pgreleases/postgresql/src/test/regress/results/cluster.out 2013-04-05 19:03:20.000000000 -0500 *************** *** 53,93 **** -- This entry is needed to test that TOASTED values are copied correctly. INSERT INTO clstr_tst (b, c, d) VALUES (6, 'seis', repeat('xyzzy', 100000)); CLUSTER clstr_tst_c ON clstr_tst; SELECT a,b,c,substring(d for 30), length(d) from clstr_tst; a | b | c | substring | length ----+----+---------------+--------------------------------+-------- - 10 | 14 | catorce | | - 18 | 5 | cinco | | - 9 | 4 | cuatro | | - 26 | 19 | diecinueve | | - 12 | 18 | dieciocho | | - 30 | 16 | dieciseis | | - 24 | 17 | diecisiete | | - 2 | 10 | diez | | - 23 | 12 | doce | | - 11 | 2 | dos | | - 25 | 9 | nueve | | - 31 | 8 | ocho | | 1 | 11 | once | | ! 28 | 15 | quince | | ! 32 | 6 | seis | xyzzyxyzzyxyzzyxyzzyxyzzyxyzzy | 500000 ! 29 | 7 | siete | | ! 15 | 13 | trece | | ! 22 | 30 | treinta | | ! 17 | 32 | treinta y dos | | 3 | 31 | treinta y uno | | 5 | 3 | tres | | - 20 | 1 | uno | | 6 | 20 | veinte | | 14 | 25 | veinticinco | | ! 21 | 24 | veinticuatro | | ! 4 | 22 | veintidos | | ! 19 | 29 | veintinueve | | 16 | 28 | veintiocho | | 27 | 26 | veintiseis | | ! 13 | 27 | veintisiete | | ! 7 | 23 | veintitres | | ! 8 | 21 | veintiuno | | (32 rows) SELECT a,b,c,substring(d for 30), length(d) from clstr_tst ORDER BY a; --- 53,95 ---- -- This entry is needed to test that TOASTED values are copied correctly. INSERT INTO clstr_tst (b, c, d) VALUES (6, 'seis', repeat('xyzzy', 100000)); CLUSTER clstr_tst_c ON clstr_tst; + WARNING: page verification failed, calculated checksum 2699 but expected 58989 + ERROR: invalid page in block 0 of relation base/16384/31148 SELECT a,b,c,substring(d for 30), length(d) from clstr_tst; a | b | c | substring | length ----+----+---------------+--------------------------------+-------- 1 | 11 | once | | ! 2 | 10 | diez | | 3 | 31 | treinta y uno | | + 4 | 22 | veintidos | | 5 | 3 | tres | | 6 | 20 | veinte | | + 7 | 23 | veintitres | | + 8 | 21 | veintiuno | | + 9 | 4 | cuatro | | + 10 | 14 | catorce | | + 11 | 2 | dos | | + 12 | 18 | dieciocho | | + 13 | 27 | veintisiete | | 14 | 25 | veinticinco | | ! 15 | 13 | trece | | 16 | 28 | veintiocho | | + 17 | 32 | treinta y dos | | + 18 | 5 | cinco | | + 19 | 29 | veintinueve | | + 20 | 1 | uno | | + 21 | 24 | veinticuatro | | + 22 | 30 | treinta | | + 23 | 12 | doce | | + 24 | 17 | diecisiete | | + 25 | 9 | nueve | | + 26 | 19 | diecinueve | | 27 | 26 | veintiseis | | ! 28 | 15 | quince | | ! 29 | 7 | siete | | ! 30 | 16 | dieciseis | | ! 31 | 8 | ocho | | ! 32 | 6 | seis | xyzzyxyzzyxyzzyxyzzyxyzzyxyzzy | 500000 (32 rows) SELECT a,b,c,substring(d for 30), length(d) from clstr_tst ORDER BY a; *************** *** 206,243 **** SELECT a,b,c,substring(d for 30), length(d) from clstr_tst; a | b | c | substring | length ----+-----+----------------+--------------------------------+-------- - 10 | 14 | catorce | | - 18 | 5 | cinco | | - 9 | 4 | cuatro | | - 26 | 19 | diecinueve | | - 12 | 18 | dieciocho | | - 30 | 16 | dieciseis | | - 24 | 17 | diecisiete | | - 2 | 10 | diez | | - 23 | 12 | doce | | - 11 | 2 | dos | | - 25 | 9 | nueve | | - 31 | 8 | ocho | | 1 | 11 | once | | ! 28 | 15 | quince | | ! 32 | 6 | seis | xyzzyxyzzyxyzzyxyzzyxyzzyxyzzy | 500000 ! 29 | 7 | siete | | ! 15 | 13 | trece | | ! 22 | 30 | treinta | | ! 17 | 32 | treinta y dos | | 3 | 31 | treinta y uno | | 5 | 3 | tres | | - 20 | 1 | uno | | 6 | 20 | veinte | | 14 | 25 | veinticinco | | ! 21 | 24 | veinticuatro | | ! 4 | 22 | veintidos | | ! 19 | 29 | veintinueve | | 16 | 28 | veintiocho | | 27 | 26 | veintiseis | | ! 13 | 27 | veintisiete | | ! 7 | 23 | veintitres | | ! 8 | 21 | veintiuno | | 0 | 100 | in child table | | (33 rows) --- 208,245 ---- SELECT a,b,c,substring(d for 30), length(d) from clstr_tst; a | b | c | substring | length ----+-----+----------------+--------------------------------+-------- 1 | 11 | once | | ! 2 | 10 | diez | | 3 | 31 | treinta y uno | | + 4 | 22 | veintidos | | 5 | 3 | tres | | 6 | 20 | veinte | | + 7 | 23 | veintitres | | + 8 | 21 | veintiuno | | + 9 | 4 | cuatro | | + 10 | 14 | catorce | | + 11 | 2 | dos | | + 12 | 18 | dieciocho | | + 13 | 27 | veintisiete | | 14 | 25 | veinticinco | | ! 15 | 13 | trece | | 16 | 28 | veintiocho | | + 17 | 32 | treinta y dos | | + 18 | 5 | cinco | | + 19 | 29 | veintinueve | | + 20 | 1 | uno | | + 21 | 24 | veinticuatro | | + 22 | 30 | treinta | | + 23 | 12 | doce | | + 24 | 17 | diecisiete | | + 25 | 9 | nueve | | + 26 | 19 | diecinueve | | 27 | 26 | veintiseis | | ! 28 | 15 | quince | | ! 29 | 7 | siete | | ! 30 | 16 | dieciseis | | ! 31 | 8 | ocho | | ! 32 | 6 | seis | xyzzyxyzzyxyzzyxyzzyxyzzyxyzzy | 500000 0 | 100 | in child table | | (33 rows) *************** *** 277,286 **** AND indrelid=pg_class_2.oid AND pg_class_2.relname = 'clstr_tst' AND indisclustered; ! relname ! ------------- ! clstr_tst_c ! (1 row) -- Try changing indisclustered ALTER TABLE clstr_tst CLUSTER ON clstr_tst_b_c; --- 279,287 ---- AND indrelid=pg_class_2.oid AND pg_class_2.relname = 'clstr_tst' AND indisclustered; ! relname ! --------- ! (0 rows) -- Try changing indisclustered ALTER TABLE clstr_tst CLUSTER ON clstr_tst_b_c; *************** *** 323,338 **** CLUSTER clstr_2; ERROR: there is no previously clustered index for table "clstr_2" CLUSTER clstr_1_pkey ON clstr_1; CLUSTER clstr_2 USING clstr_2_pkey; SELECT * FROM clstr_1 UNION ALL SELECT * FROM clstr_2 UNION ALL SELECT * FROM clstr_3; a --- - 1 2 1 2 2 1 (6 rows) --- 324,343 ---- CLUSTER clstr_2; ERROR: there is no previously clustered index for table "clstr_2" CLUSTER clstr_1_pkey ON clstr_1; + WARNING: page verification failed, calculated checksum 24058 but expected 20177 + ERROR: invalid page in block 0 of relation base/16384/31171 CLUSTER clstr_2 USING clstr_2_pkey; + WARNING: page verification failed, calculated checksum 20567 but expected 22105 + ERROR: invalid page in block 0 of relation base/16384/31175 SELECT * FROM clstr_1 UNION ALL SELECT * FROM clstr_2 UNION ALL SELECT * FROM clstr_3; a --- 2 1 2 + 1 2 1 (6 rows) *************** *** 356,363 **** SELECT * FROM clstr_3; a --- - 1 2 2 1 2 --- 361,368 ---- SELECT * FROM clstr_3; a --- 2 + 1 2 1 2 *************** *** 369,379 **** INSERT INTO clstr_1 VALUES (2); INSERT INTO clstr_1 VALUES (1); CLUSTER clstr_1; SELECT * FROM clstr_1; a --- - 1 2 (2 rows) -- Test MVCC-safety of cluster. There isn't much we can do to verify the --- 374,385 ---- INSERT INTO clstr_1 VALUES (2); INSERT INTO clstr_1 VALUES (1); CLUSTER clstr_1; + ERROR: there is no previously clustered index for table "clstr_1" SELECT * FROM clstr_1; a --- 2 + 1 (2 rows) -- Test MVCC-safety of cluster. There isn't much we can do to verify the *************** *** 405,429 **** (5 rows) CLUSTER clustertest_pkey ON clustertest; SELECT * FROM clustertest; ! key ! ----- ! 20 ! 30 ! 35 ! 80 ! 100 ! (5 rows) ! COMMIT; SELECT * FROM clustertest; key ----- 20 30 ! 35 ! 80 ! 100 (5 rows) -- check that temp tables can be clustered --- 411,429 ---- (5 rows) CLUSTER clustertest_pkey ON clustertest; + WARNING: page verification failed, calculated checksum 23239 but expected 48707 + ERROR: invalid page in block 0 of relation base/16384/31184 SELECT * FROM clustertest; ! ERROR: current transaction is aborted, commands ignored until end of transaction block COMMIT; SELECT * FROM clustertest; key ----- + 10 20 30 ! 40 ! 50 (5 rows) -- check that temp tables can be clustered ======================================================================