com.atlassian.util.concurrent.LazyReference$InitializationException: org.springframework.orm.hibernate3.HibernateObjectRetrievalFailureException: No row with the given identifier exists: [com.atlassian.bamboo.repository.RepositoryDataEntityImpl#291307744]

[vano_mashey]

Hi experts,

After sudden server restart I am facing this error in bamboo when I open any job. It seems like some data in DB is corrupted. Is there any way I can fix it with manual querying  the database? 

[rsperafico]

Hello Ivan,

You could run the following against your Bamboo's database:

select * from VCS_LOCATION where VCS_LOCATION_ID = 291307744;

select FULL_KEY, XML_DEFINITION_DATA from BUILD_DEFINITION 
  join BUILD on BUILD_DEFINITION.BUILD_ID = BUILD.BUILD_ID
  where XML_DEFINITION_DATA like '%291307744%';

Create a Support Request and attach the request above mentioning this https://answers.atlassian.com/questions/44896217 in the ticket.

—

Kind regards,
Rafael P. Sperafico