docker - dashDB local MPP deployment issue - cannot connect to database -


i facing huge problem @ deploying dashdb local cluster. after successful deployment following error comes in case of trying create single table or launch query. furthermore webserver not working in previous smp deployment.

cannot connect database "bludb" on node "20" because difference between system time on catalog node , virtual timestamp on node greater max_time_diff database manager configuration parameter.. sqlcode=-1472, sqlstate=08004, driver=4.18.60

i followed official deployment guide, followings doublechecked:

  • each physical machines' , docker containers' /etc/hosts file contains ips, qualified , simple hostnames

  • there nfs preconfigured , mounted /mnt/clusterfs on every single server

  • none of servers signed error @ phase "docker logs --follow dashdb" command

  • nodes config file located in /mnt/clusterfs directory

after starting dashdb following command:

docker exec -it dashdb start 

it looks should (see below), error can found @ /opt/ibm/dsserver/logs/dsserver.0.log.

# --- dashdb stack service status summary --- ##################################################################### redirecting /bin/systemctl status slapd.service

summary

ldaprunning: success dashdbtablesonline: success webconsole : success dashdbconnectivity : success dashdbrunning : success

# --- dashdb high availability status --- #

configuring dashdb high availability ... stopping system stopping datanode dashdb02 stopping datanode dashdb01 stopping headnode dashdb03 running sm on head node dashdb03 .. running sm on data node dashdb02 .. running sm on data node dashdb01 .. attempting activate failed nodes, if ... sm running on headnode dashdb03 (active) sm running on datanode dashdb02 (active) sm running on datanode dashdb01 (active) overall status : running

after several redeployment nothing has changed. please me in doing wrong.

many thanks, daniel

always make sure ntp service started on every single cluster node before starting docker container. otherwise take no effect on it.


Comments

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

angular - Is it possible to get native element for formControl? -

javascript - Why jQuery Select box change event is now working? -