hostnames removed for privacy's sake.



<pre>

root@puppetmaster:~# rake -f /usr/share/foreman/Rakefile puppet:import:hosts_and_facts RAILS_ENV=production

Libvirt binding are missing - hypervisor management is disabled

Importing from /var/lib/puppet/yaml/facts

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved.net.au

Importing nameremoved

rake aborted!

Mysql::Error: Column 'name' cannot be null: INSERT INTO `hosts` (`model_id`, `serial`, `ip`, `location_id`, `certname`, `root_pass`, `build`, `enabled`, `mac`, `managed`, `updated_at`, `puppet_proxy_id`, `subnet_id`, `image_id`, `organization_id`, `last_freshcheck`, `use_image`, `domain_id`, `puppet_ca_proxy_id`, `name`, `disk`, `source_file_id`, `comment`, `operatingsystem_id`, `last_compile`, `owner_type`, `environment_id`, `medium_id`, `compute_resource_id`, `architecture_id`, `owner_id`, `image_file`, `puppet_status`, `installed_at`, `environment`, `ptable_id`, `hostgroup_id`, `uuid`, `created_at`, `last_report`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, '', NULL, '2013-04-25 22:46:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, '2013-04-25 22:46:37', NULL)



Tasks: TOP => puppet:import:hosts_and_facts

(See full trace by running task with --trace)

</pre>



<pre>

root@puppetmaster:~# dpkg --list | grep foreman

ii foreman 1.1.1+debian1 Systems management web interface

rc foreman-mysql 1.1.1+debian1 metapackage providing MySQL dependencies for Foreman

ii foreman-proxy 1.1+debian1 RESTful proxies for DNS, DHCP, TFTP, and Puppet

root@puppetmaster:~# dpkg --list | grep puppet

ii facter 1.6.18-1puppetlabs1 Ruby module for collecting simple facts about a host operating system

ii hiera 1.1.2-1puppetlabs1 A simple pluggable Hierarchical Database.

ii puppet 2.6.2-5+squeeze7 Centralized configuration management - agent startup and compatibility scripts

ii puppet-common 2.6.2-5+squeeze7 Centralized configuration management

iF puppet-dashboard 1.2.23-1puppetlabs1 Dashboard for Puppet

ii puppetlabs-release 1.0-5 "Package to install Puppet Labs gpg key and apt repo"

ii puppetmaster 2.6.2-5+squeeze7 Centralized configuration management - master startup and compatibility scripts

</pre>



<pre>

root@puppetmaster:~# cat /etc/debian_version

6.0.7

root@puppetmaster:~# uname -a

Linux puppetmaster 3.2.0-0.bpo.4-686-pae #1 SMP Debian 3.2.35-2~bpo60+1 i686 GNU/Linux

</pre>

<pre>

root@puppetmaster:~# rails --version

Rails 2.3.5

root@puppetmaster:~# ruby --version

ruby 1.8.7 (2010-08-16 patchlevel 302) [i486-linux]

</pre>



I've tried looking through /var/lib/puppet/yaml/facts/* to see if I can find any yaml's with dodgy characters etc... but I can't see anything.

I believe this happened after upgrading foreman, but we only noticed the cron job failing a few days ago so I can't be certain.