Bamboo 8.1.3
CPU 16 cores
RAM 16GB
OS Windows Server 2016
Recently, we experienced a good number of failures with this error "Build XXXX had to be cancelled: it was marked as in progress in DB".
I have manually updated BUILDRESULTSUMMARY table with
- LIFE_CYCLE_STATE = 'NotBuilt'
- BUILD_STATE = 'Unknown'
- DELTA_STATE = 'None'
- and valid BUILD_CANCELLED_DATE and BUILD_COMPLETED_DATE
Somehow, Bamboo is still constantly query the DB and showing the build in progress. This blocks builds.
I get through the DB schema. It is not clear how to stop the query and the wrong report. Would like to ask our community for help.
Regards,