PG unexpected crash

From: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: PG unexpected crash
Date: 2007-01-12 14:48:48
Message-ID: 528853D3C5ED2C4AA8990B504BA7FB850106DD56@sol.transas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

select version();

"PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"

pg_log:

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;

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-01-12 15:46:38 Re: BUG #2885: to_char function
Previous Message Ravi Periasamy 2007-01-12 13:06:31 Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect