From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: Theory about XLogFlush startup failures |
Date: | 2002-01-23 23:39:16 |
Message-ID: | 3705826352029646A3E91C53F7189E32518484@sectorbase2.sectorbase.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> So the failure-to-start-up problem can be blamed entirely on 7.1's
> failure to do anything with LSN fields in pg_log pages. I was able to
No, first reported problem can be blamed on RAM failures.
> So I am still dissatisfied with doing elog(STOP) for this condition,
> as I regard it as an overly strong reaction to corrupted data;
> moreover, it does nothing to fix the problem and indeed gets in
> the way of fixing the problem.
Totally agreed but..
> I propose the attached patch.
> What do you think?
>
...
> + if (XLByteLT(LogwrtResult.Flush, record))
> + elog(InRecovery ? NOTICE : ERROR,
I suggest also to set some flag here if InRecovery,
to elog(STOP
DATA FILE(S) CORRUPTED!
RESTORE DATA FROM BACKUP OR
RESET WAL TO DUMP/MANUALLY FIX ERRORS
- or something like that -:) - after all data buffers
flushed.
What's wrong with this? It's not Ok automatically restart
knowing about errors in data.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Studenmund | 2002-01-23 23:47:55 | Re: RFD: schemas and different kinds of Postgres objects |
Previous Message | Stephan Szabo | 2002-01-23 23:30:07 | Re: RFD: schemas and different kinds of Postgres objects |