gistfile1.txt

[ERROR] 2018-01-03 11:45:13,515 [http-nio-8080-exec-4] [rest.RestScriptsController] | Error executing REST script at /scripts/rest/api/1/site/write-configuration.post.groovy 
org.craftercms.engine.exception.ScriptException: 
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
### The error may involve org.craftercms.studio.api.v1.dal.GitLogMapper.insertGitLog-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO gitlog (site_id, commit_id, processed)         VALUES (?, ?, ?)
### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
; SQL []; (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
    at org.craftercms.engine.scripting.impl.GroovyScript.execute(GroovyScript.java:61)
    at org.craftercms.engine.controller.rest.RestScriptsController.executeScript(RestScriptsController.java:165)
    at org.craftercms.engine.controller.rest.RestScriptsController.handleRequestInternal(RestScriptsController.java:99)
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:174)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:124)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:122)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.craftercms.studio.impl.v1.web.security.access.StudioAuthenticationTokenProcessingFilter.doFilter(StudioAuthenticationTokenProcessingFilter.java:76)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.craftercms.engine.servlet.filter.SiteContextResolvingFilter.doFilter(SiteContextResolvingFilter.java:46)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.craftercms.engine.servlet.filter.ExceptionHandlingFilter.doFilter(ExceptionHandlingFilter.java:56)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.craftercms.commons.http.RequestContextBindingFilter.doFilter(RequestContextBindingFilter.java:79)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.craftercms.studio.impl.v1.web.filter.MultiReadHttpServletRequestWrapperFilter.doFilter(MultiReadHttpServletRequestWrapperFilter.java:34)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.dao.DuplicateKeyException: 
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
### The error may involve org.craftercms.studio.api.v1.dal.GitLogMapper.insertGitLog-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO gitlog (site_id, commit_id, processed)         VALUES (?, ?, ?)
### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
; SQL []; (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
    at com.sun.proxy.$Proxy72.insert(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:57)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy75.insertGitLog(Unknown Source)
    at org.craftercms.studio.impl.v1.repository.git.GitContentRepository.insertGitLog(GitContentRepository.java:1389)
    at org.craftercms.studio.impl.v1.service.site.SiteServiceImpl.writeConfiguration(SiteServiceImpl.java:142)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    at com.sun.proxy.$Proxy92.writeConfiguration(Unknown Source)
    at org.craftercms.studio.api.v1.service.site.SiteService$writeConfiguration$6.call(Unknown Source)
    at scripts.api.impl.site.SpringSiteServices.writeConfiguration(SpringSiteServices.groovy:44)
    at scripts.api.impl.site.SpringSiteServices$writeConfiguration$6.call(Unknown Source)
    at scripts.api.SiteServices.writeConfiguration(SiteServices.groovy:47)
    at scripts.api.SiteServices$writeConfiguration$8.call(Unknown Source)
    at write-configuration_post.run(write-configuration.post.groovy:10)
    at groovy.util.GroovyScriptEngine.run(GroovyScriptEngine.java:605)
    at org.craftercms.engine.scripting.impl.GroovyScript.execute(GroovyScript.java:55)
    ... 85 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn:12) Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
    at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:133)
    at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
    at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
    at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)
    at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411)
    at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:361)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
    at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
    ... 113 more
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Duplicate entry 'testsiteskjxc-3182e6d710d2b78ea5a52ab6fb92143ec97886bf' for key 'uq_siteid_commitid'
Query is: INSERT INTO gitlog (site_id, commit_id, processed)
        VALUES (?, ?, ?), parameters ['testsiteskjxc','3182e6d710d2b78ea5a52ab6fb92143ec97886bf',1]
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1002)
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:588)
    at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:399)
    ... 126 more
[INFO] 2018-01-03 11:45:49,622 [http-nio-8080-exec-10] [security.SecurityServiceImpl] | User admin logged in from IP: 127.0.0.1 
[INFO] 2018-01-03 11:45:50,954 [http-nio-8080-exec-5] [search.SearchServiceImpl] | Deleted search index for site:testsiteskjxc. HTTP Status Code: 204 
[INFO] 2018-01-03 11:45:57,464 [http-nio-8080-exec-1] [security.SecurityServiceImpl] | User admin logged in from IP: 127.0.0.1 
[INFO] 2018-01-03 11:45:59,458 [http-nio-8080-exec-9] [search.SearchServiceImpl] | Creating search index for site:testsitejvkge 
[INFO] 2018-01-03 11:46:13,135 [http-nio-8080-exec-5] [security.SecurityServiceImpl] | User admin logged in from IP: 127.0.0.1 
[INFO] 2018-01-03 11:46:14,507 [http-nio-8080-exec-2] [search.SearchServiceImpl] | Deleted search index for site:testsitejvkge. HTTP Status Code: 204 
[INFO] 2018-01-03 11:46:21,378 [http-nio-8080-exec-5] [security.SecurityServiceImpl] | User admin logged in from IP: 127.0.0.1 
[INFO] 2018-01-03 11:46:23,361 [http-nio-8080-exec-6] [search.SearchServiceImpl] | Creating search index for site:testsitemqsgv 
[INFO] 2018-01-03 11:46:35,847 [http-nio-8080-exec-8] [security.SecurityServiceImpl] | User admin logged in from IP: 127.0.0.1