Spread issue when creating database on CentOS - issue/workaround

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 networ
k


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):
 
[[email protected] 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file