Pgstatspack errors in log files

Поиск
Список
Период
Сортировка
От Machiel Richards
Тема Pgstatspack errors in log files
Дата
Msg-id 1286953964.2257.9.camel@machielr-laptop
обсуждение исходный текст
Ответы Re: Pgstatspack errors in log files
Re: Pgstatspack errors in log files
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Jason Tan Boon Teck
Дата:
Сообщение: Running on multiple core server
Следующее
От: Lukasz Brodziak
Дата:
Сообщение: Re: Pgstatspack errors in log files