pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhelp database corruption
5+ messages / 3 participants
[nested] [flat]
* help database corruption
@ 2003-05-07 15:56 mdc@keko.com.ar
0 siblings, 1 reply; 5+ messages in thread
From: mdc@keko.com.ar @ 2003-05-07 15:56 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* help database corruption
@ 2003-05-07 18:12 mdc@keko.com.ar
0 siblings, 0 replies; 5+ messages in thread
From: mdc@keko.com.ar @ 2003-05-07 18:12 UTC (permalink / raw)
To: pgsql-sql; +Cc: mdc_marcelo@yahoo.com
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* help database corruption
@ 2003-05-07 18:12 mdc@keko.com.ar
0 siblings, 1 reply; 5+ messages in thread
From: mdc@keko.com.ar @ 2003-05-07 18:12 UTC (permalink / raw)
To: pgsql-sql; +Cc: mdc_marcelo@yahoo.com
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: help database corruption
@ 2003-05-07 18:57 Wei Weng <wweng@kencast.com>
parent: mdc@keko.com.ar
0 siblings, 0 replies; 5+ messages in thread
From: Wei Weng @ 2003-05-07 18:57 UTC (permalink / raw)
To: mdc@keko.com.ar; +Cc: pgsql-sql
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
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: help database corruption
@ 2003-05-07 19:16 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: mdc@keko.com.ar
0 siblings, 0 replies; 5+ messages in thread
From: Stephan Szabo @ 2003-05-07 19:16 UTC (permalink / raw)
To: mdc@keko.com.ar; +Cc: pgsql-sql; mdc_marcelo@yahoo.com
On Wed, 7 May 2003 mdc@keko.com.ar wrote:
> 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]$
Hmm, is there a pg_class entry for tmpturnos? If so, is there actually a
file in the database directory with the name of its relfilenode?
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-05-07 19:16 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-07 15:56 help database corruption mdc@keko.com.ar
2003-05-07 18:57 ` Wei Weng <wweng@kencast.com>
2003-05-07 18:12 help database corruption mdc@keko.com.ar
2003-05-07 18:12 help database corruption mdc@keko.com.ar
2003-05-07 19:16 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
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