Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group