Re: Pgstatspack errors in log files - Mailing list pgsql-novice
From | Lukasz Brodziak |
---|---|
Subject | Re: Pgstatspack errors in log files |
Date | |
Msg-id | AANLkTi=DAF9b_g4AYZgLxn3JH-y8dMCivCcDV-UTp1WZ@mail.gmail.com Whole thread Raw |
In response to | Pgstatspack errors in log files (Machiel Richards <machielr@rdc.co.za>) |
List | pgsql-novice |
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
pgsql-novice by date: