You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@servicecomb.apache.org by GitBox <gi...@apache.org> on 2019/08/21 16:00:44 UTC

[GitHub] [servicecomb-pack] ScorpJ commented on issue #446: fix mysql master_lock table schema wrong default value

ScorpJ commented 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 949feb68f61005304f6b373af3f6e7b5d011e63d.
   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:
users@infra.apache.org


With regards,
Apache Git Services