Uploaded image for project: 'Puppet'
  1. Puppet
  2. PUP-1173

Stored configs db hits integer limit

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Template:

      Description

      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:

      Thu Aug 25 15:32:40 -0400 2011 Puppet (err): Mysql::Error: Duplicate entry '2147483647' for key 1: INSERT INTO `fact_values` (`created_at`, `updated_at`, `value`, `fact_name_id`, `host_id`) VALUES('2011-08-25 15:32:40', '2011-08-25 15:32:40', '10.6.0.111', 67, 1716)
      

      2147483647=2^31 which is the 32bit integer limit.

      Which resulted in these logs on all of my clients in that environment:

      Aug 26 13:47:26 kickstart-001 puppet-agent[27506]: Could not retrieve catalog from remote server: Error 400 on SERVER: Mysql::Error: Duplicate entry '2147483647' for key 1: INSERT INTO `fact_values` (`created_at`, `updated_at`, `value`, `fact_name_id`, `host_id`) VALUES('2011-08-26 13:47:26', '2011-08-26 13:47:26', '10.6.0.104', 67, 1183)
      

      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.

        Attachments

          Activity

            jsd-sla-details-panel

              People

              • Assignee:
                Unassigned
                Reporter:
                redmine.exporter redmine.exporter
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: