13.11.2019 13:16:03 [main] ERROR [org.hippoecm.repository.RepositoryServlet.init():246] Error while setting up JCR repository: javax.jcr.RepositoryException: unchecked exception: java.lang.RuntimeException: Could not validate the REPOSITORY_HIPPO_LOCK table or could not correct it (perhaps alter table is not allowed by the application). Cannot start up the repository, correct the table REPOSITORY_HIPPO_LOCK manually. at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:161) ~[hippo-repository-connector-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.hippoecm.repository.RepositoryServlet.init(RepositoryServlet.java:204) [hippo-repository-servlets-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1134) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1089) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4871) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5180) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) [catalina.jar:9.0.27] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) [catalina.jar:9.0.27] at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:978) [catalina.jar:9.0.27] at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1849) [catalina.jar:9.0.27] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_222] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_222] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.27] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112) [?:1.8.0_222] at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:773) [catalina.jar:9.0.27] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427) [catalina.jar:9.0.27] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) [catalina.jar:9.0.27] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) [catalina.jar:9.0.27] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) [catalina.jar:9.0.27] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) [catalina.jar:9.0.27] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_222] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.27] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) [?:1.8.0_222] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) [catalina.jar:9.0.27] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.27] at org.apache.catalina.startup.Catalina.start(Catalina.java:633) [catalina.jar:9.0.27] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_222] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_222] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_222] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_222] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:344) [bootstrap.jar:9.0.27] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:475) [bootstrap.jar:9.0.27] Caused by: java.lang.RuntimeException: Could not validate the REPOSITORY_HIPPO_LOCK table or could not correct it (perhaps alter table is not allowed by the application). Cannot start up the repository, correct the table REPOSITORY_HIPPO_LOCK manually. at org.onehippo.repository.lock.db.MySqlDbLockManager.createTableIfNeeded(MySqlDbLockManager.java:70) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManager.(DbLockManager.java:131) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.MySqlDbLockManager.(MySqlDbLockManager.java:36) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManagerFactory.create(DbLockManagerFactory.java:69) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManagerFactory.create(DbLockManagerFactory.java:38) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.createRepositoryConfig(HippoEnterpriseRepository.java:158) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:281) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.create(HippoEnterpriseRepository.java:65) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.create(HippoEnterpriseRepository.java:55) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_222] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_222] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_222] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_222] at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:147) ~[hippo-repository-connector-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] ... 45 more Caused by: java.sql.BatchUpdateException: Duplicate key name 'REPOSITORY_HIPPO_LOCK_idx_1' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_222] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_222] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_222] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_222] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1162) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.StatementImpl.executeBatchInternal(StatementImpl.java:1048) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958) ~[mysql-connector-java-5.1.40.jar:5.1.40] at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[tomcat-dbcp.jar:9.0.27] at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[tomcat-dbcp.jar:9.0.27] at org.onehippo.repository.lock.db.MySqlDbLockManager.correctTableScheme(MySqlDbLockManager.java:92) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.MySqlDbLockManager.createTableIfNeeded(MySqlDbLockManager.java:67) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManager.(DbLockManager.java:131) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.MySqlDbLockManager.(MySqlDbLockManager.java:36) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManagerFactory.create(DbLockManagerFactory.java:69) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManagerFactory.create(DbLockManagerFactory.java:38) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.createRepositoryConfig(HippoEnterpriseRepository.java:158) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:281) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.create(HippoEnterpriseRepository.java:65) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.create(HippoEnterpriseRepository.java:55) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_222] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_222] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_222] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_222] at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:147) ~[hippo-repository-connector-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] ... 45 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'REPOSITORY_HIPPO_LOCK_idx_1' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_222] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_222] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_222] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_222] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1540) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.StatementImpl.executeBatchInternal(StatementImpl.java:1022) ~[mysql-connector-java-5.1.40.jar:5.1.40] at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958) ~[mysql-connector-java-5.1.40.jar:5.1.40] at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[tomcat-dbcp.jar:9.0.27] at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[tomcat-dbcp.jar:9.0.27] at org.onehippo.repository.lock.db.MySqlDbLockManager.correctTableScheme(MySqlDbLockManager.java:92) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.MySqlDbLockManager.createTableIfNeeded(MySqlDbLockManager.java:67) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManager.(DbLockManager.java:131) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.MySqlDbLockManager.(MySqlDbLockManager.java:36) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManagerFactory.create(DbLockManagerFactory.java:69) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.onehippo.repository.lock.db.DbLockManagerFactory.create(DbLockManagerFactory.java:38) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.createRepositoryConfig(HippoEnterpriseRepository.java:158) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:281) ~[hippo-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.create(HippoEnterpriseRepository.java:65) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at com.onehippo.repository.HippoEnterpriseRepository.create(HippoEnterpriseRepository.java:55) ~[hippo-enterprise-repository-engine-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_222] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_222] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_222] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_222] at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:147) ~[hippo-repository-connector-13.0.0-SNAPSHOT.jar:13.0.0-SNAPSHOT] ... 45 more