Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Bamboo

Bamboo Data Center 8.1 is now available

G’day Bamboo customers, Bamboo DC 8.1 is now available with it the following features and programs: SAML 2.0, OpenID Connect, and Crowd SSO In order to help admins with a simplified user manage...

199 views 0 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you