Inconsistent Postgres error when installing our product containing PostgreSQL 9.3.4

From: Diags101 <diags101(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Inconsistent Postgres error when installing our product containing PostgreSQL 9.3.4
Date: 2017-09-06 07:13:08
Message-ID: CAA_H3cWX3XsLSuKzfSjPY1+AvoZLQ7paNYzOPgYQ8qm5RifLOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm getting inconsistent Postgres errors, when we upgrade our product that
bundles PostgreSQL 9.3.4.
We have 13 databases and we get errors at different places of the database
setup.

Here are the failures:
1.
$POSTGRES/bin/psql -c " CREATE SEQUENCE serial1 START 1 CYCLE ;" -d $ARCHDB
exitIfCommandFailed "Schema creation"

ERROR: index "pg_type_oid_index" contains corrupted page at block 0
HINT: Please REINDEX it.

2.
$POSTGRES/bin/psql -c " CREATE TABLE RAWLOG (ID int8 PRIMARY KEY DEFAULT
nextval('serial1'),SOURCE varchar (100),RAWDATA bytea,WRITETIME timestamp
DEFAULT CURRENT_TIMESTAMP,BOOTTIME timestamp DEFAULT CURRENT_TIMESTAMP
,HIDDEN bool,VERSION int4);" -d $WORKINGDB

ERROR: relation "pg_catalog.pg_database" does not exist
LINE 7: FROM pg_catalog.pg_database d

3.
$POSTGRES/bin/pg_restore -d $EVWEB_DB -p$EVWEB_DB_PORT -U$SFMDB_SU
$VAR_TMP/evwebdump

ERROR: relation "pg_catalog.pg_namespace" does not exist
LINE 3: FROM pg_catalog.pg_namespace n

4.
$POSTGRES/bin/psql -c " CREATE TABLE RAWLOG (ID int8 PRIMARY KEY DEFAULT
nextval('serial1'),SOURCE varchar (100),RAWDATA bytea,WRITETIME timestamp
DEFAULT CURRENT_TIMESTAMP,BOOTTIME timestamp DEFAULT CURRENT_TIMESTAMP
,HIDDEN bool,VERSION int4);" -d $ARCHDB

ERROR: invalid page in block 0 of relation base/216257/11812

All these errors are inconsistent and the errors appear in some other
database, when I repeat the installation.

Any pointers or suggestions are welcome.

On behalf of the Diagnostics team,
Sanjay

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2017-09-06 09:07:44 Re: BDR, wal segment has been removed, is it possible move forward?
Previous Message Vijay Chaudhery 2017-09-06 05:16:27 Re: Postgres logs showing error after replication