Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,367,539
Community Members
 
Community Events
168
Community Groups

Bamboo server is not starting getting 502 proxy error.

Unable to login to the Bamboo server due to the recent changes in LDAP. 

Used the suggestion mentioned to login using adminstrator. here https://confluence.atlassian.com/bamboo0512/restoring-passwords-to-recover-admin-users-838556849.html#Restoringpasswordstorecoveradminusers-external.

But after restarting Bamboo. Getting this error.

```

Caused by: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl; nested exception is net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl

```

```

INFO: Initializing Spring root WebApplicationContext
Apr 20, 2021 8:35:22 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class com.atlassian.bamboo.upgrade.UpgradeLauncher
java.lang.RuntimeException: Failed to upgrade
at com.atlassian.bamboo.upgrade.UpgradeLauncher.upgradeAndStartBamboo(UpgradeLauncher.java:169)
at com.atlassian.bamboo.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:41)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4887)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5381)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl; nested exception is net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl
at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:584)
at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341)
at com.atlassian.bamboo.persistence3.HibernateDaoUtils.executeFind(HibernateDaoUtils.java:98)
at com.atlassian.bamboo.deployments.results.persistence.DeploymentResultDaoImpl.getDeploymentResultsByLifeCycleState(DeploymentResultDaoImpl.java:58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy40.getDeploymentResultsByLifeCycleState(Unknown Source)
at com.atlassian.bamboo.deployments.results.service.DeploymentResultServiceImpl.getDeploymentResultsByLifeCycleState(DeploymentResultServiceImpl.java:172)
at com.atlassian.bamboo.deployments.container.PendingDeploymentResultsCleanupImpl.cleanUp(PendingDeploymentResultsCleanupImpl.java:21)
at com.atlassian.bamboo.container.BambooContainer.start(BambooContainer.java:268)
at com.atlassian.bamboo.upgrade.UpgradeLauncher.upgradeAndStartBamboo(UpgradeLauncher.java:154)
... 10 more
Caused by: net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 68884449, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl
at net.sf.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:38)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1966)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:69)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:208)
at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2221)
at net.sf.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:319)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:309)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995)
at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93)
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288)
at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3317)
at net.sf.hibernate.collection.PersistentCollection.forceInitialization(PersistentCollection.java:336)
at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3170)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:143)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3662)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at com.atlassian.bamboo.deployments.results.persistence.DeploymentResultDaoImpl$1.doInHibernate(DeploymentResultDaoImpl.java:62)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
... 28 more

Apr 20, 2021 8:35:22 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext

```

How can we fix this error and what else information are required to fix or trace this issue.

 

1 answer

1 accepted

1 vote
Answer accepted

Just for folks who will face similar issue.

Enabled trace logs of hibernate to identify the cross linked queries.

https://confluence.atlassian.com/bamkb/how-to-enable-detailed-sql-logging-243794401.html

Able to fix this issue by deleting the reference of artifactID in the tables.

```

select * from DEPLOYMENT_VERSION_ITEM_BA where ARTIFACT_ID='6XX9';

>> get the DEPLOYMENT_VERSION_ITEM_ID that will be used in next execution.

delete from DEPLOYMENT_VERSION_ITEM_BA where ARTIFACT_ID='6XX9';

select *  from DEPLOYMENT_VERSION_ITEM where DEPLOYMENT_VERSION_ITEM_ID=6XXX8;

delete from DEPLOYMENT_VERSION_ITEM where DEPLOYMENT_VERSION_ITEM_ID=6XXX8;

```

Deleting these reference and restarting the server fix the start issue.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events