Thread: [HACKERS] 10beta1 sequence regression failure on sparc64

[HACKERS] 10beta1 sequence regression failure on sparc64

From
Christoph Berg
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Tom Lane
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Christoph Berg
Date:
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;
CREATESEQUENCE sequence_test9 AS integer INCREMENT BY -1;
 
+ ERROR:  MINVALUE (-9223372036854775808) is out of range for sequence data type integer CREATE SEQUENCE
sequence_test10AS integer MINVALUE -100000 START 1; CREATE SEQUENCE sequence_test11 AS smallint; CREATE SEQUENCE
sequence_test12AS smallint INCREMENT -1;
 
+ ERROR:  MINVALUE (-9223372036854775808) is out of range for sequence data type smallint CREATE SEQUENCE
sequence_test13AS 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_testxAS 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
ASsmallint 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
adjustedERROR:  MINVALUE (-100000) is out of range for sequence data type smallint ALTER SEQUENCE sequence_test10 AS
smallintMINVALUE -20000;  -- ok now ALTER SEQUENCE sequence_test11 AS int;  -- max will be adjusted ALTER SEQUENCE
sequence_test12AS 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
ASint;  -- 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_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 
 

======================================================================


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
MINVALUE20;
 
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
START10;
 
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
tableor 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
sequencedata type integer
 
2017-05-17 22:27:27.920 CEST [155512] pg_regress/sequence STATEMENT:  CREATE SEQUENCE sequence_test9 AS integer
INCREMENTBY -1;
 
2017-05-17 22:27:27.935 CEST [155512] pg_regress/sequence ERROR:  MINVALUE (-9223372036854775808) is out of range for
sequencedata 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
sequencedata type smallint
 
2017-05-17 22:27:27.942 CEST [155512] pg_regress/sequence STATEMENT:  CREATE SEQUENCE sequence_test14 AS smallint
MAXVALUE32767 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
typesmallint
 
2017-05-17 22:27:27.945 CEST [155512] pg_regress/sequence STATEMENT:  CREATE SEQUENCE sequence_testx AS smallint
MAXVALUE100000;
 
2017-05-17 22:27:27.946 CEST [155512] pg_regress/sequence ERROR:  MINVALUE (-100000) is out of range for sequence data
typesmallint
 
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
typesmallint
 
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
typesmallint
 
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
sequencedata 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
definedin 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
dependon 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
dependon 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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Tom Lane
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Andres Freund
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Peter Eisentraut
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Christoph Berg
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Christoph Berg
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Christoph Berg
Date:
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



Re: [HACKERS] 10beta1 sequence regression failure on sparc64

From
Jonathan Jacobson
Date:
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