You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@continuum.apache.org by Wendy Smoak <ws...@gmail.com> on 2009/02/06 18:21:14 UTC
Problems deleting things from Continuum
I'm having more and more trouble with foreign key constraint
violations when trying to delete things from Continuum.
For example, when trying to delete a project group:
javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM
SCMRESULT WHERE SCMRESULT_ID=? NestedThrowables: SQL Exception: DELETE
on table 'SCMRESULT' caused a violation of foreign key constraint
'PROJECT_FK2' for key (5). The statement has been rolled back.
I went into the group and tried to delete the build results from the
project, then tried to delete the project from the group -- same
error.
A quick look in JIRA [1] turned up:
CONTINUUM-1787 cannot delete a project, constraint violation
CONTINUUM-1972 Error attempting to delete project group
CONTINUUM-1905 I can't delete a project - Exception
CONTINUUM-1813 deleting projects not working if build-results
exist (old -- opened against 1.1)
CONTINUUM-1626 Unable to delete build definition with already
executed builds
CONTINUUM-1921 foreign key constraint violation
I'm getting failures on this Selenium IDE test when it tries to clean
up after itself:
http://svn.apache.org/repos/asf/continuum/trunk/continuum-webapp-test/src/test/selenium-ide/add_and_build_project.html
Does anyone have an idea what's going on?
[1] http://jira.codehaus.org/secure/IssueNavigator.jspa?reset=true&&query=delet*&summary=true&description=true&pid=10540&resolution=-1
--
Wendy
RE: Problems deleting things from Continuum
Posted by José Morales MartÃnez <jm...@gmv.com>.
I have detected a problem when you delete a project that are using a Template Build. Whether it is default or created. But I suppose that this is not a very common problem.
Other times, I have detect problems with the deletion of projects associated build definitions. It was as if the fetch does not bring all results. When I tried it several times, the deletion occurred successfully. I can't reply this problem.
I'll work on this bug soon.
-----Mensaje original-----
De: Marica Tan [mailto:ctan@exist.com]
Enviado el: lun 09/02/2009 1:39
Para: dev@continuum.apache.org
Asunto: Re: Problems deleting things from Continuum
On Mon, Feb 9, 2009 at 8:38 AM, Marica Tan <ct...@exist.com> wrote:
>
> I think this has something to do with my changes :( Will fix this
> immediately
At least the one with the scm result foreign key constraint violation
>
>
> Thanks
> --
> Marica
>
>
> On Sat, Feb 7, 2009 at 4:28 AM, Wendy Smoak <ws...@gmail.com> wrote:
>
>> It's happening with a fresh build from trunk, with a new empty
>> database. Just adding a project and building it is enough-- then you
>> often can't delete the build result, project, or project group.
>> Thanks, -Wendy
>>
>> On Fri, Feb 6, 2009 at 1:20 PM, Emmanuel Venisse
>> <em...@gmail.com> wrote:
>> > Is it with a fresh 1.3.x fresh db or an updated db?
>> >
>> > Emmanuel
>>
>
>
______________________
Este mensaje, y en su caso, cualquier fichero anexo al mismo,
puede contener informacion clasificada por su emisor como confidencial
en el marco de su Sistema de Gestion de Seguridad de la
Informacion siendo para uso exclusivo del destinatario, quedando
prohibida su divulgacion copia o distribucion a terceros sin la
autorizacion expresa del remitente. Si Vd. ha recibido este mensaje
erroneamente, se ruega lo notifique al remitente y proceda a su borrado.
Gracias por su colaboracion.
______________________
This message including any attachments may contain confidential
information, according to our Information Security Management System,
and intended solely for a specific individual to whom they are addressed.
Any unauthorised copy, disclosure or distribution of this message
is strictly forbidden. If you have received this transmission in error,
please notify the sender immediately and delete it.
______________________
Re: Problems deleting things from Continuum
Posted by Marica Tan <ct...@exist.com>.
On Mon, Feb 9, 2009 at 8:38 AM, Marica Tan <ct...@exist.com> wrote:
>
> I think this has something to do with my changes :( Will fix this
> immediately
At least the one with the scm result foreign key constraint violation
>
>
> Thanks
> --
> Marica
>
>
> On Sat, Feb 7, 2009 at 4:28 AM, Wendy Smoak <ws...@gmail.com> wrote:
>
>> It's happening with a fresh build from trunk, with a new empty
>> database. Just adding a project and building it is enough-- then you
>> often can't delete the build result, project, or project group.
>> Thanks, -Wendy
>>
>> On Fri, Feb 6, 2009 at 1:20 PM, Emmanuel Venisse
>> <em...@gmail.com> wrote:
>> > Is it with a fresh 1.3.x fresh db or an updated db?
>> >
>> > Emmanuel
>>
>
>
Re: Problems deleting things from Continuum
Posted by Marica Tan <ct...@exist.com>.
I think this has something to do with my changes :( Will fix this
immediately
Thanks
--
Marica
On Sat, Feb 7, 2009 at 4:28 AM, Wendy Smoak <ws...@gmail.com> wrote:
> It's happening with a fresh build from trunk, with a new empty
> database. Just adding a project and building it is enough-- then you
> often can't delete the build result, project, or project group.
> Thanks, -Wendy
>
> On Fri, Feb 6, 2009 at 1:20 PM, Emmanuel Venisse
> <em...@gmail.com> wrote:
> > Is it with a fresh 1.3.x fresh db or an updated db?
> >
> > Emmanuel
>
Re: Problems deleting things from Continuum
Posted by Wendy Smoak <ws...@gmail.com>.
It's happening with a fresh build from trunk, with a new empty
database. Just adding a project and building it is enough-- then you
often can't delete the build result, project, or project group.
Thanks, -Wendy
On Fri, Feb 6, 2009 at 1:20 PM, Emmanuel Venisse
<em...@gmail.com> wrote:
> Is it with a fresh 1.3.x fresh db or an updated db?
>
> Emmanuel
Re: Problems deleting things from Continuum
Posted by Emmanuel Venisse <em...@gmail.com>.
Is it with a fresh 1.3.x fresh db or an updated db?
Emmanuel
On Fri, Feb 6, 2009 at 6:21 PM, Wendy Smoak <ws...@gmail.com> wrote:
> I'm having more and more trouble with foreign key constraint
> violations when trying to delete things from Continuum.
>
> For example, when trying to delete a project group:
>
> javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM
> SCMRESULT WHERE SCMRESULT_ID=? NestedThrowables: SQL Exception: DELETE
> on table 'SCMRESULT' caused a violation of foreign key constraint
> 'PROJECT_FK2' for key (5). The statement has been rolled back.
>
> I went into the group and tried to delete the build results from the
> project, then tried to delete the project from the group -- same
> error.
>
> A quick look in JIRA [1] turned up:
> CONTINUUM-1787 cannot delete a project, constraint violation
> CONTINUUM-1972 Error attempting to delete project group
> CONTINUUM-1905 I can't delete a project - Exception
> CONTINUUM-1813 deleting projects not working if build-results
> exist (old -- opened against 1.1)
> CONTINUUM-1626 Unable to delete build definition with already
> executed builds
> CONTINUUM-1921 foreign key constraint violation
>
> I'm getting failures on this Selenium IDE test when it tries to clean
> up after itself:
>
> http://svn.apache.org/repos/asf/continuum/trunk/continuum-webapp-test/src/test/selenium-ide/add_and_build_project.html
>
> Does anyone have an idea what's going on?
>
> [1]
> http://jira.codehaus.org/secure/IssueNavigator.jspa?reset=true&&query=delet*&summary=true&description=true&pid=10540&resolution=-1
>
> --
> Wendy
>