Re: SCSI Error - Mailing list pgsql-hackers

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