Pgstatspack errors in log files - Mailing list pgsql-novice
| From | Machiel Richards |
|---|---|
| Subject | Pgstatspack errors in log files |
| Date | |
| Msg-id | 1286953964.2257.9.camel@machielr-laptop Whole thread Raw |
| Responses |
Re: Pgstatspack errors in log files
Re: Pgstatspack errors in log files |
| List | 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
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
pgsql-novice by date: