Uploaded image for project: 'eXo Platform'
  1. eXo Platform
  2. PLF-7078

Data initiliazation issues at startup with MySQL 5.7.14+

    Details

    • Similar issues:
      Show 10 results 
    • BV:
      90
    • Support Status:
      New

      Description

      There are data initialisation failures at startup with MySQL 5.7.14+ which prevent PLF from starting successfully :

      2017-01-31 15:02:02,230 | INFO  | db/changelog/social-rdbms.db.changelog-1.0.0.xml: db/changelog/social-rdbms.db.changelog-1.0.0.xml::1.0.0-23::social: [MySQL] Using last startWith statement (1) as table option. [liquibase<localhost-startStop-6>] 
      2017-01-31 15:02:02,237 | ERROR | db/changelog/social-rdbms.db.changelog-1.0.0.xml: db/changelog/social-rdbms.db.changelog-1.0.0.xml::1.0.0-23::social: Change Set db/changelog/social-rdbms.db.changelog-1.0.0.xml::1.0.0-23::social failed.  Error: Invalid default value for 'CREATED_DATE' [Failed SQL: CREATE TABLE plf.SOC_SPACES (SPACE_ID BIGINT AUTO_INCREMENT NOT NULL, PRETTY_NAME NVARCHAR(200) NOT NULL, DISPLAY_NAME NVARCHAR(200) NOT NULL, REGISTRATION TINYINT NOT NULL, DESCRIPTION NVARCHAR(2000) NULL, AVATAR_LAST_UPDATED timestamp NULL, VISIBILITY TINYINT NOT NULL, PRIORITY TINYINT NULL, GROUP_ID NVARCHAR(200) NOT NULL, URL NVARCHAR(500) NULL, CREATED_DATE timestamp NOT NULL, CONSTRAINT PK_SOC_SPACES PRIMARY KEY (SPACE_ID), CONSTRAINT UK_SOC_SPACE_PRETTY_NAME UNIQUE (PRETTY_NAME)) AUTO_INCREMENT=1 ENGINE=INNODB CHARSET=UTF8 COLLATE utf8_general_ci] [liquibase<localhost-startStop-6>] 
      liquibase.exception.DatabaseException: Invalid default value for 'CREATED_DATE' [Failed SQL: CREATE TABLE plf.SOC_SPACES (SPACE_ID BIGINT AUTO_INCREMENT NOT NULL, PRETTY_NAME NVARCHAR(200) NOT NULL, DISPLAY_NAME NVARCHAR(200) NOT NULL, REGISTRATION TINYINT NOT NULL, DESCRIPTION NVARCHAR(2000) NULL, AVATAR_LAST_UPDATED timestamp NULL, VISIBILITY TINYINT NOT NULL, PRIORITY TINYINT NULL, GROUP_ID NVARCHAR(200) NOT NULL, URL NVARCHAR(500) NULL, CREATED_DATE timestamp NOT NULL, CONSTRAINT PK_SOC_SPACES PRIMARY KEY (SPACE_ID), CONSTRAINT UK_SOC_SPACE_PRETTY_NAME UNIQUE (PRETTY_NAME)) AUTO_INCREMENT=1 ENGINE=INNODB CHARSET=UTF8 COLLATE utf8_general_ci]
      	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:554) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) [liquibase-core-3.4.2.jar:na]
      	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:212) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:192) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:188) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:181) [liquibase-core-3.4.2.jar:na]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.applyChangeLog(LiquibaseDataInitializer.java:146) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.initData(LiquibaseDataInitializer.java:124) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.initData(LiquibaseDataInitializer.java:105) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.start(LiquibaseDataInitializer.java:93) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_111]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_111]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111]
      	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111]
      	at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:98) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:157) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ConcurrentContainer.start(ConcurrentContainer.java:472) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ExoContainer.start(ExoContainer.java:255) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.RootContainer$7.run(RootContainer.java:874) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.RootContainer$7.run(RootContainer.java:868) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:311) [exo.kernel.commons-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.RootContainer.buildRootContainer(RootContainer.java:867) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.RootContainer.getInstance(RootContainer.java:950) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ExoContainerContext.getTopContainer(ExoContainerContext.java:146) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.PortalContainer.reloadConfig(PortalContainer.java:716) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.PortalContainer.<clinit>(PortalContainer.java:92) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.web.PortalContainerConfigOwner.contextInitialized(PortalContainerConfigOwner.java:40) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634) [catalina.jar:7.0.75]
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) [catalina.jar:7.0.75]
      	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1092) [catalina.jar:7.0.75]
      	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1984) [catalina.jar:7.0.75]
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_111]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_111]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_111]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_111]
      	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_111]
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'CREATED_DATE'
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111]
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111]
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111]
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111]
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.Util.getInstance(Util.java:387) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) ~[tomcat-dbcp.jar:7.0.75]
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) ~[tomcat-dbcp.jar:7.0.75]
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) ~[tomcat-dbcp.jar:7.0.75]
      	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299) ~[liquibase-core-3.4.2.jar:na]
      	... 49 common frames omitted
      

      and

      2017-01-31 15:03:05,026 | INFO  | db/changelog/wiki.db.changelog-1.0.0.xml: db/changelog/wiki.db.changelog-1.0.0.xml::1.0.0-2::wiki: [MySQL] Using last startWith statement (1) as table option. [liquibase<Catalina-startStop-1>] 
      2017-01-31 15:03:05,029 | ERROR | db/changelog/wiki.db.changelog-1.0.0.xml: db/changelog/wiki.db.changelog-1.0.0.xml::1.0.0-2::wiki: Change Set db/changelog/wiki.db.changelog-1.0.0.xml::1.0.0-2::wiki failed.  Error: Invalid default value for 'UPDATED_DATE' [Failed SQL: CREATE TABLE plf.WIKI_PAGES (PAGE_ID BIGINT AUTO_INCREMENT NOT NULL, WIKI_ID BIGINT NOT NULL, PARENT_PAGE_ID BIGINT NULL, AUTHOR NVARCHAR(200) NULL, NAME NVARCHAR(550) NOT NULL, OWNER NVARCHAR(200) NULL, CREATED_DATE timestamp NOT NULL, UPDATED_DATE timestamp NOT NULL, CONTENT LONGTEXT NULL, SYNTAX NVARCHAR(30) NULL, TITLE NVARCHAR(550) NULL, EDITION_COMMENT NVARCHAR(1000) NULL, URL NVARCHAR(500) NULL, MINOR_EDIT BIT(1) NULL, ACTIVITY_ID NVARCHAR(36) NULL, DELETED BIT(1) DEFAULT 0 NULL, CONSTRAINT PK_WIKI_PAGES_ID PRIMARY KEY (PAGE_ID)) AUTO_INCREMENT=1 ENGINE=INNODB CHARSET=UTF8 COLLATE utf8_general_ci] [liquibase<Catalina-startStop-1>] 
      liquibase.exception.DatabaseException: Invalid default value for 'UPDATED_DATE' [Failed SQL: CREATE TABLE plf.WIKI_PAGES (PAGE_ID BIGINT AUTO_INCREMENT NOT NULL, WIKI_ID BIGINT NOT NULL, PARENT_PAGE_ID BIGINT NULL, AUTHOR NVARCHAR(200) NULL, NAME NVARCHAR(550) NOT NULL, OWNER NVARCHAR(200) NULL, CREATED_DATE timestamp NOT NULL, UPDATED_DATE timestamp NOT NULL, CONTENT LONGTEXT NULL, SYNTAX NVARCHAR(30) NULL, TITLE NVARCHAR(550) NULL, EDITION_COMMENT NVARCHAR(1000) NULL, URL NVARCHAR(500) NULL, MINOR_EDIT BIT(1) NULL, ACTIVITY_ID NVARCHAR(36) NULL, DELETED BIT(1) DEFAULT 0 NULL, CONSTRAINT PK_WIKI_PAGES_ID PRIMARY KEY (PAGE_ID)) AUTO_INCREMENT=1 ENGINE=INNODB CHARSET=UTF8 COLLATE utf8_general_ci]
      	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:554) ~[liquibase-core-3.4.2.jar:na]
      	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) [liquibase-core-3.4.2.jar:na]
      	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:212) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:192) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:188) [liquibase-core-3.4.2.jar:na]
      	at liquibase.Liquibase.update(Liquibase.java:181) [liquibase-core-3.4.2.jar:na]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.applyChangeLog(LiquibaseDataInitializer.java:146) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.initData(LiquibaseDataInitializer.java:124) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.initData(LiquibaseDataInitializer.java:105) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.persistence.impl.LiquibaseDataInitializer.start(LiquibaseDataInitializer.java:93) [commons-component-common-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at sun.reflect.GeneratedMethodAccessor319.invoke(Unknown Source) ~[na:na]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111]
      	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111]
      	at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:98) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:157) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ConcurrentContainer.start(ConcurrentContainer.java:472) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.AbstractContainer.start(AbstractContainer.java:67) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ExoContainer.start(ExoContainer.java:282) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.PortalContainer.start(PortalContainer.java:638) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ExoContainer.start(ExoContainer.java:255) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.PortalContainer.start(PortalContainer.java:645) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.ExoContainer.start(ExoContainer.java:255) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:774) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:356) [exo.kernel.container-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:52) [plf-tomcat-pc-creator-listener-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.platform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:50) [plf-tomcat-pc-creator-listener-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:291) [exo.kernel.commons-2.7.x-SNAPSHOT.jar:2.7.x-SNAPSHOT]
      	at org.exoplatform.platform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:50) [plf-tomcat-pc-creator-listener-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.exoplatform.platform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:39) [plf-tomcat-pc-creator-listener-4.5.x-SNAPSHOT.jar:4.5.x-SNAPSHOT]
      	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) [catalina.jar:7.0.75]
      	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90) [catalina.jar:7.0.75]
      	at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:388) [catalina.jar:7.0.75]
      	at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:333) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1136) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:819) [catalina.jar:7.0.75]
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1571) [catalina.jar:7.0.75]
      	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1561) [catalina.jar:7.0.75]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_111]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_111]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_111]
      	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_111]
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'UPDATED_DATE'
      	at sun.reflect.GeneratedConstructorAccessor234.newInstance(Unknown Source) ~[na:na]
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111]
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111]
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.Util.getInstance(Util.java:387) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) ~[mysql-connector-java-5.1.39.jar:5.1.39]
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) ~[tomcat-dbcp.jar:7.0.75]
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) ~[tomcat-dbcp.jar:7.0.75]
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) ~[tomcat-dbcp.jar:7.0.75]
      	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299) ~[liquibase-core-3.4.2.jar:na]
      	... 49 common frames omitted
      

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            aymen aymen Boughzela (Inactive) added a comment - - edited

            same issue : https://jira.exoplatform.org/browse/SOC-5452

            As workaround change the sql mode
            SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

            Show
            aymen aymen Boughzela (Inactive) added a comment - - edited same issue : https://jira.exoplatform.org/browse/SOC-5452 As workaround change the sql mode SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
            Hide
            thomas_delhomenie Thomas Delhoménie added a comment -

            Right. I will close SOC-5452 as duplicated since social-rdbms code is now integrated in PLF. We will continue the resolution here.

            As workaround change the sql mode
            SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

            Yep. We now need a real fix for that

            Show
            thomas_delhomenie Thomas Delhoménie added a comment - Right. I will close SOC-5452 as duplicated since social-rdbms code is now integrated in PLF. We will continue the resolution here. As workaround change the sql mode SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; Yep. We now need a real fix for that
            Hide
            boubaker Boubaker KHANFIR added a comment -

            The PR seems ok, but I have just a question (see PR).

            Show
            boubaker Boubaker KHANFIR added a comment - The PR seems ok, but I have just a question (see PR).
            Hide
            thomas_delhomenie Thomas Delhoménie added a comment -

            Tuyen The Nguyen The build of the Social PR fails, can you have a look please ? Also rebase your PRs on develop to make sure everything is ok.

            Show
            thomas_delhomenie Thomas Delhoménie added a comment - Tuyen The Nguyen The build of the Social PR fails, can you have a look please ? Also rebase your PRs on develop to make sure everything is ok.
            Hide
            tuyennt Tuyen The Nguyen added a comment -

            The PRs are updated and build pass now.

            Show
            tuyennt Tuyen The Nguyen added a comment - The PRs are updated and build pass now.
            Hide
            boubaker Boubaker KHANFIR added a comment -

            ok for me

            Show
            boubaker Boubaker KHANFIR added a comment - ok for me

              People

              • Assignee:
                tuyennt Tuyen The Nguyen
                Reporter:
                thomas_delhomenie Thomas Delhoménie
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response:

                  Development