Thread: BUG #5380: error in xlog

BUG #5380: error in xlog

From
"Krishnamoorthy"
Date:
The following bug has been logged online:

Bug reference:      5380
Logged by:          Krishnamoorthy
Email address:      krishnachml@gmail.com
PostgreSQL version: 8.0.3
Operating system:   RHEL 3
Description:        error in xlog
Details:

Dear Sir/Mam.

Kindly find the below  error,when i am trying to view database using /d
command,

WARNING:  could not write block 521 of 1663/31219/31430
DETAIL:  Multiple failures --- write error may be permanent.
ERROR:  xlog flush request 0/37395DB4 is not satisfied --- flushed only to
0/30000058
CONTEXT:  writing block 521 of relation 1663/31219/31430

Kindly send me the solution for above mentioned issue.

Thanks and Regards,
Krishnamoorthy

Re: BUG #5380: error in xlog

From
tomas@tuxteam.de
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, Mar 19, 2010 at 05:30:30AM +0000, Krishnamoorthy wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5380
> Logged by:          Krishnamoorthy
> Email address:      krishnachml@gmail.com
> PostgreSQL version: 8.0.3
> Operating system:   RHEL 3
> Description:        error in xlog
> Details:
>
> Dear Sir/Mam.
>
> Kindly find the below  error,when i am trying to view database using /d
> command,
>
> WARNING:  could not write block 521 of 1663/31219/31430
> DETAIL:  Multiple failures --- write error may be permanent.
> ERROR:  xlog flush request 0/37395DB4 is not satisfied --- flushed only to
> 0/30000058
> CONTEXT:  writing block 521 of relation 1663/31219/31430
>
> Kindly send me the solution for above mentioned issue.

This looks like a full disk or some other hardware failure, not like a
PostgreSQL bug. Please check your hardware (e.g. have a look at the
system log files: /var/log/syslog may be a good starting point).

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFLpGQ7Bcgs9XrR2kYRAixlAJ4+vrwmEsXRKMBUtSd9Is902nSIdACeIX6G
9+R04+ysSvJVpYqTEz2XEdU=
=yX2a
-----END PGP SIGNATURE-----