Bug #2431
Updated by Dominic Cleal almost 10 years ago
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.
<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.