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



Fri, 20 Sep 2002 12:08:51 -0000
"Ricardo Fogliati" <ricardo@4linux.com.br>
SCSI Error
On Fri, 20 Sep 2002, 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
> [deleted]...
> 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


Not sure what you're asking for. That's a hardware error. Back up immediately,
if you haven't already got decent backups, and fix the disk/controller.

Could possibly be a filesystem error but even if so it's still casting doubt on
the hardware. On the other hand I do believe I saw a message recently saying
that some of the 2.4 series kernels had file system bugs. I don't know which,
someone else might be able to expand.


--
Nigel J. Andrews



Fri, 20 Sep 2002 13:32:52 +0100 (BST)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: SCSI Error
On Fri, Sep 20, 2002 at 01:32:52PM +0100, Nigel J. Andrews wrote:

> the hardware. On the other hand I do believe I saw a message
> recently saying that some of the 2.4 series kernels had file system
> bugs.

I recall problems, offhand, with 2.4.5, 2.4.10, 2.4.11 (which was so
broken that you couldn't recover), and 2.4.15.  I seem to recall a
report on 2.4.12, also.  There's a page at
<http://www.atnf.csiro.au/people/rgooch/linux/docs/kernel-newsflash.html>
that provides some summaries of known problems, and filesystem
corruption doesn't show up for all the ones I mentioned, so maybe my
memory is faulty (alas, I didn't get the ECC option).

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


Fri, 20 Sep 2002 11:02:05 -0400
Andrew Sullivan <andrew@libertyrms.info>
Re: SCSI Error
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
20 Sep 2002 11:01:12 -0500
Greg Copeland <greg@CopelandConsulting.Net>
Re: SCSI Error
> > the hardware. On the other hand I do believe I saw a message
> > recently saying that some of the 2.4 series kernels had file system
> > bugs.
>
> I recall problems, offhand, with 2.4.5, 2.4.10, 2.4.11 (which was so
> broken that you couldn't recover), and 2.4.15.  I seem to recall a
> report on 2.4.12, also.  There's a page at
> <http://www.atnf.csiro.au/people/rgooch/linux/docs/kernel-newsflash.html>
> that provides some summaries of known problems, and filesystem
> corruption doesn't show up for all the ones I mentioned, so maybe my
> memory is faulty (alas, I didn't get the ECC option).

Hehehe - those poor sad people who use Linux - try FreeBSD for a change, at
least it works ;)

Chris


Mon, 23 Sep 2002 10:45:53 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: SCSI Error