Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-30604

PSQLException: This connection has been closed. during sync of 26k tasks

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • prod/bigpicture/jiracloud/2020/12/16/15_10
    • None
    • None
    • 9509f8ec8bf75db85d41dc3ba88b56c90a0b2e51eba3189027f3e5dc20c72a9105b054db7c2553fc6016f534d45ca563077f4bd220d37d55188bd9848475c384
    • Space
    • BigPicture
    • JIRA cloud
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}
    • 1 week, 2 hours, 36 minutes, 53 seconds
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_21302"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_19201"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19300"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_19301"); if(cfToHide4){cfToHide4.style.display="none";} var cfToHide5 = document.getElementById("rowForcustomfield_19302"); if(cfToHide5){cfToHide5.style.display="none";} var cfToHide6 = document.getElementById("rowForcustomfield_19303"); if(cfToHide6){cfToHide6.style.display="none";} var cfToHide7 = document.getElementById("rowForcustomfield_19204"); if(cfToHide7){cfToHide7.style.display="none";} var cfToHide8 = document.getElementById("rowForcustomfield_19205"); if(cfToHide8){cfToHide8.style.display="none";}

    Description

      Sync of program  having 26k tasks fails with following exception:

      2020-12-17 10:11:22,011 [0051155] ERROR [SP-biggantt-0051155.DefaultEventBusSingleJobExecutor-4113194-t-0051155] [StructureManagerImpl] [AC:d1e88430] Token: 9509f8ec8bf75db85d41dc3ba88b56c90a0b2e51eba3189027f3e5dc20c72a9105b054db7c2553fc6016f534d45ca563077f4bd220d37d55188bd9848475c384.61778a1307ee98d2edffb15ac30614289633148d1133c758172970bcbfae94e9fcca75bd265e439fc70195536e05fa1513a5231c60100ea97c4bcc9fc219768e.f2c5e923c9a7daa65f2362ca32f9183076133f11fe9d88f61b4e634cc054f8b6ba2d1e3e555caeea8308641e18ca9675b283795c146dfad1428485fbc8f8d5d9.Thu Dec 17 10:11:22 UTC 2020, Error during sync
      java.util.concurrent.CompletionException: com.softwareplant.util.concurrent.job.JobExecutionException: jobDescription: StructureManagerImpl.sync com.softwareplant.util.rest.exceptionhandling.NDCException: com.softwareplant.ppm.scheduling.core.domain.task.BoxTaskTransactionException: org.hibernate.TransactionException: rollback failed
      	at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)
      	at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280)
      	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1606)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:652)
      	at java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:649)
      	at java.security.AccessController.doPrivileged(Native Method)
      	at java.util.concurrent.Executors$PrivilegedThreadFactory$1.run(Executors.java:649)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: com.softwareplant.util.concurrent.job.JobExecutionException: jobDescription: StructureManagerImpl.sync com.softwareplant.util.rest.exceptionhandling.NDCException: com.softwareplant.ppm.scheduling.core.domain.task.BoxTaskTransactionException: org.hibernate.TransactionException: rollback failed
      	at com.softwareplant.system.tenant.core.concurrent.job.TenantSystemEndPointJobContext.call(TenantSystemEndPointJobContext.java:72)
      	at com.softwareplant.system.core.concurrent.job.TransactionContextJobContextProxyFactory.lambda$createProxy$5df0134e$1(TransactionContextJobContextProxyFactory.java:18)
      	at com.softwareplant.util.concurrent.job.ExceptionHandlingJobContext.call(ExceptionHandlingJobContext.java:15)
      	at com.softwareplant.util.concurrent.job.SingleJobExecutorImpl.lambda$execute$0(SingleJobExecutorImpl.java:26)
      	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
      	... 7 more
      Caused by: com.softwareplant.util.rest.exceptionhandling.NDCException: com.softwareplant.ppm.scheduling.core.domain.task.BoxTaskTransactionException: org.hibernate.TransactionException: rollback failed
      	at com.softwareplant.system.manager.cloud.environment.core.multitenant.MultiTenantLoggerNDCSetter.invoke(MultiTenantLoggerNDCSetter.java:53)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.core.endpoint.interceptors.TransactionContextSystemEndPointInterceptor.invoke(TransactionContextSystemEndPointInterceptor.java:23)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.core.endpoint.interceptors.SystemStatusEndpointInterceptor.invoke(SystemStatusEndpointInterceptor.java:17)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.core.endpoint.TechnicalSystemEndPointInterceptors.run(TechnicalSystemEndPointInterceptors.java:32)
      	at com.softwareplant.system.tenant.core.MultiTenantSystem.runWithinInterceptors(MultiTenantSystem.java:69)
      	at com.softwareplant.system.core.TechnicalSystem.invoke(TechnicalSystem.java:171)
      	at com.softwareplant.system.tenant.core.MultiTenantSystem.invoke(MultiTenantSystem.java:109)
      	at com.softwareplant.system.tenant.core.concurrent.job.TenantSystemEndPointJobContext.call(TenantSystemEndPointJobContext.java:44)
      	... 11 more
      Caused by: com.softwareplant.ppm.scheduling.core.domain.task.BoxTaskTransactionException: org.hibernate.TransactionException: rollback failed
      	at com.softwareplant.ppm.scheduling.core.domain.task.BoxTaskTransaction.executeWithin(BoxTaskTransaction.java:22)
      	at com.softwareplant.ppm.scheduling.core.domain.task.AbstractScheduledResizableTaskBundle.forcedRescheduleResizePeriod(AbstractScheduledResizableTaskBundle.java:86)
      	at com.softwareplant.ppm.scheduling.core.domain.task.ScheduleSynchronizerImpl.rescheduleChangedTasksWithTemporaryMode(ScheduleSynchronizerImpl.java:87)
      	at com.softwareplant.ppm.scheduling.core.domain.task.ScheduleSynchronizerImpl.rescheduleChangedTasks(ScheduleSynchronizerImpl.java:62)
      	at com.softwareplant.ppm.wbs.core.domain.sync.SingleStructureFullSynchronizer.rescheduleChanged(SingleStructureFullSynchronizer.java:100)
      	at com.softwareplant.ppm.wbs.core.domain.sync.StructureSynchronizer.syncStructure(StructureSynchronizer.java:210)
      	at com.softwareplant.ppm.wbs.core.domain.sync.StructureSynchronizer.sync(StructureSynchronizer.java:127)
      	at com.softwareplant.ppm.structure.core.domain.sync.StructureSyncAction.sync(StructureSyncAction.java:82)
      	at com.softwareplant.ppm.structure.core.domain.sync.StructureSyncAction.perform(StructureSyncAction.java:65)
      	at com.softwareplant.ppm.structure.core.domain.sync.StructureSyncAction.perform(StructureSyncAction.java:21)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl.performActionImmediately(StructureManagerImpl.java:304)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl.lambda$performActionInternally$3(StructureManagerImpl.java:275)
      	at com.softwareplant.util.concurrent.lock.AbstractLock.execute(AbstractLock.java:114)
      	at com.softwareplant.util.concurrent.lock.MonitoredLock.lambda$execute$4(MonitoredLock.java:87)
      	at com.softwareplant.util.monitoring.DropwizardMetrics.measure(DropwizardMetrics.java:49)
      	at com.softwareplant.util.monitoring.MonitoringImpl.monitore(MonitoringImpl.java:33)
      	at com.softwareplant.util.concurrent.lock.MonitoredLock.lambda$execute$5(MonitoredLock.java:85)
      	at com.softwareplant.util.concurrent.lock.MonitoredLock.logCallableExecutionTime(MonitoredLock.java:97)
      	at com.softwareplant.util.concurrent.lock.MonitoredLock.execute(MonitoredLock.java:84)
      	at com.softwareplant.util.concurrent.lock.AbstractLock.executeWithin(AbstractLock.java:96)
      	at com.softwareplant.util.concurrent.lock.AbstractLock.executeWithin(AbstractLock.java:77)
      	at com.softwareplant.ppm.structure.core.domain.lock.StructureLock.executeWithin(StructureLock.java:59)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl.performActionInternally(StructureManagerImpl.java:275)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl.access$600(StructureManagerImpl.java:55)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl$1.lambda$call$0(StructureManagerImpl.java:189)
      	at com.softwareplant.ppm.scenario.core.ScenarioServiceImpl.runWithinLiveScenario(ScenarioServiceImpl.java:124)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl$1.call(StructureManagerImpl.java:185)
      	at com.softwareplant.ppm.structure.core.domain.StructureManagerImpl$1.call(StructureManagerImpl.java:174)
      	at com.softwareplant.system.tenant.core.concurrent.job.TenantSystemEndPointJobContext$2.call(TenantSystemEndPointJobContext.java:88)
      	at com.softwareplant.util.concurrent.job.JobContextImpl.call(JobContextImpl.java:8)
      	at com.softwareplant.ppm.scenario.core.ScenarioContextJobContextProxyFactory.lambda$createProxy$e12e3d61$1(ScenarioContextJobContextProxyFactory.java:17)
      	at com.softwareplant.system.core.concurrent.job.BusinessTransactionJobContextProxy.lambda$createProxy$4d58840c$1(BusinessTransactionJobContextProxy.java:26)
      	at com.softwareplant.system.tenant.core.concurrent.job.TenantSystemEndPointJobContext.jobContextCall(TenantSystemEndPointJobContext.java:77)
      	at com.softwareplant.system.tenant.core.concurrent.job.TenantSystemEndPointJobContext.access$100(TenantSystemEndPointJobContext.java:16)
      	at com.softwareplant.system.tenant.core.concurrent.job.TenantSystemEndPointJobContext$1.invoke(TenantSystemEndPointJobContext.java:63)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:24)
      	at com.softwareplant.ppm.scenario.core.ScenarioActionResultStorageSystemEndpointInterceptor.invoke(ScenarioActionResultStorageSystemEndpointInterceptor.java:26)
      	at com.softwareplant.ppm.scenario.core.ScenarioActionResultStorageSystemEndpointInterceptor.invoke(ScenarioActionResultStorageSystemEndpointInterceptor.java:12)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.tenant.core.endpoint.RequiredPermissionSystemEndPointInterceptor.invoke(RequiredPermissionSystemEndPointInterceptor.java:30)
      	at com.softwareplant.system.tenant.core.endpoint.RequiredPermissionSystemEndPointInterceptor.invoke(RequiredPermissionSystemEndPointInterceptor.java:12)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.manager.cloud.environment.jiracloud.core.permission.JiraCloudInsufficientPermissionsSystemEndPointInterceptor.invoke(JiraCloudInsufficientPermissionsSystemEndPointInterceptor.java:37)
      	at com.softwareplant.system.manager.cloud.environment.jiracloud.core.permission.JiraCloudInsufficientPermissionsSystemEndPointInterceptor.invoke(JiraCloudInsufficientPermissionsSystemEndPointInterceptor.java:14)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.tenant.core.endpoint.TenantActivationSystemEndpointInterceptor.invoke(TenantActivationSystemEndpointInterceptor.java:31)
      	at com.softwareplant.system.tenant.core.endpoint.TenantActivationSystemEndpointInterceptor.invoke(TenantActivationSystemEndpointInterceptor.java:14)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.tenant.core.cache.TenantCacheSystemEndPointInterceptor.invoke(TenantCacheSystemEndPointInterceptor.java:36)
      	at com.softwareplant.system.tenant.core.cache.TenantCacheSystemEndPointInterceptor.invoke(TenantCacheSystemEndPointInterceptor.java:13)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.core.endpoint.TechnicalSystemEndPointInterceptors.run(TechnicalSystemEndPointInterceptors.java:32)
      	at com.softwareplant.system.tenant.core.TenantSystem.runWithinInterceptors(TenantSystem.java:70)
      	at com.softwareplant.system.core.TechnicalSystem.invoke(TechnicalSystem.java:171)
      	at com.softwareplant.system.tenant.core.MultiTenantSystem$1.invoke(MultiTenantSystem.java:126)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:24)
      	at com.softwareplant.system.core.transaction.SystemTransactionManagerImpl.invoke(SystemTransactionManagerImpl.java:25)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.core.endpoint.interceptors.SessionContextSystemEndPointInterceptor.invoke(SessionContextSystemEndPointInterceptor.java:27)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.tenant.core.endpoint.MonitoringTenantSystemEndPointInterceptor.lambda$invoke$0(MonitoringTenantSystemEndPointInterceptor.java:40)
      	at com.softwareplant.util.monitoring.DropwizardMetrics.measure(DropwizardMetrics.java:49)
      	at com.softwareplant.util.monitoring.MonitoringImpl.monitore(MonitoringImpl.java:33)
      	at com.softwareplant.system.tenant.core.endpoint.MonitoringTenantSystemEndPointInterceptor.invoke(MonitoringTenantSystemEndPointInterceptor.java:40)
      	at com.softwareplant.system.core.endpoint.SystemEndPointChainImpl.processRequest(SystemEndPointChainImpl.java:28)
      	at com.softwareplant.system.manager.cloud.environment.core.multitenant.MultiTenantLoggerNDCSetter.invoke(MultiTenantLoggerNDCSetter.java:46)
      	... 21 more
      Caused by: org.hibernate.TransactionException: rollback failed
      	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)
      	at com.softwareplant.util.storage.jpa.AbstractSessionContext.callInNewTransaction(AbstractSessionContext.java:140)
      	at com.softwareplant.util.storage.jpa.AbstractSessionContext.call(AbstractSessionContext.java:98)
      	at com.softwareplant.util.storage.jpa.AbstractSessionContext.callNoLogs(AbstractSessionContext.java:89)
      	at com.softwareplant.ppm.task.core.infrastructure.TaskDAO.setFieldValues(TaskDAO.java:224)
      	at com.softwareplant.ppm.task.core.infrastructure.TaskStorage.setFieldValues(TaskStorage.java:119)
      	at com.softwareplant.ppm.task.core.infrastructure.TaskFieldValueRepositoryImpl.setFieldValues(TaskFieldValueRepositoryImpl.java:21)
      	at com.softwareplant.ppm.task.core.domain.commit.local.StoredFieldCommitExecutor.execute(StoredFieldCommitExecutor.java:25)
      	at com.softwareplant.ppm.task.core.domain.commit.TaskFieldAuditCommitExecutorDecorator.execute(TaskFieldAuditCommitExecutorDecorator.java:35)
      	at com.softwareplant.ppm.task.core.domain.commit.TaskCommitServiceImpl.commit(TaskCommitServiceImpl.java:65)
      	at com.softwareplant.ppm.task.infrastructure.TaskAnemiaUpdater.updateTasks(TaskAnemiaUpdater.java:54)
      	at com.softwareplant.ppm.task.infrastructure.TaskAnemiaRepositoryStorageImpl.updateTasks(TaskAnemiaRepositoryStorageImpl.java:52)
      	at com.softwareplant.ppm.task.domain.TaskRepositoryImpl.updateTasks(TaskRepositoryImpl.java:293)
      	at com.softwareplant.ppm.task.domain.scenario.TaskScenarioRepositoryDelegator.updateTasks(TaskScenarioRepositoryDelegator.java:158)
      	at com.softwareplant.ppm.scheduling.core.domain.task.AbstractScheduledTask.forceCommitTaskUpdates(AbstractScheduledTask.java:80)
      	at com.softwareplant.ppm.scheduling.core.domain.task.AbstractScheduledResizableTaskBundle.lambda$forcedRescheduleResizePeriod$4(AbstractScheduledResizableTaskBundle.java:88)
      	at com.softwareplant.ppm.scheduling.core.domain.task.BoxTaskTransaction.executeWithin(BoxTaskTransaction.java:20)
      	... 86 more
      Caused by: org.hibernate.TransactionException: unable to rollback against JDBC connection
      	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)
      	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)
      	... 102 more
      Caused by: org.postgresql.util.PSQLException: This connection has been closed.
      	at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:857)
      	at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:864)
      	at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)
      	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)
      	... 103 more
      

      Attachments

        Activity

          People

            evgeny.frolov Evgeny Frolov (Inactive)
            marcin.kita Marcin Kita
            lukasz.barc Łukasz Barć , martyna.turowska Martyna Turowska , evgeny.frolov Evgeny Frolov (Inactive) , grzegorz.duzy Grzegorz Duży , igor.szymanczyk Igor Szymanczyk , marcin.kita Marcin Kita
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: