BUG #7625: corrupted pid file prevents postgreSQL from normal starting

From: tixu(at)cs(dot)ucsd(dot)edu
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7625: corrupted pid file prevents postgreSQL from normal starting
Date: 2012-10-29 00:07:01
Message-ID: E1TScsf-0003iy-78@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7625
Logged by: Tianyin Xu
Email address: tixu(at)cs(dot)ucsd(dot)edu
PostgreSQL version: 9.2.1
Operating system: Linux (actually doesn't matter)
Description:

Hi, Postgresql,

Maybe this problem is well studied, but I still hope to point it again
because the problem still exists in PostgreSQL and is affecting a lot of
users.

------------------

I met the following message because of the issue I reported in BUG #7624:

FATAL: XX000: bogus data in lock file
"/home/tianyin/postgresql-9.2.1/local/pgsql/data/.s.PGSQL.5432.lock": ""

Searching a bit on the Internet, I found so many people are suffering from
the same problem (actually this's good for fixing):

http://solaimurugan.blogspot.com/2010/10/fatal-bogus-data-in-lock-file-in.html

http://www.backtrack-linux.org/forums/showthread.php?t=41151

http://dbaspot.com/postgresql/209123-postmaster-refuses-start.html

http://jameslovecomputers.wordpress.com/2012/10/09/fatal-bogus-data-in-lock-file-postmaster-pid/

I noticed you guys had discussion on the similar problem in the pgsql-hacker
mailing list,

http://archives.postgresql.org/message-id/4F05A338.7000409%40enterprisedb.com

I don't know whether I encountered the same problem, since the reported
problem is for postmaster
(FATAL: bogus data in lock file "postmaster.pid": "") but mine is for
postgreSQL server.

I strongly agree that,
"On a laptop it's not a big deal, but it sort of sucks if your production
database fails to start automatically after an unexpected power outage."

I apologize if it's the same problem. But, if not, it's still worthy solving
the problem.

Thanks a lot,
Tianyin

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2012-10-29 14:19:21 Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations
Previous Message tixu 2012-10-28 07:35:36 BUG #7624: Misleading Log Message & Inconsistent Configuration Design