The Vertica Database Forums

*** Creating database: EFDemo2 ***
10.10.100.6 OK [vertica][(6, 1, 3)][000][x86_64]
10.10.100.5 OK [vertica][(6, 1, 3)][000][x86_64]
10.10.100.4 OK [vertica][(6, 1, 3)][000][x86_64]
Checking full connectivity
Creating database EFDemo2
Spread does not seem to be running on 10.10.100.6. The database will not be started on this host.
Spread does not seem to be running on 10.10.100.4. The database will not be started on this host.
Spread does not seem to be running on 10.10.100.5. The database will not be started on this host.

The following host(s) are not available: 10.10.100.6 , 10.10.100.4 , 10.10.100.5.
You should get them running first. Operation can not be completed.


So I went and restarted spread on all nodes:
[root@vertica2 ~]# /etc/init.d/spreadd restart
Stopping spread daemon: [ OK ]

Starting spread daemon: spread (pid 1969) is running...
[ OK ]

Can someone assist with this?

I am simply attempting to create a Database for a POC

Hi!

Can you post the contents of the /opt/vertica/config/vspread.conf and /opt/vertica/log/spread_<host>.log files?

Also, what is the output of the following Linux command?

• chkconfig --list ntpd

Did you disable the Linux firewall on all hosts?

/opt/vertica/config/vspread.conf

Spread_Segment 10.10.100.255:4803 {
N010010100004 10.10.100.4 {
10.10.100.4
127.0.0.1
}
N010010100005 10.10.100.5 {
10.10.100.5
127.0.0.1
}
N010010100006 10.10.100.6 {
10.10.100.6
127.0.0.1
}
}
EventLogFile = /dev/null
EventTimeStamp = "[%a %d %b %Y %H:%M:%S]"
DaemonUser = spread
DaemonGroup = verticadba
DebugFlags = { EXIT }


There arent any /opt/vertica/log/spread_<host>.log files on any of the hosts.
[root@vertica2 ~]# cd /opt/vertica/log/
[root@vertica2 log]# ls
adminTools-dbadmin.errors agent.log
adminTools-dbadmin.log agent.pid
agent_dbadmin.err agentStdMsg.log
agent_dbadmin.log hashlib-20081119-py2.7-linux-x86_64.egg-tmp

On all three hosts, the chkconfig --list ntpd shows:

ntpd 0:off 1:off 2:on 3:on 4:on 5:on 6:off

Oh yeah firewall is off on all three hosts using:
service iptables save
service iptables off
chkconfig iptables off

Hi!

[DELETED]

Thanks, spread does not work in a subnet?

Hi!

[DELETED]