Issue #5067 has been updated by Markus Roberts. Status changed from Unreviewed to Duplicate
Upgrading to activerecord 2.3 has been reported to fix this. ---------------------------------------- Bug #5067: Mysql::Error: MySQL server has gone away https://projects.puppetlabs.com/issues/5067 Author: MaxiM Basunov Status: Duplicate Priority: Normal Assignee: Category: Target version: Affected Puppet version: 2.6.1 Keywords: Branch: We have two puppet-master installations where stored configs configured using MySQL. Very often, puppet master reports: <blockquote> Thu Oct 21 18:48:19 +0400 2010 //host.domain.com/Puppet (err): Could not retrieve catalog from remote server: Error 400 on SERVER: Mysql::Error: MySQL server has gone away: SELECT * FROM `hosts` WHERE (`hosts`.`name` = 'host.domain.com') LIMIT 1 Thu Oct 21 18:48:19 +0400 2010 //host.domain.com/Puppet (notice): Using cached catalog Thu Oct 21 18:48:19 +0400 2010 //host.domain.com/Puppet (err): Could not retrieve catalog; skipping run </blockquote> SQL may differ. Every master controls 5-10 agents (each agent runs every 5 minutes), but we plan to control total 200+ hosts, and this behavior will be very annoying under high load. Message reported for different agent hosts, time between reports differs from 5 to 120 minutes. Software used on affected servers: Linux system is CentOS 5/32 (XEN VM), puppet 2.6.1, Nginx, Mongrel, MySQL 5.0.77, Rails and ActiveRecord 2.2.2, Ruby 1.8.6-111 FreeBSD system is 7.3/amd64, puppet 2.6.2, Nginx, Mongrel, MySQL 5.1.48, Rails and ActiveRecord 2.2.2, Ruby 1.8.7-248 All mysql servers with default configuration (on FreeBSD - buffers configured) with InnoDB enabled, and Puppet tables in InnoDB. Puppet config from Linux (on BSD slighty differs): <blockquote> [main] vardir = /var/lib/puppet logdir = /var/log/puppet rundir = /var/run/puppet ssldir = $vardir/ssl report = true [master] bindaddress = 0.0.0.0 reports = log,tagmail,store syslogfacility = user modulepath = /etc/puppet/modules/main:/etc/puppet/modules/custom:/usr/share/puppet/modules storeconfigs = true dbadapter = mysql dbuser = puppet dbpassword = password dbserver = localhost dbsocket = /var/lib/mysql/mysql.sock </blockquote> -- 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.
