Re: [Unity-idm-discuss] Unity v2.1.0 fails to start-up

[Shiraz M. <a....@fz...>]

Hi,

I have dropped the existing db and created a new one (the error still persists though):

unity might be expecting a different version of mysql (?):
mysql  Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) using readline 6.3


unity-server.log
#############

2017-08-04T16:09:20,768 [main] WARN  org.springframework.context.support.ClassPathXmlApplicationContext: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverManagementImpl' defined in
URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-engine-2.1.0.jar!/pl/edu/icm/unity/engine/server/ServerManagementImpl.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creati
ng bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.Uns
atisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribu
tion-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apa
che.ibatis.exceptions.PersistenceException:
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) 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 '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8

unity-startup.log
#################

Aug 4, 2017 4:09:00 PM CEST: Starting UNITY Web Server
Exception in thread "main" org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverManagementImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-engine-2.1.0.jar!/pl/edu/icm/unity/engine/server/ServerManagementImpl.class]: Unsatis
fied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity
/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.spr
ingframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.spring
framework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) 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 '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
       at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
       at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
       at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
       at pl.edu.icm.unity.engine.server.UnityApplication.run(UnityApplication.java:60)
       at pl.edu.icm.unity.engine.server.UnityApplication.main(UnityApplication.java:69)
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed t
hrough constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bea
n with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [p
l.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) 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 '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
       at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
       at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
       ... 14 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in
URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Construc
tor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) 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 '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engine=InnoDB, character set utf8
       at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:588)
       at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
       at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
       at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.addCandidateEntry(DefaultListableBeanFactory.java:1316)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1282)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveMultipleBeans(DefaultListableBeanFactory.java:1205)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1096)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
       at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
       at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
       ... 28 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested excep
tion is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction.  Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

               )  engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(

               ID INTEGER PRIMARY KEY AUTO_INCREMENT,
               NAME VARCHAR(200),
               CONTENTS VARBINARY(60000)
        ,
               TYPE VARCHAR(100),
               LAST_UPDATE
               DATETIME(3)
         DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
               UNIQUE(NAME, TYPE)

Cheers,
Shiraz





--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)

Phone: +49 2461 61 6899
Fax:     +49 2461 61 6656


------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------