Dear All ,
I am using postgres 7.3. on RHEL 4.0
If I do any operation(select , delete , count , update , vacuum,reindex) on a table ; the error comes "Cannot read block 348938 of pdbsynchtable"
Given below is the o/p of the files corresponding to the table
-rw------- 1 postgres postgres 1073741824 Apr 7 10:56 25205
-rw------- 1 postgres postgres 1073741824 Aug 29 2009 25205.1
-rw------- 1 postgres postgres 1073741824 Mar 30 12:32 25205.2
-rw------- 1 postgres postgres 1048674304 Apr 7 10:55 25205.3
I some blogs its given that this problem occurs due to bad sectors on disk and the resolution given is reidexing, vacuuming the table or restoring to the last backup.
In my case neither the table is getting reindexed nor vaccum ,even i am not able to get the count of the recordss in the table. There is no option of restoring to backup as i dont have one.
Even if If i try to pad the file 25205.3 using DD command I am not able to calculate the bytes to be padded as the total count of the blocks is comming out to be 521228 and the error is coming cannot read the 348938 block.
Kindly help in identifying and solving this problem.
Regards,
Utsav
Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the origin al intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for los s or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no bin ding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.