Does this message in application.log can be the source of problem
wuaueng.dll (1204) Synchronous read page checksum error -1018 ((1:801 1:801)
(0-13218) (0-14642)) occurred. Please restore the databases from a previous
backup.
Regards Ardian,
----- Original Message -----
From: "Richard Huxton" <dev@xxxxxxxxxxxx>
To: "Ardian Xharra" <axharra@xxxxxxxxxx>
Cc: "postgreSQL postgreSQL" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Friday, November 17, 2006 5:44 AM
Subject: Re: [GENERAL] Why the data changes it's value by itself!
Ardian Xharra wrote:
For the column: date(varchar 8) '2000606' the
SELECT ascii(substring(date,4,1)) from jnlsale WHERE id_jnlsale=28384
gives: 22
SELECT ascii('6'); gives 54
Hmm - a difference of 32, or a single bit (2^5).
For the column: amount(float 8) 1.20932764209866e-307 the
SELECT ascii(substring(amount,20,1)) from jnlsale WHERE id_jnlsale=28382
gives: 48
Sorry - this only applies to the text. I'd need to figure out the internal
format of the float8 and see what happened.
Well, if all the textual differences are single-bit (1,2,4,8,16,32...) I'd
suspect hardware. I can't imagine the kind of bug in PostgreSQL that would
cause that kind of error.
I can imagine a faulty RAM chip or slowly failing hard-disk causing that
kind of error though. I'd find a Linux live CD that supports memtest86 (or
one of its spin-offs) and leave it testing your RAM for 24 hours or so.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/536 - Release Date: 16/11/2006
