psql: FATAL: the database system is starting up
Hi,
I run out of disk space on the box and had to delete some files and restart postgres. Ever since I have been getting the above message. PS shows this process:
9351 ? D 0:04 postgres: startup process
Running an strace on this process shows that it is trying to write 8K of zeros to a file called 023D in pg_clog but fails at 224K and it just keeps trying forever.
I tried replacing the file with one I created - 256K as the other files in the pg_clog and filled with zeros. But it keeps doing the same thing :
open("pg_clog/023D", O_RDWR|O_CREAT|O_LARGEFILE, 0600) = 10
_llseek(10, 221184, [221184], SEEK_SET) = 0
write(10, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192
fsync(10) = 0
close(10)
Any ideas on what might be causing this and what I can do to fix it will be greatly appreciated. Need to get it fixed fast.
Many Thanks
valiouk
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
Valentin Bogdanov <valiouk@yahoo.co.uk> writes:
I run out of disk space on the box and had to delete some files and restart postgres. Ever since I have been getting the above message. PS shows this process:
9351 ? D 0:04 postgres: startup process
Running an strace on this process shows that it is trying to write 8K of zeros to a file called 023D in pg_clog but fails at 224K and it just keeps trying forever.
What PG version is this, exactly? What files did you delete (any of
Postgres' files)?
regards, tom lane
Valentin Bogdanov <valiouk@yahoo.co.uk> writes:
What PG version is this, exactly? What files did you
delete (any of Postgres' files)?
It's 8.1 and no I didn't delete any postgres files, just some old proxy logs.
8.1.what?
regards, tom lane
Import Notes
Reply to msg id not found: 605428.46654.qm@web25807.mail.ukl.yahoo.comReference msg id not found: 605428.46654.qm@web25807.mail.ukl.yahoo.com | Resolved by subject fallback
It's 8.1.11
--- On Wed, 2/7/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:From: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [BUGS] psql: FATAL: the database system is starting up
To: valiouk@yahoo.co.uk
Cc: pgsql-bugs@postgreSQL.org
Date: Wednesday, 2 July, 2008, 3:19 PM
Valentin Bogdanov <valiouk@yahoo.co.uk> writes:What PG version is this, exactly? What files did
you
delete (any of Postgres' files)?
It's 8.1 and no I didn't delete any postgres
files, just some old proxy logs.
8.1.what?
regards, tom lane
--
Sent via pgsql-bugs mailing list
(pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html