postgresql crushed with XLogWrite error
| От | Tsirkin Evgeny |
|---|---|
| Тема | postgresql crushed with XLogWrite error |
| Дата | |
| Msg-id | opr1awxehzjbdarf@localhost обсуждение исходный текст |
| Список | pgsql-admin |
Hello dear list! I am using postgresql 7.3.3 .Last night the errors occured. Since then I can't start the postgresql !We are recovering from the type by now ,but what happened?Is that a known bug?What to do next time? The last change I made was that: syslog=1 log_min_error_statement log_timestamp = true stats_reset_on_server_start = false I can't think why those changes could crush the postgres! Here is the log: #============================================================================================ 2004-01-05 05:30:35 PANIC: XLogWrite: write request 15/EF40E000 is past end of log 15/EF40E000 2004-01-05 05:30:35 LOG: statement: update tyuta_rashum set chugid=521 where studentid=3587261 and maslulsignid=8014022 and c ourseid=67538; 2004-01-05 05:30:35 LOG: server process (pid 2527) was terminated by signal 6 2004-01-05 05:30:35 LOG: terminating any other active server processes 2004-01-05 05:30:35 LOG: all server processes terminated; reinitializing shared memory and semaphores 2004-01-05 05:30:35 LOG: database system was interrupted at 2004-01-05 03:42:11 IST 2004-01-05 05:30:35 LOG: checkpoint record is at 15/EF40DFC0 2004-01-05 05:30:35 LOG: redo record is at 15/EF40DFC0; undo record is at 0/0; shutdown TRUE 2004-01-05 05:30:35 LOG: next transaction id: 88539506; next oid: 88761828 2004-01-05 05:30:35 LOG: database system was not properly shut down; automatic recovery in progress 2004-01-05 05:30:35 FATAL: The database system is starting up 2004-01-05 05:30:35 FATAL: The database system is starting up 2004-01-05 05:30:35 FATAL: The database system is starting up 2004-01-05 05:30:35 LOG: ReadRecord: unexpected pageaddr 15/E640E000 in log file 21, segment 239, offset 4251648 2004-01-05 05:30:35 LOG: redo is not required 2004-01-05 05:30:35 FATAL: The database system is starting up 2004-01-05 05:30:35 FATAL: The database system is starting up 2004-01-05 05:30:38 PANIC: XLogWrite: write request 15/EF40E000 is past end of log 15/EF40E000 2004-01-05 05:30:38 LOG: startup process (pid 2529) was terminated by signal 6 2004-01-05 05:30:38 LOG: aborting startup due to startup process failure #============================================================================================ And since that, every time I am trying to start the db I get this: #============================================================================================ 2004-01-05 08:49:10 LOG: database system shutdown was interrupted at 2004-01-05 05:30:35 IST 2004-01-05 08:49:10 LOG: checkpoint record is at 15/EF40DFC0 2004-01-05 08:49:10 LOG: redo record is at 15/EF40DFC0; undo record is at 0/0; shutdown TRUE 2004-01-05 08:49:10 LOG: next transaction id: 88539506; next oid: 88761828 2004-01-05 08:49:10 LOG: database system was not properly shut down; automatic recovery in progress 2004-01-05 08:49:10 LOG: ReadRecord: unexpected pageaddr 15/E640E000 in log file 21, segment 239, offset 4251648 2004-01-05 08:49:10 LOG: redo is not required 2004-01-05 08:49:12 PANIC: XLogWrite: write request 15/EF40E000 is past end of log 15/EF40E000 2004-01-05 08:49:12 LOG: startup process (pid 2907) was terminated by signal 6 2004-01-05 08:49:12 LOG: aborting startup due to startup process failure #============================================================================================ Here is the ls -al from the pg_clog directory. I can't see any problems in log file 21: -rw------- 1 postgres postgres 262144 Jul 6 2003 0000 -rw------- 1 postgres postgres 262144 Jul 10 02:10 0001 -rw------- 1 postgres postgres 262144 Jul 16 00:24 0002 -rw------- 1 postgres postgres 262144 Jul 21 21:15 0003 -rw------- 1 postgres postgres 262144 Jul 27 11:53 0004 -rw------- 1 postgres postgres 262144 Jul 29 11:11 0005 -rw------- 1 postgres postgres 262144 Jul 30 18:41 0006 -rw------- 1 postgres postgres 262144 Aug 3 20:24 0007 -rw------- 1 postgres postgres 262144 Aug 5 02:07 0008 -rw------- 1 postgres postgres 262144 Aug 6 18:52 0009 -rw------- 1 postgres postgres 262144 Aug 11 17:51 000A -rw------- 1 postgres postgres 262144 Aug 12 18:50 000B -rw------- 1 postgres postgres 262144 Aug 14 02:34 000C -rw------- 1 postgres postgres 262144 Aug 15 13:40 000D -rw------- 1 postgres postgres 262144 Aug 17 18:04 000E -rw------- 1 postgres postgres 262144 Aug 20 15:58 000F -rw------- 1 postgres postgres 262144 Aug 24 10:09 0010 -rw------- 1 postgres postgres 262144 Aug 25 14:52 0011 -rw------- 1 postgres postgres 262144 Aug 27 15:15 0012 -rw------- 1 postgres postgres 262144 Aug 31 14:58 0013 -rw------- 1 postgres postgres 262144 Sep 8 10:05 0014 -rw------- 1 postgres postgres 262144 Sep 8 13:55 0015 -rw------- 1 postgres postgres 262144 Sep 8 23:46 0016 -rw------- 1 postgres postgres 262144 Sep 9 21:01 0017 -rw------- 1 postgres postgres 262144 Sep 10 02:00 0018 -rw------- 1 postgres postgres 262144 Sep 10 09:49 0019 -rw------- 1 postgres postgres 262144 Sep 10 12:16 001A -rw------- 1 postgres postgres 262144 Sep 10 16:28 001B -rw------- 1 postgres postgres 262144 Sep 11 04:51 001C -rw------- 1 postgres postgres 262144 Sep 11 14:00 001D -rw------- 1 postgres postgres 262144 Sep 14 13:57 001E -rw------- 1 postgres postgres 262144 Sep 15 02:02 001F -rw------- 1 postgres postgres 262144 Sep 15 10:41 0020 -rw------- 1 postgres postgres 262144 Sep 15 12:37 0021 -rw------- 1 postgres postgres 262144 Sep 15 15:19 0022 -rw------- 1 postgres postgres 262144 Sep 15 22:58 0023 -rw------- 1 postgres postgres 262144 Sep 16 13:26 0024 -rw------- 1 postgres postgres 262144 Sep 17 06:43 0025 -rw------- 1 postgres postgres 262144 Sep 17 15:27 0026 -rw------- 1 postgres postgres 262144 Sep 18 13:14 0027 -rw------- 1 postgres postgres 262144 Sep 21 13:37 0028 -rw------- 1 postgres postgres 262144 Sep 22 09:21 0029 -rw------- 1 postgres postgres 262144 Sep 22 15:44 002A -rw------- 1 postgres postgres 262144 Sep 23 01:15 002B -rw------- 1 postgres postgres 262144 Sep 23 10:49 002C -rw------- 1 postgres postgres 262144 Sep 23 14:36 002D -rw------- 1 postgres postgres 262144 Sep 24 00:32 002E -rw------- 1 postgres postgres 262144 Sep 24 11:56 002F -rw------- 1 postgres postgres 262144 Sep 24 22:18 0030 -rw------- 1 postgres postgres 262144 Sep 25 14:11 0031 -rw------- 1 postgres postgres 262144 Sep 29 12:43 0032 -rw------- 1 postgres postgres 262144 Sep 30 00:31 0033 -rw------- 1 postgres postgres 262144 Sep 30 18:49 0034 -rw------- 1 postgres postgres 262144 Oct 2 14:04 0035 -rw------- 1 postgres postgres 262144 Oct 19 08:42 0036 -rw------- 1 postgres postgres 262144 Oct 19 12:59 0037 -rw------- 1 postgres postgres 262144 Oct 19 16:11 0038 -rw------- 1 postgres postgres 262144 Oct 20 10:18 0039 -rw------- 1 postgres postgres 262144 Oct 20 14:40 003A -rw------- 1 postgres postgres 262144 Oct 21 09:03 003B -rw------- 1 postgres postgres 262144 Oct 21 15:06 003C -rw------- 1 postgres postgres 262144 Oct 22 11:47 003D -rw------- 1 postgres postgres 262144 Oct 22 23:09 003E -rw------- 1 postgres postgres 262144 Oct 23 16:15 003F -rw------- 1 postgres postgres 262144 Oct 26 11:09 0040 -rw------- 1 postgres postgres 262144 Oct 26 15:16 0041 -rw------- 1 postgres postgres 262144 Oct 27 11:00 0042 -rw------- 1 postgres postgres 262144 Oct 27 15:42 0043 -rw------- 1 postgres postgres 262144 Oct 28 10:45 0044 -rw------- 1 postgres postgres 262144 Oct 28 19:55 0045 -rw------- 1 postgres postgres 262144 Oct 29 13:31 0046 -rw------- 1 postgres postgres 262144 Oct 30 11:04 0047 -rw------- 1 postgres postgres 262144 Oct 31 15:34 0048 -rw------- 1 postgres postgres 262144 Nov 2 15:27 0049 -rw------- 1 postgres postgres 262144 Nov 3 16:16 004A -rw------- 1 postgres postgres 262144 Nov 4 18:06 004B -rw------- 1 postgres postgres 262144 Nov 6 08:59 004C -rw------- 1 postgres postgres 262144 Nov 9 10:24 004D -rw------- 1 postgres postgres 262144 Nov 10 12:55 004E -rw------- 1 postgres postgres 262144 Nov 11 16:06 004F -rw------- 1 postgres postgres 262144 Nov 12 19:03 0050 -rw------- 1 postgres postgres 262144 Nov 13 15:45 0051 -rw------- 1 postgres postgres 262144 Nov 20 12:14 0052 -rw------- 1 postgres postgres 262144 Dec 17 19:56 0053 -rw------- 1 postgres postgres 122880 Jan 5 00:08 0054
В списке pgsql-admin по дате отправления: