Issue #4487 has been updated by Jordan Sissel.
<pre>
mysql> select substring_index(name;, ".", 2), length(environment),
substring(environment,1,20) from hosts where environment like "%---%" order by
length(environment);
+-------------------------------+---------------------+-----------------------------+
| substring_index(name, ".", 2) | length(environment) |
substring(environment,1,20) |
+-------------------------------+---------------------+-----------------------------+
| solr45-2.prod | 65535 | --- "--- \"--- \\\"-
|
| solr13-1.prod | 65535 | --- "--- \"--- \\\"-
|
| solr13-2.prod | 65535 | --- "--- \"--- \\\"-
|
| solr45-1.prod | 65535 | --- "--- \"--- \\\"-
|
| solr00-1.prod | 65535 | --- "--- \"--- \\\"-
|
+-------------------------------+---------------------+-----------------------------+
</pre>
Seems like there's some bad yaml encapsulation going on. I don't think this is
a mysql rubygem bug.
----------------------------------------
Bug #4487: Environment column in hosts table updating incorrectly
https://projects.puppetlabs.com/issues/4487
Author: Jason Koppe
Status: Rejected
Priority: High
Assignee: Matt Robinson
Category:
Target version: 2.6.2
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.
