Re: Pgstatspack errors in log files

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(at)rdc(dot)co(dot)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