Base de datos borrada
Publicado por Heiku (2 intervenciones) el 06/04/2008 17:36:48
Buenas a todos,
el problema es el siguiente: Tenemos una aplicación con una base de datos postgresql 8.2. con Windows. En el momento en que según el log se produjo el fallo, se hizo una conexión remota al servidor, con un sistema de control remoto, se desistaló tomcat, se volvio a instalar una nueva versión y se bajo y subió el servicio de postgres.
El caso es que la carpeta donde se encontraba el tablespace de la base de datos desapareció.
Lo que aparece en el log es lo siguiente:
2008-04-04 09:40:15 LOG: unexpected EOF on client connection
2008-04-04 09:40:15 LOG: unexpected EOF on client connection
2008-04-04 09:45:51 LOG: unexpected EOF on client connection
2008-04-04 13:01:58 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:01:58 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:03:58 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:03:58 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:05:59 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:05:59 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:07:59 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:07:59 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:09:33 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:09:33 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:10:01 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:10:01 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:10:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:10:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:12:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:12:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:14:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:14:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:16:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:16:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:18:03 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:18:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:20:03 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:20:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:22:03 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:22:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:22:06 LOG: received fast shutdown request
2008-04-04 13:22:06 LOG: shutting down
2008-04-04 13:22:06 LOG: database system is shut down
2008-04-04 13:22:07 LOG: logger shutting down
2008-04-04 13:22:52 LOG: database system was shut down at 2008-04-04 13:22:06 Hora de verano romance
2008-04-04 13:22:52 LOG: checkpoint record is at 0/274ED648
2008-04-04 13:22:52 LOG: redo record is at 0/274ED648; undo record is at 0/0; shutdown TRUE
2008-04-04 13:22:52 LOG: next transaction ID: 0/1192198; next OID: 17381
2008-04-04 13:22:52 LOG: next MultiXactId: 27; next MultiXactOffset: 53
2008-04-04 13:22:52 LOG: database system is ready
2008-04-04 13:23:53 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:23:53 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
Alguien sabe que ha podido pasar y como podemos recuperarlo.
el problema es el siguiente: Tenemos una aplicación con una base de datos postgresql 8.2. con Windows. En el momento en que según el log se produjo el fallo, se hizo una conexión remota al servidor, con un sistema de control remoto, se desistaló tomcat, se volvio a instalar una nueva versión y se bajo y subió el servicio de postgres.
El caso es que la carpeta donde se encontraba el tablespace de la base de datos desapareció.
Lo que aparece en el log es lo siguiente:
2008-04-04 09:40:15 LOG: unexpected EOF on client connection
2008-04-04 09:40:15 LOG: unexpected EOF on client connection
2008-04-04 09:45:51 LOG: unexpected EOF on client connection
2008-04-04 13:01:58 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:01:58 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:03:58 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:03:58 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:05:59 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:05:59 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:07:59 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:07:59 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:09:33 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:09:33 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:10:01 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:10:01 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:10:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:10:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:12:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:12:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:14:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:14:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:16:02 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:16:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:18:03 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:18:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:20:03 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:20:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:22:03 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:22:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
2008-04-04 13:22:06 LOG: received fast shutdown request
2008-04-04 13:22:06 LOG: shutting down
2008-04-04 13:22:06 LOG: database system is shut down
2008-04-04 13:22:07 LOG: logger shutting down
2008-04-04 13:22:52 LOG: database system was shut down at 2008-04-04 13:22:06 Hora de verano romance
2008-04-04 13:22:52 LOG: checkpoint record is at 0/274ED648
2008-04-04 13:22:52 LOG: redo record is at 0/274ED648; undo record is at 0/0; shutdown TRUE
2008-04-04 13:22:52 LOG: next transaction ID: 0/1192198; next OID: 17381
2008-04-04 13:22:52 LOG: next MultiXactId: 27; next MultiXactOffset: 53
2008-04-04 13:22:52 LOG: database system is ready
2008-04-04 13:23:53 FATAL: database "bdaplicacion" does not exist
2008-04-04 13:23:53 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing.
Alguien sabe que ha podido pasar y como podemos recuperarlo.
Valora esta pregunta


0