Re: Problem with PostgreSQL 9.2.7 and make check on AIX 7.1 - Mailing list pgsql-bugs

Hello,
I am currently checking the hang problem with IBM.

The have found some other test failures on AXI 7.1 TL2:
They do not see the hang on TL2 but instead they see the
following test errors. I do not see these errors in AIX 6.1 TL8
or AIX 7.1 TL3 (with prepared_xacts and plpgsql removed).

Any ideas? I have attached the diff file for better readability.

*** /stuff/postgresql-9.2.7/src/test/regress/expected/inherit.out    Mon
Feb 17 13:38:15 2014
--- /stuff/postgresql-9.2.7/src/test/regress/results/inherit.out    Tue
Mar 11 16:55:26 2014
***************
*** 576,592 ****
  from
    ( select f1 from foo union all select f1+3 from foo ) ss
  where bar.f1 = ss.f1;
  select tableoid::regclass::text as relname, bar.* from bar order by 1,2;
   relname | f1 | f2
  ---------+----+-----
!  bar     |  1 | 201
!  bar     |  2 | 202
!  bar     |  3 | 203
!  bar     |  4 | 104
!  bar2    |  1 | 201
!  bar2    |  2 | 202
!  bar2    |  3 | 203
!  bar2    |  4 | 104
  (8 rows)

  /* Test multiple inheritance of column defaults */
--- 576,593 ----
  from
    ( select f1 from foo union all select f1+3 from foo ) ss
  where bar.f1 = ss.f1;
+ ERROR:  rel 5 already exists
  select tableoid::regclass::text as relname, bar.* from bar order by 1,2;
   relname | f1 | f2
  ---------+----+-----
!  bar     |  1 | 101
!  bar     |  2 | 102
!  bar     |  3 | 103
!  bar     |  4 |   4
!  bar2    |  1 | 101
!  bar2    |  2 | 102
!  bar2    |  3 | 103
!  bar2    |  4 |   4
  (8 rows)

  /* Test multiple inheritance of column defaults */
***************
*** 1391,1427 ****
    (SELECT unique1 AS x FROM tenk1 a
     UNION ALL
     SELECT unique2 AS x FROM tenk1 b) s;
!                              QUERY PLAN
! --------------------------------------------------------------------
!  Result
!    InitPlan 1 (returns $0)
!      ->  Limit
!            ->  Merge Append
!                  Sort Key: a.unique1
!                  ->  Index Only Scan using tenk1_unique1 on tenk1 a
!                        Index Cond: (unique1 IS NOT NULL)
!                  ->  Index Only Scan using tenk1_unique2 on tenk1 b
!                        Index Cond: (unique2 IS NOT NULL)
! (9 rows)
!
  explain (costs off)
  SELECT min(y) FROM
    (SELECT unique1 AS x, unique1 AS y FROM tenk1 a
     UNION ALL
     SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s;
!                              QUERY PLAN
! --------------------------------------------------------------------
!  Result
!    InitPlan 1 (returns $0)
!      ->  Limit
!            ->  Merge Append
!                  Sort Key: a.unique1
!                  ->  Index Only Scan using tenk1_unique1 on tenk1 a
!                        Index Cond: (unique1 IS NOT NULL)
!                  ->  Index Only Scan using tenk1_unique2 on tenk1 b
!                        Index Cond: (unique2 IS NOT NULL)
! (9 rows)
!
  -- XXX planner doesn't recognize that index on unique2 is sufficiently
sorted
  explain (costs off)
  SELECT x, y FROM
--- 1392,1404 ----
    (SELECT unique1 AS x FROM tenk1 a
     UNION ALL
     SELECT unique2 AS x FROM tenk1 b) s;
! ERROR:  rel 4 already exists
  explain (costs off)
  SELECT min(y) FROM
    (SELECT unique1 AS x, unique1 AS y FROM tenk1 a
     UNION ALL
     SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s;
! ERROR:  rel 4 already exists
  -- XXX planner doesn't recognize that index on unique2 is sufficiently
sorted
  explain (costs off)
  SELECT x, y FROM
***************
*** 1429,1445 ****
     UNION ALL
     SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s
  ORDER BY x, y;
!                             QUERY PLAN
! -------------------------------------------------------------------
!  Result
!    ->  Merge Append
!          Sort Key: a.thousand, a.tenthous
!          ->  Index Only Scan using tenk1_thous_tenthous on tenk1 a
!          ->  Sort
!                Sort Key: b.unique2, b.unique2
!                ->  Index Only Scan using tenk1_unique2 on tenk1 b
! (7 rows)
!
  reset enable_seqscan;
  reset enable_indexscan;
  reset enable_bitmapscan;
--- 1406,1412 ----
     UNION ALL
     SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s
  ORDER BY x, y;
! ERROR:  rel 4 already exists
  reset enable_seqscan;
  reset enable_indexscan;
  reset enable_bitmapscan;

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

*** /stuff/postgresql-9.2.7/src/test/regress/expected/union.out    Mon
Feb 17 13:38:15 2014
--- /stuff/postgresql-9.2.7/src/test/regress/results/union.out    Tue
Mar 11 16:55:32 2014
***************
*** 474,489 ****
    UNION ALL
    SELECT * FROM t2) t
   WHERE ab = 'ab';
!                     QUERY PLAN
! ---------------------------------------------------
!  Result
!    ->  Append
!          ->  Index Scan using t1_ab_idx on t1
!                Index Cond: ((a || b) = 'ab'::text)
!          ->  Index Only Scan using t2_pkey on t2
!                Index Cond: (ab = 'ab'::text)
! (6 rows)
!
  explain (costs off)
   SELECT * FROM
   (SELECT a || b AS ab FROM t1
--- 474,480 ----
    UNION ALL
    SELECT * FROM t2) t
   WHERE ab = 'ab';
! ERROR:  rel 4 already exists
  explain (costs off)
   SELECT * FROM
   (SELECT a || b AS ab FROM t1
***************
*** 510,522 ****
     UNION ALL
     SELECT 2 AS t, * FROM tenk1 b) c
   WHERE t = 2;
!            QUERY PLAN
! ---------------------------------
!  Result
!    ->  Append
!          ->  Seq Scan on tenk1 b
! (3 rows)
!
  -- Test that we push quals into UNION sub-selects only when it's safe
  explain (costs off)
  SELECT * FROM
--- 501,507 ----
     UNION ALL
     SELECT 2 AS t, * FROM tenk1 b) c
   WHERE t = 2;
