help database corruption

From: mdc(at)keko(dot)com(dot)ar
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Cc: mdc_marcelo(at)yahoo(dot)com
Subject: help database corruption
Date: 2003-05-07 18:12:44
Message-ID: 1052331164.3eb94c9cb5122@keko.techtelnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hi guys

the database seems to corrupt .
the messages are
intent to vacumm:

[postgres(at)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(at)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

Browse pgsql-sql by date

  From Date Subject
Next Message mdc 2003-05-07 18:12:48 help database corruption
Previous Message mallah 2003-05-07 18:01:24 Re: [GENERAL] PostgreSQL Qs