Issue #4487 has been updated by Cody Herriges.
This looks like an incompatibility of Puppet 2.6.x and older rails/activerecord/mysql gem versions. Reproducible with Centos 5.5 and Debian Lenny running rails 2.2.1 and 2.2.0. Installed Ruby EE 1.8.7 on Centos 5.5, installed rails through gems instead of through yum and the errors subside completely. ---------------------------------------- Bug #4487: Environment column in hosts table updating incorrectly https://projects.puppetlabs.com/issues/4487 Author: Jason Koppe Status: Re-opened Priority: High Assignee: Matt Robinson Category: Target version: Affected Puppet version: 2.6.0 Keywords: storedconfig, mysql, environment, hosts table Branch: http://github.com/MarkusQ/puppet/tree/ticket/2.6.x/4487 Posted on puppet-users at [thread/7237b49342ff9890](http://groups.google.com/group/puppet-users/browse_thread/thread/7237b49342ff9890) Below I null out the environment column, show that it's null for a particular host, then run puppetd a few times on the host. <pre> mysql for r...@localhost on indadm1> select * from hosts where name like 'iad-web2%'; +----+---------------------+---------------+-------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ | id | name | ip | environment | last_compile | last_freshcheck | last_report | updated_at |source_file_id | created_at | +----+---------------------+---------------+-------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ | 9 | iad-web2.indeed.net | 10.24.186.136 | NULL | 2010-08-06 03:31:23 | NULL | NULL | 2010-08-06 03:31:23 | NULL | 2010-06-08 19:47:22 | +----+---------------------+---------------+-------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ 1 row in set (0.00 sec) mysql for r...@localhost on indadm1> select * from hosts where name like'iad-web2%'; +----+---------------------+---------------+----------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ | id | name | ip | environment | last_compile | last_freshcheck | last_report | updated_at | source_file_id | created_at | +----+---------------------+---------------+----------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ | 9 | iad-web2.indeed.net | 10.24.186.136 | --- production | 2010-08-06 03:31:23 | NULL | NULL | 2010-08-06 03:32:42 | NULL | 2010-06-08 19:47:22 | +----+---------------------+---------------+----------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ 1 row in set (0.00 sec) mysql for r...@localhost on indadm1> select * from hosts where name like 'iad-web2%'; +----+---------------------+---------------+----------------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ | id | name | ip | environment | last_compile | last_freshcheck | last_report | updated_at | source_file_id | created_at | +----+---------------------+---------------+----------------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ | 9 | iad-web2.indeed.net | 10.24.186.136 | --- "--- production" | 2010-08-06 03:32:50 | NULL | NULL | 2010-08-06 03:32:50 | NULL | 2010-06-08 19:47:22 | +----+---------------------+---------------+----------------------+---------------------+-----------------+-------------+---------------------+----------------+---------------------+ 1 row in set (0.00 sec) </pre> -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
