Log message " last_statrequest ... is later than collector's time" - what does it mean?

From: Stephan Vollmer <vollmer(dot)stephan(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Log message " last_statrequest ... is later than collector's time" - what does it mean?
Date: 2011-09-16 12:00:55
Message-ID: CAA2gb+dgYnChJ1Th54j3V6R0fa2BFNS9C=FmPe-OYRWBUY7VaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I upgraded our test database from PostgreSQL 8.4.8 to 9.0.4 via pg_dumpall.
The database seems to work fine, but now the logfile of the new database is
flooded with log messages like these:

2011-09-16 13:48:32 CEST: LOG: database system was shut down at 2011-09-16
13:48:29 CEST
2011-09-16 13:48:32 CEST: LOG: autovacuum launcher started
2011-09-16 13:48:32 CEST: LOG: database system is ready to accept
connections
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.614476+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.626524+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.638498+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.650502+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.662507+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.674506+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.686507+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.698498+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.710517+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.722504+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.734495+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.746498+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.758503+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.770501+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.782509+02
2011-09-16 13:48:54 CEST: LOG: last_statrequest 2011-09-16
13:48:55.890743+02 is later than collector's time 2011-09-16
13:48:54.794496+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.500691+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.51259+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.524583+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.536605+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.548601+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.560569+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.572571+02
2011-09-16 13:49:07 CEST: LOG: last_statrequest 2011-09-16
13:49:08.176573+02 is later than collector's time 2011-09-16
13:49:07.584579+02

Configuration:
- SUSE Linux Enterprise Server 10 (i586)
- uname -a: Linux 2.6.16.21-0.8-bigsmp #1 SMP Mon Jul 3 18:25:39 UTC 2006
i686 athlon i386 GNU/Linux
- PostgreSQL 9.0.4, installed with RPM: postgresql-9.0.4-54.5

What do these messages mean and what can I do to avoid them?

Cheers,
Stephan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darin Perusich 2011-09-16 12:39:28 Re: forcing table ownership
Previous Message marc_firth 2011-09-16 10:34:38 Re: CUBE, ROLLUP, GROUPING SETS?