-
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.
- relates to
-
DEVHELP-2267 Loading...