Re: Win32 Powerfail testing - results

Dave Page <dpage@vale-housing.co.uk>

From: "Dave Page" <dpage@vale-housing.co.uk>
To: <vev@michvhf.com>
Cc: <dpage@vale-housing.co.uk>, <pgsql-hackers@postgresql.org>
Date: 2003-02-03T19:54:15Z
Lists: pgsql-hackers
 Vince Vielhaber allegedly said:
> On Mon, 3 Feb 2003, Dave Page wrote:
>
>> Run | Errors Detected
>> =============================================================
>>  07 | COUNT CHECK - Duplicate or missing rows detected (10262)!! 09 |
>>  DISTINCT CHECK - Duplicate or missing rows detected (9893)!!
>>     | COUNT CHECK - Duplicate or missing rows detected (9893)!!
>>  14 | COUNT CHECK - Duplicate or missing rows detected (10024)!!
>
> Out of curiousity, what was required to return things to normal
> again?

I ran the test app in reset mode which drops the table, then re-creates it
and populates it with fresh data. I thought it best to drop first to
eliminate possible problems with corrupt, but invisible tuples (if such a
thing could have occured).
Regards, Dave.