[PDB-176] insert or update on table "certname_catalogs" violates foreign key constraint "certname_catalogs_catalog_fkey" Created: 2013/12/04 Updated: 2014/11/17 Resolved: 2013/12/18
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
The user 'ak0ska' has been seeing the following errors in his postgresql logs:
Although up until now we can't reproduce it directly with PuppetDB yet, we do believe the following SQL if for some reason was able to be reproduced in production would recreate this scenario:
should get error "ERROR: insert or update on table "certname_catalogs" violates foreign key constraint "certname_catalogs_catalog_fkey""
So the net result after the constraint error is that the replace catalog request goes back into the queue, tries again and we see no data loss. The concern is that those requests block until the GC is complete, so ideally we should try to minimize this.
The original google groups discussion is here: <https://groups.google.com/forum/?fromgroups=#!topic/puppet-users/yRMI1J_y6Ps>
|Comment by Deepak Giridharagopal [ 2013/12/18 ]|
This is handled by