Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group