! ERROR:  rel 4 already exists
  -- Test that we push quals into UNION sub-selects only when it's safe
  explain (costs off)
  SELECT * FROM
***************
*** 617,641 ****
  select * from
    (select * from t3 a union all select * from t3 b) ss
    join int4_tbl on f1 = expensivefunc(x);
!                          QUERY PLAN
! ------------------------------------------------------------
!  Nested Loop
!    ->  Seq Scan on int4_tbl
!    ->  Append
!          ->  Index Scan using t3i on t3 a
!                Index Cond: (expensivefunc(x) = int4_tbl.f1)
!          ->  Index Scan using t3i on t3 b
!                Index Cond: (expensivefunc(x) = int4_tbl.f1)
! (7 rows)
!
  select * from
    (select * from t3 a union all select * from t3 b) ss
    join int4_tbl on f1 = expensivefunc(x);
!  x | f1
! ---+----
!  0 |  0
!  0 |  0
! (2 rows)
!
  drop table t3;
  drop function expensivefunc(int);
--- 602,611 ----
  select * from
    (select * from t3 a union all select * from t3 b) ss
    join int4_tbl on f1 = expensivefunc(x);
! ERROR:  rel 6 already exists
  select * from
    (select * from t3 a union all select * from t3 b) ss
    join int4_tbl on f1 = expensivefunc(x);
! ERROR:  rel 6 already exists
  drop table t3;
  drop function expensivefunc(int);

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

***
/stuff/postgresql-9.2.7/src/test/regress/expected/security_label.out
Tue Mar 11 16:53:52 2014
---
/stuff/postgresql-9.2.7/src/test/regress/results/security_label.out
Tue Mar 11 16:55:37 2014
***************
*** 92,110 ****
  SECURITY LABEL ON SCHEMA seclabel_test IS 'unclassified';        -- OK
  SELECT objtype, objname, provider, label FROM pg_seclabels
      ORDER BY objtype, objname;
!  objtype  |     objname     | provider |    label
! ----------+-----------------+----------+--------------
!  column   | seclabel_tbl1.a | dummy    | unclassified
!  domain   | seclabel_domain | dummy    | classified
!  function | seclabel_four() | dummy    | classified
!  role     | seclabel_user1  | dummy    | classified
!  role     | seclabel_user2  | dummy    | unclassified
!  schema   | seclabel_test   | dummy    | unclassified
!  table    | seclabel_tbl1   | dummy    | top secret
!  table    | seclabel_tbl2   | dummy    | classified
!  view     | seclabel_view1  | dummy    | classified
! (9 rows)
!
  -- clean up objects
  DROP FUNCTION seclabel_four();
  DROP DOMAIN seclabel_domain;
