From: | Martin Pitt <martin(at)piware(dot)de> |
---|---|
To: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Cc: | evert(at)witelcom(dot)com, James Troup <james(at)nocrew(dot)org> |
Subject: | More graceful handling of invalid log_*_stats conf in 7.4 |
Date: | 2005-06-02 10:23:07 |
Message-ID: | 20050602102307.GA22314@piware.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi PostgreSQL developers!
We just experienced a bug that gave us a serious headache until we
found the reason. When doing "psql template1" we got an error message
psql: FATAL: invalid cache id: 30
Evert Meulie found a similar problem at
http://archives.postgresql.org/pgsql-novice/2004-11/msg00237.php
so maybe it's the same bug, since the thread never came to a
conclusion.
I found out that activating
log_parser_stats = true
log_planner_stats = true
log_executor_stats = true
log_statement_stats = true
in postgresql.conf leads to this bug (test case attached, adapt the
$BIN variable to your postgresql bin directory and run the script). In
8.0 the server complains about an "invalid value for
log_statement_stats", and the documentation explains that the first
three and the 4th option are mutually exclusive. However, this is not
mentioned in the 7.4 docs. Can this case be handled more gracefully in
7.4? Maybe the check from 8.0 can be ported to 7.4?
Thanks and have a nice day!
Martin
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian Developer http://www.debian.org
Attachment | Content-Type | Size |
---|---|---|
psql_bug_cacheid.sh | application/x-sh | 720 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bahadur Singh | 2005-06-02 11:05:00 | BUG #1697: Select getting slower on continously updating data |
Previous Message | dpage | 2005-06-02 00:58:41 | Spam Re: Sample |