Hi fellas,
I am hav a serious problems of corruption of my database. Isnt the second time that appears this error message in my application:
Code:
PANIC: could not write to log file 2, segment 241 at offset 16089088: Input/output error server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
And when verify the log of postgresql, appears this:
Code:
LOG: statement: LOCK TABLE public.msg_rcv IN ACCESS SHARE MODE
LOG: statement: LOCK TABLE public.msg_send IN ACCESS SHARE MODE
LOG: statement: LOCK TABLE public.notas IN ACCESS SHARE MODE
LOG: statement: LOCK TABLE public.noticias IN ACCESS SHARE MODE
LOG: server process (PID 67356) was terminated by signal 6
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
CONTEXT: writing block 0 of relation 1663/17230/3565201
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
CONTEXT: writing block 2 of relation 1663/17230/3565201
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
CONTEXT: writing block 1258 of relation 1663/17230/16724
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2005-08-31 07:59:59 BRT
LOG: checkpoint record is at 2/F1F57740
LOG: redo record is at 2/F1F57740; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 943861; next OID: 3602731
LOG: database system was not properly shut down; automatic recovery in progres
Anyone can solve this question?
