Looks like this message didn''t reach the group for some reason.
For clarity though, I found that this was occurring on all three
masters. I was able to resolve this by downgrading the activerecord
gem on the puppet masters from 3.1.3 to 3.0.5.
On 13 January 2012 08:31, jamese <james.eckersall@gmail.com>
wrote:> I''m currently running three puppet masters (version 2.7.3 via
apache
> +passenger) in a cluster, 2 on CentOS 5.7, 1 on CentOS 6.1
>
> On the 6.1 master, I am frequently getting the following error
> (approximately 50% of the time when a client connects):
>
> err: Could not retrieve catalog from remote server: Error 400 on
> SERVER: Mysql::Error: Unknown prepared statement handler (7) given to
> mysqld_stmt_execute: INSERT INTO `inventory_facts` (`name`, `node_id`,
> `value`) VALUES (?, ?, ?)
>
> I don''t see any errors on the other two masters running CentOS
5.7.
>
> I have a separate server running CentOS 6.1 and MySQL 5.1.52 for the
> inventory db.
>
> On the masters, I have inventory configured in the puppet.conf as
> follows:
> facts_terminus = inventory_active_record
> dbadapter = mysql
> dbname = inventory
> dbuser = inventory
> dbpass = xxxx
> dbserver = x.x.x.x
>
> The masters are running ruby enterprise 1.8.7 and all have exactly the
> same versions of ruby gems installed.
>
> *** LOCAL GEMS ***
>
> activemodel (3.1.3)
> activerecord (3.1.3)
> activesupport (3.1.3)
> arel (2.2.1)
> builder (3.0.0)
> facter (1.6.3)
> fastthread (1.0.7)
> i18n (0.6.0)
> multi_json (1.0.3)
> mysql (2.8.1)
> mysql2 (0.3.10)
> passenger (2.2.9)
> puppet (2.7.3)
> rack (1.1.0)
> rake (0.8.7)
> tzinfo (0.3.31)
>
> The only (potentially related) differences I can see between the
> masters are with the mysql-libs package (5.1.52-1 on EL6.1 and
> 5.0.77-4 on EL5.7) and the ruby-mysql package (ruby-mysql-2.8.2-1 on
> EL6.1, ruby-mysql-2.7.3-1 on EL5.7), although I''m not sure if this
is
> relevant.
>
> Any help regarding these errors would be greatly appreciated.
--
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.