nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Deleted project name still exists

Louie Penaflor1

I deleted a project and all of it's builds because I wanted to start over because I think some artifacts weren't working correctly. When I go to create a new plan and new project it says that the project name and key are already taken. I checked the bamboo database and they are still there, but there is a flag that says mark_for_deletion and they are both set to true. Is this a bug in Bamboo? Can I force Bamboo to go do a clean of things? I've already tried re-indexing and restarted the Bamboo service. Thanks in advance!

Accepted answers

Louie Penaflor1

Somehow the database contained a deadlock with my plans. I created a support ticket and they were able to fix my existing database. Yet another great demonstration on how Atlassian stands behind their product and service.

All comments

Przemek Bruski

Is this a recent Bamboo version? It takes a while before all the data is deleted, give it a while. You can also have a look at the log file to check if there are any error logs from DeletionService .

Louie Penaflor1

It's a recent bamboo version 3.4.1. It's been about an hour and I think I did see an error from Deletion Service:

Detail: Key (vcs_location_id)=(7077891) is still referenced from table "repository_changeset".

2012-01-03 20:10:16,626 WARN [QuartzScheduler_Worker-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 23503

2012-01-03 20:10:16,629 ERROR [QuartzScheduler_Worker-1] [JDBCExceptionReporter] Batch entry 0 delete from VCS_LOCATION where VCS_LOCATION_ID='7077891' was aborted. Call getNextException to see the cause.

2012-01-03 20:10:16,629 WARN [QuartzScheduler_Worker-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 23503

2012-01-03 20:10:16,630 ERROR [QuartzScheduler_Worker-1] [JDBCExceptionReporter] ERROR: update or delete on table "vcs_location" violates foreign key constraint "fk4a5687dd1d68b66c" on table "repository_changeset"

Detail: Key (vcs_location_id)=(7077891) is still referenced from table "repository_changeset".

2012-01-03 20:10:16,630 ERROR [QuartzScheduler_Worker-1] [SessionImpl] Could not synchronize database state with session

2012-01-03 20:10:16,634 ERROR [QuartzScheduler_Worker-1] [DeletionServiceImpl] Unable to complete delayed deletion:

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute JDBC batch update; SQL []; Batch entry 0 delete from VCS_LOCATION where VCS_LOCATION_ID='7077891' was aborted. Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 0 delete from VCS_LOCATION where VCS_LOCATION_ID='7077891' was aborted. Call getNextException to see the cause.

Caused by: java.sql.BatchUpdateException: Batch entry 0 delete from VCS_LOCATION where VCS_LOCATION_ID='7077891' was aborted. Call getNextException to see the cause.

at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)

Przemek Bruski

It's a bug. It has been fixed in 3.4.2.

Louie Penaflor1

I just upgraded to 3.4.2 and it has not been fixed. I am getting the same exception in the logs. I'm also still getting

another postgresql error about updating: 2012-01-03 19:02:17,328 WARN [QuartzScheduler_Worker-5] [BuildResultsSummaryHibernateDao] Unexpected exception while executing profiler wrapper

org.postgresql.util.PSQLException: ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets"

Detail: Key (repository_changeset_id)=(6815755) is still referenced from table "relevant_changesets".

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)

Thanks and I look forward to your reply!

Louie Penaflor1

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

bamboo