Spread issue when creating database on CentOS - issue/workaround
![[Deleted User]](https://us.v-cdn.net/6029397/uploads/defaultavatar/nD0LWW9MQTB29.jpg)
On certain flavors of centOS /etc/sysconfig has altered permissions on the files in that directory,
which gives rise to issues when after a Vertica install, an attempt is made to create a database.
The issue often manifests itself as a "spreadd" problem, like the following:
*** Creating database: bg ***
127.0.0.1 OK [vertica-ce][(6, 0, 1)][000][x86_64]
Creating database bg
Spread does not seem to be running on 127.0.0.1. The database will not be started on this host.
The following host(s) are not available: 127.0.0.1.
You should get them running first. Operation can not be completed.
adminTools Last Chance Error Handler running...
raised error:
error message: list index out of range
trace file: /opt/vertica/log/adminTools-dbadmin.errors
REPORT THIS INFORMATION TO TECHNICAL SUPPORT
AND INCLUDE CONTENTS OF THE TRACE FILE IN YOUR REPORT
These type errors will occur, even though "spreadd" is really running.
The fix is to ensure that the permission bits on certain files in /etc/sysconfig are set to 644 - namely /etc/sysconfig/init and /etc/sysconfig/network.
If they are not, then do:
# sudo chmod 644 init
# sudo chmod 644 network
Once done, creating a database within "/opt/vertica/bin/admintools" should now work.
Generally, your /etc/sysconfig directory should look like the following (check - permission bits settings):
[dbadmin@rarcher1 sysconfig]$ ls -l
total 212
-rw-r--r--. 1 root root 403 Jan 30 2012 atd
-rw-r-----. 1 root root 647 Jun 22 2012 auditd
-rw-r--r--. 1 root root 398 Jun 27 2011 authconfig
-rw-r--r--. 1 root root 4035 Nov 9 2012 autofs
drwxr-xr-x. 2 root root 4096 Jun 27 2011 cbq
-rw-r--r-- 1 root root 219 Apr 25 21:06 clock
drwxr-xr-x. 2 root root 4096 Sep 17 2012 console
-rw-r--r--. 1 root root 2651 Nov 11 2010 cpuspeed
-rw-r--r--. 1 root root 110 Jul 19 2011 crond
-rw-r--r--. 1 root root 17 Jun 27 2011 firstboot
-rw-r--r--. 1 root root 25 Jun 27 2011 grub
-rw-r--r--. 1 root root 47 Jun 27 2011 i18n
-rw-r--r--. 1 root root 1154 Sep 17 2012 init
-rw-------. 1 root root 1753 Feb 25 2012 ip6tables-config
-rw-------. 1 root root 481 Jun 27 2011 ip6tables.old
-rw-------. 1 root root 1740 Feb 25 2012 iptables-config
-rw-------. 1 root root 476 Jun 27 2011 iptables.old
-rw-r--r--. 1 root root 647 Aug 2 2012 irqbalance
-rw-r--r--. 1 root root 1212 Dec 10 14:53 kdump
-rw-r--r--. 1 root root 180 Jun 27 2011 kernel
-rw-r--r--. 1 root root 63 Jun 27 2011 keyboard
drwxr-xr-x. 2 root root 4096 Sep 17 2012 modules
-rw-r--r--. 1 root root 634 Sep 17 2012 netconsole
-rw-r--r-- 1 root root 73 Apr 15 14:53 network
drwxr-xr-x. 2 root root 4096 Apr 15 14:53 networking
drwxr-xr-x. 2 root root 4096 Apr 15 14:53 network-scripts
-rw-r--r--. 1 root root 1744 Jun 22 2012 nfs
-rw-r--r--. 1 root root 712 Nov 13 2012 nspluginwrapper
-rw-r--r--. 1 root root 85 May 20 2009 ntpd
-rw-r--r--. 1 root root 119 May 20 2009 ntpdate
-rw-r--r--. 1 root root 1459 Nov 23 2004 prelink
-rw-r--r--. 1 root root 178 Dec 6 2010 quota_nld
-rw-r--r--. 1 root root 2440 Apr 26 2012 raid-check
-rw-r--r--. 1 root root 551 Aug 23 2010 readahead
-rw-r--r--. 1 root root 659 Sep 17 2012 readonly-root
-rw-r-----. 1 root root 41 Dec 17 2011 rngd
-rw-r--r--. 1 root root 200 May 17 2012 rsyslog
-rw-r--r--. 1 root root 111 Jun 22 2012 samba
-rw-r--r--. 1 root root 136 Jun 22 2012 sandbox
-rw-r--r--. 1 root root 553 Nov 20 2012 saslauthd
-rw-r--r--. 1 root root 125 Jun 22 2012 smartmontools
-rw-r--r--. 1 root root 85 Jul 23 2012 snmpd
-rw-r--r--. 1 root root 76 Jul 23 2012 snmptrapd
-rwxrwxrwx 1 root root 301 Jun 3 19:01 spreadd
-rw-r-----. 1 root root 438 Nov 9 2012 sshd
-rw-r--r--. 1 root root 428 Jun 22 2012 sysstat
-rw-r--r--. 1 root root 6253 Jun 22 2012 sysstat.ioconf
-rw-------. 1 root root 74 Mar 18 13:10 system-config-firewall
-rw-------. 1 root root 73 Jun 27 2011 system-config-firewall.old
-rw-r--r--. 1 root root 304 Jul 20 2011 system-config-users
-rw-r--r--. 1 root root 183 Jul 3 2012 udev
-rw-r--r--. 1 root root 644 Feb 4 12:50 wpa_supplicant
which gives rise to issues when after a Vertica install, an attempt is made to create a database.
The issue often manifests itself as a "spreadd" problem, like the following:
*** Creating database: bg ***
127.0.0.1 OK [vertica-ce][(6, 0, 1)][000][x86_64]
Creating database bg
Spread does not seem to be running on 127.0.0.1. The database will not be started on this host.
The following host(s) are not available: 127.0.0.1.
You should get them running first. Operation can not be completed.
adminTools Last Chance Error Handler running...
raised error:
error message: list index out of range
trace file: /opt/vertica/log/adminTools-dbadmin.errors
REPORT THIS INFORMATION TO TECHNICAL SUPPORT
AND INCLUDE CONTENTS OF THE TRACE FILE IN YOUR REPORT
These type errors will occur, even though "spreadd" is really running.
The fix is to ensure that the permission bits on certain files in /etc/sysconfig are set to 644 - namely /etc/sysconfig/init and /etc/sysconfig/network.
If they are not, then do:
# sudo chmod 644 init
# sudo chmod 644 network
Once done, creating a database within "/opt/vertica/bin/admintools" should now work.
Generally, your /etc/sysconfig directory should look like the following (check - permission bits settings):
[dbadmin@rarcher1 sysconfig]$ ls -l
total 212
-rw-r--r--. 1 root root 403 Jan 30 2012 atd
-rw-r-----. 1 root root 647 Jun 22 2012 auditd
-rw-r--r--. 1 root root 398 Jun 27 2011 authconfig
-rw-r--r--. 1 root root 4035 Nov 9 2012 autofs
drwxr-xr-x. 2 root root 4096 Jun 27 2011 cbq
-rw-r--r-- 1 root root 219 Apr 25 21:06 clock
drwxr-xr-x. 2 root root 4096 Sep 17 2012 console
-rw-r--r--. 1 root root 2651 Nov 11 2010 cpuspeed
-rw-r--r--. 1 root root 110 Jul 19 2011 crond
-rw-r--r--. 1 root root 17 Jun 27 2011 firstboot
-rw-r--r--. 1 root root 25 Jun 27 2011 grub
-rw-r--r--. 1 root root 47 Jun 27 2011 i18n
-rw-r--r--. 1 root root 1154 Sep 17 2012 init
-rw-------. 1 root root 1753 Feb 25 2012 ip6tables-config
-rw-------. 1 root root 481 Jun 27 2011 ip6tables.old
-rw-------. 1 root root 1740 Feb 25 2012 iptables-config
-rw-------. 1 root root 476 Jun 27 2011 iptables.old
-rw-r--r--. 1 root root 647 Aug 2 2012 irqbalance
-rw-r--r--. 1 root root 1212 Dec 10 14:53 kdump
-rw-r--r--. 1 root root 180 Jun 27 2011 kernel
-rw-r--r--. 1 root root 63 Jun 27 2011 keyboard
drwxr-xr-x. 2 root root 4096 Sep 17 2012 modules
-rw-r--r--. 1 root root 634 Sep 17 2012 netconsole
-rw-r--r-- 1 root root 73 Apr 15 14:53 network
drwxr-xr-x. 2 root root 4096 Apr 15 14:53 networking
drwxr-xr-x. 2 root root 4096 Apr 15 14:53 network-scripts
-rw-r--r--. 1 root root 1744 Jun 22 2012 nfs
-rw-r--r--. 1 root root 712 Nov 13 2012 nspluginwrapper
-rw-r--r--. 1 root root 85 May 20 2009 ntpd
-rw-r--r--. 1 root root 119 May 20 2009 ntpdate
-rw-r--r--. 1 root root 1459 Nov 23 2004 prelink
-rw-r--r--. 1 root root 178 Dec 6 2010 quota_nld
-rw-r--r--. 1 root root 2440 Apr 26 2012 raid-check
-rw-r--r--. 1 root root 551 Aug 23 2010 readahead
-rw-r--r--. 1 root root 659 Sep 17 2012 readonly-root
-rw-r-----. 1 root root 41 Dec 17 2011 rngd
-rw-r--r--. 1 root root 200 May 17 2012 rsyslog
-rw-r--r--. 1 root root 111 Jun 22 2012 samba
-rw-r--r--. 1 root root 136 Jun 22 2012 sandbox
-rw-r--r--. 1 root root 553 Nov 20 2012 saslauthd
-rw-r--r--. 1 root root 125 Jun 22 2012 smartmontools
-rw-r--r--. 1 root root 85 Jul 23 2012 snmpd
-rw-r--r--. 1 root root 76 Jul 23 2012 snmptrapd
-rwxrwxrwx 1 root root 301 Jun 3 19:01 spreadd
-rw-r-----. 1 root root 438 Nov 9 2012 sshd
-rw-r--r--. 1 root root 428 Jun 22 2012 sysstat
-rw-r--r--. 1 root root 6253 Jun 22 2012 sysstat.ioconf
-rw-------. 1 root root 74 Mar 18 13:10 system-config-firewall
-rw-------. 1 root root 73 Jun 27 2011 system-config-firewall.old
-rw-r--r--. 1 root root 304 Jul 20 2011 system-config-users
-rw-r--r--. 1 root root 183 Jul 3 2012 udev
-rw-r--r--. 1 root root 644 Feb 4 12:50 wpa_supplicant
0