PG unexpected crash
От | Zubkovsky, Sergey |
---|---|
Тема | PG unexpected crash |
Дата | |
Msg-id | 528853D3C5ED2C4AA8990B504BA7FB850106DD56@sol.transas.com обсуждение исходный текст |
Список | pgsql-bugs |
select version(); "PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" =20 pg_log: =20 2007-01-12 16:41:23 STATEMENT: EXPLAIN COPY "MsgRoot" TO 'C:/Program Files/PostgreSQL/8.2/data/MsgRoot.txt' 2007-01-12 17:16:04 LOG: checkpoints are occurring too frequently (11 seconds apart) 2007-01-12 17:16:04 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:16:14 LOG: checkpoints are occurring too frequently (10 seconds apart) 2007-01-12 17:16:14 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:16:36 LOG: checkpoints are occurring too frequently (22 seconds apart) 2007-01-12 17:16:36 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:16:47 LOG: checkpoints are occurring too frequently (11 seconds apart) 2007-01-12 17:16:47 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:16:57 LOG: checkpoints are occurring too frequently (10 seconds apart) 2007-01-12 17:16:57 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:17:07 LOG: checkpoints are occurring too frequently (10 seconds apart) 2007-01-12 17:17:07 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:20:47 LOG: checkpoints are occurring too frequently (8 seconds apart) 2007-01-12 17:20:47 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:21:01 LOG: checkpoints are occurring too frequently (14 seconds apart) 2007-01-12 17:21:01 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:21:07 LOG: checkpoints are occurring too frequently (6 seconds apart) 2007-01-12 17:21:07 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:21:22 LOG: checkpoints are occurring too frequently (15 seconds apart) 2007-01-12 17:21:22 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:21:30 LOG: checkpoints are occurring too frequently (8 seconds apart) 2007-01-12 17:21:30 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:21:43 LOG: checkpoints are occurring too frequently (13 seconds apart) 2007-01-12 17:21:43 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:21:50 LOG: checkpoints are occurring too frequently (7 seconds apart) 2007-01-12 17:21:50 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:22:04 LOG: checkpoints are occurring too frequently (14 seconds apart) 2007-01-12 17:22:04 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:22:12 LOG: checkpoints are occurring too frequently (8 seconds apart) 2007-01-12 17:22:12 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:22:26 LOG: checkpoints are occurring too frequently (14 seconds apart) 2007-01-12 17:22:26 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:22:32 LOG: checkpoints are occurring too frequently (6 seconds apart) 2007-01-12 17:22:32 HINT: Consider increasing the configuration parameter "checkpoint_segments". 2007-01-12 17:22:41 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "part_20070114000000_MsgRoot_pkey" for table "part_20070114000000_MsgRoot" 2007-01-12 17:23:16 PANIC: could not open control file "global/pg_control": Permission denied 2007-01-12 17:23:16 CONTEXT: COPY part_20070114000000_MsgRoot, line 111982 2007-01-12 17:23:16 STATEMENT: COPY "part_20070114000000_MsgRoot" FROM 'C:/Program Files/PostgreSQL/8.2/data/MsgRoot.bin' WITH BINARY; =20 This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. 2007-01-12 17:23:16 LOG: server process (PID 1224) exited with exit code 3 2007-01-12 17:23:16 LOG: terminating any other active server processes 2007-01-12 17:23:16 WARNING: terminating connection because of crash of another server process 2007-01-12 17:23:16 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. 2007-01-12 17:23:16 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2007-01-12 17:23:16 WARNING: terminating connection because of crash of another server process 2007-01-12 17:23:17 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. 2007-01-12 17:23:17 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2007-01-12 17:23:17 WARNING: terminating connection because of crash of another server process 2007-01-12 17:23:17 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. 2007-01-12 17:23:17 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2007-01-12 17:23:17 WARNING: terminating connection because of crash of another server process 2007-01-12 17:23:17 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. 2007-01-12 17:23:17 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2007-01-12 17:23:17 LOG: all server processes terminated; reinitializing 2007-01-12 17:23:18 LOG: database system was interrupted at 2007-01-12 17:23:14 Russian Standard Time 2007-01-12 17:23:18 LOG: checkpoint record is at 1/54214018 2007-01-12 17:23:18 LOG: redo record is at 1/54008010; undo record is at 0/0; shutdown FALSE 2007-01-12 17:23:18 LOG: next transaction ID: 0/71200; next OID: 30686 2007-01-12 17:23:18 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2007-01-12 17:23:18 LOG: database system was not properly shut down; automatic recovery in progress 2007-01-12 17:23:18 LOG: redo starts at 1/54008010 2007-01-12 17:23:21 LOG: unexpected pageaddr 1/4E000000 in log file 1, segment 86, offset 0 2007-01-12 17:23:21 LOG: redo done at 1/55FFFF58 2007-01-12 17:23:22 LOG: database system is ready
В списке pgsql-bugs по дате отправления: