[Postgres-xl-bugs] Cancelling analyze distributed table results in

Krzysztof Nienartowicz krzysztof.nienartowicz at unige.ch
Fri Aug 21 04:01:09 PDT 2015


XL95:
After starting, cancelling and starting again analyze on a distributed
table, we noticed two analyze processes continued to run (including the
cancelled one), causing some statistics table errors:

2015-08-21 12:50:25.332
CEST,"postgres","surveys",31414,"::1:46683",55d61b32.7ab6,85,"ANALYZE",2015-08-20
20:23:46 CEST,54/260,2098827,LOG,00000,"Connection error duplicate key
value violates unique constraint
""pg_statistic_relid_att_inh_index""",,,,,,"analyze verbose
mdb_cu1_completesource_011;",,"add_error_message, pgxcnode.c:2033","psql"
2015-08-21 12:55:14.996
CEST,"postgres","surveys",31414,"::1:46683",55d61b32.7ab6,86,"ANALYZE",2015-08-20
20:23:46 CEST,54/260,2098827,ERROR,23505,"duplicate key value violates
unique constraint ""pg_statistic_relid_att_inh_index""",,,,,,"analyze
verbose mdb_cu1_completesource_011;",,"pgxc_node_report_error,
execRemote.c:9241","psql"
2015-08-21 12:55:47.071
CEST,"postgres","surveys",31414,"::1:46683",55d61b32.7ab6,87,"SELECT",2015-08-20
20:23:46
CEST,54/261,2098869,ERROR,42809,"""pg_statistic_relid_att_inh_index"" is an
index",,,,,,"select * from
pg_statistic_relid_att_inh_index;",15,"heap_openrv_extended,
heapam.c:1294","psql"

Looks like cancelled and 'proper process' had some races going on resulting
in this error.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20150821/5078fcbe/attachment.htm>


More information about the postgres-xl-bugs mailing list