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:48 |
Message-ID: | 1052331168.3eb94ca086b4e@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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2003-05-07 18:16:54 | Re: PostgreSQL Qs |
Previous Message | mdc | 2003-05-07 18:12:44 | help database corruption |