--- 92,98 ----
  SECURITY LABEL ON SCHEMA seclabel_test IS 'unclassified';        -- OK
  SELECT objtype, objname, provider, label FROM pg_seclabels
      ORDER BY objtype, objname;
! ERROR:  rel 16 already exists
  -- clean up objects
  DROP FUNCTION seclabel_four();
  DROP DOMAIN seclabel_domain;
***************
*** 117,123 ****
  -- make sure we don't have any leftovers
  SELECT objtype, objname, provider, label FROM pg_seclabels
      ORDER BY objtype, objname;
!  objtype | objname | provider | label
! ---------+---------+----------+-------
! (0 rows)
!
--- 105,108 ----
  -- make sure we don't have any leftovers
  SELECT objtype, objname, provider, label FROM pg_seclabels
      ORDER BY objtype, objname;
! ERROR:  rel 16 already exists

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

***
/stuff/postgresql-9.2.7/src/test/regress/expected/foreign_data.out
Mon Feb 17 13:38:15 2014
--- /stuff/postgresql-9.2.7/src/test/regress/results/foreign_data.out
Tue Mar 11 16:55:46 2014
***************
*** 900,922 ****
  (7 rows)

  SELECT * FROM information_schema.usage_privileges WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
!       grantor      |        grantee        | object_catalog |
object_schema | object_name |     object_type      | privilege_type |
is_grantable
!

-------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+--------------
!  foreign_data_user | foreign_data_user     | regression
|               | foo         | FOREIGN DATA WRAPPER | USAGE          | YES
!  foreign_data_user | foreign_data_user     | regression
|               | s6          | FOREIGN SERVER       | USAGE          | YES
!  foreign_data_user | regress_test_indirect | regression
|               | foo         | FOREIGN DATA WRAPPER | USAGE          | NO
!  foreign_data_user | regress_test_role2    | regression
|               | s6          | FOREIGN SERVER       | USAGE          | YES
! (4 rows)
!
  SELECT * FROM information_schema.role_usage_grants WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
!       grantor      |        grantee        | object_catalog |
object_schema | object_name |     object_type      | privilege_type |
is_grantable
!

-------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+--------------
!  foreign_data_user | foreign_data_user     | regression
|               | foo         | FOREIGN DATA WRAPPER | USAGE          | YES
!  foreign_data_user | foreign_data_user     | regression
|               | s6          | FOREIGN SERVER       | USAGE          | YES
!  foreign_data_user | regress_test_indirect | regression
|               | foo         | FOREIGN DATA WRAPPER | USAGE          | NO
!  foreign_data_user | regress_test_role2    | regression
|               | s6          | FOREIGN SERVER       | USAGE          | YES
! (4 rows)
!
  SELECT * FROM information_schema.foreign_tables ORDER BY 1, 2, 3;
   foreign_table_catalog | foreign_table_schema | foreign_table_name |
foreign_server_catalog | foreign_server_name

-----------------------+----------------------+--------------------+------------------------+---------------------
--- 900,908 ----
  (7 rows)

  SELECT * FROM information_schema.usage_privileges WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
! ERROR:  could not open relation with OID 0
  SELECT * FROM information_schema.role_usage_grants WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
! ERROR:  could not open relation with OID 0
  SELECT * FROM information_schema.foreign_tables ORDER BY 1, 2, 3;
   foreign_table_catalog | foreign_table_schema | foreign_table_name |
foreign_server_catalog | foreign_server_name

-----------------------+----------------------+--------------------+------------------------+---------------------
***************
*** 943,961 ****
  (5 rows)

  SELECT * FROM information_schema.usage_privileges WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
!       grantor      |        grantee        | object_catalog |
object_schema | object_name |     object_type      | privilege_type |
is_grantable
!

-------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+--------------
!  foreign_data_user | regress_test_indirect | regression
|               | foo         | FOREIGN DATA WRAPPER | USAGE          | NO
!  foreign_data_user | regress_test_role2    | regression
|               | s6          | FOREIGN SERVER       | USAGE          | YES
! (2 rows)
!
  SELECT * FROM information_schema.role_usage_grants WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
!       grantor      |        grantee        | object_catalog |
object_schema | object_name |     object_type      | privilege_type |
is_grantable
!

