[Anthill-pro] Error when trying to delete environment

[Peter Steele]

We just have one project but lots and lots of build lives. I tried doing
a manual search through the old buildlife records for the couple of
builds that used this environment but I eventually gave up. I'll wait a
couple more weeks to see if our automated cleanup deletes the builds in
question. If I still can't delete the environment I'll try another
manual scan...

 

From: anthill-pro-bounces at lists.urbancode.com
[mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Steve
Boone
Sent: Wednesday, July 16, 2008 6:49 AM
To: AnthillPro user and support list.
Subject: Re: [Anthill-pro] Error when trying to delete environment

 

Peter,

You should be able to delete the environment if it is not being used in
an active buildlife.  

You can not search by environment, but you can search by project and
buildlife.  If you knew what project used the environment you could
search by project and look back through the buildlifes to see if there
are any still using that specific environment.  




On Tue, Jul 15, 2008 at 4:45 PM, Peter Steele <psteele at maxiscale.com>
wrote:

The environment was used in a couple of test builds weeks ago, sometime
around the first part of May, all of them secondary builds. I do not
know what exact builds these would have been though. Can you search for
this kind of thing-builds that used a specific environment? I have a
cleanup job that runs daily, deleting old builds more than two months
old, so they may very well all be marked inactive. 

 

From: anthill-pro-bounces at lists.urbancode.com
[mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Steve
Boone
Sent: Tuesday, July 15, 2008 10:13 AM
To: AnthillPro user and support list.
Subject: Re: [Anthill-pro] Error when trying to delete environment

 

Peter,

Was this environment used in any builds previously, and if so, have
those buildlifes been marked inactive?  

Cheers,
Steve

On Fri, Jul 11, 2008 at 5:58 PM, Peter Steele <psteele at maxiscale.com>
wrote:

I have an unused Environment that I want to delete but when I try to
delete it I get the following exception:

 

2008-07-11 14:50:32,490 ERROR http-0.0.0.0-8080-Processor14
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/].[

ControllerServlet] - Servlet.service() for servlet ControllerServlet
threw exception

com.urbancode.anthill3.domain.persistent.PersistenceRuntimeException:
com.urbancode.anthill3.domain.persistent.PersistenceExcep

tion: Error removing ServerGroup object in database

        at
com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:1
87)

...

        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:81)

        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:689)

        at java.lang.Thread.run(Thread.java:619)

Caused by:
com.urbancode.anthill3.domain.persistent.PersistenceException: Error
removing ServerGroup object in database

        at
com.urbancode.anthill3.domain.servergroup.ServerGroupDaoSql.delete(Serve
rGroupDaoSql.java:310)

        at
com.urbancode.anthill3.persistence.UnitOfWorkDefault.commit0(UnitOfWorkD
efault.java:177)

        at
com.urbancode.anthill3.persistence.UnitOfWork.commit(UnitOfWork.java:701
)

        at
com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:1
78)

        ... 34 more

Caused by: org.apache.derby.client.am.SqlException: DELETE on table
'SERVER_GROUP' caused a violation of foreign key constraint

 'BR_SERVER_GROUP_FK' for key (8).  The statement has been rolled back.

        at org.apache.derby.client.am.Statement.completeExecute(Unknown
Source)

...

        at
com.p6spy.engine.logging.P6LogPreparedStatement.executeUpdate(P6LogPrepa
redStatement.java:183)

        at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.java:101)

        at
com.urbancode.anthill3.domain.servergroup.ServerGroupDaoSql.delete(Serve
rGroupDaoSql.java:300)

 

This occurs while I am logged on as user admin. Why is Anthill
complaining about me trying to delete this environment?

 


_______________________________________________
Anthill-pro mailing list
Anthill-pro at lists.urbancode.com
http://lists.urbancode.com/mailman/listinfo/anthill-pro

 


_______________________________________________
Anthill-pro mailing list
Anthill-pro at lists.urbancode.com
http://lists.urbancode.com/mailman/listinfo/anthill-pro

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20080716/bc4a0134/attachment.htm