From: | "Ardian Xharra" <axharra(at)boxxo(dot)info> |
---|---|
To: | "postgreSQL postgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Data corruption |
Date: | 2006-11-14 18:34:28 |
Message-ID: | 054a01c7081b$84f7f3d0$0f01a8c0@Boxxo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
We have a database installed on Intel Xeon (Dell) and running on postgreSQL 8.1.
And the database couldn't start. Here is the logfile of what happend:
2006-11-14 00:28:38 PANIC: could not write to log file 6, segment 239 at offset 6430720, length 16384: Permission denied
2006-11-14 00:28:38 CONTEXT: writing block 557 of relation 1663/16403/985708
2006-11-14 00:28:38 STATEMENT: VACUUM client
abnormal program termination
2006-11-14 00:28:38 LOG: server process (PID 2868) was terminated by signal 3
2006-11-14 00:28:38 LOG: terminating any other active server processes
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 WARNING: terminating connection because of crash of another server process
2006-11-14 00:28:38 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.
2006-11-14 00:28:38 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2006-11-14 00:28:38 LOG: all server processes terminated; reinitializing
2006-11-14 00:28:38 LOG: database system was interrupted at 2006-11-14 00:17:21 Eastern Standard Time
2006-11-14 00:28:38 LOG: checkpoint record is at 6/EEE1ED60
2006-11-14 00:28:38 LOG: redo record is at 6/EEE1ED60; undo record is at 0/0; shutdown FALSE
2006-11-14 00:28:38 LOG: next transaction ID: 13802854; next OID: 4807439
2006-11-14 00:28:38 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-11-14 00:28:38 LOG: database system was not properly shut down; automatic recovery in progress
2006-11-14 00:28:38 LOG: redo starts at 6/EEE1EDA8
2006-11-14 00:28:40 LOG: could not read from log file 6, segment 239, offset 0: Permission denied
2006-11-14 00:28:40 LOG: redo done at 6/EEFFE740
2006-11-14 00:28:43 LOG: database system is ready
2006-11-14 00:28:43 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres"
2006-11-14 01:50:58 LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
2006-11-14 01:50:58 LOG: unexpected EOF on client connection
2006-11-14 01:51:18 ERROR: xlog flush request 6/EF5FB6B8 is not satisfied --- flushed only to 6/EEFFE7D0
2006-11-14 01:51:18 CONTEXT: writing block 21 of relation 1663/16403/2696
2006-11-14 01:51:19 ERROR: xlog flush request 6/EF5F8C50 is not satisfied --- flushed only to 6/EEFFE7D0
2006-11-14 01:51:19 CONTEXT: writing block 384 of relation 1663/16403/2619
Could someone tell us the cause of this. Or it's simply the command Vacuum client who caused all of this
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-11-14 18:45:10 | Re: CUBE, ROLLUP, GROUPING SETS? |
Previous Message | Desmond Coughlan | 2006-11-14 18:34:09 | RE : Re: database design ... |