-------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+--------------
!  foreign_data_user | regress_test_indirect | regression
|               | foo         | FOREIGN DATA WRAPPER | USAGE          | NO
!  foreign_data_user | regress_test_role2    | regression
|               | s6          | FOREIGN SERVER       | USAGE          | YES
! (2 rows)
!
  DROP USER MAPPING FOR current_user SERVER t1;
  SET ROLE regress_test_role2;
  SELECT * FROM information_schema.user_mapping_options ORDER BY 1, 2, 3, 4;
--- 929,937 ----
  (5 rows)

  SELECT * FROM information_schema.usage_privileges WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
! ERROR:  rel 11 already exists
  SELECT * FROM information_schema.role_usage_grants WHERE object_type
LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5;
! ERROR:  rel 14 already exists
  DROP USER MAPPING FOR current_user SERVER t1;
  SET ROLE regress_test_role2;
  SELECT * FROM information_schema.user_mapping_options ORDER BY 1, 2, 3, 4;

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

*** /stuff/postgresql-9.2.7/src/test/regress/expected/window.out    Mon
Feb 17 13:38:15 2014
--- /stuff/postgresql-9.2.7/src/test/regress/results/window.out    Tue
Mar 11 16:55:44 2014
***************
*** 957,966 ****

  -- with UNION
  SELECT count(*) OVER (PARTITION BY four) FROM (SELECT * FROM tenk1
UNION ALL SELECT * FROM tenk2)s LIMIT 0;
!  count
! -------
! (0 rows)
!
  -- ordering by a non-integer constant is allowed
  SELECT rank() OVER (ORDER BY length('abc'));
   rank
--- 957,963 ----

  -- with UNION
  SELECT count(*) OVER (PARTITION BY four) FROM (SELECT * FROM tenk1
UNION ALL SELECT * FROM tenk2)s LIMIT 0;
! ERROR:  rel 4 already exists
  -- ordering by a non-integer constant is allowed
  SELECT rank() OVER (ORDER BY length('abc'));
   rank

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

*** /stuff/postgresql-9.2.7/src/test/regress/expected/with.out    Mon
Feb 17 13:38:15 2014
--- /stuff/postgresql-9.2.7/src/test/regress/results/with.out    Tue Mar
11 16:55:57 2014
***************
*** 384,396 ****
          (SELECT 2 AS i UNION ALL SELECT 3 AS i) AS t2
          JOIN t ON (t2.i = t.i+1))
      SELECT * FROM t;
!  i | j
! ---+---
!  1 | 2
!  2 | 3
!  3 | 4
! (3 rows)
!
  --
  -- different tree example
  --
--- 384,390 ----
          (SELECT 2 AS i UNION ALL SELECT 3 AS i) AS t2
          JOIN t ON (t2.i = t.i+1))
      SELECT * FROM t;
! ERROR:  rel 6 already exists
  --
  -- different tree example
  --

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



Bye
  Rainer

On 04.03.2014 17:21, Rainer Tammer wrote:
> Hello,
> the problem has reached the development support at IBM.
>
> As soon as I have a solution for the problem I will setup a build farm
> member (hopefully).
>
> I can probably smoke HEAD on AIX 7.1 and 6.1.
>
> Bye
>   Rainer
>
> On 27.02.2014 08:21, Rainer Tammer wrote:
>> Hello,
>> I have checked this:
>>
>> >From prepared_xacts:
>>
>> LOG:  Send kill to PID: 11731118
>> LOG:  Retrun value of kill PID: ret= 0
>>
>> From: plpgsql
>>
>> LOG:  Send kill to PID: 11731120
>> LOG:  Retrun value of kill PID: ret= 0
>>
>> A kill -2 on the shell does not stop the backend process.
>> A kill -15 does stop the backend process.
>>
>> So the kill does not return a failure.
>>
>> The code in /src/backend/storage/lmgr/proc.c - CheckStatementTimeout()
>> of 8.4.20
>> does not look much different. The code in pqsignal.c is also the not
>> really different.
>>
>> Bye
>>   Rainer
>>
>> On 26.02.2014 18:00, Tom Lane wrote:
>>> Rainer Tammer <pgsql@spg.schulergroup.com> writes:
>>>> So we can be pretty sure that the SIGINT does not interrupt semop() on
>>>> AIX 71.
>>> Looks that way :-(.  It would be interesting to add a check to see if the
>>> kill() is returning a failure indication or not.  The existing code
>>> doesn't bother because there's not really anything it can do about it,
>>> but for this purpose it would be good to know.
>>>
>>>             regards, tom lane
>>>
>>>
>>
>
>