Resolution: Won't Fix
Affects Version/s: None
Fix Version/s: None
It looks like the default schema for puppet's stored configs (lib/puppet/rails/database/schema.rb) sets `id` columns as int(11) vs using bigint.
In my largest puppet environment, I noticed this:
2147483647=2^31 which is the 32bit integer limit.
Which resulted in these logs on all of my clients in that environment:
Updating the database schema for stored configs to use bigint for the `id` fields vs int, will help auto increment avoid the issue.
I checked the code for 2.7 (since I am running 2.6.9) and it seems to be the same there as well, this could potentially affect the dashboard as well.
My immediate work around was to truncate fact_values and set AUTO_INCREMENT=1; But this only will band-aid it until it reaches that point again.