BUG #1148: server restarts depending on stats options

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

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-patches by date

  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