Ensure you don't have termination issues. Make sure your SCSI interface is configured correctly for your SCSI environment, especially on matters of termination. Make sure you have enough power to your drive and if possible, make sure your drives are hung off of distinct power segments coming from your power supply. Of course, make sure you have enough power being supplied from your power supply to power all of your drives and *equipment* (cards, CPU, fans, etc). Last, be sure your cables are in good working order and that they are as far away from the power supply and cables as is possible. SCSI is notorious for suffering from RF interference especially on long cables. If all else fails, you may try swapping cables to see if this helps.
If at all possible, immediately fsck (!!!!don't make it perform any repairs!!!!) and backup! The fsck will let you know if you should reasonably expect to have a meaningful backup. Requesting fsck to repair in this situation could actually result in more/worse (unrecoverable) corruption. If the fsck does report potential FS damage, accept the fact that some of your data (and resulting backup) may be corrupt, perhaps even unrecoverably so. I'm using a 7880 here and have never had notable issues save only for bugs in the Linux SCSI drivers. Greg On Fri, 2002-09-20 at 07:08, Ricardo Fogliati wrote: > Hiya Lists.... > > Somebody could help me? I am with an error when the Postgresql makes Insert, > Delete or Update > > kernel: SCSI disk error : host 2 channel 0 id 0 lun 0 return code = 70000 > kernel: I/O error: dev 08:08, sector 47938856 > kernel: SCSI disk error : host 2 channel 0 id 0 lun 0 return code = 70000 > kernel: I/O error: dev 08:08, sector 47938800 > kernel: SCSI disk error : host 2 channel 0 id 0 lun 0 return code = 70000 > kernel: I/O error: dev 08:08, sector 47938864 > kernel: SCSI disk error : host 2 channel 0 id 0 lun 0 return code = 70000 > kernel: I/O error: dev 08:08, sector 47938872 > kernel: SCSI disk error : host 2 channel 0 id 0 lun 0 return code = 70000 > kernel: I/O error: dev 08:08, sector 47938808 > > Version: > > postgresql-7.2.1-5 > postgresql-devel-7.2.1-5 > postgresql-libs-7.2.1-5 > postgresql-server-7.2.1-5 > > Server: > > processor : 0 > vendor_id : GenuineIntel > cpu family : 6 > model : 11 > model name : Intel(R) Pentium(R) III CPU family 1266MHz > stepping : 1 > cpu MHz : 1258.309 > cache size : 512 KB > fdiv_bug : no > hlt_bug : no > f00f_bug : no > coma_bug : no > fpu : yes > fpu_exception : yes > cpuid level : 2 > wp : yes > flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca > cmov pat pse36 mmx fxsr sse > bogomips : 2510.02 > > Kernel: > > Linux version 2.4.7-10custom (gcc version 2.96 20000731 (Red Hat Linux 7.1 > 2.96-98)) #9 Mon > Sep 16 17:50:13 BRT 2002 > > Mem Info > total: used: free: shared: buffers: cached: > Mem: 789540864 782589952 6950912 81764352 34406400 583122944 > Swap: 802873344 2957312 799916032 > MemTotal: 771036 kB > MemFree: 6788 kB > MemShared: 79848 kB > Buffers: 33600 kB > Cached: 566568 kB > SwapCached: 2888 kB > Active: 14476 kB > Inact_dirty: 664852 kB > Inact_clean: 3576 kB > Inact_target: 136 kB > HighTotal: 0 kB > HighFree: 0 kB > LowTotal: 771036 kB > LowFree: 6788 kB > SwapTotal: 784056 kB > SwapFree: 781168 kB > NrSwapPages: 195292 pages > > pci > > Bus 2, device 9, function 0: > SCSI storage controller: Adaptec 7899P (rev 1). > IRQ 10. > Master Capable. Latency=96. Min Gnt=40.Max Lat=25. > I/O at 0x2100 [0x21ff]. > Non-prefetchable 64 bit memory at 0xedfff000 [0xedffffff]. > > Swap > > Filename Type Size Used Priority > /dev/sda6 partition 784056 2888 -1 > > Tkanksfull > -- > Ricardo Fogliati > 4 Linux/Vesper > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
signature.asc
Description: This is a digitally signed message part
