From: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1148: server restarts depending on stats options |
Date: | 2004-05-06 21:10:04 |
Message-ID: | 20040506211004.13C78CF5427@www.postgresql.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
The following bug has been logged online:
Bug reference: 1148
Logged by: Robert Treat
Email address: xzilla(at)users(dot)sourceforge(dot)net
PostgreSQL version: 7.5 Dev
Operating system: Slackware Linux 8.1 (Kernel 2.4.18)
Description: server restarts depending on stats options
Details:
set log_statement_stats = true and any of
log_(executer|planner|parser)_stats = true and you will get a database
restart when attempting to connect.
from my logs:
postgres(at)phppgadmin:/usr/local/pgsql-7.5dev$ cat data/logfile
LOG: received smart shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2004-05-06 12:59:01 PDT
LOG: checkpoint record is at 0/9DDC68
LOG: redo record is at 0/9DDC68; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 460; next OID: 17207
LOG: database system is ready
WARNING: statement-level statistics are disabled because parser, planner,
or executor statistics are on
TRAP: BadState("!(((bool) ((CurrentUserId) != 0)))", File: "miscinit.c",
Line: 252)
LOG: server process (PID 22690) was terminated by signal 6
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2004-05-06 12:59:02 PDT
LOG: checkpoint record is at 0/9DDC68
LOG: redo record is at 0/9DDC68; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 460; next OID: 17207
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/9DDCA8
LOG: redo is not required
LOG: database system is ready
this is from a snapshot build on may 5th
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-05-06 22:10:21 | Re: BUG #1148: server restarts depending on stats options |
Previous Message | Bruce Momjian | 2004-05-06 17:49:55 | Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-05-06 22:10:21 | Re: BUG #1148: server restarts depending on stats options |
Previous Message | Bruce Momjian | 2004-05-06 19:31:56 | Re: Alter Table phase 1 -- Please apply to 7.5 |