From: Jennifer Redman <jenred@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Incomplete Startup Packet on startup and when pg_maintenance --analyze runs in cron
Date: Thu, 18 Dec 2008 15:34:37 -0800
Message-ID: <93f118f0812181534w1f78f0a5tda3a21a7074b04e6@mail.gmail.com> (raw)
In-Reply-To: <93f118f0812181248s122a93d3vaa09831d64d9e6ae@mail.gmail.com>
References: <93f118f0812181248s122a93d3vaa09831d64d9e6ae@mail.gmail.com>
It looks like this is a problem with the Ubuntu package postgresql-common.
I opened a bug there:
https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/309496
And for those of you who may have the same issue:
Running
# /etc/init.d/postgresql-8.3 autovac-restart
* Restarting PostgreSQL 8.3 autovacuum daemon
Results in:
* Error: PostgreSQL 8.1 and above has an integrated autovacuum daemon which
cannot be controlled by this program.
Looks like /etc/cron.d/postgresql-common
# Run VACUUM ANALYSE on all databases every 5 hours if pg_autovacuum is not
# running
2 0,5,10,15,20 * * 1-6 root if [ -x /usr/sbin/pg_maintenance ]; then
/usr/sbin/pg_maintenance --analyze >/dev/null; fi
Is deprecated for postgresql versions 8.1 and higher and needs to be
commented out by default in those packages.
The same error message appears on start-up
( incomplete startup packet)
but I could not figure out where in
/usr/share/postgresql-common/init.d-functions the pg_maintenance script was
being called.
Additionally,
Running:
#/sbin/pg_maintenance --analyze
results in:
Skipping cluster 8.3/main since autovacuuming is enabled for it
and the subsequent:
2008-12-18 15:21:18 PST LOG: 08P01: incomplete startup packet
2008-12-18 15:21:18 PST LOCATION: ProcessStartupPacket, postmaster.c:1396
in /postgresql-8.3-main.log
On Thu, Dec 18, 2008 at 12:48 PM, Jennifer Redman <jenred@gmail.com> wrote:
> Running Ubuntu 8.04 LTS, with postgresql-8-3, postgresql-client-8.3,
> postgresql-common - standard Ubuntu stable postgresql package. The same
> error occurs on a system with postgresql-8-2. Both boxes are also running
> python-psycopg2. Connections limited to localhost. Nothing monitoring or
> scanning port 5432 at a 5 hour interval.
>
> I'm get the following error in the logs at startup and at the exact
> interval that -x /usr/sbin/pg_maintenance ]; then /usr/sbin/pg_maintenance
> --analyze appears to run in cron:
>
> From /postgresql-8.3-main.log :
>
> 2008-12-17 00:02:01 PST LOG: incomplete startup packet
> 2008-12-17 05:02:01 PST LOG: incomplete startup packet
> 2008-12-17 10:02:01 PST LOG: incomplete startup packet
> 2008-12-17 15:02:01 PST LOG: incomplete startup packet
> 2008-12-17 20:02:01 PST LOG: incomplete startup packet
>
> Verbose on startup:
>
> 2008-12-18 12:15:48 PST LOCATION: StartupXLOG, xlog.c:4816
> 2008-12-18 12:15:48 PST LOG: 00000: autovacuum launcher started
> 2008-12-18 12:15:48 PST LOCATION: AutoVacLauncherMain, autovacuum.c:520
> 2008-12-18 12:15:48 PST LOG: 00000: database system is ready to accept
> connections
> 2008-12-18 12:15:48 PST LOCATION: reaper, postmaster.c:2156
> 2008-12-18 12:15:49 PST LOG: 08P01: incomplete startup packet
> 2008-12-18 12:15:49 PST LOCATION: ProcessStartupPacket, postmaster.c:1396
>
> From /syslog
>
> Dec 17 00:02:01 nameofserver /USR/SBIN/CRON[26124]: (root) CMD (if [ -x
> /usr/sbin/pg_maintenance ]; then /usr/sbin/pg_maintenance --analyze
> >/dev/null; fi)
> Dec 17 05:02:01 nameofserver /USR/SBIN/CRON[1879]: (root) CMD (if [ -x
> /usr/sbin/pg_maintenance ]; then /usr/sbin/pg_maintenance --analyze
> >/dev/null; fi)
> Dec 17 10:02:01 nameofserver /USR/SBIN/CRON[9264]: (root) CMD (if [ -x
> /usr/sbin/pg_maintenance ]; then /usr/sbin/pg_maintenance --analyze
> >/dev/null; fi)
> Dec 17 15:02:01 nameofserver /USR/SBIN/CRON[15886]: (root) CMD (if [ -x
> /usr/sbin/pg_maintenance ]; then /usr/sbin/pg_maintenance --analyze
> >/dev/null; fi)
> Dec 17 20:02:01 nameofserver /USR/SBIN/CRON[12183]: (root) CMD (if [ -x
> /usr/sbin/pg_maintenance ]; then /usr/sbin/pg_maintenance --analyze
> >/dev/null; fi)
>
> This seems like a missed configuration option -- but I'm not sure where.
> Any ideas?
>
> Thanks,
> 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
Subject: Re: Incomplete Startup Packet on startup and when pg_maintenance --analyze runs in cron
In-Reply-To: <93f118f0812181534w1f78f0a5tda3a21a7074b04e6@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