cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <>
Subject [jira] [Commented] (CLOUDSTACK-8763) Deleting a POD/Zone always fails due to a SQLException
Date Wed, 16 Sep 2015 20:26:45 GMT


ASF GitHub Bot commented on CLOUDSTACK-8763:

GitHub user borisroman opened a pull request:

    [4.6][BLOCKER]CLOUDSTACK-8763: Resolved POD/ZONE deletion failure.

    Instead of having both checkIfPodIsDeletable() and checkIfZoneIsDeletable have there own
SQL query, I've refactored them so they use DAO SQL Queries.
    This resolves the SQL Exception thrown by both classes.

You can merge this pull request into a Git repository by running:

    $ git pull CLOUDSTACK-8763

Alternatively you can review and apply these changes as the patch at:

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #845
commit 0648cb98042eba19eb581c9d7f5b4d0c69ccd4e1
Author: Boris Schrijver <>
Date:   2015-09-16T20:13:10Z

    Added findByPodId(Long podId) to HostDao and HostDaoImpl.

commit 45861fa1b7e82250f404e22dd13ef4925c60da4e
Author: Boris Schrijver <>
Date:   2015-09-16T20:14:05Z

    Refactored checkIfPodIsDeletable().
    It now makes use of various DAO DB function instead of running a self build query.

commit 473f1937e2c13bc7cca0b42c7585fe16accf7415
Author: Boris Schrijver <>
Date:   2015-09-16T20:15:00Z

    Added countIPs(long dcId, boolean onlyCountAllocated) to DataCenterIpAddressDao and DataCenterIpAddressDaoImpl.

commit 12fc2b4c26145721622b34f1a4f40d4e06faea93
Author: Boris Schrijver <>
Date:   2015-09-16T20:15:53Z

    Added countIPs(long dcId, boolean onlyCountAllocated) to IPAddressDao and IPAddressDaoImpl.

commit 0df3357cac73a2191cf4e01d5ef8db48a0bcbc64
Author: Boris Schrijver <>
Date:   2015-09-16T20:17:27Z

    Added findByDc(long dcId) to VolumeDao and VolumeDaoImpl.

commit b31e64d49df4f9cf1e16179354bf7916f19b0b3b
Author: Boris Schrijver <>
Date:   2015-09-16T20:19:14Z

    Refactored checkIfZoneIsDeletable().
    It now makes use of various DAO DB function instead of running a self build query.


> Deleting a POD/Zone always fails due to a SQLException
> ------------------------------------------------------
>                 Key: CLOUDSTACK-8763
>                 URL:
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>    Affects Versions: 4.6.0
>            Reporter: Remi Bergsma
>            Assignee: Boris Schrijver
>            Priority: Blocker
> The Management Server failed to detect if pod is deletable. Please contact Cloud Support.
> This also means Marvin cannot clean up after a test.
> 2015-08-21 10:07:10,822 DEBUG [c.c.a.ApiServlet] (1226927357@qtp-701028225-5:ctx-0000a82e)
===START=== -- GET  command=deletePod&id=358df0b2-0bc0-480b-81a8-0675c59a808e&response=json&_=1440151630775
> 2015-08-21 10:07:10,826 ERROR [c.c.a.ApiServer] (1226927357@qtp-701028225-5:ctx-0000a82e
ctx-1c95970d) unhandled exception executing api command: [Ljava.lang.String;@3cc57321
> The Management Server failed to detect
if pod is deletable. Please contact Cloud Support.
>         at
>         at
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
>         at java.lang.reflect.Method.invoke(
>         at
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>         at com.sun.proxy.$Proxy110.deletePod(Unknown Source)
>         at org.apache.cloudstack.api.command.admin.pod.DeletePodCmd.execute(
>         at
>         at
>         at
>         at
>         at$
>         at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$
>         at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(
>         at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(
>         at
>         at
>         at javax.servlet.http.HttpServlet.service(
>         at javax.servlet.http.HttpServlet.service(
>         at org.mortbay.jetty.servlet.ServletHolder.handle(
>         at org.mortbay.jetty.servlet.ServletHandler.handle(
>         at
>         at org.mortbay.jetty.servlet.SessionHandler.handle(
>         at org.mortbay.jetty.handler.ContextHandler.handle(
>         at org.mortbay.jetty.webapp.WebAppContext.handle(
>         at org.mortbay.jetty.handler.ContextHandlerCollection.handle(
>         at org.mortbay.jetty.handler.HandlerCollection.handle(
>         at org.mortbay.jetty.handler.HandlerWrapper.handle(
>         at org.mortbay.jetty.Server.handle(
>         at org.mortbay.jetty.HttpConnection.handleRequest(
>         at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(
>         at org.mortbay.jetty.HttpParser.parseNext(
>         at org.mortbay.jetty.HttpParser.parseAvailable(
>         at org.mortbay.jetty.HttpConnection.handle(
>         at
>         at org.mortbay.thread.QueuedThreadPool$
> 2015-08-21 10:07:10,827 DEBUG [c.c.a.ApiServlet] (1226927357@qtp-701028225-5:ctx-0000a82e
ctx-1c95970d) ===END=== -- GET  command=deletePod&id=358df0b2-0bc0-480b-81a8-0675c59a808e&response=json&_=1440151630775
> 2015-08-21 10:07:11,540 INFO  [o.a.c.f.j.i.AsyncJobManagerImpl] (AsyncJobMgr-Heartbeat-1:ctx-37b4fb95)
Begin cleanup expired async-jobs
> Same for deleting a zone:
> (local) � > delete zone id=47b7f0d0-7018-419a-8e44-99ed022f0de4
> Error 530: The Management Server failed to detect if zone is deletable. Please contact
Cloud Support.

This message was sent by Atlassian JIRA

View raw message