unable to locate a valid checkpoint

Поиск
Список
Период
Сортировка
Искать

unable to locate a valid checkpoint

От:
Auri Mason <amason@syntrex.com>
Дата:
Hi to all,

I'm quite new for this list, but I've already a big problem.
After a shutdown, the postmaster doesn't restart due to a checkpoint 
error.
The data of the DB is ... ehm important... so, how can I recover my 
installation?

message:
##########################################

FindExec: found "/usr/bin/postmaster" using argv[0]
2002-03-22 13:42:46 [6002]   DEBUG:  database system was shut down at 
2002-03-22 11:46:11 CET
2002-03-22 13:42:46 [6002]   DEBUG:  ReadRecord: invalid resource manager 
id 157 at (0, 561372168)
2002-03-22 13:42:46 [6002]   DEBUG:  Invalid primary checkPoint record
2002-03-22 13:42:46 [6002]   DEBUG:  Invalid RMID in secondary checkPoint 
record
2002-03-22 13:42:46 [6002]   FATAL 2:  Unable to locate a valid CheckPoint 
record
2002-03-22 13:42:46 [6002]   DEBUG:  proc_exit(2)
2002-03-22 13:42:46 [6002]   DEBUG:  shmem_exit(2)
2002-03-22 13:42:46 [6002]   DEBUG:  exit(2)
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: Startup proc 6002 exited wit
##############################

TIA, Auri 

Re: unable to locate a valid checkpoint

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Auri Mason  writes:
> I'm quite new for this list, but I've already a big problem.
> After a shutdown, the postmaster doesn't restart due to a checkpoint 
> error.

"Shutdown"?  Exactly what happened there?  It certainly doesn't look
like you had a clean shutdown.

At this point I think your only hope is contrib/pg_resetxlog, but that's
a very blunt instrument.  It'd be nice to understand what went wrong.

			regards, tom lane

Re: unable to locate a valid checkpoint

От:
Auri Mason <amason@syntrex.com>
Дата:
Hi Tom & pg_list,

> "Shutdown"?  Exactly what happened there?  It certainly doesn't look
> like you had a clean shutdown.

mmm, yes the postmaster was running in foregroud and was interrupted by a 
CTRL+C....

What's the correct way to shutdown? kill -15 I think...

> At this point I think your only hope is contrib/pg_resetxlog, but that's
> a very blunt instrument.  It'd be nice to understand what went wrong.

pg_resetxlog.... mmm I've to read something about this command! U think 
this is the solution?

TIA, Auri


Re: unable to locate a valid checkpoint

От:
Auri Mason <amason@syntrex.com>
Дата:
Always me... ;P

I've just recover my installation by using pg_resetxlog.

But, what is the operation made by this command? I believe it performs a 
reset to the previous checkpoint, so some data could be lost..

From now I'll use the start/stop/status script that I've found in 
contrib/start_script dir!

Auri

FAQ