From: | Carmen Gloria Sepulveda Dedes <csepulveda(at)atichile(dot)com> |
---|---|
To: | Pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx |
Subject: | [Pgsql-ayuda] Postmaster no levanta |
Date: | 2003-10-20 13:57:21 |
Message-ID: | 3F93E9C1.82BB8E36@atichile.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola a todos.
Tuve el siguiente problema.
Estaba intentando crear una tabla y cometi un error de tipeo:
mdbs=# create table talseria ();
PANIC: XLogWrite: write request 0/94A000 is past end of log 0/94A000
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#
Despues de esto, perdi la conexion a la base de datos. Sali de psql y
al intentar entrar de nuevo, me dice que no esta corriendo el proceso
postmaster. Al intentar levantarlo, aparece lo siguiente:
huapi(at)rmadmin:~> postmaster -B 32 -N 16 -i &
[1] 743
huapi(at)rmadmin:~> LOG: database system shutdown was interrupted at
2003-10-20 10:51:19 CLST
LOG: checkpoint record is at 0/949FC0
LOG: redo record is at 0/949FC0; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 646; next oid: 17009
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: invalid magic number 0000 in log file 0, segment 0,
offset 9740288
LOG: redo is not required
PANIC: XLogWrite: write request 0/94A000 is past end of log 0/94A000
LOG: startup process (pid 746) was terminated by signal 6
LOG: aborting startup due to startup process failure
y el proceso no sube. Alguien me puede explicar por favor, como
solucionar este
problema??
Saludos y gracias.
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Andrade Fonseca | 2003-10-20 16:20:55 | [Pgsql-ayuda] Nombres de objetos de bases de datos |
Previous Message | Martin Marques | 2003-10-19 23:05:02 | Re: [Pgsql-ayuda] Cambio de indices |