topic Activiti 1.4.1 mysql bug in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219829#M172959 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Activiti 1.4.1 bugs if I try to connect it with a mysql database.</SPAN><BR /><SPAN>I retried with 1.2.1 (this works)</SPAN><BR /><BR /><SPAN>Stracktrace:</SPAN><BR /><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />INFO 3/1/16 12:40 PM: liquibase: classpath:META-INF/liquibase/db-changelog-onpremise.xml: classpath:META-INF/liquibase/db-changelog-onpremise.xml::1::tijsrademakers: Table hibernate_sequences created<BR />SEVERE 3/1/16 12:40 PM: liquibase: classpath:META-INF/liquibase/db-changelog-onpremise.xml: classpath:META-INF/liquibase/db-changelog-onpremise.xml::1::tijsrademakers: Change Set classpath:META-INF/liquibase/db-<BR />changelog-onpremise.xml::1::tijsrademakers failed.&nbsp; Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NULL, externa<BR />l_id VARCHAR(2000) NULL, last_sync_timestamp timestamp(6) NULL,' at line 1 [Failed SQL: CREATE TABLE `activiti-app`.USERS (id BIGINT NOT NULL, pass_word VARCHAR(100) NULL, first_name VARCHAR(50) NULL, last_name <BR />VARCHAR(50) NULL, email VARCHAR(100) NULL, company VARCHAR(100) NULL, created datetime NULL, status SMALLINT NULL, account_type SMALLINT DEFAULT 1 NULL, tenant_id BIGINT NULL, manager_user_id BIGINT NULL, pictur<BR />e_image_id BIGINT NULL, last_update timestamp(6) NULL, external_id VARCHAR(2000) NULL, last_sync_timestamp timestamp(6) NULL, last_sync_timestamp_epoch BIGINT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]<BR />liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NULL, external_id VARCHAR(2000) N<BR />ULL, last_sync_timestamp timestamp(6) NULL,' at line 1 [Failed SQL: CREATE TABLE `activiti-app`.USERS (id BIGINT NOT NULL, pass_word VARCHAR(100) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, em<BR />ail VARCHAR(100) NULL, company VARCHAR(100) NULL, created datetime NULL, status SMALLINT NULL, account_type SMALLINT DEFAULT 1 NULL, tenant_id BIGINT NULL, manager_user_id BIGINT NULL, picture_image_id BIGINT NU<BR />LL, last_update timestamp(6) NULL, external_id VARCHAR(2000) NULL, last_sync_timestamp timestamp(6) NULL, last_sync_timestamp_epoch BIGINT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:210)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:190)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:434)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:391)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.activiti.servlet.WebConfigurer.contextInitialized(WebConfigurer.java:85)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4738)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5181)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1798)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.FutureTask.run(FutureTask.java:266)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:745)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 01 Mar 2016 12:05:14 GMT robinho 2016-03-01T12:05:14Z Activiti 1.4.1 mysql bug https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219829#M172959 HiActiviti 1.4.1 bugs if I try to connect it with a mysql database.I retried with 1.2.1 (this works)Stracktrace:INFO 3/1/16 12:40 PM: liquibase: classpath:META-INF/liquibase/db-changelog-onpremise.xml: classpath:META-INF/liquibase/db-changelog-onpremise.xml::1::tijsrademakers: Table hibernate_sequen Tue, 01 Mar 2016 12:05:14 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219829#M172959 robinho 2016-03-01T12:05:14Z Re: Activiti 1.4.1 mysql bug https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219830#M172960 <HTML><HEAD></HEAD><BODY><SPAN>Which mySQL version? We all use MySQL in development, so this sounds very odd that it happens with MySQL.</SPAN></BODY></HTML> Tue, 01 Mar 2016 21:20:22 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219830#M172960 jbarrez 2016-03-01T21:20:22Z Re: Activiti 1.4.1 mysql bug https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219831#M172961 <HTML><HEAD></HEAD><BODY><SPAN>mysql&nbsp; Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (x86_64)</SPAN><BR /><SPAN>I removed this mysql version.</SPAN><BR /><BR /><SPAN> I installed mySql 5.6.28</SPAN><BR /><SPAN>Now it works!</SPAN><BR /><BR /><SPAN>Thanks anyway I should have upgraded mysql earlier</SPAN></BODY></HTML> Wed, 02 Mar 2016 10:19:46 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219831#M172961 robinho 2016-03-02T10:19:46Z Re: Activiti 1.4.1 mysql bug https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219832#M172962 <HTML><HEAD></HEAD><BODY><SPAN>Ah yes, it should be 5.6+. The reason is that 5.5 has low precision when it comes to storing timestamps (which is quite important for audit logs for example).</SPAN></BODY></HTML> Mon, 07 Mar 2016 09:01:23 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-1-4-1-mysql-bug/m-p/219832#M172962 jbarrez 2016-03-07T09:01:23Z