Data corruption after an update set ...?

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Data corruption after an update set ...?
Date: 2011-08-22 20:36:31
Message-ID: 20110822203631.GA30483@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

[Using postgresql-8.4.8-0squeeze1 under GNU-linux/debian]

Hi all!

I've just discovered that 456 records out of 1510 contained in a table
of my db bear the same content in two fields: the original data have
disappeared and I do not know how this occurred.

Luckily enough I'll be able to recover a large part of lost data but
would like to understand what happened: looking at .psql_history I can
see the command which might have caused the whole mess (see below)
although similar commands have been used in many other occasions without
doing any harm.

So the question are:
1. what caused the mess?
2. might depend on the processor (1300Mhz 10 years old)?
3. a HD failure?

I should be grateful for any hints.

Regards,
ennio

---------------------- .psql_history (partial)

_HiStOrY_V2_
..............
# update bibl_provv set titolo='Città scomparse. Tit.or.: «Versunken
# Städte. Eine Buch von Glanz und Untergang»', altre_notizie='Trad. di
# Enrico Massa. Prima edizione maggio 1971 nella collezione "I
# Garzanti"', n_pag_testo=363, car_tec_ed='br.fig.', largh_cm=11.0,
# alt_cm=17.8 where n_prog=10606;
..............
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
Ricevo solo messaggi Content-Type: plain/text (no html o multipart). )=(
!!! --> e-mail a mio nome via OE (M$) sono false e infette <-- !!!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Merlin Moncure 2011-08-22 21:27:18 Re: Data corruption after an update set ...?
Previous Message Alan Hodgson 2011-08-20 18:55:33 Re: PostgreSQL on Amazon EC2/EBS