Issue #2816 has been updated by Jesse Wolfe. Status changed from Investigating to Ready for Testing Branch set to http://github.com/jes5199/puppet/tree/ticket/0.25.x/2816
This patch sets :reconnect to true, as suggested by the ticket. ---------------------------------------- Bug #2816: Storeconfigs - MySQL server has gone away http://projects.reductivelabs.com/issues/2816 Author: Dan Carley Status: Ready for Testing Priority: Normal Assigned to: Jesse Wolfe Category: Rails Target version: 0.25.2 Affected version: 0.25.1 Keywords: Branch: http://github.com/jes5199/puppet/tree/ticket/0.25.x/2816 I am receiving the following error from storeconfigs with a MySQL backend. <pre> Mysql::Error: MySQL server has gone away </pre> Respawning one client in a loop doesn't produce the error. Spawning all clients (17 on this particular network) at once from cron reproduces the error every time. Several of the clients then fail to complete. Attached is a puppetmasterd log of such a run. Observing MySQL's processlist at the time shows that it holds up to 18 idle connections open until the point at which the errors are logged and then connections are closed. The puppetmaster is setup like so. * Gentoo Linux * Puppet 0.25.0 * Mongrel 1.1.5 (5 puppetmasterd processes) * Nginx 0.8.17 * Rails 2.3.4 * ActiveRecord 2.3.4 * MySQL/Ruby 2.7.5 * MySQL 5.0.70 (unix socket, default settings) I have tried combinations of the following with no success. * Downgrading to Rails 2.2 and ActiveRecord 2.2.3 (with patch from #2508). * Upgrading to MySQL/Ruby 2.8.1 I have noticed that amending @rails.rb@ to set the ActiveRecord connection option @:reconnect = true@ seems to resolve the issue. However I'm not clear whether such an approach is transaction safe for Puppet to use. -- 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://reductivelabs.com/redmine/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.
