Thread: Pgstatspack errors in log files

Pgstatspack errors in log files

From
Machiel Richards
Date:
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

Re: Pgstatspack errors in log files

From
Lukasz Brodziak
Date:
Hi,

From my experience such errors are an effect of a typo in function
name or agrument. Refer to the help file or any other type of
documentation maybe You should use "<arg value>" instead of '<arg
value>'. I often have such problems qith PostgreSQL built in functions
because I tend to type them as I did in MS SQL.

2010/10/13 Machiel Richards <machielr@rdc.co.za>:
> 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



--
Łukasz Brodziak
II MU Bioinformatyka

Re: Pgstatspack errors in log files

From
Mladen Gogala
Date:
On 10/13/2010 3:12 AM, Machiel Richards wrote:
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
Did you load pg_stat_statements module? Without loading that module, pgstatspack will not be created and will not run.
-- 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com