10beta1 sequence regression failure on sparc64
The sequence regression tests are failing on Debian/sparc64:
sequence ... FAILED
polymorphism ... ok
rowtypes ... ok
returning ... ok
largeobject ... ok
with ... ok
xml ... ok
test identity ... ok
test event_trigger ... ok
test stats ... ok
============== shutting down postmaster ==============
========================
1 of 178 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/<<PKGBUILDDIR>>/build/src/test/regress/regression.diffs". A copy of the test summary that you see
above is saved in the file "/<<PKGBUILDDIR>>/build/src/test/regress/regression.out".
GNUmakefile:130: recipe for target 'check' failed
make[2]: *** [check] Error 1
make[2]: Leaving directory '/<<PKGBUILDDIR>>/build/src/test/regress'
Makefile:28: recipe for target 'check-regress-recurse' failed
make[1]: *** [check-regress-recurse] Error 2
make[1]: Leaving directory '/<<PKGBUILDDIR>>/build/src/test'
GNUmakefile:69: recipe for target 'check-world-src/test-recurse' failed
make: *** [check-world-src/test-recurse] Error 2
make: Leaving directory '/<<PKGBUILDDIR>>/build'
******** build/src/test/regress/regression.diffs ********
*** 477,485 ****
------------------+-----------------+--------------------+-----------+-------------------+-------------------------+---------------+-------------+----------------------+---------------------+-----------+--------------
regression | public | sequence_test10 | smallint | 16 | 2 | 0 | 1 | -20000 | 32767 | 1 | NO
regression | public | sequence_test11 | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
! regression | public | sequence_test12 | integer | 32 | 2 | 0 | -1 | -2147483648 | -1 | -1 | NO
! regression | public | sequence_test13 | integer | 32 | 2 | 0 | -32768 | -2147483648 | 2147483647 | 1 | NO
! regression | public | sequence_test14 | integer | 32 | 2 | 0 | 32767 | -2147483648 | 2147483647 | -1 | NO
regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES
regression | public | sequence_test3 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test4 | bigint | 64 | 2 | 0 | -1 | -9223372036854775808 | -1 | -1 | NO
--- 484,490 ----
------------------+-----------------+--------------------+-----------+-------------------+-------------------------+---------------+-------------+----------------------+---------------------+-----------+--------------
regression | public | sequence_test10 | smallint | 16 | 2 | 0 | 1 | -20000 | 32767 | 1 | NO
regression | public | sequence_test11 | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
! regression | public | sequence_test13 | smallint | 16 | 2 | 0 | -32768 | -32768 | 32767 | 1 | NO
regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES
regression | public | sequence_test3 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test4 | bigint | 64 | 2 | 0 | -1 | -9223372036854775808 | -1 | -1 | NO
***************
*** 487,500 ****
regression | public | sequence_test6 | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | sequence_test7 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test8 | smallint | 16 | 2 | 0 | 1 | 1 | 20000 | 1 | NO
- regression | public | sequence_test9 | smallint | 16 | 2 | 0 | -1 | -32768 | -1 | -1 | NO
regression | public | serialtest1_f2_foo | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f2_seq | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f3_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f4_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f5_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | serialtest2_f6_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
! (19 rows) SELECT schemaname, sequencename, start_value, min_value, max_value, increment_by, cycle, cache_size, last_value
FROM pg_sequences
--- 492,504 ----
regression | public | sequence_test6 | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | sequence_test7 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test8 | smallint | 16 | 2 | 0 | 1 | 1 | 20000 | 1 | NO
regression | public | serialtest1_f2_foo | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f2_seq | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f3_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f4_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f5_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | serialtest2_f6_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
! (16 rows) SELECT schemaname, sequencename, start_value, min_value, max_value, increment_by, cycle, cache_size, last_value
FROM pg_sequences
***************
*** 504,512 ****
------------+--------------------+-------------+----------------------+---------------------+--------------+-------+------------+------------
public | sequence_test10 | 1 | -20000 | 32767 | 1 | f | 1 |
public | sequence_test11 | 1 | 1 | 2147483647 | 1 | f | 1 |
! public | sequence_test12 | -1 | -2147483648 | -1 | -1 | f | 1 |
! public | sequence_test13 | -32768 | -2147483648 | 2147483647 | 1 | f | 1 |
! public | sequence_test14 | 32767 | -2147483648 | 2147483647 | -1 | f | 1 |
public | sequence_test2 | 32 | 5 | 36 | 4 | t | 1 | 5
public | sequence_test3 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test4 | -1 | -9223372036854775808 | -1 | -1 | f | 1 | -1
--- 508,514 ----
------------+--------------------+-------------+----------------------+---------------------+--------------+-------+------------+------------
public | sequence_test10 | 1 | -20000 | 32767 | 1 | f | 1 |
public | sequence_test11 | 1 | 1 | 2147483647 | 1 | f | 1 |
! public | sequence_test13 | -32768 | -32768 | 32767 | 1 | f | 1 |
public | sequence_test2 | 32 | 5 | 36 | 4 | t | 1 | 5
public | sequence_test3 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test4 | -1 | -9223372036854775808 | -1 | -1 | f | 1 | -1
***************
*** 514,527 ****
public | sequence_test6 | 1 | 1 | 32767 | 1 | f | 1 |
public | sequence_test7 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test8 | 1 | 1 | 20000 | 1 | f | 1 |
- public | sequence_test9 | -1 | -32768 | -1 | -1 | f | 1 |
public | serialtest1_f2_foo | 1 | 1 | 2147483647 | 1 | f | 1 | 3
public | serialtest2_f2_seq | 1 | 1 | 2147483647 | 1 | f | 1 | 2
public | serialtest2_f3_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f4_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f5_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
public | serialtest2_f6_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
! (19 rows) SELECT * FROM pg_sequence_parameters('sequence_test4'::regclass);
start_value | minimum_value | maximum_value | increment | cycle_option | cache_size | data_type
--- 516,528 ----
public | sequence_test6 | 1 | 1 | 32767 | 1 | f | 1 |
public | sequence_test7 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test8 | 1 | 1 | 20000 | 1 | f | 1 |
public | serialtest1_f2_foo | 1 | 1 | 2147483647 | 1 | f | 1 | 3
public | serialtest2_f2_seq | 1 | 1 | 2147483647 | 1 | f | 1 | 2
public | serialtest2_f3_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f4_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f5_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
public | serialtest2_f6_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
! (16 rows) SELECT * FROM pg_sequence_parameters('sequence_test4'::regclass);
start_value | minimum_value | maximum_value | increment | cycle_option | cache_size | data_type
======================================================================
(This is only the last 100 lines of regression.diffs, if it helps I
can try rebuilding and grabbing the full file.)
Christoph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Christoph Berg <myon@debian.org> writes:
The sequence regression tests are failing on Debian/sparc64:
...
(This is only the last 100 lines of regression.diffs, if it helps I
can try rebuilding and grabbing the full file.)
Yes please. What we can see here looks to be just fallout from
a failure earlier in the run.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Re: Tom Lane 2017-05-17 <30016.1495041213@sss.pgh.pa.us>
Christoph Berg <myon@debian.org> writes:
The sequence regression tests are failing on Debian/sparc64:
...
(This is only the last 100 lines of regression.diffs, if it helps I
can try rebuilding and grabbing the full file.)Yes please. What we can see here looks to be just fallout from
a failure earlier in the run.
*** /home/myon/postgresql-10-10~beta1/build/../src/test/regress/expected/sequence.out 2017-05-15 23:20:59.000000000 +0200
--- /home/myon/postgresql-10-10~beta1/build/src/test/regress/results/sequence.out 2017-05-17 22:27:28.834225769 +0200
***************
*** 34,44 ****
--- 34,47 ----
CREATE SEQUENCE sequence_test7 AS bigint;
CREATE SEQUENCE sequence_test8 AS integer MAXVALUE 100000;
CREATE SEQUENCE sequence_test9 AS integer INCREMENT BY -1;
+ ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer
CREATE SEQUENCE sequence_test10 AS integer MINVALUE -100000 START 1;
CREATE SEQUENCE sequence_test11 AS smallint;
CREATE SEQUENCE sequence_test12 AS smallint INCREMENT -1;
+ ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint
CREATE SEQUENCE sequence_test13 AS smallint MINVALUE -32768;
CREATE SEQUENCE sequence_test14 AS smallint MAXVALUE 32767 INCREMENT -1;
+ ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint
CREATE SEQUENCE sequence_testx AS text;
ERROR: sequence type must be smallint, integer, or bigint
CREATE SEQUENCE sequence_testx AS nosuchtype;
***************
*** 54,66 ****
--- 57,73 ----
ERROR: MAXVALUE (100000) is out of range for sequence data type smallint
ALTER SEQUENCE sequence_test8 AS smallint MAXVALUE 20000; -- ok now
ALTER SEQUENCE sequence_test9 AS smallint; -- success, min will be adjusted
+ ERROR: relation "sequence_test9" does not exist
ALTER SEQUENCE sequence_test10 AS smallint; -- fail, min has to be adjusted
ERROR: MINVALUE (-100000) is out of range for sequence data type smallint
ALTER SEQUENCE sequence_test10 AS smallint MINVALUE -20000; -- ok now
ALTER SEQUENCE sequence_test11 AS int; -- max will be adjusted
ALTER SEQUENCE sequence_test12 AS int; -- min will be adjusted
+ ERROR: relation "sequence_test12" does not exist
ALTER SEQUENCE sequence_test13 AS int; -- min and max will be adjusted
+ ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer
ALTER SEQUENCE sequence_test14 AS int; -- min and max will be adjusted
+ ERROR: relation "sequence_test14" does not exist
---
--- test creation of SERIAL column
---
***************
*** 477,485 ****
------------------+-----------------+--------------------+-----------+-------------------+-------------------------+---------------+-------------+----------------------+---------------------+-----------+--------------
regression | public | sequence_test10 | smallint | 16 | 2 | 0 | 1 | -20000 | 32767 | 1 | NO
regression | public | sequence_test11 | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
! regression | public | sequence_test12 | integer | 32 | 2 | 0 | -1 | -2147483648 | -1 | -1 | NO
! regression | public | sequence_test13 | integer | 32 | 2 | 0 | -32768 | -2147483648 | 2147483647 | 1 | NO
! regression | public | sequence_test14 | integer | 32 | 2 | 0 | 32767 | -2147483648 | 2147483647 | -1 | NO
regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES
regression | public | sequence_test3 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test4 | bigint | 64 | 2 | 0 | -1 | -9223372036854775808 | -1 | -1 | NO
--- 484,490 ----
------------------+-----------------+--------------------+-----------+-------------------+-------------------------+---------------+-------------+----------------------+---------------------+-----------+--------------
regression | public | sequence_test10 | smallint | 16 | 2 | 0 | 1 | -20000 | 32767 | 1 | NO
regression | public | sequence_test11 | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
! regression | public | sequence_test13 | smallint | 16 | 2 | 0 | -32768 | -32768 | 32767 | 1 | NO
regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES
regression | public | sequence_test3 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test4 | bigint | 64 | 2 | 0 | -1 | -9223372036854775808 | -1 | -1 | NO
***************
*** 487,500 ****
regression | public | sequence_test6 | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | sequence_test7 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test8 | smallint | 16 | 2 | 0 | 1 | 1 | 20000 | 1 | NO
- regression | public | sequence_test9 | smallint | 16 | 2 | 0 | -1 | -32768 | -1 | -1 | NO
regression | public | serialtest1_f2_foo | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f2_seq | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f3_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f4_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f5_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | serialtest2_f6_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
! (19 rows) SELECT schemaname, sequencename, start_value, min_value, max_value, increment_by, cycle, cache_size, last_value
FROM pg_sequences
--- 492,504 ----
regression | public | sequence_test6 | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | sequence_test7 | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | sequence_test8 | smallint | 16 | 2 | 0 | 1 | 1 | 20000 | 1 | NO
regression | public | serialtest1_f2_foo | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f2_seq | integer | 32 | 2 | 0 | 1 | 1 | 2147483647 | 1 | NO
regression | public | serialtest2_f3_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f4_seq | smallint | 16 | 2 | 0 | 1 | 1 | 32767 | 1 | NO
regression | public | serialtest2_f5_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
regression | public | serialtest2_f6_seq | bigint | 64 | 2 | 0 | 1 | 1 | 9223372036854775807 | 1 | NO
! (16 rows) SELECT schemaname, sequencename, start_value, min_value, max_value, increment_by, cycle, cache_size, last_value
FROM pg_sequences
***************
*** 504,512 ****
------------+--------------------+-------------+----------------------+---------------------+--------------+-------+------------+------------
public | sequence_test10 | 1 | -20000 | 32767 | 1 | f | 1 |
public | sequence_test11 | 1 | 1 | 2147483647 | 1 | f | 1 |
! public | sequence_test12 | -1 | -2147483648 | -1 | -1 | f | 1 |
! public | sequence_test13 | -32768 | -2147483648 | 2147483647 | 1 | f | 1 |
! public | sequence_test14 | 32767 | -2147483648 | 2147483647 | -1 | f | 1 |
public | sequence_test2 | 32 | 5 | 36 | 4 | t | 1 | 5
public | sequence_test3 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test4 | -1 | -9223372036854775808 | -1 | -1 | f | 1 | -1
--- 508,514 ----
------------+--------------------+-------------+----------------------+---------------------+--------------+-------+------------+------------
public | sequence_test10 | 1 | -20000 | 32767 | 1 | f | 1 |
public | sequence_test11 | 1 | 1 | 2147483647 | 1 | f | 1 |
! public | sequence_test13 | -32768 | -32768 | 32767 | 1 | f | 1 |
public | sequence_test2 | 32 | 5 | 36 | 4 | t | 1 | 5
public | sequence_test3 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test4 | -1 | -9223372036854775808 | -1 | -1 | f | 1 | -1
***************
*** 514,527 ****
public | sequence_test6 | 1 | 1 | 32767 | 1 | f | 1 |
public | sequence_test7 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test8 | 1 | 1 | 20000 | 1 | f | 1 |
- public | sequence_test9 | -1 | -32768 | -1 | -1 | f | 1 |
public | serialtest1_f2_foo | 1 | 1 | 2147483647 | 1 | f | 1 | 3
public | serialtest2_f2_seq | 1 | 1 | 2147483647 | 1 | f | 1 | 2
public | serialtest2_f3_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f4_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f5_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
public | serialtest2_f6_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
! (19 rows) SELECT * FROM pg_sequence_parameters('sequence_test4'::regclass);
start_value | minimum_value | maximum_value | increment | cycle_option | cache_size | data_type
--- 516,528 ----
public | sequence_test6 | 1 | 1 | 32767 | 1 | f | 1 |
public | sequence_test7 | 1 | 1 | 9223372036854775807 | 1 | f | 1 |
public | sequence_test8 | 1 | 1 | 20000 | 1 | f | 1 |
public | serialtest1_f2_foo | 1 | 1 | 2147483647 | 1 | f | 1 | 3
public | serialtest2_f2_seq | 1 | 1 | 2147483647 | 1 | f | 1 | 2
public | serialtest2_f3_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f4_seq | 1 | 1 | 32767 | 1 | f | 1 | 2
public | serialtest2_f5_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
public | serialtest2_f6_seq | 1 | 1 | 9223372036854775807 | 1 | f | 1 | 2
! (16 rows) SELECT * FROM pg_sequence_parameters('sequence_test4'::regclass);
start_value | minimum_value | maximum_value | increment | cycle_option | cache_size | data_type
======================================================================
2017-05-17 22:27:27.804 CEST [155512] pg_regress/sequence ERROR: unlogged sequences are not supported
2017-05-17 22:27:27.804 CEST [155512] pg_regress/sequence STATEMENT: CREATE UNLOGGED SEQUENCE sequence_testx;
2017-05-17 22:27:27.805 CEST [155512] pg_regress/sequence ERROR: INCREMENT must not be zero
2017-05-17 22:27:27.805 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx INCREMENT BY 0;
2017-05-17 22:27:27.806 CEST [155512] pg_regress/sequence ERROR: MINVALUE (20) must be less than MAXVALUE (-1)
2017-05-17 22:27:27.806 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx INCREMENT BY -1 MINVALUE 20;
2017-05-17 22:27:27.807 CEST [155512] pg_regress/sequence ERROR: MINVALUE (1) must be less than MAXVALUE (-20)
2017-05-17 22:27:27.807 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx INCREMENT BY 1 MAXVALUE -20;
2017-05-17 22:27:27.807 CEST [155512] pg_regress/sequence ERROR: START value (10) cannot be greater than MAXVALUE (-1)
2017-05-17 22:27:27.807 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx INCREMENT BY -1 START 10;
2017-05-17 22:27:27.808 CEST [155512] pg_regress/sequence ERROR: START value (-10) cannot be less than MINVALUE (1)
2017-05-17 22:27:27.808 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx INCREMENT BY 1 START -10;
2017-05-17 22:27:27.809 CEST [155512] pg_regress/sequence ERROR: CACHE (0) must be greater than zero
2017-05-17 22:27:27.809 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx CACHE 0;
2017-05-17 22:27:27.822 CEST [155512] pg_regress/sequence ERROR: invalid OWNED BY option
2017-05-17 22:27:27.822 CEST [155512] pg_regress/sequence HINT: Specify OWNED BY table.column or OWNED BY NONE.
2017-05-17 22:27:27.822 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx OWNED BY nobody;
2017-05-17 22:27:27.843 CEST [155512] pg_regress/sequence ERROR: referenced relation "pg_class_oid_index" is not a table or foreign table
2017-05-17 22:27:27.843 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx OWNED BY pg_class_oid_index.oid;
2017-05-17 22:27:27.855 CEST [155512] pg_regress/sequence ERROR: sequence must be in same schema as table it is linked to
2017-05-17 22:27:27.855 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx OWNED BY pg_class.relname;
2017-05-17 22:27:27.877 CEST [155512] pg_regress/sequence ERROR: column "b" of relation "sequence_test_table" does not exist
2017-05-17 22:27:27.877 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx OWNED BY sequence_test_table.b;
2017-05-17 22:27:27.920 CEST [155512] pg_regress/sequence ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer
2017-05-17 22:27:27.920 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_test9 AS integer INCREMENT BY -1;
2017-05-17 22:27:27.935 CEST [155512] pg_regress/sequence ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint
2017-05-17 22:27:27.935 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_test12 AS smallint INCREMENT -1;
2017-05-17 22:27:27.942 CEST [155512] pg_regress/sequence ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint
2017-05-17 22:27:27.942 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_test14 AS smallint MAXVALUE 32767 INCREMENT -1;
2017-05-17 22:27:27.943 CEST [155512] pg_regress/sequence ERROR: sequence type must be smallint, integer, or bigint
2017-05-17 22:27:27.943 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx AS text;
2017-05-17 22:27:27.944 CEST [155512] pg_regress/sequence ERROR: type "nosuchtype" does not exist at character 35
2017-05-17 22:27:27.944 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx AS nosuchtype;
2017-05-17 22:27:27.945 CEST [155512] pg_regress/sequence ERROR: MAXVALUE (100000) is out of range for sequence data type smallint
2017-05-17 22:27:27.945 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx AS smallint MAXVALUE 100000;
2017-05-17 22:27:27.946 CEST [155512] pg_regress/sequence ERROR: MINVALUE (-100000) is out of range for sequence data type smallint
2017-05-17 22:27:27.946 CEST [155512] pg_regress/sequence STATEMENT: CREATE SEQUENCE sequence_testx AS smallint MINVALUE -100000;
2017-05-17 22:27:27.949 CEST [155512] pg_regress/sequence ERROR: MAXVALUE (100000) is out of range for sequence data type smallint
2017-05-17 22:27:27.949 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test8 AS smallint;
2017-05-17 22:27:27.951 CEST [155512] pg_regress/sequence ERROR: relation "sequence_test9" does not exist
2017-05-17 22:27:27.951 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test9 AS smallint;
2017-05-17 22:27:27.953 CEST [155512] pg_regress/sequence ERROR: MINVALUE (-100000) is out of range for sequence data type smallint
2017-05-17 22:27:27.953 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test10 AS smallint;
2017-05-17 22:27:27.957 CEST [155512] pg_regress/sequence ERROR: relation "sequence_test12" does not exist
2017-05-17 22:27:27.957 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test12 AS int;
2017-05-17 22:27:27.958 CEST [155512] pg_regress/sequence ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer
2017-05-17 22:27:27.958 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test13 AS int;
2017-05-17 22:27:27.959 CEST [155512] pg_regress/sequence ERROR: relation "sequence_test14" does not exist
2017-05-17 22:27:27.959 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test14 AS int;
2017-05-17 22:27:27.999 CEST [155512] pg_regress/sequence ERROR: null value in column "f2" violates not-null constraint
2017-05-17 22:27:27.999 CEST [155512] pg_regress/sequence DETAIL: Failing row contains (wrong, null).
2017-05-17 22:27:27.999 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest1 VALUES ('wrong', NULL);
2017-05-17 22:27:28.077 CEST [155512] pg_regress/sequence ERROR: smallint out of range
2017-05-17 22:27:28.077 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f3)
2017-05-17 22:27:28.078 CEST [155512] pg_regress/sequence ERROR: smallint out of range
2017-05-17 22:27:28.078 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f4)
2017-05-17 22:27:28.079 CEST [155512] pg_regress/sequence ERROR: smallint out of range
2017-05-17 22:27:28.079 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f3)
2017-05-17 22:27:28.080 CEST [155512] pg_regress/sequence ERROR: smallint out of range
2017-05-17 22:27:28.080 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f4)
2017-05-17 22:27:28.082 CEST [155512] pg_regress/sequence ERROR: bigint out of range
2017-05-17 22:27:28.082 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f5)
2017-05-17 22:27:28.083 CEST [155512] pg_regress/sequence ERROR: bigint out of range
2017-05-17 22:27:28.083 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f6)
2017-05-17 22:27:28.084 CEST [155512] pg_regress/sequence ERROR: bigint out of range
2017-05-17 22:27:28.084 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f5)
2017-05-17 22:27:28.086 CEST [155512] pg_regress/sequence ERROR: bigint out of range
2017-05-17 22:27:28.086 CEST [155512] pg_regress/sequence STATEMENT: INSERT INTO serialTest2 (f1, f6)
2017-05-17 22:27:28.123 CEST [155512] pg_regress/sequence ERROR: currval of sequence "sequence_test" is not yet defined in this session
2017-05-17 22:27:28.123 CEST [155512] pg_regress/sequence STATEMENT: SELECT currval('sequence_test'::regclass);
2017-05-17 22:27:28.197 CEST [155512] pg_regress/sequence ERROR: cannot drop sequence t1_f1_seq because other objects depend on it
2017-05-17 22:27:28.197 CEST [155512] pg_regress/sequence DETAIL: default for table t1 column f1 depends on sequence t1_f1_seq
2017-05-17 22:27:28.197 CEST [155512] pg_regress/sequence HINT: Use DROP ... CASCADE to drop the dependent objects too.
2017-05-17 22:27:28.197 CEST [155512] pg_regress/sequence STATEMENT: DROP SEQUENCE t1_f1_seq;
2017-05-17 22:27:28.199 CEST [155512] pg_regress/sequence ERROR: cannot drop sequence myseq2 because other objects depend on it
2017-05-17 22:27:28.199 CEST [155512] pg_regress/sequence DETAIL: default for table t1 column f2 depends on sequence myseq2
2017-05-17 22:27:28.199 CEST [155512] pg_regress/sequence HINT: Use DROP ... CASCADE to drop the dependent objects too.
2017-05-17 22:27:28.199 CEST [155512] pg_regress/sequence STATEMENT: DROP SEQUENCE myseq2;
2017-05-17 22:27:28.345 CEST [155512] pg_regress/sequence ERROR: sequence "t1_f1_seq" does not exist
2017-05-17 22:27:28.345 CEST [155512] pg_regress/sequence STATEMENT: DROP SEQUENCE t1_f1_seq;
2017-05-17 22:27:28.355 CEST [155512] pg_regress/sequence ERROR: "pg_class" is not a sequence
2017-05-17 22:27:28.355 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE pg_class CYCLE;
2017-05-17 22:27:28.377 CEST [155512] pg_regress/sequence ERROR: RESTART value (0) cannot be less than MINVALUE (1)
2017-05-17 22:27:28.377 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test2 RESTART WITH 0;
2017-05-17 22:27:28.378 CEST [155512] pg_regress/sequence ERROR: RESTART value (40) cannot be greater than MAXVALUE (-1)
2017-05-17 22:27:28.378 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test4 RESTART WITH 40;
2017-05-17 22:27:28.390 CEST [155512] pg_regress/sequence ERROR: nextval: reached maximum value of sequence "sequence_test2" (36)
2017-05-17 22:27:28.390 CEST [155512] pg_regress/sequence STATEMENT: SELECT nextval('sequence_test2');
2017-05-17 22:27:28.402 CEST [155512] pg_regress/sequence ERROR: nextval: reached minimum value of sequence "sequence_test2" (-36)
2017-05-17 22:27:28.402 CEST [155512] pg_regress/sequence STATEMENT: SELECT nextval('sequence_test2');
2017-05-17 22:27:28.404 CEST [155512] pg_regress/sequence ERROR: setval: value -100 is out of bounds for sequence "sequence_test2" (5..36)
2017-05-17 22:27:28.404 CEST [155512] pg_regress/sequence STATEMENT: SELECT setval('sequence_test2', -100);
2017-05-17 22:27:28.405 CEST [155512] pg_regress/sequence ERROR: setval: value 100 is out of bounds for sequence "sequence_test2" (5..36)
2017-05-17 22:27:28.405 CEST [155512] pg_regress/sequence STATEMENT: SELECT setval('sequence_test2', 100);
2017-05-17 22:27:28.516 CEST [155512] pg_regress/sequence ERROR: relation "asdf" does not exist
2017-05-17 22:27:28.516 CEST [155512] pg_regress/sequence STATEMENT: COMMENT ON SEQUENCE asdf IS 'won''t work';
2017-05-17 22:27:28.531 CEST [155512] pg_regress/sequence ERROR: lastval is not yet defined in this session
2017-05-17 22:27:28.531 CEST [155512] pg_regress/sequence STATEMENT: SELECT lastval();
2017-05-17 22:27:28.548 CEST [155512] pg_regress/sequence ERROR: lastval is not yet defined in this session
2017-05-17 22:27:28.548 CEST [155512] pg_regress/sequence STATEMENT: SELECT lastval();
2017-05-17 22:27:28.558 CEST [155512] pg_regress/sequence ERROR: cannot execute nextval() in a read-only transaction
2017-05-17 22:27:28.558 CEST [155512] pg_regress/sequence STATEMENT: SELECT nextval('sequence_test2');
2017-05-17 22:27:28.561 CEST [155512] pg_regress/sequence ERROR: cannot execute setval() in a read-only transaction
2017-05-17 22:27:28.561 CEST [155512] pg_regress/sequence STATEMENT: SELECT setval('sequence_test2', 1);
2017-05-17 22:27:28.576 CEST [155512] pg_regress/sequence ERROR: permission denied for sequence seq3
2017-05-17 22:27:28.576 CEST [155512] pg_regress/sequence STATEMENT: SELECT nextval('seq3');
2017-05-17 22:27:28.640 CEST [155512] pg_regress/sequence ERROR: permission denied for sequence seq3
2017-05-17 22:27:28.640 CEST [155512] pg_regress/sequence STATEMENT: SELECT currval('seq3');
2017-05-17 22:27:28.689 CEST [155512] pg_regress/sequence ERROR: permission denied for sequence seq3
2017-05-17 22:27:28.689 CEST [155512] pg_regress/sequence STATEMENT: SELECT lastval();
2017-05-17 22:27:28.720 CEST [155512] pg_regress/sequence ERROR: permission denied for sequence seq3
2017-05-17 22:27:28.720 CEST [155512] pg_regress/sequence STATEMENT: SELECT setval('seq3', 5);
2017-05-17 22:27:28.730 CEST [155512] pg_regress/sequence ERROR: must be owner of relation sequence_test2
2017-05-17 22:27:28.730 CEST [155512] pg_regress/sequence STATEMENT: ALTER SEQUENCE sequence_test2 START WITH 1;
Christoph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Christoph Berg <myon@debian.org> writes:
*** 34,44 **** --- 34,47 ---- CREATE SEQUENCE sequence_test7 AS bigint; CREATE SEQUENCE sequence_test8 AS integer MAXVALUE 100000; CREATE SEQUENCE sequence_test9 AS integer INCREMENT BY -1; + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer CREATE SEQUENCE sequence_test10 AS integer MINVALUE -100000 START 1; CREATE SEQUENCE sequence_test11 AS smallint; CREATE SEQUENCE sequence_test12 AS smallint INCREMENT -1; + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint CREATE SEQUENCE sequence_test13 AS smallint MINVALUE -32768; CREATE SEQUENCE sequence_test14 AS smallint MAXVALUE 32767 INCREMENT -1; + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint CREATE SEQUENCE sequence_testx AS text; ERROR: sequence type must be smallint, integer, or bigint CREATE SEQUENCE sequence_testx AS nosuchtype;
Well, that's just wacko. Somehow sequence.c's init_params() must
be falling down on the job in selecting the right seqform->seqmin,
but I'm darned if I see anything that's either wrong or potentially
machine-dependent in that code. It almost looks like it must be
a compiler bug, though I hesitate to jump to that conclusion so
quickly. Peter, any ideas?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 2017-05-18 10:11:48 -0400, Tom Lane wrote:
Christoph Berg <myon@debian.org> writes:
*** 34,44 **** --- 34,47 ---- CREATE SEQUENCE sequence_test7 AS bigint; CREATE SEQUENCE sequence_test8 AS integer MAXVALUE 100000; CREATE SEQUENCE sequence_test9 AS integer INCREMENT BY -1; + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type integer CREATE SEQUENCE sequence_test10 AS integer MINVALUE -100000 START 1; CREATE SEQUENCE sequence_test11 AS smallint; CREATE SEQUENCE sequence_test12 AS smallint INCREMENT -1; + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint CREATE SEQUENCE sequence_test13 AS smallint MINVALUE -32768; CREATE SEQUENCE sequence_test14 AS smallint MAXVALUE 32767 INCREMENT -1; + ERROR: MINVALUE (-9223372036854775808) is out of range for sequence data type smallint CREATE SEQUENCE sequence_testx AS text; ERROR: sequence type must be smallint, integer, or bigint CREATE SEQUENCE sequence_testx AS nosuchtype;Well, that's just wacko. Somehow sequence.c's init_params() must
be falling down on the job in selecting the right seqform->seqmin,
but I'm darned if I see anything that's either wrong or potentially
machine-dependent in that code. It almost looks like it must be
a compiler bug, though I hesitate to jump to that conclusion so
quickly. Peter, any ideas?
Weird. Christoph, IIRC you can help gaining access to a porter machine
to reproduce this?
- Andres
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 5/18/17 10:11, Tom Lane wrote:
Well, that's just wacko. Somehow sequence.c's init_params() must
be falling down on the job in selecting the right seqform->seqmin,
but I'm darned if I see anything that's either wrong or potentially
machine-dependent in that code. It almost looks like it must be
a compiler bug, though I hesitate to jump to that conclusion so
quickly. Peter, any ideas?
If we had a typo or something in that code, the build farm should have
caught it by now.
I would try compiling with lower -O and see what happens.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Re: Peter Eisentraut 2017-05-18 <7a4d3b0f-78da-2a5b-7f3b-8b3509c1e183@2ndquadrant.com>
If we had a typo or something in that code, the build farm should have
caught it by now.I would try compiling with lower -O and see what happens.
Trying -O0 now.
Re: Andres Freund 2017-05-18 <20170518184811.7c44jcvwjvnzczho@alap3.anarazel.de>
Weird. Christoph, IIRC you can help gaining access to a porter machine
to reproduce this?
I'll let the build run over night (the machine has 32 cores but is
dead slow) and see what I can arrange tomorrow. (Peter will already
have access, it's notker.debian.net.)
Christoph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Import Notes
Reply to msg id not found: 7a4d3b0f-78da-2a5b-7f3b-8b3509c1e183@2ndquadrant.com20170518184811.7c44jcvwjvnzczho@alap3.anarazel.de | Resolved by subject fallback
Re: To Andres Freund 2017-05-18 <20170518192924.jkrzevlencp3ggi6@msg.df7cb.de>
If we had a typo or something in that code, the build farm should have
caught it by now.I would try compiling with lower -O and see what happens.
Trying -O0 now.
Sorry for the late reply, I was hoping to catch you on IRC, but then
didn't manage to be around at a time that would fit the timezone
shift.
The -O0 build passed the regression tests. Not sure what that means
for our problem, though.
Re: Andres Freund 2017-05-18 <20170518184811.7c44jcvwjvnzczho@alap3.anarazel.de>
Weird. Christoph, IIRC you can help gaining access to a porter machine
to reproduce this?I'll let the build run over night (the machine has 32 cores but is
dead slow) and see what I can arrange tomorrow. (Peter will already
have access, it's notker.debian.net.)
Will send you a separate mail for that.
Christoph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Re: To Andres Freund 2017-05-24 <20170524170921.7pykzbt54dlfktdr@msg.df7cb.de>
If we had a typo or something in that code, the build farm should have
caught it by now.I would try compiling with lower -O and see what happens.
Trying -O0 now.
Sorry for the late reply, I was hoping to catch you on IRC, but then
didn't manage to be around at a time that would fit the timezone
shift.The -O0 build passed the regression tests. Not sure what that means
for our problem, though.
Fwiw, the problem is fixed with beta2, even with -O2:
https://buildd.debian.org/status/logs.php?pkg=postgresql-10&arch=sparc64
Christoph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Christoph, what beta2 change was it that fixed that problem?
I'm having exactly the same regression test failure in version 10.1 (not beta) running on Solaris 9
Compiler used: GCC 4.6.4
CFLAGS: -O2 -m64
On 13/07/2017 20:05, Christoph Berg wrote:
Re: To Andres Freund 2017-05-24 <20170524170921.7pykzbt54dlfktdr@msg.df7cb.de>
If we had a typo or something in that code, the build farm should have
caught it by now.I would try compiling with lower -O and see what happens.
Trying -O0 now.
Sorry for the late reply, I was hoping to catch you on IRC, but then
didn't manage to be around at a time that would fit the timezone
shift.The -O0 build passed the regression tests. Not sure what that means
for our problem, though.Fwiw, the problem is fixed with beta2, even with -O2:
https://buildd.debian.org/status/logs.php?pkg=postgresql-10&arch=sparc64
Christoph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers