UnixWare 7 vacuum failures on the regression database.

From: "Billy G(dot) Allie" <Bill(dot)Allie(at)mug(dot)org>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: UnixWare 7 vacuum failures on the regression database.
Date: 1998-09-20 04:34:39
Message-ID: 199809200434.AAA13129@bgalli.mug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The following failures in the regression tests have started appearing in the
last couple of days in the sanity_check test:

====== sanity_check ======
1a2,3
> NOTICE: AbortTransaction and not in in-progress state
> NOTICE: AbortTransaction and not in in-progress state
6,32c8,9
< relname |relhasindex
< --------------+-----------
< bt_f8_heap |t
< bt_i4_heap |t
< bt_name_heap |t
< bt_txt_heap |t
[...]
< shighway |t
< tenk1 |t
< tenk2 |t
< (23 rows)
<
---
> NOTICE: AbortTransaction and not in in-progress state
> NOTICE: AbortTransaction and not in in-progress state

The VACUUM command against the regression data base fails with the following
error messages:

[...]
DEBUG: --Relation circle_tbl--
DEBUG: Pages 1: Changed 0, Reapped 0, Empty 0, New 0; Tup 6: Vac 0, Crash 0,
Un
Used 0, MinLen 64, MaxLen 64; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail.
P
ages 0/0. Elapsed 0/0 sec.
DEBUG: --Relation timespan_tbl--
DEBUG: Pages 1: Changed 0, Reapped 0, Empty 0, New 0; Tup 10: Vac 0, Crash 0,
U
nUsed 0, MinLen 52, MaxLen 52; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail.
Pages 0/0. Elapsed 0/0 sec.
ERROR: cannot write block 0 of circle_tbl [regression] blind
NOTICE: AbortTransaction and not in in-progress state
ERROR: cannot write block 0 of circle_tbl [regression] blind
NOTICE: AbortTransaction and not in in-progress state

Running the VACUUM command manually in the regression data base fails but at
different blocks in different tables (no obvious pattern in blocks and tables).

Once vacuum runs and fails, any query in the database will fail with the:
NOTICE: AbortTransaction and not in in-progress state
NOTICE: AbortTransaction and not in in-progress state
messages displayed. Re-connecting to the database (i.e. '\c regression')
allows the queries to succeed (until vacuum is executed).

Any help will be greatly appreciated.
--
____ | Billy G. Allie | Domain....: Bill(dot)Allie(at)mug(dot)org
| /| | 7436 Hartwell | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)com
|/ |LLIE | (313) 582-1540 |

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy J.M. Cain 1998-09-20 04:45:23 SQL Triggers
Previous Message Robert Bruccoleri 1998-09-20 03:50:44 Results of port of Sept 18 port of PostgreSQL