Getting this error; The max pool size is currently 5; consider increasing it using MySQL. Surprisingly, I haven''t been able to find exactly where I make the configuration change that Puppet suggests. Any clues? Thanks. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
Matthew Burgess
2013-Jul-13 16:53 UTC
Re: [Puppet Users] where do I configure ''max pool size''?
On 13 July 2013 16:18, Steve Wray <stevedwray@gmail.com> wrote:> Getting this error; > The max pool size is currently 5; consider increasing it > > using MySQL. > > Surprisingly, I haven''t been able to find exactly where I make the > configuration change that Puppet suggests. > > Any clues? >Just add/change the following line in /etc/my.cnf: max_connections = x Where x is however many clients you think will be connecting simultaneously + some room for growth; then restart MySQL. Regards, Matt. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
On 7/13/2013 8:18 AM, Steve Wray wrote:> Getting this error; > The max pool size is currently 5; consider increasing it > > using MySQL. > > Surprisingly, I haven''t been able to find exactly where I make the > configuration change that Puppet suggests. > > Any clues?Where is the error coming from? Also paste the full text of the error. Not nearly enough information here to even suggest what to do next. Ramin -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
Steve Wray
2013-Jul-14 02:53 UTC
Re: [Puppet Users] where do I configure ''max pool size''?
Jul 14 02:36:51 puppet puppet-master[9566]: could not obtain a database connection within 5 seconds. The max pool size is currently 5; consider increasing it. Jul 14 02:37:14 puppet-master[9566]: last message repeated 12 times MySQL is configured for 300 connections. I have 72 hosts managed with Puppet. I don''t think the error message is about the MySQL configuration, I think theres an undocumented Puppet configuration. On Sunday, 14 July 2013 01:26:48 UTC+8, Ramin K wrote:> > On 7/13/2013 8:18 AM, Steve Wray wrote: > > Getting this error; > > The max pool size is currently 5; consider increasing it > > > > using MySQL. > > > > Surprisingly, I haven''t been able to find exactly where I make the > > configuration change that Puppet suggests. > > > > Any clues? > > Where is the error coming from? Also paste the full text of the error. > Not nearly enough information here to even suggest what to do next. > > Ramin > >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
What you''re running into is the default value of the Mysql connection pool that is set within the gem Activerecord. You can use dbconnections = 10 to increase it. However it appears you''re using the webrick Puppet master so it seems a bit strange that a single thread can use all five connections. Which version of the Activerecord gem or package do you have installed? Also which versions of Puppet and your distro? There are known problems with versions less than 2.3.5 of Activerecord. Ramin On 7/13/2013 7:53 PM, Steve Wray wrote:> Jul 14 02:36:51 puppet puppet-master[9566]: could not obtain a database > connection within 5 seconds. The max pool size is currently 5; consider > increasing it. > Jul 14 02:37:14 puppet-master[9566]: last message repeated 12 times > > MySQL is configured for 300 connections. I have 72 hosts managed with > Puppet. I don''t think the error message is about the MySQL > configuration, I think theres an undocumented Puppet configuration. > > On Sunday, 14 July 2013 01:26:48 UTC+8, Ramin K wrote: > > On 7/13/2013 8:18 AM, Steve Wray wrote: > > Getting this error; > > The max pool size is currently 5; consider increasing it > > > > using MySQL. > > > > Surprisingly, I haven''t been able to find exactly where I make the > > configuration change that Puppet suggests. > > > > Any clues? > > Where is the error coming from? Also paste the full text of the error. > Not nearly enough information here to even suggest what to do next. > > Ramin-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.