pgstatspack pg_stat_statements error

Поиск
Список
Период
Сортировка
От Brett Gaston
Тема pgstatspack pg_stat_statements error
Дата
Msg-id CAEO=Rvrs_z34PcuUXU=knWhER+MP7pKhQX=mSDxUMptUuGRMvg@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Дерево обсуждения
When I load pg_stat_statements in the shared library and try to run a pgstatspack snapshot, I get the following errors:  I am running version 2.3.1.  Ironically, if I don't load load pg_stat_statements in the shared library, I don't get these errors when running a snapshot although I do get log warnings that I should load pg_stat_statements.  Anyone have an idea of what the issue could be?

2012-12-18 17:00:02.067 UTC postgres@test 22749 [local] ERROR:  duplicate key value violates unique constraint "idx_pgstatspack_names_name"
2012-12-18 17:00:02.067 UTC postgres@test 22749 [local] DETAIL:  Key (name)=(bgaston) already exists.
2012-12-18 17:00:02.067 UTC postgres@test 22749 [local] CONTEXT:  SQL statement "insert into pgstatspack_names (name)
     select pg_get_userbyid(userid)
     from pg_stat_statements
     left join pgstatspack_names on pg_get_userbyid(userid)=name
     where
      dbid=(select oid from pg_database where datname=current_database()) and
      name is null"
PL/pgSQL function "pgstatspack_snap" line 178 at SQL statement
2012-12-18 17:00:02.067 UTC postgres@test 22749 [local] STATEMENT:  select pgstatspack_snap('Cron-Based Snapshot');
2012-12-18 17:00:02.293 UTC postgres@dcm_selfcare 22751 [local] ERROR:  duplicate key value violates unique constraint "idx_pgstatspack_names_name"
2012-12-18 17:00:02.293 UTC postgres@dcm_selfcare 22751 [local] DETAIL:  Key (name)=(zenoss) already exists.
2012-12-18 17:00:02.293 UTC postgres@dcm_selfcare 22751 [local] CONTEXT:  SQL statement "insert into pgstatspack_names (name)
     select pg_get_userbyid(userid)
     from pg_stat_statements
     left join pgstatspack_names on pg_get_userbyid(userid)=name
     where
      dbid=(select oid from pg_database where datname=current_database()) and
      name is null"
PL/pgSQL function "pgstatspack_snap" line 178 at SQL statement
2012-12-18 17:00:02.293 UTC postgres@dcm_selfcare 22751 [local] STATEMENT:  select pgstatspack_snap('Cron-Based Snapshot');
2012-12-18 17:00:02.595 UTC postgres@dcm 22753 [local] ERROR:  duplicate key value violates unique constraint "idx_pgstatspack_names_name"
2012-12-18 17:00:02.595 UTC postgres@dcm 22753 [local] DETAIL:  Key (name)=(bgaston) already exists.
2012-12-18 17:00:02.595 UTC postgres@dcm 22753 [local] CONTEXT:  SQL statement "insert into pgstatspack_names (name)
     select pg_get_userbyid(userid)
     from pg_stat_statements
     left join pgstatspack_names on pg_get_userbyid(userid)=name
     where
      dbid=(select oid from pg_database where datname=current_database()) and
      name is null"
PL/pgSQL function "pgstatspack_snap" line 178 at SQL statement
2012-12-18 17:00:02.595 UTC postgres@dcm 22753 [local] STATEMENT:  select pgstatspack_snap('Cron-Based Snapshot');
2012-12-18 17:00:02.687 UTC postgres@portal 22755 [local] ERROR:  duplicate key value violates unique constraint "idx_pgstatspack_names_name"
2012-12-18 17:00:02.688 UTC postgres@portal 22755 [local] DETAIL:  Key (name)=(zenoss) already exists.
2012-12-18 17:00:02.688 UTC postgres@portal 22755 [local] CONTEXT:  SQL statement "insert into pgstatspack_names (name)
     select pg_get_userbyid(userid)
     from pg_stat_statements
     left join pgstatspack_names on pg_get_userbyid(userid)=name
     where
      dbid=(select oid from pg_database where datname=current_database()) and
      name is null"
PL/pgSQL function "pgstatspack_snap" line 178 at SQL statement

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

Предыдущее
От: Shams Khan
Дата:
Сообщение: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level