Issue #4487 has been updated by Marek Wodzinski.
I can confirm that. In my case it occurs on both backends: mysql and sqlite. In
case of using sqlite, it looks like there is no limit for length of this field,
so puppet agent which tries to use stored variables eats all memory after some
time.
I'm using puppet from debian lenny-backports (puppet 2.6.2-1~bpo50+1)
mysql> select name, length(environment) from hosts;
+----------------------+---------------------+
| name | length(environment) |
+----------------------+---------------------+
| debian-1.example.com | 65535 |
| debian-3.example.com | 65535 |
| debian-4.example.com | 65535 |
| debian-2.example.com | 65535 |
+----------------------+---------------------+
4 rows in set (0.00 sec)
----------------------------------------
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.
