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 по дате отправления:

Предыдущее
От: "Akio Iwaasa"
Дата:
Сообщение: BUG #2885: to_char function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2885: to_char function