Re: Why the data changes it's value by itself!
От | Ardian Xharra |
---|---|
Тема | Re: Why the data changes it's value by itself! |
Дата | |
Msg-id | 022501c70a6d$f428dc20$0f01a8c0@Boxxo обсуждение исходный текст |
Ответ на | Why the data changes it's value by itself! ("Ardian Xharra" <axharra@boxxo.info>) |
Ответы |
Re: Why the data changes it's value by itself!
|
Список | pgsql-general |
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@archonet.com> To: "Ardian Xharra" <axharra@boxxo.info> Cc: "postgreSQL postgreSQL" <pgsql-general@postgresql.org> 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 > >
В списке pgsql-general по дате отправления: