472,950 Members | 2,451 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,950 software developers and data experts.

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


-----Original Message-----
From: pg***************@postgresql.org
[mailto:pg***************@postgresql.org]On Behalf Of Egyd Csaba
Sent: 2004. jlius 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 Egyd

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
0 1698

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: OneSolution | last post by:
I need to decide on which database system to use for our company. What is the popular opinion on PostGres vs. MySql? Thanks, Santosh
7
by: Abdul-Wahid Paterson | last post by:
Hi, I have had a site working for the last 2 years and have had no problems until at the weekend I replace my database server with a newer one. The database migration went like a dream and I had...
11
by: Angel Todorov | last post by:
Hello, sometimes I get a strange error from postgresql when I try to connect using ssl to the server: LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token "hostssl" FATAL: ...
7
by: Ken Guest | last post by:
Folks, I have a question or two regarding PHP and Postgres on the issue of speed: 1. Is the semicolon at the end of SQL superflous when sent to Postgres? Should it make much of a difference if I...
18
by: Chris Travers | last post by:
Hi all; I have been looking into how to ensure that synchronous replication, etc. could best be implimented. To date, I see only two options: incorporate the replication code into the database...
4
by: Gregory S. Williamson | last post by:
If anyone has any advice on building Postgres 7.4 for a freeBSD box it surewould be welcome. TIA, Greg Williamson DBA GlobeXplorer LLC ----------------------
8
by: Mike | last post by:
Hello, I have a few rather urgent questions that I hope someone can help with (I need to figure this out prior to a meeting tomorrow.) First, a bit of background: The company I work for is...
1
by: Matthew Hixson | last post by:
I am currently working on a Java web application in which we are making use of the JDBC driver for Postgres 7.4.1. Part of our application allows the administrators to manage a large number of...
1
by: Karam Chand | last post by:
Hello, My linux admin left the job. We had a PostgreSQL installed under his username. He used to maintain it. Now I am looking at the Linux box and I am just a super duper newbie in Linux...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.