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