continuum-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maria Odea Ching (JIRA)" <j...@codehaus.org>
Subject [jira] Commented: (CONTINUUM-2403) Build definition is not removed in database even if you've already removed the build definition from the project/project group and all the build results that references it
Date Wed, 04 Nov 2009 10:53:07 GMT

    [ http://jira.codehaus.org/browse/CONTINUUM-2403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=197139#action_197139
] 

Maria Odea Ching commented on CONTINUUM-2403:
---------------------------------------------

Make sure you delete the build results first before deleting the build definition from the
database. It is tedious looking for the build results from the UI, it is somewhat easier (but
still painful) by querying the database directly. Here are a few SQL statements that is helpful
for checking project groups, projects and build results that reference the build definition:

select PROJECTGROUP.NAME from SCHEDULE, BUILDDEFINITION, PROJECTGROUP, PROJECTGROUP_BUILDDEFINITIONS
where PROJECTGROUP_BUILDDEFINITIONS.ID_EID = BUILDDEFINITION.ID and PROJECTGROUP.ID = PROJECTGROUP_BUILDDEFINITIONS.ID_OID
and SCHEDULE.name = [NAME OF YOUR SCHEDULE] and SCHEDULE.ID = BUILDDEFINITION.SCHEDULE_ID_OID;

select PROJECT.NAME from SCHEDULE, BUILDDEFINITION, PROJECT, PROJECT_BUILDDEFINITIONS where
PROJECT_BUILDDEFINITIONS.ID_EID = BUILDDEFINITION.ID and PROJECT.ID = PROJECT_BUILDDEFINITIONS.ID_OID
and SCHEDULE.name = [NAME OF YOUR SCHEDULE] and SCHEDULE.ID = BUILDDEFINITION.SCHEDULE_ID_OID;

select PROJECTGROUP.NAME, PROJECT.NAME, BUILDRESULT.PROJECT_ID_OID, BUILDRESULT.ID, BUILDRESULT.BUILD_URL,
BUILDRESULT.BUILD_NUMBER from PROJECTGROUP, PROJECT, SCHEDULE, BUILDDEFINITION, BUILDRESULT
where BUILDRESULT.BUILD_DEFINITION_ID_OID = BUILDDEFINITION.ID and SCHEDULE.name = [NAME OF
YOUR SCHEDULE] and SCHEDULE.ID = BUILDDEFINITION.SCHEDULE_ID_OID and PROJECT.ID = BUILDRESULT.PROJECT_ID_OID
and PROJECT.PROJECT_GROUP_ID_OID = PROJECTGROUP.ID;

> Build definition is not removed in database even if you've already removed the build
definition from the project/project group and all the build results that references it
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CONTINUUM-2403
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-2403
>             Project: Continuum
>          Issue Type: Bug
>          Components: Database
>    Affects Versions: 1.3.4
>            Reporter: Maria Odea Ching
>
> Because of this, it is not possible to delete the schedule where this build definition
is attached.
> To reproduce this:
> 1. Create a new schedule named 'SCHEDULE_1'
> 2. Create a new build definition for your project group and attach this build definition
to 'SCHEDULE_1'
> 3. Build the project group
> 4. Delete the build definition for the project group
> 5. Delete the build results that used this build definition
> 6. Delete 'SCHEDULE_1'
> You will not be able to delete SCHEDULE_1 and get the following error:
> 'The schedule cant be removed, it is probably used by a build definition.'
> If you look at the BUILDDEFINITION table, you will see that the build definition you
created in step 2 is still there even though no project group/project/build result references
it.
> This only happens if you already used the build definition for building the project (e.g.
a build result was created). Otherwise, the build definition is removed from the database.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message