[HACKERS] 10beta1 sequence regression failure on sparc64 - Mailing list pgsql-hackers
| From | Christoph Berg |
|---|---|
| Subject | [HACKERS] 10beta1 sequence regression failure on sparc64 |
| Date | |
| Msg-id | 20170517165113.3kfo3353n73awqu4@msg.df7cb.de Whole thread Raw |
| Responses |
Re: [HACKERS] 10beta1 sequence regression failure on sparc64
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-hackers |
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_valueFROM 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_valueFROM 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.)
https://buildd.debian.org/status/fetch.php?pkg=postgresql-10&arch=sparc64&ver=10~beta1-1&stamp=1495038068&raw=0
Christoph
pgsql-hackers by date: