From: Wei Weng <wweng@kencast.com>
To: mdc@keko.com.ar
Cc: pgsql-sql@postgresql.org
Subject: Re: help database corruption
Date: Wed, 07 May 2003 14:57:14 -0400
Message-ID: <3EB9570A.6090202@kencast.com> (raw)
In-Reply-To: <1052322969.3eb92c997f6de@keko.techtelnet.com>
References: <1052322969.3eb92c997f6de@keko.techtelnet.com>
Sorry I couldn't help you with the problem, but I have been pondering
this question for a while.
How do you get the "backend messages"? Do they get logged somewhere? How
do you turn them on?
Thanks.
Wei
mdc@keko.com.ar wrote:
>hi guys
>
> the database seems to corrupt .
> the messages are
>intent to vacumm:
>
>[postgres@defiant postgres]$ /usr/local/pgsql/bin/vacuumdb -a
>Vacuuming EstacionVasconiaDevelop
>ERROR: _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
>el directorio
>vacuumdb: vacuum EstacionVasconiaDevelop failed
>[postgres@defiant postgres]$
>
>
>backend messages
>
> XLogFlush: request 0/109118E8 is not satisfied --- flushed only to 0/108EA9D8
>ERROR: _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
>el directorio
>ERROR: _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
>el directorio
>
>
>explanation:
>
> the applicatoin create the tmpturnos with
>
> select into tmpturnos from ....
>
> the table tmpturnos does not exist for database
> if you try
>
> create tmpturnos(...)
> refuse with databse already exists
> if try
> drop table tmpturnos
> refuse with
> database tmpturnos not exists
>
> any ideas ?
>
> technical information
>
> linux mandrake 8.0
> postgres version 7.3.1
>
> best regards
> MDc
>
>
>
>
>-------------------------------------------------
>¿Todavía no navegás con Keko?
>Hacé click aquí: http://www.keko.com.ar
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wweng@kencast.com, mdc@keko.com.ar
Subject: Re: help database corruption
In-Reply-To: <3EB9570A.6090202@kencast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox