org.postgresql.util.PSQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • nutz 1.4.2 postgresql 的问题
    via GitHub by csg0328
    ,
  • GitHub comment 28#95938163
    via GitHub by lksv
    ,
  • I'm experiencing corruption as discussed in this thread: http://forums.jfrog.org/Metadata-file-and-artifact-errors-during-backup-td7578253.html. That's definitely a problem, but I don't consider that part of this issue (only background). However, I'm now seeing problems publishing new, internal artifacts via Maven. Maven doesn't see any errors, however, so this is resulting in data loss. Looking at the log file, I think Artifactory may be interpreting this failure as a success. If everything isn't stored correctly, I should see the failure as soon as possible in the process, so the problem can be addressed immediately (ideally during the Maven upload, if possible). 2012-10-22 11:14:41,951 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar' Content-Length: 21334 2012-10-22 11:14:42,089 [http-/0.0.0.0:8080-21] [ERROR] (o.a.j.c.o.ObservationDispatcher:216) - Synchronous EventConsumer threw exception. java.lang.RuntimeException: Could not process item event. at org.artifactory.io.checksum.ChecksumPathsListener.processEvents(ChecksumPathsListener.java:162) [artifactory-jcr-storage-2.6.4.jar:na] at org.artifactory.io.checksum.ChecksumPathsListener.onEvent(ChecksumPathsListener.java:80) [artifactory-jcr-storage-2.6.4.jar:na] at org.apache.jackrabbit.core.observation.EventConsumer.consumeEvents(EventConsumer.java:248) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.observation.ObservationDispatcher.dispatchEvents(ObservationDispatcher.java:214) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.observation.EventStateCollection.dispatch(EventStateCollection.java:475) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:790) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.XAItemStateManager.commit(XAItemStateManager.java:181) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:215) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:327) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:95) [se-jcr-0.9.jar:na] at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) [se-jcr-0.9.jar:na] at org.artifactory.jcr.JcrTransactionManager.doCommit(JcrTransactionManager.java:76) [artifactory-jcr-storage-2.6.4.jar:na] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121) [artifactory-jcr-storage-2.6.4.jar:na] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49) [artifactory-jcr-storage-2.6.4.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy51.uploadWithinTransaction(Unknown Source) [na:na] at org.artifactory.engine.UploadServiceImpl.adjustResponseAndUpload(UploadServiceImpl.java:222) [artifactory-core-2.6.4.jar:na] at org.artifactory.engine.UploadServiceImpl.validateRequestAndUpload(UploadServiceImpl.java:177) [artifactory-core-2.6.4.jar:na] at org.artifactory.engine.UploadServiceImpl.upload(UploadServiceImpl.java:138) [artifactory-core-2.6.4.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.7.0_04] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [na:1.7.0_04] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [na:1.7.0_04] at java.lang.reflect.Method.invoke(Method.java:601) [na:1.7.0_04] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy51.upload(Unknown Source) [na:na] at org.artifactory.webapp.servlet.RepoFilter.doUpload(RepoFilter.java:203) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:145) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:84) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:272) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:193) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:175) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:143) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:57) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:72) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:67) [mod_cluster-container-jbossweb-1.2.1.Final-redhat-1.jar!/:1.2.1.Final-redhat-1] at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:48) [mod_cluster-container-jbossweb-1.2.1.Final-redhat-1.jar!/:1.2.1.Final-redhat-1] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.2.Final-redhat-1.jar!/:7.1.2.Final-redhat-1] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at java.lang.Thread.run(Thread.java:722) [na:1.7.0_04] Caused by: java.lang.RuntimeException: Could not insert new checksum path (9848b8b23cc78b866a3add1d82ab48c36920b751/21334@/repositories/jackson-release-local/com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar). at org.artifactory.io.checksum.ChecksumPathsImpl.addChecksumPath(ChecksumPathsImpl.java:210) [artifactory-jcr-storage-2.6.4.jar:na] at org.artifactory.io.checksum.ChecksumPathsImpl.addChecksumPath(ChecksumPathsImpl.java:194) [artifactory-jcr-storage-2.6.4.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.7.0_04] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [na:1.7.0_04] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [na:1.7.0_04] at java.lang.reflect.Method.invoke(Method.java:601) [na:1.7.0_04] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy58.addChecksumPath(Unknown Source) [na:na] at org.artifactory.io.checksum.ChecksumPathsListener.processEvents(ChecksumPathsListener.java:128) [artifactory-jcr-storage-2.6.4.jar:na] ... 60 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ts_idx" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381) [postgresql-9.1-901.jdbc4.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:469) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:334) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:316) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:312) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:500) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:312) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.artifactory.io.checksum.ChecksumPathsImpl.addChecksumPath(ChecksumPathsImpl.java:207) [artifactory-jcr-storage-2.6.4.jar:na] ... 69 common frames omitted 2012-10-22 11:14:42,119 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0.jar' was indexed successfully. 2012-10-22 11:14:42,143 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar.sha1' Content-Length: 40 2012-10-22 11:14:42,196 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar.md5' Content-Length: 32 2012-10-22 11:14:42,241 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.pom' Content-Length: 1379 2012-10-22 11:14:42,348 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.pom.sha1' Content-Length: 40 2012-10-22 11:14:42,401 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.pom.md5' Content-Length: 32 2012-10-22 11:14:42,568 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/maven-metadata.xml' Content-Length: 349 2012-10-22 11:14:42,661 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/maven-metadata.xml.sha1' Content-Length: 40 2012-10-22 11:14:42,678 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/maven-metadata.xml.md5' Content-Length: 32 2012-10-22 11:14:42,763 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-source-release.zip' Content-Length: 21468 2012-10-22 11:14:42,833 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0-source-release.zip' was indexed successfully. 2012-10-22 11:14:42,856 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-source-release.zip.sha1' Content-Length: 40 2012-10-22 11:14:42,899 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-source-release.zip.md5' Content-Length: 32 2012-10-22 11:14:42,963 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-sources.jar' Content-Length: 19079 2012-10-22 11:14:43,033 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0-sources.jar' was indexed successfully. 2012-10-22 11:14:43,056 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-sources.jar.sha1' Content-Length: 40 2012-10-22 11:14:43,116 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-sources.jar.md5' Content-Length: 32 2012-10-22 11:14:43,173 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-javadoc.jar' Content-Length: 106862 2012-10-22 11:14:43,273 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0-javadoc.jar' was indexed successfully. 2012-10-22 11:14:43,299 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-javadoc.jar.sha1' Content-Length: 40 2012-10-22 11:14:43,343 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-javadoc.jar.md5' Content-Length: 32
    via by Rick Houser,
  • I'm experiencing corruption as discussed in this thread: http://forums.jfrog.org/Metadata-file-and-artifact-errors-during-backup-td7578253.html. That's definitely a problem, but I don't consider that part of this issue (only background). However, I'm now seeing problems publishing new, internal artifacts via Maven. Maven doesn't see any errors, however, so this is resulting in data loss. Looking at the log file, I think Artifactory may be interpreting this failure as a success. If everything isn't stored correctly, I should see the failure as soon as possible in the process, so the problem can be addressed immediately (ideally during the Maven upload, if possible). 2012-10-22 11:14:41,951 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar' Content-Length: 21334 2012-10-22 11:14:42,089 [http-/0.0.0.0:8080-21] [ERROR] (o.a.j.c.o.ObservationDispatcher:216) - Synchronous EventConsumer threw exception. java.lang.RuntimeException: Could not process item event. at org.artifactory.io.checksum.ChecksumPathsListener.processEvents(ChecksumPathsListener.java:162) [artifactory-jcr-storage-2.6.4.jar:na] at org.artifactory.io.checksum.ChecksumPathsListener.onEvent(ChecksumPathsListener.java:80) [artifactory-jcr-storage-2.6.4.jar:na] at org.apache.jackrabbit.core.observation.EventConsumer.consumeEvents(EventConsumer.java:248) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.observation.ObservationDispatcher.dispatchEvents(ObservationDispatcher.java:214) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.observation.EventStateCollection.dispatch(EventStateCollection.java:475) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:790) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.state.XAItemStateManager.commit(XAItemStateManager.java:181) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:215) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:327) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.springframework.extensions.jcr.jackrabbit.support.JackRabbitUserTransaction.commit(JackRabbitUserTransaction.java:95) [se-jcr-0.9.jar:na] at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doCommit(LocalTransactionManager.java:189) [se-jcr-0.9.jar:na] at org.artifactory.jcr.JcrTransactionManager.doCommit(JcrTransactionManager.java:76) [artifactory-jcr-storage-2.6.4.jar:na] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121) [artifactory-jcr-storage-2.6.4.jar:na] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49) [artifactory-jcr-storage-2.6.4.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy51.uploadWithinTransaction(Unknown Source) [na:na] at org.artifactory.engine.UploadServiceImpl.adjustResponseAndUpload(UploadServiceImpl.java:222) [artifactory-core-2.6.4.jar:na] at org.artifactory.engine.UploadServiceImpl.validateRequestAndUpload(UploadServiceImpl.java:177) [artifactory-core-2.6.4.jar:na] at org.artifactory.engine.UploadServiceImpl.upload(UploadServiceImpl.java:138) [artifactory-core-2.6.4.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.7.0_04] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [na:1.7.0_04] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [na:1.7.0_04] at java.lang.reflect.Method.invoke(Method.java:601) [na:1.7.0_04] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy51.upload(Unknown Source) [na:na] at org.artifactory.webapp.servlet.RepoFilter.doUpload(RepoFilter.java:203) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:145) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:84) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:272) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:193) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:175) [artifactory-web-application-2.6.4.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:143) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:57) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:72) [artifactory-web-application-2.6.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:67) [mod_cluster-container-jbossweb-1.2.1.Final-redhat-1.jar!/:1.2.1.Final-redhat-1] at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:48) [mod_cluster-container-jbossweb-1.2.1.Final-redhat-1.jar!/:1.2.1.Final-redhat-1] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.2.Final-redhat-1.jar!/:7.1.2.Final-redhat-1] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) [jbossweb-7.0.16.Final-redhat-1.jar!/:na] at java.lang.Thread.run(Thread.java:722) [na:1.7.0_04] Caused by: java.lang.RuntimeException: Could not insert new checksum path (9848b8b23cc78b866a3add1d82ab48c36920b751/21334@/repositories/jackson-release-local/com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar). at org.artifactory.io.checksum.ChecksumPathsImpl.addChecksumPath(ChecksumPathsImpl.java:210) [artifactory-jcr-storage-2.6.4.jar:na] at org.artifactory.io.checksum.ChecksumPathsImpl.addChecksumPath(ChecksumPathsImpl.java:194) [artifactory-jcr-storage-2.6.4.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.7.0_04] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [na:1.7.0_04] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [na:1.7.0_04] at java.lang.reflect.Method.invoke(Method.java:601) [na:1.7.0_04] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy58.addChecksumPath(Unknown Source) [na:na] at org.artifactory.io.checksum.ChecksumPathsListener.processEvents(ChecksumPathsListener.java:128) [artifactory-jcr-storage-2.6.4.jar:na] ... 60 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ts_idx" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [postgresql-9.1-901.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381) [postgresql-9.1-901.jdbc4.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:469) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:334) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:316) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:312) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:500) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:312) [jackrabbit-core-jfrog-2.2.8d.jar:2.2.8d] at org.artifactory.io.checksum.ChecksumPathsImpl.addChecksumPath(ChecksumPathsImpl.java:207) [artifactory-jcr-storage-2.6.4.jar:na] ... 69 common frames omitted 2012-10-22 11:14:42,119 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0.jar' was indexed successfully. 2012-10-22 11:14:42,143 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar.sha1' Content-Length: 40 2012-10-22 11:14:42,196 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.jar.md5' Content-Length: 32 2012-10-22 11:14:42,241 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.pom' Content-Length: 1379 2012-10-22 11:14:42,348 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.pom.sha1' Content-Length: 40 2012-10-22 11:14:42,401 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0.pom.md5' Content-Length: 32 2012-10-22 11:14:42,568 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/maven-metadata.xml' Content-Length: 349 2012-10-22 11:14:42,661 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/maven-metadata.xml.sha1' Content-Length: 40 2012-10-22 11:14:42,678 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/maven-metadata.xml.md5' Content-Length: 32 2012-10-22 11:14:42,763 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-source-release.zip' Content-Length: 21468 2012-10-22 11:14:42,833 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0-source-release.zip' was indexed successfully. 2012-10-22 11:14:42,856 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-source-release.zip.sha1' Content-Length: 40 2012-10-22 11:14:42,899 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-source-release.zip.md5' Content-Length: 32 2012-10-22 11:14:42,963 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-sources.jar' Content-Length: 19079 2012-10-22 11:14:43,033 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0-sources.jar' was indexed successfully. 2012-10-22 11:14:43,056 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-sources.jar.sha1' Content-Length: 40 2012-10-22 11:14:43,116 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-sources.jar.md5' Content-Length: 32 2012-10-22 11:14:43,173 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:424) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-javadoc.jar' Content-Length: 106862 2012-10-22 11:14:43,273 [art-exec-101] [INFO ] (o.a.s.a.ArchiveIndexer:102) - The content of the archive: 'appconnectorclient-1.0.0-javadoc.jar' was indexed successfully. 2012-10-22 11:14:43,299 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-javadoc.jar.sha1' Content-Length: 40 2012-10-22 11:14:43,343 [http-/0.0.0.0:8080-21] [INFO ] (o.a.e.UploadServiceImpl:285) - Deploy to 'jackson-release-local:com/jackson/appconnector/appconnectorclient/1.0.0/appconnectorclient-1.0.0-javadoc.jar.md5' Content-Length: 32
    via by Rick Houser,
  • Problem with PostgreSQL driver
    via by Jacobus,
    • org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $1 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381) at tests.com.paramatrix.pace.archival.file.TestFileArchival.main(TestFileArchival.java:63)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown UserUnknown User
    9 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    silexsilex
    6 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    90 more bugmates