Hi guys,
When installing Vertica as part of the output I see the message:
NTP service not synchronized on the hosts: ['ZZZ.ZZZ.ZZZ.ZZ1', 'ZZZ.ZZZ.ZZZ.ZZ2', 'ZZZ.ZZZ.ZZZ.ZZ3']
Check your NTP configuration for valid NTP servers.
Vertica recommends that you keep the system clock synchronized using
How can I fix this?
NTP service not synchronized on the hosts
Moderator: NorbertKrupa
Re: NTP service not synchronized on the hosts
See below.
Hope this helps.Verify That NTP daemon is Running
The network time protocol (NTP) daemon needs to be running on all of the hosts in the cluster to ensure their clocks are synchronized. The spread daemon relies on all of the nodes in the having their clocks synchronized for timing purposes. If your nodes do not have NTP running, the installation can fail with a spread configuration error as well as other potential errors.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Note: Different Linux distributions refer to the NTP daemon in different ways. For example, SUSE and Debian refer to it as ntp, while CentOS and Red Hat refer to it as ntpd. If the following commands produce an error, try using ntp in place of ntpd.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
To check if your hosts are configured to run the NTP daemon on startup, run the following command:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------Code: Select all
$ chkconfig --list ntpd
Note: Debian does not install chkconfig by default, but does offer it as an optional package. See the Debian documentation for information on how to obtain and install packages.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
If chkconfig command produces an error similar to ntpd: unknown service, check to ensure your Linux distribution does not refer to the NTP daemon as ntp rather than ntpd. If it does not, you need to install the NTP daemon package before you can configure it. Consult your Linux documentation for instructions on how to locate and install packages.
If the NTP daemon is installed, output should resemble the following:
ntp 0:off 1:off 2:on 3:on 4:off 5:on 6:off
The output indicates the runlevels where the daemon runs. Verify that the current runlevel of the system (usually 3 or 5) has the NTP daemon set to on. If you do not know the current runlevel, you can find it using the runlevel command:
If the current runlevel does not have the NTP daemon enabled, you can enable it by running the command:Code: Select all
$ runlevel N 3
This configures the NTP daemon to run in the current runlevel. You then need to either reboot the host, or manually start the NTP daemon before continuing the installation process. You can start the daemon manually using the command:Code: Select all
$ chkconfig ntpd on
Code: Select all
$ /etc/init.d/ntpd start
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)
DBA Specialist (Vertica/Oracle)
Re: NTP service not synchronized on the hosts
Thanks, BoMBaY!
But if I run the chkconfig on each of my node hosts, it seems that the ntpd service is on:
But if I run the chkconfig on each of my node hosts, it seems that the ntpd service is on:
Code: Select all
[root@ ~]# chkconfig --list ntpd
ntpd 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@ ~]# runlevel
N 5
Re: NTP service not synchronized on the hosts
Can you please issue the following command on all nodes in the cluster to verify that the Network Time Protocol Daemon (NTPD) is operating correctly and post the result.
Code: Select all
/usr/sbin/ntpq -c rv | grep stratum
Itipong Chewinpipat (Bay)
DBA Specialist (Vertica/Oracle)
DBA Specialist (Vertica/Oracle)