Pgstatspack errors in log files

From: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Pgstatspack errors in log files
Date: 2010-10-13 07:12:44
Message-ID: 1286953964.2257.9.camel@machielr-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All

I am hoping someone else have had this before.

We have configured pgstatspack to run on one of many database
servers as we want to test the impact and results before deploying to
all servers.

On the test server everything was working fine without any
errors.

However, we then deployed this to one of the production server
and even though we are getting relevant results, snapshots,etc... the
following errors appear in the Postgresql log files.

Does anybody know why we would be getting this and how to
resolve this. I would really appreciate the help.

2010-10-13 04:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 04:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 04:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 04:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 04:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 05:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 05:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 05:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 05:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 05:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 05:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 05:02:01 SAST LOG: incomplete startup packet
2010-10-13 06:00:02 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 06:00:02 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 06:00:02 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 06:00:02 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 06:00:02 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 06:00:02 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 07:00:02 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 07:00:02 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 07:00:02 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 07:00:02 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 07:00:02 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 07:00:02 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 08:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 08:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 08:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 08:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 08:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 08:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 09:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 09:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 09:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');
2010-10-13 09:00:01 SAST ERROR: function pgstatspack_snap(unknown) does
not exist at character 8
2010-10-13 09:00:01 SAST HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2010-10-13 09:00:01 SAST STATEMENT: select pgstatspack_snap('cron based
snapshot');

Regards
Machiel

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lukasz Brodziak 2010-10-13 11:12:37 Re: Pgstatspack errors in log files
Previous Message Jason Tan Boon Teck 2010-10-13 04:03:22 Running on multiple core server