Active Objects - org.postgresql.util.PSQLException: ERROR: canceling statement due to user request

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: None
    • Component/s: None
    • 1
    • Severity 2 - Major
    • 0

      Issue Summary

      There was a SQL exception thrown by the Active Objects library. It affects repository indexing wherein some data is not included to the index, so the customer gets incorrect statistics.

      Environment

      Database

      • name:PostgreSQL
      • version:9.3.17
      • minor version:3
      • major version:9
        Driver
      • PostgreSQL JDBC Driver version 42.1.4

      Steps to Reproduce

      Actual Results

      The below exception is thrown:

      2019-02-02 23:09:02,917 INFO [AtlassianEvent::thread-3] fc6964d83a8a446f @8ISL7Nx1388x3169146x3 fn8c35 10.69.9.64 SSH - git-receive-pack '/scps/genesis_ocius.git' a.l.c.s.b.g.i.c.GraphsIndexQueue Ticket #10935 (type=REF_CHANGE) was scheduled for indexation (SCPS/genesis_ocius[1764])2019-02-02 23:09:02,920 INFO [awesome-graphs-indexer:thread-1] a.l.c.s.b.g.i.c.DefaultTicketProcessor Ticket #10935 (status=PENDING) has been started for indexation2019-02-02 23:09:03,300 ERROR [awesome-graphs-indexer:thread-1] a.l.c.s.b.g.i.c.DefaultTicketProcessor Unable to index ticket #10935com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:Database: - name:PostgreSQL - version:9.3.17 - minor version:3 - major version:9Driver: - name:PostgreSQL JDBC Driver - version:42.1.4org.postgresql.util.PSQLException: ERROR: canceling statement due to user request at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:142) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:296) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at com.stiltsoft.bitbucket.graphs.idx.commits.ao.CommitsDao.fetchCommits(CommitsDao.java:51) at com.stiltsoft.bitbucket.graphs.idx.commits.GraphsService.lambda$moveCommitsTo$17(GraphsService.java:138) at java.util.HashMap$Values.forEach(HashMap.java:981) at com.stiltsoft.bitbucket.graphs.idx.commits.GraphsService.moveCommitsTo(GraphsService.java:131) at com.stiltsoft.bitbucket.graphs.idx.commits.GraphsIndexingService.lambda$index$1(GraphsIndexingService.java:54) at java.util.ArrayList.forEach(ArrayList.java:1257) at com.stiltsoft.bitbucket.graphs.idx.commits.GraphsIndexingService.index(GraphsIndexingService.java:54) at com.stiltsoft.bitbucket.graphs.idx.commits.DefaultTicketProcessor.process(DefaultTicketProcessor.java:51) at com.stiltsoft.bitbucket.graphs.idx.commits.GraphsIndexingWorker.processTicket(GraphsIndexingWorker.java:68) at java.util.Optional.map(Optional.java:215) at com.stiltsoft.bitbucket.graphs.idx.commits.GraphsIndexingWorker.lambda$new$2(GraphsIndexingWorker.java:96) at com.stiltsoft.bitbucket.graphs.idx.commits.WorkerExecutor.lambda$null$0(WorkerExecutor.java:52) at com.atlassian.stash.internal.user.DefaultEscalatedSecurityContext.call(DefaultEscalatedSecurityContext.java:58) at com.stiltsoft.bitbucket.graphs.idx.commits.WorkerExecutor.lambda$escalated$1(WorkerExecutor.java:51) at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.lang.Thread.run(Thread.java:748) ... 16 frames trimmedCaused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at net.java.ao.EntityManager.find(EntityManager.java:671) at net.java.ao.EntityManager.find(EntityManager.java:621) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:140) ... 28 common frames omitted
      

      Notes

      The problem description:
      https://stackoverflow.com/a/14158622
      https://github.com/pgjdbc/pgjdbc/issues/412

      Workaround

      Currently, there is no known workaround for this behavior. A workaround will be added here when available.

            Assignee:
            Unassigned
            Reporter:
            Pavel Lukyanenko
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: