From: mdc@keko.com.ar
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Cc: mdc_marcelo@yahoo.com
Subject: help database corruption
Date: Wed, 7 May 2003 15:12:48 -0300
Message-ID: <1052331168.3eb94ca086b4e@keko.techtelnet.com> (raw)
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
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: mdc@keko.com.ar, mdc_marcelo@yahoo.com
Subject: Re: help database corruption
In-Reply-To: <1052331168.3eb94ca086b4e@keko.techtelnet.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