From: Jennifer Redman <jenred@gmail.com>
To: John Lister <john.lister-ps@kickstone.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Incomplete Startup Packet on startup and when pg_maintenance --analyze runs in cron
Date: Sat, 20 Dec 2008 12:32:17 -0800
Message-ID: <93f118f0812201232s5a5bf166y1701f940303a19f1@mail.gmail.com> (raw)
In-Reply-To: <E68310A7222D4261AE7E96703FA775F7@squarepi.com>
References: <93f118f0812181248s122a93d3vaa09831d64d9e6ae@mail.gmail.com>
<93f118f0812181534w1f78f0a5tda3a21a7074b04e6@mail.gmail.com>
<E68310A7222D4261AE7E96703FA775F7@squarepi.com>
On Sat, Dec 20, 2008 at 12:26 AM, John Lister
<john.lister-ps@kickstone.com>wrote:
>
>
> The pg_maintenance scripts check the state of the autovacuuum flag in the
> postgres config files. If it is enabled they simply quit and don't do
> anything. Disabling autovacuum causes them to run... So you can leave them
> uncommented...
Why would you want to continue to run a cron job that is:
1) No longer applicable to the current version of software (Postgresql 8.1+)
2) Throwing an error in your logs?
The default behavior should be that this cron job is not active by default
if one is running Postgresql 8.1+
>
>
> Although why it causes the "Incomplete start-up packet" messages is a
> mystery...
Because the Debian and Debian derivative packages (Ubuntu) of
postgresql-common -- which is a required dependency for the main postgresql
package, was not rev'd correctly when the autovaccuum feature was added by
default into Postgresql. The script, pg_maintenance, is no longer
functioning as was intended against the current version. This is a software
bug, and I've filed bug reports in both the Debian and Ubuntu systems.
A version check needs to happen on install of postgresql-common to determine
the correct behavior of pg_maintenance based upon the version of PostgresSQL
(patch exisiting package) or a new package needs to be created for
postgresql 8.1+.
In the meantime, if you are here because you want to know how to get rid of
the 'incomplete start-up packet' message in your postgresql logs (thrown at
the exact same interval as the referenced cron job) are running a derivative
of Debian (not sure if this happens with other distros or OS's) comment out
the cron job.
Unfortunately, the message is still thrown when starting and stopping
postgresql, since the init script in postgresql-common is also running the
pg_maintenance check. Hopefully, a patch will fix. This is something much
more reasonable to live with then a cron job that doesn't work running every
5 hours.
Me, I like to bring up new systems with completely clean logs, and identify,
fix any errors in those logs if running an existing system, and not run cron
jobs that are not needed. ;>
Regards,
Jennifer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jenred@gmail.com, john.lister-ps@kickstone.com
Subject: Re: Incomplete Startup Packet on startup and when pg_maintenance --analyze runs in cron
In-Reply-To: <93f118f0812201232s5a5bf166y1701f940303a19f1@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox