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