1. CloudStack
  2. CLOUDSTACK-1200

Unknown column 'vm_instance.disk_offering_id' in table vm_instance, db exception shown in MS log


    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.0
    • Component/s: Management Server
    • Security Level: Public (Anyone can view this level - this is the default.)
    • Labels:
    • Environment:
      CentOS 6.3



      Step 1 : Created new build from 4.1 branch
      Step 2 : Install and configure MS server

      You can see below exception log also in error dialog displayed in UI

      2013-02-07 16:54:36,464 DEBUG [cloud.consoleproxy.ConsoleProxyManagerImpl] (consoleproxy-1:null) Skip capacity scan due to there is no Primary Storage UPintenance mode
      2013-02-07 16:54:40,115 ERROR [network.router.VirtualNetworkApplianceManagerImpl] (RouterStatusMonitor-1:null) Fail to complete the CheckRouterTask! DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@67b9238a: SELECT,, vm_instance.vnc_password, vm_instance.proxy_id, vm_instance.proxy_assign_time, vm_instance.state, vm_instance.private_ip_address, vm_instance.instance_name, vm_instance.vm_template_id, vm_instance.guest_os_id, vm_instance.host_id, vm_instance.last_host_id, vm_instance.pod_id, vm_instance.private_mac_address, vm_instance.data_center_id, vm_instance.vm_type, vm_instance.ha_enabled, vm_instance.limit_cpu_use, vm_instance.update_count, vm_instance.created, vm_instance.removed, vm_instance.update_time, vm_instance.domain_id, vm_instance.account_id, vm_instance.service_offering_id, vm_instance.reservation_id, vm_instance.hypervisor_type, vm_instance.uuid, vm_instance.disk_offering_id, domain_router.element_id, domain_router.public_ip_address, domain_router.public_mac_address, domain_router.public_netmask, domain_router.is_redundant_router, domain_router.priority, domain_router.is_priority_bumpup, domain_router.redundant_state, domain_router.stop_pending, domain_router.role, domain_router.template_version, domain_router.scripts_version, domain_router.vpc_id FROM domain_router INNER JOIN vm_instance ON INNER JOIN router_network_ref ON WHERE vm_instance.type='DomainRouter' AND vm_instance.removed IS NULL AND (router_network_ref.guest_type = 'Isolated' )
      at net.sf.cglib.proxy.MethodProxy.invoke(
      at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
      at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(
      at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
      at java.lang.reflect.Method.invoke(
      at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(
      at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(
      at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(
      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.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(

      in db i cannot see the cloumn vm_instance.disk_offering_id

      mysql> desc vm_instance;

      Field Type Null Key Default Extra


      id bigint(20) unsigned NO PRI NULL  
      name varchar(255) NO   NULL  
      uuid varchar(40) YES UNI NULL  
      instance_name varchar(255) NO   NULL  
      state varchar(32) NO MUL NULL  
      desired_state varchar(32) YES   NULL  
      vm_template_id bigint(20) unsigned YES MUL NULL  
      guest_os_id bigint(20) unsigned NO   NULL  
      private_mac_address varchar(17) YES   NULL  
      private_ip_address char(40) YES   NULL  
      pod_id bigint(20) unsigned YES MUL NULL  
      data_center_id bigint(20) unsigned NO MUL NULL  
      host_id bigint(20) unsigned YES MUL NULL  
      last_host_id bigint(20) unsigned YES MUL NULL  
      proxy_id bigint(20) unsigned YES   NULL  
      proxy_assign_time datetime YES   NULL  
      vnc_password varchar(255) NO   NULL  
      ha_enabled tinyint(1) NO   0  
      limit_cpu_use tinyint(1) unsigned NO   0  
      update_count bigint(20) unsigned NO MUL 0  
      update_time datetime YES MUL NULL  
      created datetime NO   NULL  
      removed datetime YES MUL NULL  
      type varchar(32) NO MUL NULL  
      vm_type varchar(32) NO   NULL  
      account_id bigint(20) unsigned NO MUL NULL  
      domain_id bigint(20) unsigned NO   NULL  
      service_offering_id bigint(20) unsigned NO MUL NULL  
      reservation_id char(40) YES   NULL  
      hypervisor_type char(32) YES   NULL  

      30 rows in set (0.03 sec)


        Rayees Namathponnan created issue -
        Alex Huang made changes -
        Field Original Value New Value
        Assignee Prachi Damle [ prachidamle ]
        Prachi Damle made changes -
        Assignee Prachi Damle [ prachidamle ] Rohit Yadav [ bhaisaab ]
        Rohit Yadav made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        Sudha Ponnaganti made changes -
        Status Resolved [ 5 ] Closed [ 6 ]


          • Assignee:
            Rohit Yadav
            Rayees Namathponnan
          • Votes:
            0 Vote for this issue
            5 Start watching this issue


            • Created: