Thread: FW: [ADMIN] URGENT - Postgres won't work

FW: [ADMIN] URGENT - Postgres won't work

From
Együd Csaba
Date:

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Együd Csaba
> Sent: 2004. július 16. 12:23
> To: pgsql-admin (E-mail)
> Subject: [ADMIN] URGENT - Postgres won't work
>
>
> 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@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@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@tgrweb log]# pwd
> /var/log
> [root@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.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index
> scan if your
>       joining column's datatypes do not match
>
> ---
> Incoming 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.
>

---
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.