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.servicesummary
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
Post a Comment