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

BoxAreaTaskViewUpgradeTaskV0 fails

    XMLWordPrintable

Details

    • Infrastructure
    • BigPicture, BigGantt
    • JIRA server, JIRA cloud
    • 5
    • 5
    • Development
    • $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";}
    • Sprint 2020/21
    • PI2020/4
    • 1 day, 13 hours, 57 minutes, 58 seconds
    • 1 day, 18 hours, 54 minutes, 1 second
    • 1 hour, 28 minutes, 42 seconds
    • 2 hours, 32 minutes, 27 seconds
    • 38 seconds
    • 22 minutes, 27 seconds
    • 4 hours, 39 minutes, 16 seconds
    • $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

      DML part of Upgrade Tasks lasts more than 30 minutes. There is a 30-minute timeout in the Cloud for connection.

      2020-09-24 13:13:10,163 [0000735] INFO  [SP-bigpicture-TenantActivationSingleJobExecutor-51-t-0000735] [ScheduledUpgradeTasksExecutor] [TC:00000000] Token: db701b4836cc73f9f15689c9f296d5bdb5f98626b8388de2540981a1d72ad292493aff13e4709cdee39ba602f679d603230d1864c1877bb49007b4f34bb25b35.952c54d0217eb9e28ed6f6c185b5b5be2580025bf73b698a3630de65a9e7eba0309097b3b09d1eed2aad1a08163c902ed1c3b346c175287d367e9af060001a04.Thu Sep 24 13:13:10 CEST 2020, Upgrade failed!!!!, stage = 28@DML
      com.softwareplant.util.storage.dbupgrade.domain.exceptions.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      null
      null
      
      org.postgresql.util.PSQLException: This connection has been closed.
      	at com.softwareplant.system.manager.cloud.core.dbupgrade.transaction.CloudTransactionManager.doInTransaction(CloudTransactionManager.java:33)
      	at com.softwareplant.system.manager.cloud.core.dbupgrade.infrastructure.CloudEntityManagedActiveObjects.doInTransaction(CloudEntityManagedActiveObjects.java:209)
      	at com.softwareplant.util.storage.dbupgrade.ScheduledUpgradeTasksExecutor.executeUpgradeTask(ScheduledUpgradeTasksExecutor.java:70)
      	at com.softwareplant.util.storage.dbupgrade.ScheduledUpgradeTasksExecutor.executeUpgradeTasks(ScheduledUpgradeTasksExecutor.java:54)
      	at com.softwareplant.util.storage.dbupgrade.ScheduledUpgradeTasksExecutor.execute(ScheduledUpgradeTasksExecutor.java:46)
      	at com.softwareplant.util.storage.dbupgrade.DatabaseUpgradeExecutor.executeScheduledUpgradeTasks(DatabaseUpgradeExecutor.java:78)
      	at com.softwareplant.util.storage.dbupgrade.DatabaseUpgradeExecutor.upgrade(DatabaseUpgradeExecutor.java:54)
      	at com.softwareplant.system.manager.cloud.environment.core.dbupgrade.CloudDatabaseUpgradeTenantActivator.beforeSystemEnabled(CloudDatabaseUpgradeTenantActivator.java:27)
      	at com.softwareplant.system.manager.cloud.environment.core.dbupgrade.CloudDatabaseUpgradeTenantActivator.beforeSystemEnabled(CloudDatabaseUpgradeTenantActivator.java:14)
      	at com.softwareplant.system.core.activator.TechnicalActivators.runEnabled(TechnicalActivators.java:33)
      	at com.softwareplant.system.core.TechnicalSystem.systemOn(TechnicalSystem.java:77)
      	at com.softwareplant.system.tenant.core.MultiTenantSystem.tenantOn(MultiTenantSystem.java:77)
      	at com.softwareplant.system.tenant.core.MultiTenantSystemTenantActivator$1.call(MultiTenantSystemTenantActivator.java:51)
      	at com.softwareplant.system.tenant.core.MultiTenantSystemTenantActivator$1.call(MultiTenantSystemTenantActivator.java:47)
      	at com.softwareplant.util.concurrent.job.JobContextImpl.call(JobContextImpl.java:8)
      	at com.softwareplant.system.core.concurrent.job.SystemEndPointJobContext.jobContextCall(SystemEndPointJobContext.java:61)
      	at com.softwareplant.system.core.concurrent.job.SystemEndPointJobContext$1.invoke(SystemEndPointJobContext.java:47)
      	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:39)
      	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.core.concurrent.job.SystemEndPointJobContext.call(SystemEndPointJobContext.java:33)
      	at com.softwareplant.system.core.concurrent.job.TransactionContextJobContextProxyFactory.lambda$createProxy$5df0134e$1(TransactionContextJobContextProxyFactory.java:18)
      	at com.softwareplant.util.concurrent.job.SingleJobExecutorImpl.lambda$execute$0(SingleJobExecutorImpl.java:32)
      	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
      	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)
      	Suppressed: org.postgresql.util.PSQLException: This connection has been closed.
      		at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:857)
      		at org.postgresql.jdbc.PgConnection.getMetaData(PgConnection.java:1315)
      		at com.mchange.v2.c3p0.impl.NewProxyConnection.getMetaData(NewProxyConnection.java:806)
      		at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
      		at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      		at java.lang.reflect.Method.invoke(Method.java:498)
      		at net.java.ao.DelegateConnectionHandler.delegate(DelegateConnectionHandler.java:118)
      		at net.java.ao.DelegateConnectionHandler.invoke(DelegateConnectionHandler.java:85)
      		at com.sun.proxy.$Proxy133.getMetaData(Unknown Source)
      		at com.softwareplant.util.storage.dbupgrade.domain.exceptions.ActiveObjectsSqlException.getInformation(ActiveObjectsSqlException.java:69)
      		at com.softwareplant.util.storage.dbupgrade.domain.exceptions.ActiveObjectsSqlException.<init>(ActiveObjectsSqlException.java:34)
      		... 45 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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at net.java.ao.DelegateConnectionHandler.delegate(DelegateConnectionHandler.java:118)
      	at net.java.ao.DelegateConnectionHandler.invoke(DelegateConnectionHandler.java:85)
      	at com.sun.proxy.$Proxy133.rollback(Unknown Source)
      	at net.java.ao.DatabaseProvider.rollbackTransaction(DatabaseProvider.java:899)
      	at net.java.ao.Transaction.execute(Transaction.java:154)
      	at com.softwareplant.system.manager.cloud.core.dbupgrade.transaction.CloudTransactionManager.doInTransaction(CloudTransactionManager.java:30)
      	... 44 more
      
      

      Attachments

        Activity

          People

            marcin.budzinski Marcin Budzinski (Inactive)
            bartlomiej.janczak Bartłomiej Jańczak
            tomasz.jaskiewicz Tomasz Jaśkiewicz , grzegorz.duzy Grzegorz Duży , mateusz.wyzinski Mateusz Wyzinski , pawel.guz Pawel Guz , system.jenkins Jenkins , katarzyna.rajchert Katarzyna Rajchert , mateusz.kielbowicz Mateusz Kielbowicz , system.gerrit Gerrit , szymon.zimecki Szymon Zimecki (Inactive) , bartlomiej.janczak Bartłomiej Jańczak
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: