[Anthill-pro] Error when trying to delete environment

[Steve Boone]

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:187)
>
> …
>
>         at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.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(ServerGroupDaoSql.java:310)
>
>         at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.commit0(UnitOfWorkDefault.java:177)
>
>         at
> com.urbancode.anthill3.persistence.UnitOfWork.commit(UnitOfWork.java:701)
>
>         at
> com.urbancode.anthill3.web.util.Conversation.unbind0(Conversation.java:178)
>
>         ... 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(P6LogPreparedStatement.java:183)
>
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
>
>         at
> com.urbancode.anthill3.domain.servergroup.ServerGroupDaoSql.delete(ServerGroupDaoSql.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/c4e163a1/attachment-0001.htm