Hello, My customer has experienced a serious data corruption. He was using a posgresql version 8.0.3 I know that it is an old version.
Postgresql started to log "could not access status of transaction" messages. Since the transaction IDs were far away from what server was using I took a look at data files i pgsql/base/ and I found a total garbage there. In five tables (of about 100) I have found a one to four blocks of random data. In two places it was data from other table instead of random data. All these blocks have sizes which are multiplications of 512 (for example 1, 9, 26) and starts at offsets which are also a multiplication of 512. The database is small <1G and there are no deletes or updates to affected tables, just inserts and selects. The database was vacuumed about 3 months before the time the corruption has been noticed. The system is linux 2.4.31 filesystem XFS on RAID5 And there are no messages sugesting I/O error or something My question is: Is there any known bug in postgresql 8.0.3 that could lead to such a data corruption or is it rather a hardware problem? Best regards, Jacek Rembisz PS. Please cc me as I'm not a subscriber. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
