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 puppet-users+unsubscr...@googlegroups.com. 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.
