Skip site navigation (1) Skip section navigation (2)

URGENT - Postgres won't work

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "pgsql-admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: URGENT - Postgres won't work
Date: 2004-07-16 10:22:38
Message-ID: 002801c46b1e$e9ccf1d0$230a0a0a@compaq (view raw or flat)
Thread:
Lists: pgsql-admin
Hi All,
I have the following problem: (RH7.1, PostgreSQL 7.4.1)
After stopping postresql service the /data/pgsql/tgr/data/postmaster.pid is
not deleted.

Starting Postgresql (after deleting the pid file manually):
-------------------------------------------------------
[root(at)tgrweb /root]# /etc/init.d/postgresql start
Checking postgresql installation: no database files found.
Initializing database...                                   [  OK  ]
Starting postgresql service:                               [  OK  ]
-------------------------------------------------------


Trying to start psql console:
-------------------------------------------------------
[tgruser(at)tgrweb tgruser]$ psql tgr
psql: FATAL:  the database system is starting up
-------------------------------------------------------


When I try to 'ls -l' the $PGDATA/base/19536 directory then the console
freezes and does nothing. Can it be a filesystem error? Or what else? What
can I do with it? How can I check it? The system is on a RAID1 SCSI array.
Fsck says that it is mounted and not recomended running fsck on a mounted
volume.

Some log entries regarding SCSI (is any of them critical?):
-------------------------------------------------------
[root(at)tgrweb log]# pwd
/var/log
[root(at)tgrweb log]# grep -r "SCSI" *
dmesg:SCSI subsystem driver Revision: 1.00
dmesg:sym53c896-0: Downloading SCSI SCRIPTS.
dmesg:sym53c896-1: Downloading SCSI SCRIPTS.
dmesg:  Type:   Direct-Access                      ANSI SCSI revision: 02
dmesg:  Type:   Direct-Access                      ANSI SCSI revision: 02
dmesg:  Type:   Processor                          ANSI SCSI revision: 02
dmesg:sym53c896-0-<0,*>: WIDE SCSI (16 bit) enabled.
dmesg:sym53c896-0-<0,*>: FAST-40 WIDE SCSI 80.0 MB/s (25 ns, offset 31)
dmesg:SCSI device sda: 71132960 512-byte hdwr sectors (36420 MB)
dmesg:sym53c896-0-<1,*>: WIDE SCSI (16 bit) enabled.
dmesg:sym53c896-0-<1,*>: FAST-40 WIDE SCSI 80.0 MB/s (25 ns, offset 31)
dmesg:SCSI device sdb: 71132960 512-byte hdwr sectors (36420 MB)
messages:Jul 12 01:00:24 Tgrweb kernel: sym53c896-0: SCSI parity error
detected: SCR1=1 DBC=11000200 SBCL=ae
messages:Jul 12 01:00:24 Tgrweb kernel: sym53c896-0-<0,*>: WIDE SCSI (16
bit) enabled.
messages:Jul 12 01:00:24 Tgrweb kernel: sym53c896-0-<0,*>: FAST-40 WIDE SCSI
80.0 MB/s (25 ns, offset 31)
messages:Jul 12 01:00:24 Tgrweb kernel: sym53c896-0: SCSI parity error
detected: SCR1=3 DBC=11000000 SBCL=29
messages:Jul 12 01:00:24 Tgrweb kernel: sym53c896-0-<0,*>: WIDE SCSI (16
bit) enabled.
messages:Jul 12 01:00:25 Tgrweb kernel: sym53c896-0-<0,*>: FAST-40 WIDE SCSI
80.0 MB/s (25 ns, offset 31)
messages:Jul 12 01:00:25 Tgrweb kernel: sym53c896-0: SCSI parity error
detected: SCR1=3 DBC=11000600 SBCL=ae
messages:Jul 12 01:00:26 Tgrweb kernel: sym53c896-0-<1,*>: WIDE SCSI (16
bit) enabled.
messages:Jul 12 01:00:27 Tgrweb kernel: sym53c896-0-<1,*>: FAST-40 WIDE SCSI
80.0 MB/s (25 ns, offset 31)
messages.2:Jul  9 10:21:20 Tgrweb kernel: SCSI subsystem driver Revision:
1.00
messages.2:Jul  9 10:21:20 Tgrweb kernel: sym53c896-0: Downloading SCSI
SCRIPTS.
messages.2:Jul  9 10:21:20 Tgrweb kernel: sym53c896-1: Downloading SCSI
SCRIPTS.
messages.2:Jul  9 10:21:20 Tgrweb kernel:   Type:   Direct-Access
ANSI SCSI revision: 02
messages.2:Jul  9 10:21:20 Tgrweb kernel:   Type:   Direct-Access
ANSI SCSI revision: 02
messages.2:Jul  9 10:21:20 Tgrweb kernel:   Type:   Processor
ANSI SCSI revision: 02
messages.2:Jul  9 10:21:20 Tgrweb kernel: sym53c896-0-<0,*>: WIDE SCSI (16
bit) enabled.
messages.2:Jul  9 10:21:20 Tgrweb kernel: sym53c896-0-<0,*>: FAST-40 WIDE
SCSI 80.0 MB/s (25 ns, offset 31)
messages.2:Jul  9 10:21:20 Tgrweb kernel: SCSI device sda: 71132960 512-byte
hdwr sectors (36420 MB)
messages.2:Jul  9 10:21:21 Tgrweb kernel: sym53c896-0-<1,*>: WIDE SCSI (16
bit) enabled.
messages.2:Jul  9 10:21:21 Tgrweb kernel: sym53c896-0-<1,*>: FAST-40 WIDE
SCSI 80.0 MB/s (25 ns, offset 31)
messages.2:Jul  9 10:21:21 Tgrweb kernel: SCSI device sdb: 71132960 512-byte
hdwr sectors (36420 MB)
------------------------------------------------------------------


Many thanks for any reply.

-- Csaba Együd

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 2004. 07. 12.



Responses

pgsql-admin by date

Next:From: Joost KraaijeveldDate: 2004-07-16 10:42:15
Subject: Re: Missing casts in PgAdmin III
Previous:From: Joost KraaijeveldDate: 2004-07-16 09:12:02
Subject: Missing casts in PgAdmin III

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group