artifactory - 尝试删除工件时出现 PSQL 错误

Question

通过 Pro-Team 订阅，我们已经成功使用 Artifactory 一段时间了。但是，当尝试删除服务器上的任何工件（来自 UI 和 CLI）时，它现在似乎失败并出现内部错误 500。我在日志中看到的堆栈如下：

2021-05-11T12:44:21.349Z [jfrt ] [ERROR] [                ] [a.e.ShiftEventsServiceImpl:114] [tEventsServiceImpl-1] - Unexpected error
org.artifactory.storage.db.security.service.VersioningCacheException: Fail to reload cache: Failed to shift events
    at org.artifactory.storage.db.security.service.VersioningCacheImpl.get(VersioningCacheImpl.java:98)
    at org.artifactory.event.ShiftEventsServiceImpl.run(ShiftEventsServiceImpl.java:98)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.artifactory.storage.StorageException: Failed to shift events
    at org.artifactory.storage.db.event.service.EventsServiceImpl.shiftEvents(EventsServiceImpl.java:256)
    at org.artifactory.event.ShiftEventsServiceImpl.shiftEvents(ShiftEventsServiceImpl.java:145)
    at org.artifactory.event.ShiftEventsServiceImpl.lambda$new$0(ShiftEventsServiceImpl.java:83)
    at org.artifactory.storage.db.security.service.VersioningCacheImpl.get(VersioningCacheImpl.java:95)
    ... 6 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: relation "node_events_tmp" does not exist
  Position: 62
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
    at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:236)
    at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
    at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
    at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:109)
    at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:89)
    at org.artifactory.storage.db.event.dao.EventsDao.shiftAndDeleteTmpEvents(EventsDao.java:385)
    at org.artifactory.storage.db.event.dao.EventsDao$$FastClassBySpringCGLIB$$18eb8be0.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
    at org.artifactory.storage.db.event.dao.EventsDao$$EnhancerBySpringCGLIB$$f6a550a3.shiftAndDeleteTmpEvents(<generated>)
    at org.artifactory.storage.db.event.service.EventsServiceImpl.shiftEvents(EventsServiceImpl.java:254)
    ... 9 common frames omitted

我们没有进行任何更改，并且正在运行托管的 Artifactory 服务器。内部 PostgreSql 存储和节点事件似乎存在问题。

有没有人见过这个问题？此外，不知道如何在没有企业订阅的情况下联系 JFrog 支持。是否有任何支持电子邮件可用于此类问题？

先感谢您！:)

标签： artifactoryjfrog