Issue #4694 has been updated by Hector Rivas.
The same problem for me.
In my case my installation is:
* 7 nodes: 1 debian lenny, 1 suse 11.1 x86_64, 1 suse 11.0 s390x (ZLinux), 2
AIX 6.1 ML3
* Puppet 2.6.1rc3
* facter 1.5.7
* mongrel 1.1.5-5 (apache+mongrel) (debian package)
* libmysql-ruby1.8 2.7.4-1 (debian package)
* mysql-server 5.0.51a-24+lenny4
* Ruby:
* puppetmaster: ruby 1.8.7.72-3lenny1 (debian package)
* AIX nodes: ruby-1.8.7-p302-aix61
* Suse (zLinux & x86): ruby-1.8.7.p72-5.22.1
But I only have the error on the AIX and Suse ZLinux nodes, not on Linux x86
(debian or suse) (???)
Some errors that I am getting:
* More often: "SERVER: Mysql::Error: MySQL server has gone away: SELECT * FROM
`hosts` WHERE (`hosts`.`name` = 'hostname') LIMIT 1"
* SERVER: Mysql::Error: MySQL server has gone away: INSERT INTO `fact_values`
(`created_at`, `updated_at`, `value`, `fact_name_id`, `host_id`)
VALUES('2010-09-03 12:36:35', '2010-09-03 12:36:35', '0', 1, 4)
* SERVER: Mysql::Error: MySQL server has gone away: INSERT INTO `param_values`
(`created_at`, `line`, `resource_id`, `updated_at`, `value`, `param_name_id`)
VALUES('2010-09-03 12:34:08', 75, 1197, '2010-09-03 12:34:08', '4', 47)
* SERVER: Mysql::Error: MySQL server has gone away: DELETE FROM `param_values`
WHERE (`id` IN ('7401','7402'))
* SERVER: Mysql::Error: MySQL server has gone away: SELECT t.id,
t.resource_id, p.name FROM resource_tags t INNER JOIN resources r ON
t.resource_id=r.id INNER JOIN puppet_tags p ON t.puppet_tag_id=p.id WHERE
r.host_id=4
----------------------------------------
Bug #4694: Storeconfig issue with AR/MySQL
http://projects.puppetlabs.com/issues/4694
Author: Andrew Forgue
Status: Unreviewed
Priority: Normal
Assignee:
Category: stored configuration
Target version: 0.25.6
Affected version: 0.25.5
Keywords: stored configs
Branch:
We're having an issue with storeconfigs generating random MySQL disconnect
errors. This is not related to #2880 or #2816. Though I suspect that the
underlying cause may be the same.
First:
err: Mysql::Error: MySQL server has gone away: INSERT INTO `fact_values`
(...)
Second:
err: Puppet::Parser::Compiler failed with error
ActiveRecord::StatementInvalid: Mysql::Error: Lost connection to MySQL server
during query: SELECT * FROM `param_values` WHERE (`param_values`.resource_id =
1136908 AND (param_name_id = 133)) on node xxx.
Third:
err: Mysql::Error: Lost connection to MySQL server during query: SELECT
t.id, t.resource_id, p.name FROM resource_tags as t INNER JOIN resources r ON
t.resource_id=r.id INNER JOIN puppet_tags as p ON t.puppet_tag_id=p.id WHERE
r.host_id=531
So they're coming from all over the place. I've verified that in the code
we're using, reconnect is set to true but it's not reconnecting. Here's the
versions:
* Puppet 0.25.5
* Rails 2.3.8
* Mongrel 1.1.5
* OS X Leopard (server)
* MySQL gem 2.8.1
* MySQL client library 5.0.82
* MySQL server 5.1.48
* Ruby 1.8.7-p22
Here's a summary of a single incident -- puppet server (puppet) to SQL server
conversation:
Puppet -> SQL: SYN
Puppet <- SQL: SYN+ACK
Puppet -> SQL: ACK
So the TCP connection is open,
1. MySQL Login successful
1. SET NAMES
1. SELECT * FROM HOSTS where hosts.name='hostname'
1. SELECT Facts for host
1. executes a bunch of queries for facts
1. Runs SELECT `param_names`.* FROM `param_names` INNER JOIN `param_values` ON
`param_names`.id = `param_values`.param_name_id WHERE
((`param_values`.resource_id = 943831))
1. Server returns results and then the client issues a quit (!)?
1. Socket is shutdown, client sends FIN+ACK, server responds with FIN+ACK
1. Server sends RST to client twice.
I've been working on this for a day or 2 and I have no idea what could be
causing this. I don't see any pattern.
--
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.
