I have a module that manages various bios settings on HP proliant servers (basically hacked up the conrep module from the forge) Anyhow, the resource names (resource_title) can get fairly long and break the 40 character column width in the database, as shown with the error below:
2017-04-22 13:30:25.912 EDT [db:pe-puppetdb,sess:58fb8caf.8cbb,pid:36027,vtid:29/23277,tid:396758] STATEMENT: INSERT INTO resource_events ( new_value, corrective_change, property, file, report_id, old_value, containing_class, certname_id, line, resource_type, status, resource_title, timestamp, containment_path, message ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15 ) RETURNING * 2017-04-22 13:30:25.978 EDT [db:pe-puppetdb,sess:58fb8caf.8cbb,pid:36027,vtid:29/23281,tid:396760] ERROR: value too long for type character varying(40) Is this something I can change without having to recreate the entire database or having puppet somehow change it back? I am not a DBA, so SQL isn't my strongest skill. I am running PE 2017.1.1, but this error has been going on a long time (since PE3.7 when I introduced the bios module) Thanks Bill -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/66ef125a-5d7e-4f97-b96b-0d253e22b35f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
