hello! centos 5.5, puppet 2.6.4, storeconfig, mysql, about150 clients. time to time i recive following error: Puppet (err): Could not retrieve catalog from remote server: Error 400 on SERVER: Mysql::Error: MySQL server has gone away how can i fix it? wbr, alw -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Mon, Dec 6, 2010 at 17:17, walexey <walexey@gmail.com> wrote:> hello! > > centos 5.5, puppet 2.6.4, storeconfig, mysql, about150 clients. > time to time i recive following error: > > Puppet (err): Could not retrieve catalog from remote server: Error 400 > on SERVER: Mysql::Error: MySQL server has gone away > > how can i fix it?At a guess, you are allowing more concurrency in your puppet server than you are in your MySQL service. Check to see if that is the case and, if necessary, reduce or increase allowed concurrency. If that isn''t the case, check that your MySQL service isn''t aborting connections or restarting when this happens. Regards, Daniel -- ✣ Daniel Pittman ✉ daniel@rimspace.net ☎ +61 401 155 707 ♽ made with 100 percent post-consumer electrons -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Dec 5, 10:17 pm, walexey <wale...@gmail.com> wrote:> hello! > > centos 5.5, puppet 2.6.4, storeconfig, mysql, about150 clients. > time to time i recive following error: > > Puppet (err): Could not retrieve catalog from remote server: Error 400 > on SERVER: Mysql::Error: MySQL server has gone away > > how can i fix it? > > wbr, alwWould you happen to be running the puppet master(s) in mongrel? -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
> > Puppet (err): Could not retrieve catalog from remote server: Error 400 > > on SERVER: Mysql::Error: MySQL server has gone away > > > how can i fix it? > > > wbr, alw > > Would you happen to be running the puppet master(s) in mongrel?Yes, it runs with mongrel wbr, alw -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Dec 12, 11:17 pm, walexey <wale...@gmail.com> wrote:> > > Puppet (err): Could not retrieve catalog from remote server: Error 400 > > > on SERVER: Mysql::Error: MySQL server has gone away > > > > how can i fix it? > > > > wbr, alw > > > Would you happen to be running the puppet master(s) in mongrel? > > Yes, it runs with mongrel > > wbr, alwIt''s anecdotal, but we had these same spurious disconnects. Mongrel, not the activerecord/mysql handler, seemed to be periodically closing an open mysql connection. When AR went to reuse the existing pooled connection it would get a RST from the server. Never tracked down exactly why, but it completely stopped with a change to Passenger. I''d suggest giving Passenger a try, though I do think it''s a poor answer. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
I have the same issue with Passenger. This is preventing me from using Storeconfigs all together. On Dec 14, 12:47 pm, donavan <dona...@desinc.net> wrote:> On Dec 12, 11:17 pm, walexey <wale...@gmail.com> wrote: > > > > > Puppet (err): Could not retrieve catalog from remote server: Error 400 > > > > on SERVER: Mysql::Error: MySQL server has gone away > > > > > how can i fix it? > > > > > wbr, alw > > > > Would you happen to be running the puppet master(s) in mongrel? > > > Yes, it runs with mongrel > > > wbr, alw > > It''s anecdotal, but we had these same spurious disconnects. Mongrel, > not the activerecord/mysql handler, seemed to be periodically closing > an open mysql connection. When AR went to reuse the existing pooled > connection it would get a RST from the server. Never tracked down > exactly why, but it completely stopped with a change to Passenger. > > I''d suggest giving Passenger a try, though I do think it''s a poor > answer.-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.