Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

0 votes
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 101 Video

G’day Community! As we gear up to introduce Bamboo Data Center to the world, we wanted to make sure that we shared a bit more about Bamboo, the product. Our team has put together an overview video ...

190 views 4 6
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