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

Postmaster already running !!!

From: "Sivaraman K(dot)G" <Ganapathy(dot)Sivaraman(at)alcatel(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Postmaster already running !!!
Date: 2005-07-22 06:30:52
Message-ID: 42E0929C.66C09F29@alcatel.com (view raw or flat)
Thread:
Lists: pgsql-bugs
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi,
<p>I am running PostgreSQL version 8.0 in Solaris 8.
<br>I am starting the postmaster when the system is coming up.
<br>I am facing the following problem :
<p>FATAL:&nbsp; lock file "/data/ALAsm/PGSQL/data/postmaster.pid" already
exists
<br>HINT:&nbsp; Is another postmaster (PID 448) running in data directory
"/data/ALAsm/PGSQL/data"?
<p>is coming, eventhough postmaster wasn't running and postmaster fail
to start, which makes my system to go down (due to my script).
<p>I have to manually clean up the postmaster.pid from the directory /data/ALAsm/PGSQL/data
(from where I have initialized the database using
<br>initdb and running the postmaster).
<p>Can anyone help what is the problem here ?.
<p>Also, I got another problem.
<p>LOG:&nbsp; could not bind IPv6 socket: Cannot assign requested address
<br>HINT:&nbsp; Is another postmaster already running on port 5432? If
not, wait a few seconds and
<br>retry.
<br>LOG:&nbsp; could not bind socket for statistics collector: Cannot assign
requested address
<br>LOG:&nbsp; database system was interrupted at 2005-07-21 15:05:15 CDT
<br>LOG:&nbsp; checkpoint record is at 0/E06260
<br>LOG:&nbsp; redo record is at 0/E06260; undo record is at 0/0; shutdown
TRUE
<br>LOG:&nbsp; next transaction ID: 174106; next OID: 25721
<br>LOG:&nbsp; database system was not properly shut down; automatic recovery
in progress
<br>LOG:&nbsp; record with zero length at 0/E062A0
<br>LOG:&nbsp; redo is not required
<br>PANIC:&nbsp; could not access status of transaction 174106
<br>DETAIL:&nbsp; could not read from file "/data/ALAsm/PGSQL/data/pg_clog/0000"
at offset 40960: Error 0
<br>LOG:&nbsp; startup process (PID 501) was terminated by signal 6
<br>LOG:&nbsp; aborting startup due to startup process failure
<p>After this, postmaster is not running and the system got rebooted continuously.
<br>In this case, I have to manually cleanup all the database and run initdb
again to setup the database.
<p>Can any one help, what is the problem?.
<br>&nbsp;
<p>Thanks
<br>Siva
<br>&nbsp;
<br>&nbsp;
<pre>--&nbsp;
K.G.Sivaraman, Axes Technologies (I) Pvt Ltd

"The only SERVICE to be done for our lower classes is to give them&nbsp;
EDUCATION, to develop their lost individuality" - Swami Vivekananda</pre>
&nbsp;</html>



Attachment: unknown_filename
Description: text/html (2.3 KB)

Responses

pgsql-bugs by date

Next:From: Andrus AdamchikDate: 2005-07-22 08:45:46
Subject: BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB columns
Previous:From: jwDate: 2005-07-22 05:47:36
Subject: abstime bug

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