ScorpJ removed a comment on issue #446: fix mysql master_lock table schema 
wrong default value
URL: https://github.com/apache/servicecomb-pack/pull/446#issuecomment-523525189
 
 
   Still get the same error after patch fix 
f6e9498208cb061f4d01825927f883e8db0d0f2f.
   My env is alpha-server:0.4.0 and mysql-connector-java-8.0.15.jar
   
   And the issue has gone with below fix.
   CREATE TABLE IF NOT EXISTS master_lock (
     serviceName varchar(36) not NULL,
     expireTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP**(3)**,
     lockedTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP**(3)**,
     instanceId  varchar(255) not NULL,
     PRIMARY KEY (serviceName)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   
   I refered below link;
   
https://stackoverflow.com/questions/23671222/mysql-default-value-for-timestamp3

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to