On 23/11/05 9:36 pm, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > Adam Witney <awitney@xxxxxxxxxx> writes: >> Thanks for the help.... Here is the output: > >> adam@bugsdb:/opt$ dd bs=8k skip=73333 count=1 if=134401991.4 | od -x >> 0000000 0000 0000 0000 0000 0000 0000 0000 0000 >> * >> 0010000 1d9e 201c 0fa0 0000 0010 0000 0000 000b >> 0010020 0ca6 19fb 1797 0ab4 000a 0000 0000 0001 >> 0010040 01af 0000 000a 0000 0000 0001 0ca7 0000 >> 0010060 0012 0000 0000 0010 0002 1190 068f 0c9a >> ... > >> Unfortunately I have no idea what any of that means! > > The second half of the page looks reasonable, but the first half > is all zeroes :-(. (dd uses "*" to mean "same as above".) > > It's unlikely that this is Postgres' fault; I can't think of any > plausible pathology within PG that would so carefully zero out just > half of a page. What seems more likely is that the block size on the > underlying filesystem is 4K, and that either a kernel bug or a disk > drive error has caused the system to drop the contents of one block. > If I had to bet with no additional info, I'd bet on kernel bug. What's > the platform exactly, and what filesystem are you using? Linux bugsdb 2.4.26 #1 SMP Wed May 5 12:08:48 BST 2004 i686 unknown /dev/md2 on /pg_data type xfs (rw,noatime) /dev/md2 is a software RAID5 device. Also PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC 2.95.4 This table is only ever COPY'd to from data files, no updates or deletes, if I could find out which data file this bit comes from I could just reupload that file... Is it possible to tell what the data actually is from the data I sent? Thanks again Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
