Problem with PostgreSQL 9.2.7 and make check on AIX 7.1

From: Rainer Tammer <pgsql(at)spg(dot)schulergroup(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem with PostgreSQL 9.2.7 and make check on AIX 7.1
Date: 2014-02-24 10:29:00
Message-ID: 530B1EEC.1080402@spg.schulergroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,
I am still using a 8.2 PortgresSQL for an older application.
I have compiled 8.2.11 (same as on the old server) and
8.2.23 (latest 8.2) on AIX 7.1 TL3 SP1 (latest level) with
the IBM C/C++ V12 compiler.

Unfortunate I see the following errors:

...
2014-02-24 10:07:30 CET LOG: received fast shutdown request <--- here
2014-02-24 10:07:30 CET LOG: shutting down
2014-02-24 10:07:30 CET LOG: database system is shut down
2014-02-24 10:07:36 CET LOG: database system was shut down at
2014-02-24 10:07:30 CET
2014-02-24 10:07:36 CET LOG: checkpoint record is at 0/E9F073E0
2014-02-24 10:07:36 CET LOG: redo record is at 0/E9F073E0; undo record
is at 0/0; shutdown TRUE
2014-02-24 10:07:36 CET LOG: next transaction ID: 0/7161900; next OID:
39134
2014-02-24 10:07:36 CET LOG: next MultiXactId: 1; next MultiXactOffset: 0
2014-02-24 10:07:36 CET LOG: database system is ready
2014-02-24 10:08:35 CET LOG: received fast shutdown request <--- here
2014-02-24 10:08:35 CET LOG: shutting down
2014-02-24 10:08:35 CET LOG: database system is shut down
2014-02-24 10:10:45 CET LOG: database system was shut down at
2014-02-24 10:08:35 CET
2014-02-24 10:10:45 CET LOG: checkpoint record is at 0/E9F07430
2014-02-24 10:10:45 CET LOG: redo record is at 0/E9F07430; undo record
is at 0/0; shutdown TRUE
2014-02-24 10:10:45 CET LOG: next transaction ID: 0/7161950; next OID:
39134
2014-02-24 10:10:45 CET LOG: next MultiXactId: 1; next MultiXactOffset: 0
2014-02-24 10:10:45 CET LOG: database system is ready

I had set a higher log level to see all client statements.
Unfortunately I could see in the log file that when the
fast shutdown was executed that there where no running statements.

I never had a problem on AIX 5.3. Do you have any ideas??

So I have decided to give 9.2.7 a try. During the make check I have
found two failures - to be more precisely two hangs.

I have changed parallel_schedule to run most test sequential.
The following tests do show a problem:

1. problem

plpgsql.out <- this test hangs in statement_timeout.

...
end$$ language plpgsql;
set statement_timeout to 2000;
select blockme(); <- hang

2. problem

prepared_xacts.out <- this test hangs in statement_timeout.

...
-- pxtest3 should be locked because of the pending DROP
set statement_timeout to 2000;
SELECT * FROM pxtest3; <- hang

These tests do not move forward even if I wait 10 minutes.

So my conclusion is that the statement_timeout does not work as expected.

Bye
Rainer

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rainer Tammer 2014-02-24 11:32:38 Re: Problem with PostgreSQL 9.2.7 and make check on AIX 7.1
Previous Message cyriacmaliyil 2014-02-24 10:20:27 BUG #9333: The PostgreSQL service stops unexpectedly