Обсуждение: Pgstatspack errors in log files
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
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
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
On 10/13/2010 3:12 AM, Machiel Richards wrote:
Hi AllDid you load pg_stat_statements module? Without loading that module, pgstatspack will not be created and will not run.
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
-- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com