You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by David Comerford <da...@gmail.com> on 2013/10/02 23:49:21 UTC
Re: issues ( and release notes needs to be fixed ) --> cloudstack
2.2.14 to 4.1 ( advance networking with security groups)
Aww snap. I got the same error also on CentOS 6.4
Best regards,
David Comerford
------------------------
Tel: +353 87 1238295
Email: davestyle@gmail.com
Website: http://dave.ie
GPG key: http://gpg.dave.ie
On 1 May 2013 12:26, Shashi Dahal <s....@leaseweb.com> wrote:
> Hi.
>
> In the git log, I can see
> CLOUDSTACK-1977: Add management setup directory to classpath ..
>
> The Environment of the bug-report is Ubuntu 12.04
>
> My upgrade environment is Centos 6.4 (if that makes any difference)
>
> Cheers,
> Shashi
>
>
> -----Original Message-----
> From: Shashi Dahal [mailto:s.dahal@leaseweb.com]
> Sent: Wednesday, 1 May, 2013 1:08 PM
> To: users@cloudstack.apache.org
> Subject: issues ( and release notes needs to be fixed ) --> cloudstack
> 2.2.14 to 4.1 ( advance networking with security groups)
>
> Hi,
>
> I downloaded the latest build from today, and built the centos rpms.
>
> ------------this was the latest commit on it -----
>
> commit c2457b52889928afa906b3f634c4fd54f879b878
> Author: Kelven Yang <ke...@gmail.com>
> Date: Tue Apr 30 10:31:10 2013 -0700
>
> CLOUDSTACK-2194: Fix ApiServer component initialization sequence
>
>
> I performed an upgrade from cloudstack 2.2.14 to 4.1 ( advance networking
> with security groups).
> I followed the 2.2.14 to 4.1 upgrade using this release note:
>
> http://dissociatedpress.net/uploads/Apache_CloudStack-4.1.0-Release_Notes-en-US.pdf
>
>
> Some output of the process:
>
> #Step 11..
> Dependencies Resolved
>
>
> ==========================================================================================================================================
> Package Arch Version
> Repository Size
>
> ==========================================================================================================================================
> Installing:
> cloudstack-awsapi x86_64 4.1.0-SNAPSHOT.el6
> /cloudstack-awsapi-4.1.0-SNAPSHOT.el6.x86_64 83 M
> cloudstack-cli x86_64 4.1.0-SNAPSHOT.el6
> /cloudstack-cli-4.1.0-SNAPSHOT.el6.x86_64 565 k
> cloudstack-common x86_64 4.1.0-SNAPSHOT.el6
> /cloudstack-common-4.1.0-SNAPSHOT.el6.x86_64 56 M
> replacing cloud-core.x86_64 2.2.14-1.el6
> replacing cloud-deps.x86_64 2.2.14-1.el6
> replacing cloud-python.x86_64 2.2.14-1.el6
> replacing cloud-setup.x86_64 2.2.14-1.el6
> replacing cloud-utils.x86_64 2.2.14-1.el6
> cloudstack-management x86_64 4.1.0-SNAPSHOT.el6
> /cloudstack-management-4.1.0-SNAPSHOT.el6.x86_64 52 M
> replacing cloud-client.x86_64 2.2.14-1.el6
> replacing cloud-client-ui.x86_64 2.2.14-1.el6
> replacing cloud-server.x86_64 2.2.14-1.el6
> cloudstack-usage x86_64 4.1.0-SNAPSHOT.el6
> /cloudstack-usage-4.1.0-SNAPSHOT.el6.x86_64 42 M
> Installing for dependencies:
> apache-tomcat-apis noarch 0.1-1.el6
> base 164 k
> geronimo-specs noarch 1.0-3.5.M2.el6
> base 111 k
> geronimo-specs-compat noarch 1.0-3.5.M2.el6
> base 7.1 k
> jakarta-commons-daemon-jsvc x86_64 1:1.0.1-8.9.el6
> base 27 k
> mysql-connector-java noarch 1:5.1.17-6.el6
> base 1.4 M
> slf4j noarch 1.5.8-8.el6
> base 131 k
>
> Transaction Summary
>
> ==========================================================================================================================================
> Install 11 Package(s)
>
> Total size: 236 M
> Total download size: 1.9 M
> y
> Is this ok [y/N]: y
> Downloading Packages:
> (1/6): apache-tomcat-apis-0.1-1.el6.noarch.rpm
> | 164 kB 00:00
> (2/6): geronimo-specs-1.0-3.5.M2.el6.noarch.rpm
> | 111 kB 00:00
> (3/6): geronimo-specs-compat-1.0-3.5.M2.el6.noarch.rpm
> | 7.1 kB 00:00
> (4/6): jakarta-commons-daemon-jsvc-1.0.1-8.9.el6.x86_64.rpm
> | 27 kB 00:00
> (5/6): mysql-connector-java-5.1.17-6.el6.noarch.rpm
> | 1.4 MB 00:00
> (6/6): slf4j-1.5.8-8.el6.noarch.rpm
> | 131 kB 00:00
>
> ------------------------------------------------------------------------------------------------------------------------------------------
> Total
> 5.4 MB/s | 1.9 MB 00:00
> Running rpm_check_debug
> Running Transaction Test
> Transaction Test Succeeded
> Running Transaction
> Installing : apache-tomcat-apis-0.1-1.el6.noarch
> 1/19
> Installing : geronimo-specs-1.0-3.5.M2.el6.noarch
> 2/19
> Installing : geronimo-specs-compat-1.0-3.5.M2.el6.noarch
> 3/19
> Installing : cloudstack-common-4.1.0-SNAPSHOT.el6.x86_64
> 4/19
> Installing : 1:jakarta-commons-daemon-jsvc-1.0.1-8.9.el6.x86_64
> 5/19
> Installing : slf4j-1.5.8-8.el6.noarch
> 6/19
> Installing : 1:mysql-connector-java-5.1.17-6.el6.noarch
> 7/19
> Installing : cloudstack-awsapi-4.1.0-SNAPSHOT.el6.x86_64
> 8/19
> Installing : cloudstack-management-4.1.0-SNAPSHOT.el6.x86_64
> 9/19
> Please download vhd-util from
> http://download.cloud.com.s3.amazonaws.com/tools/vhd-util and put it in
> /usr/share/cloudstack-common/scripts/vm/hypervisor/xenserver/
> cp: cannot stat `/etc/cloud.rpmsave/management/key': No such file or
> directory
> Installing : cloudstack-usage-4.1.0-SNAPSHOT.el6.x86_64
> 10/19
> Replacing db.properties with management server db.properties
> Installing : cloudstack-cli-4.1.0-SNAPSHOT.el6.x86_64
> 11/19
> Erasing : cloud-client-ui-2.2.14-1.el6.x86_64
> 12/19
> Erasing : cloud-client-2.2.14-1.el6.x86_64
> 13/19
> Stopping cloud-management:[ OK ]
> Erasing : cloud-setup-2.2.14-1.el6.x86_64
> 14/19
> Erasing : cloud-server-2.2.14-1.el6.x86_64
> 15/19
> Erasing : cloud-core-2.2.14-1.el6.x86_64
> 16/19
> Erasing : cloud-deps-2.2.14-1.el6.x86_64
> 17/19
> Erasing : cloud-utils-2.2.14-1.el6.x86_64
> 18/19
> Erasing : cloud-python-2.2.14-1.el6.x86_64
> 19/19
> Verifying : slf4j-1.5.8-8.el6.noarch
> 1/19
> Verifying : geronimo-specs-1.0-3.5.M2.el6.noarch
> 2/19
> Verifying : geronimo-specs-compat-1.0-3.5.M2.el6.noarch
> 3/19
> Verifying : 1:jakarta-commons-daemon-jsvc-1.0.1-8.9.el6.x86_64
> 4/19
> Verifying : 1:mysql-connector-java-5.1.17-6.el6.noarch
> 5/19
> Verifying : cloudstack-common-4.1.0-SNAPSHOT.el6.x86_64
> 6/19
> Verifying : cloudstack-usage-4.1.0-SNAPSHOT.el6.x86_64
> 7/19
> Verifying : cloudstack-cli-4.1.0-SNAPSHOT.el6.x86_64
> 8/19
> Verifying : cloudstack-management-4.1.0-SNAPSHOT.el6.x86_64
> 9/19
> Verifying : cloudstack-awsapi-4.1.0-SNAPSHOT.el6.x86_64
> 10/19
> Verifying : apache-tomcat-apis-0.1-1.el6.noarch
> 11/19
> Verifying : cloud-python-2.2.14-1.el6.x86_64
> 12/19
> Verifying : cloud-utils-2.2.14-1.el6.x86_64
> 13/19
> Verifying : cloud-deps-2.2.14-1.el6.x86_64
> 14/19
> Verifying : cloud-core-2.2.14-1.el6.x86_64
> 15/19
> Verifying : cloud-client-2.2.14-1.el6.x86_64
> 16/19
> Verifying : cloud-client-ui-2.2.14-1.el6.x86_64
> 17/19
> Verifying : cloud-server-2.2.14-1.el6.x86_64
> 18/19
> Verifying : cloud-setup-2.2.14-1.el6.x86_64
> 19/19
>
> Installed:
> cloudstack-awsapi.x86_64 0:4.1.0-SNAPSHOT.el6
> cloudstack-cli.x86_64 0:4.1.0-SNAPSHOT.el6
> cloudstack-common.x86_64 0:4.1.0-SNAPSHOT.el6
> cloudstack-management.x86_64 0:4.1.0-SNAPSHOT.el6
> cloudstack-usage.x86_64 0:4.1.0-SNAPSHOT.el6
>
> Dependency Installed:
> apache-tomcat-apis.noarch 0:0.1-1.el6
> geronimo-specs.noarch 0:1.0-3.5.M2.el6
> geronimo-specs-compat.noarch 0:1.0-3.5.M2.el6
> jakarta-commons-daemon-jsvc.x86_64 1:1.0.1-8.9.el6
> mysql-connector-java.noarch 1:5.1.17-6.el6
> slf4j.noarch 0:1.5.8-8.el6
>
> Replaced:
> cloud-client.x86_64 0:2.2.14-1.el6 cloud-client-ui.x86_64
> 0:2.2.14-1.el6 cloud-core.x86_64 0:2.2.14-1.el6
> cloud-deps.x86_64 0:2.2.14-1.el6 cloud-python.x86_64
> 0:2.2.14-1.el6 cloud-server.x86_64 0:2.2.14-1.el6
> cloud-setup.x86_64 0:2.2.14-1.el6 cloud-utils.x86_64
> 0:2.2.14-1.el6
>
> Complete!
>
> Step #14 - cloud-setup-encryption .. this command is now
> cloudstack-setup-encryption
>
> Step #16
> service cloud-management start
>
> This fails with:
> /etc/sysconfig/cloudstack-management: line 21:
> /etc/cloudstack/management/tomcat6.conf: No such file or directory
> Starting cloudstack-management: awk: cmd. line:1: fatal: cannot open file
> `/etc/cloudstack/management/tomcat6.conf' for reading
> (No such file or directory)
> Error code 4 [FAILED]
>
> I found that there is no tomcat6.conf , but tomcat6-nonssl.conf and
> tomcat6-ssl.conf
> I did ln -s tomcat6-nonssl.conf tomcat6.conf and restarted the
> management server.
>
> [root@da-upgr-01-mgmt management]# /etc/init.d/cloudstack-management start
> Starting cloudstack-management: [ OK ]
>
> But there were no processes running, so I did:
> tail -f /var/log/cloud/management/management-server.log - which showed
> nothing.
>
> Digging around, found that in 4.1 it is in
> /var/log/cloudstack/management/management-server.log [/var/log/cloud is
> left untouched].. maybe it should also be made /var/log/cloud.rpmsave or
> something ( like the rpm renames for /etc/cloud and installs everything on
> /etc/cloudstack )
>
> I could not see anything in the logs.
> Checking, I found this in the catalina.out
>
> May 1, 2013 12:26:06 PM org.apache.catalina.startup.Catalina load
> WARNING: Can't load server.xml from
> /usr/share/cloudstack-management/conf/server.xml
> May 1, 2013 12:26:07 PM org.apache.catalina.startup.Catalina load
> WARNING: Can't load server.xml from
> /usr/share/cloudstack-management/conf/server.xml
> May 1, 2013 12:26:07 PM org.apache.catalina.startup.Catalina start
> SEVERE: Cannot start server. Server instance is not configured.
>
> So there is no server.xml also , so I had to do ln -s server-nonssl.xml
> server.xml and restart the cloudstack-management.
>
> This started it up and the database upgrade started.
>
> === logs ===
>
> 2013-05-01 12:27:22,424 INFO [web.context.ContextLoader] (main:null) Root
> WebApplicationContext: initialization started
> 2013-05-01 12:27:22,537 INFO [context.support.XmlWebApplicationContext]
> (main:null) Refreshing Root WebApplicationContext: startup date [Wed May 01
> 12:27:22 CEST 2013]; root of context hierarchy
> 2013-05-01 12:27:22,627 INFO [factory.xml.XmlBeanDefinitionReader]
> (main:null) Loading XML bean definitions from class path resource
> [applicationContext.xml]
> 2013-05-01 12:27:23,343 INFO [factory.xml.XmlBeanDefinitionReader]
> (main:null) Loading XML bean definitions from class path resource
> [componentContext.xml]
> 2013-05-01 12:27:25,130 INFO
> [factory.annotation.AutowiredAnnotationBeanPostProcessor] (main:null)
> JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> 2013-05-01 12:27:25,172 INFO [context.support.XmlWebApplicationContext]
> (main:null) Bean 'transactionContextBuilder' of type [class
> com.cloud.utils.db.TransactionContextBuilder] is not eligible for getting
> processed by all BeanPostProcessors (for example: not eligible for
> auto-proxying)
> 2013-05-01 12:27:25,176 INFO [context.support.XmlWebApplicationContext]
> (main:null) Bean 'actionEventInterceptor' of type [class
> com.cloud.event.ActionEventInterceptor] is not eligible for getting
> processed by all BeanPostProcessors (for example: not eligible for
> auto-proxying)
> 2013-05-01 12:27:25,254 INFO [factory.support.DefaultListableBeanFactory]
> (main:null) Pre-instantiating singletons in
> org.springframework.beans.factory.support.DefaultListableBeanFactory@4d5fc672:
> defining beans
> [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,componentContext,transactionContextBuilder,actionEventInterceptor,instantiatePostProcessor,onwireRegistry,messageSerializer,transportProvider,rpcProvider,eventBus,serviceOfferingDaoImpl,diskOfferingDaoImpl,dataCenterDaoImpl,hostPodDaoImpl,vlanDaoImpl,userDaoImpl,VMTemplateDaoImpl,hypervisorCapabilitiesDaoImpl,accountDaoImpl,accountDetailsDaoImpl,accountJoinDaoImpl,accountVlanMapDaoImpl,agentUpgradeDaoImpl,alertDaoImpl,asyncJobDaoImpl,asyncJobJoinDaoImpl,autoScalePolicyConditionMapDaoImpl,autoScalePolicyDaoImpl,autoScaleVmGroupDaoImpl,autoScaleVmGroupPolicyMapDaoImpl,autoScaleVmProfileDaoImpl,capacityDaoImpl,certificateDaoImpl,clusterDaoImpl,clusterDetailsDaoImpl,commandExecLogDaoImpl,conditionDaoImpl,consoleProxyDaoImpl,counterDaoImpl,dataCenterIpAddressDaoImpl,dataCenterJoinDaoImpl,dataCenterLinkLocalIpAddressDaoImpl,dataCenterVnetDaoImpl,dataStoreProviderDaoImpl,dcDetailsDaoImpl,engineDcDetailsDaoImpl,diskOfferingJoinDaoImpl,domainDaoImpl,domainRouterDaoImpl,domainRouterJoinDaoImpl,elasticLbVmMapDaoImpl,engineClusterDaoImpl,engineDataCenterDaoImpl,engineHostDaoImpl,engineHostPodDaoImpl,eventDaoImpl,eventJoinDaoImpl,externalFirewallDeviceDaoImpl,externalLoadBalancerDeviceDaoImpl,externalPublicIpStatisticsDaoImpl,firewallRulesCidrsDaoImpl,firewallRulesDaoImpl,guestOSCategoryDaoImpl,guestOSDaoImpl,highAvailabilityDaoImpl,hostDaoImpl,hostDetailsDaoImpl,engineHostDetailsDaoImpl,hostJoinDaoImpl,engineHostTagsDaoImpl,hostTagsDaoImpl,hostTransferMapDaoImpl,iPAddressDaoImpl,identityDaoImpl,imageDaoStoreDaoImpl,imageDataDaoImpl,imageDataStoreProviderDaoImpl,inlineLoadBalancerNicMapDaoImpl,instanceGroupDaoImpl,instanceGroupJoinDaoImpl,instanceGroupVMMapDaoImpl,itWorkDaoImpl,keystoreDaoImpl,lBStickinessPolicyDaoImpl,launchPermissionDaoImpl,loadBalancerDaoImpl,loadBalancerVMMapDaoImpl,managementServerHostDaoImpl,managementServerHostPeerDaoImpl,networkAccountDaoImpl,networkDaoImpl,networkDomainDaoImpl,networkExternalFirewallDaoImpl,networkExternalLoadBalancerDaoImpl,networkOfferingDaoImpl,networkOfferingServiceMapDaoImpl,networkOpDaoImpl,networkRuleConfigDaoImpl,networkServiceMapDaoImpl,nicDaoImpl,objectInDataStoreDaoImpl,ovsTunnelInterfaceDaoImpl,ovsTunnelNetworkDaoImpl,physicalNetworkDaoImpl,physicalNetworkIsolationMethodDaoImpl,physicalNetworkServiceProviderDaoImpl,physicalNetworkTagDaoImpl,physicalNetworkTrafficTypeDaoImpl,podVlanDaoImpl,podVlanMapDaoImpl,portForwardingRulesDaoImpl,primaryDataStoreDaoImpl,primaryDataStoreDetailsDaoImpl,privateIpDaoImpl,projectAccountDaoImpl,projectAccountJoinDaoImpl,projectDaoImpl,projectInvitationDaoImpl,projectInvitationJoinDaoImpl,projectJoinDaoImpl,regionDaoImpl,remoteAccessVpnDaoImpl,resourceCountDaoImpl,resourceLimitDaoImpl,resourceTagJoinDaoImpl,resourceTagsDaoImpl,routerNetworkDaoImpl,s3DaoImpl,sSHKeyPairDaoImpl,secondaryStorageVmDaoImpl,securityGroupDaoImpl,securityGroupJoinDaoImpl,securityGroupRuleDaoImpl,securityGroupRulesDaoImpl,securityGroupVMMapDaoImpl,securityGroupWorkDaoImpl,serviceOfferingJoinDaoImpl,site2SiteCustomerGatewayDaoImpl,site2SiteVpnConnectionDaoImpl,site2SiteVpnGatewayDaoImpl,snapshotDao2Impl,snapshotDaoImpl,snapshotPolicyDaoImpl,snapshotScheduleDaoImpl,stackMaidDaoImpl,staticRouteDaoImpl,storageNetworkIpAddressDaoImpl,storageNetworkIpRangeDaoImpl,storagePoolDaoImpl,storagePoolDetailsDaoImpl,storagePoolHostDaoImpl,storagePoolJoinDaoImpl,storagePoolWorkDaoImpl,swiftDaoImpl,syncQueueDaoImpl,syncQueueItemDaoImpl,templatePrimaryDataStoreDaoImpl,uploadDaoImpl,usageDaoImpl,usageEventDaoImpl,usageIPAddressDaoImpl,usageJobDaoImpl,usageLoadBalancerPolicyDaoImpl,usageNetworkDaoImpl,usageNetworkOfferingDaoImpl,usagePortForwardingRuleDaoImpl,usageSecurityGroupDaoImpl,usageStorageDaoImpl,usageVMInstanceDaoImpl,usageVPNUserDaoImpl,usageVolumeDaoImpl,userAccountDaoImpl,userAccountJoinDaoImpl,userIpv6AddressDaoImpl,userStatisticsDaoImpl,userStatsLogDaoImpl,userVmDetailsDaoImpl,userVmJoinDaoImpl,vMComputeTagDaoImpl,vMEntityDaoImpl,vMInstanceDaoImpl,vMNetworkMapDaoImpl,vMReservationDaoImpl,vMRootDiskTagDaoImpl,vMTemplateDetailsDaoImpl,vMTemplateHostDaoImpl,vMTemplatePoolDaoImpl,vMTemplateS3DaoImpl,vMTemplateSwiftDaoImpl,vMTemplateZoneDaoImpl,versionDaoImpl,virtualRouterProviderDaoImpl,vmRulesetLogDaoImpl,volumeDao2Impl,volumeDaoImpl,volumeHostDaoImpl,volumeJoinDaoImpl,volumeReservationDaoImpl,vpcDaoImpl,vpcGatewayDaoImpl,vpcOfferingDaoImpl,vpcOfferingServiceMapDaoImpl,vpnUserDaoImpl,userVmDaoImpl,portProfileDaoImpl,clusterVSMMapDaoImpl,encryptionSecretKeyChecker,StaticRoleBasedAPIAccessChecker,databaseIntegrityChecker,domainChecker,basicAgentAuthManager,MD5UserAuthenticator,LDAPUserAuthenticator,Ovs,SecurityGroupProvider,VirtualRouter,VpcVirtualRouter,elasticLoadBalancerElement,firstFitAllocator,randomAllocator,FirstFitRouting,LocalStoragePoolAllocator,FirstFitStoragePoolAllocator,UserConcentratedAllocator,useLocalForRootAllocator,garbageCollectingStoragePoolAllocator,randomStoragePoolAllocator,recreatableFencer,recreateHostAllocator,secondaryStorageVmDefaultAllocator,ConsoleProxyAllocator,ExteralIpAddressAllocator,hyervisorTemplateAdapter,clusterAlertAdapter,consoleProxyAlertAdapter,secondaryStorageVmAlertAdapter,clusterServiceServletAdapter,CheckOnAgentInvestigator,XenServerInvestigator,UserVmDomRInvestigator,ManagementIPSystemVMInvestigator,XenServerFencer,KVMFencer,OvmFencer,XcpServerDiscoverer,SecondaryStorageDiscoverer,KvmServerDiscoverer,HypervServerDiscoverer,OvmDiscoverer,dummyHostDiscoverer,UserDispersingPlanner,UserConcentratedPodPlanner,clusterBasedAgentLoadBalancerPlanner,StorageNetworkGuru,ExternalGuestNetworkGuru,PublicNetworkGuru,PodBasedNetworkGuru,ControlNetworkGuru,DirectNetworkGuru,DirectPodBasedNetworkGuru,OvsGuestNetworkGuru,PrivateNetworkGuru,XenServerGuru,KVMGuru,OvmGuru,HypervisorPlannerSelector,accountManagerImpl,managementServerImpl,storageManagerImpl,FirstFitPlanner,resourceManagerImpl,highAvailabilityManagerExtImpl,clusteredVirtualMachineManagerImpl,networkManagerImpl,networkModelImpl,configurationServerImpl,clusterManagerImpl,clusteredAgentManagerImpl,userVmManagerImpl,consoleProxyManagerImpl,securityGroupManagerImpl2,premiumSecondaryStorageManagerImpl,ipv6AddressManagerImpl,apiRateLimitServiceImpl,alertManagerImpl,asyncJobExecutorContextImpl,asyncJobManagerImpl,autoScaleManagerImpl,capacityManagerImpl,clusterFenceManagerImpl,configurationManagerImpl,dataStoreProviderManagerImpl,domainManagerImpl,downloadMonitorImpl,elasticLoadBalancerManagerImpl,entityManagerImpl,externalLoadBalancerUsageManagerImpl,externalNetworkDeviceManagerImpl,firewallManagerImpl,hypervisorGuruManagerImpl,identityServiceImpl,keystoreManagerImpl,loadBalancingRulesManagerImpl,networkACLManagerImpl,networkServiceImpl,networkUsageManagerImpl,oCFS2ManagerImpl,ovsTunnelManagerImpl,projectManagerImpl,queryManagerImpl,regionManagerImpl,regionServiceImpl,remoteAccessVpnManagerImpl,resourceLimitManagerImpl,rulesManagerImpl,s3ManagerImpl,site2SiteVpnManagerImpl,snapshotManagerImpl,snapshotSchedulerImpl,storageNetworkManagerImpl,swiftManagerImpl,syncQueueManagerImpl,taggedResourceManagerImpl,templateManagerImpl,upgradeManagerImpl,uploadMonitorImpl,usageServiceImpl,virtualNetworkApplianceManagerImpl,vpcManagerImpl,vpcVirtualNetworkApplianceManagerImpl,cloudZonesStartupProcessor,managementServerNode,actionEventUtils,agentMonitor,alertGenerator,apiDBUtils,apiDiscoveryServiceImpl,apiDispatcher,apiResponseHelper,apiServer,apiServlet,cloudOrchestrator,clusterRestService,consoleProxyServlet,dataCenterResourceManagerImpl,dataDisk,dataMotionServiceImpl,dataObjectManagerImpl,dataStoreManagerImpl,defaultEndPointSelector,defaultImageDataStoreProvider,defaultImageMotionStrategy,defaultPrimaryDataStoreProviderManagerImpl,defaultPrimaryDatastoreProviderImpl,eventUtils,hypervisorBasedSnapshot,hypervsiorHostEndPointRpcServer,iSCSI,ISO,imageDataFactoryImpl,imageDataManagerImpl,imageDataStoreHelper,imageDataStoreManagerImpl,imageFormatHelper,imageMotionServiceImpl,imageServiceImpl,iso,networkFileSystem,networkRestService,OVA,objectInDataStoreManagerImpl,podRestService,primaryDataStoreHelper,provisioningServiceImpl,QCOW2,registerCompleteServlet,rootDisk,snapshotDataFactoryImpl,snapshotServiceImpl,statsCollector,templateInstallStrategyImpl,unknown,usageEventUtils,userContextInitializer,VHD,vMEntityManagerImpl,virtualMachineEntityImpl,virtualMachineRestService,volumeDataFactoryImpl,volumeManagerImpl,volumeRestService,volumeServiceImpl,volumeTypeHelper,zoneRestService,databaseUpgradeChecker,configurationDaoImpl,niciraNvpDaoImpl,niciraNvpNicMappingDaoImpl,niciraNvpRouterMappingDaoImpl,NiciraNvpGuestNetworkGuru,NiciraNvp,userAuthenticators,securityCheckers,resourceDiscoverers,haInvestigators,haFenceBuilders,deploymentPlanners,podAllocators,hostAllocators,storagePoolAllocators,ipDeployers,dhcpProviders,networkGurus,networkElements,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0];
> root of factory hierarchy
> 2013-05-01 12:27:25,266 INFO [utils.component.ComponentContext]
> (main:null) Setup Spring Application context
> 2013-05-01 12:27:25,706 DEBUG [utils.crypt.EncryptionSecretKeyChecker]
> (main:null) Encryption Type: file
> 2013-05-01 12:27:31,795 INFO [cloud.serializer.GsonHelper] (main:null)
> Default Builder inited.
> 2013-05-01 12:27:32,997 INFO [web.context.ContextLoader] (main:null) Root
> WebApplicationContext: initialization completed in 10572 ms
> 2013-05-01 12:27:33,031 INFO [cloud.utils.LogUtils] (main:null) log4j
> configuration found at /etc/cloudstack/management/log4j-cloud.xml
> 2013-05-01 12:27:33,051 INFO
> [factory.annotation.AutowiredAnnotationBeanPostProcessor] (main:null)
> JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> 2013-05-01 12:27:33,330 INFO
> [factory.annotation.AutowiredAnnotationBeanPostProcessor]
> (catalina-exec-1:null) JSR-330 'javax.inject.Inject' annotation found and
> supported for autowiring
> 2013-05-01 12:27:33,384 DEBUG [cloud.api.ApiServlet]
> (catalina-exec-1:null) ===START=== 10.11.104.11 -- GET
> apiKey=RwG-nDfbVfvEMV_npXrVbcmHcJdF2quI6L9SqZfDXQ9q60nDLNL8AU3fivSzlIR6w8a8H_R3vhjWykneJms_Bw&command=listAsyncJobs&listall=true&response=json&signature=b8eL2iteVxY%2FDEL504FCnwARzSE%3D
> 2013-05-01 12:27:33,386 ERROR [cloud.api.ApiServlet]
> (catalina-exec-1:null) unknown exception writing api response
> java.lang.NullPointerException
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:280)
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:143)
> at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:238)
> at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889)
> at
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721)
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2274)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:679)
> 2013-05-01 12:27:33,398 DEBUG [cloud.api.ApiServlet]
> (catalina-exec-1:null) ===END=== 10.11.104.11 -- GET
> apiKey=RwG-nDfbVfvEMV_npXrVbcmHcJdF2quI6L9SqZfDXQ9q60nDLNL8AU3fivSzlIR6w8a8H_R3vhjWykneJms_Bw&command=listAsyncJobs&listall=true&response=json&signature=b8eL2iteVxY%2FDEL504FCnwARzSE%3D
> 2013-05-01 12:27:43,438 DEBUG [cloud.api.ApiServlet]
> (catalina-exec-2:null) ===START=== 10.11.104.11 -- GET
> apiKey=RwG-nDfbVfvEMV_npXrVbcmHcJdF2quI6L9SqZfDXQ9q60nDLNL8AU3fivSzlIR6w8a8H_R3vhjWykneJms_Bw&command=listAsyncJobs&listall=true&response=json&signature=b8eL2iteVxY%2FDEL504FCnwARzSE%3D
> 2013-05-01 12:27:44,039 ERROR [cloud.api.ApiServlet]
> (catalina-exec-2:null) unknown exception writing api response
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> com.mysql.jdbc.JDBC4PreparedStatement@221e5f0: SELECT user.id,
> user.username, user.password, user.firstname, user.lastname,
> user.account_id, user.email, user.state, user.api_key, user.secret_key,
> user.created, user.removed, user.timezone, user.registration_token,
> user.is_registered, user.uuid FROM user WHERE user.id = 1 AND
> user.removed IS NULL
> at
> com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:979)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:956)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:917)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:280)
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:143)
> at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:238)
> at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889)
> at
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721)
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2274)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'user.uuid' in 'field list'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:976)
> ... 39 more
> 2013-05-01 12:27:44,041 DEBUG [cloud.api.ApiServlet]
> (catalina-exec-2:null) ===END=== 10.11.104.11 -- GET
> apiKey=RwG-nDfbVfvEMV_npXrVbcmHcJdF2quI6L9SqZfDXQ9q60nDLNL8AU3fivSzlIR6w8a8H_R3vhjWykneJms_Bw&command=listAsyncJobs&listall=true&response=json&signature=b8eL2iteVxY%2FDEL504FCnwARzSE%3D
> 2013-05-01 12:27:44,775 INFO [utils.component.ComponentContext]
> (Timer-1:null) Running SystemIntegrityChecker encryptionSecretKeyChecker
> 2013-05-01 12:27:44,782 DEBUG [utils.crypt.EncryptionSecretKeyChecker]
> (Timer-1:null) Encryption Type: file
> 2013-05-01 12:27:44,782 WARN [utils.crypt.EncryptionSecretKeyChecker]
> (Timer-1:null) Encryption already enabled, is check() called twice?
> 2013-05-01 12:27:44,788 INFO [utils.component.ComponentContext]
> (Timer-1:null) Running SystemIntegrityChecker databaseIntegrityChecker
> 2013-05-01 12:27:44,788 INFO [cloud.upgrade.DatabaseIntegrityChecker]
> (Timer-1:null) Grabbing lock to check for database integrity.
> 2013-05-01 12:27:44,794 INFO [cloud.upgrade.DatabaseIntegrityChecker]
> (Timer-1:null) Performing database integrity check
> 2013-05-01 12:27:44,824 DEBUG [cloud.upgrade.DatabaseIntegrityChecker]
> (Timer-1:null) No duplicate hosts with the same local storage found in
> database
> 2013-05-01 12:27:44,835 DEBUG [upgrade.dao.VersionDaoImpl] (Timer-1:null)
> Checking to see if the database is at a version before it was the version
> table is created
> 2013-05-01 12:27:44,882 INFO [utils.component.ComponentContext]
> (Timer-1:null) Running SystemIntegrityChecker managementServerNode
> 2013-05-01 12:27:44,882 INFO [utils.component.ComponentContext]
> (Timer-1:null) Running SystemIntegrityChecker databaseUpgradeChecker
> 2013-05-01 12:27:44,882 INFO [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Grabbing lock to check for database upgrade.
> 2013-05-01 12:27:44,884 DEBUG [upgrade.dao.VersionDaoImpl] (Timer-1:null)
> Checking to see if the database is at a version before it was the version
> table is created
> 2013-05-01 12:27:44,887 INFO [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) DB version = 2.2.14.20120210102939 Code Version =
> 4.1.0-SNAPSHOT
> 2013-05-01 12:27:44,887 INFO [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Database upgrade must be performed from
> 2.2.14.20120210102939 to 4.1.0-SNAPSHOT
> 2013-05-01 12:27:44,888 DEBUG [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Running upgrade Upgrade2214to30 to upgrade from 2.2.14-3.0.0
> to 3.0.0
> 2013-05-01 12:27:44,893 DEBUG [utils.script.Script] (Timer-1:null) Looking
> for db/schema-2214to30.sql in the classpath
> 2013-05-01 12:27:44,893 DEBUG [utils.script.Script] (Timer-1:null) System
> resource: file:/usr/share/cloudstack-management/setup/db/schema-2214to30.sql
> 2013-05-01 12:27:44,893 DEBUG [utils.script.Script] (Timer-1:null)
> Absolute path =
> /usr/share/cloudstack-management/setup/db/schema-2214to30.sql
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> Licensed to the Apache Software Foundation (ASF) under one
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- or
> more contributor license agreements. See the NOTICE file
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> distributed with this work for additional information
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> regarding copyright ownership. The ASF licenses this file
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- to
> you under the Apache License, Version 2.0 (the
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> "License"); you may not use this file except in compliance
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> with the License. You may obtain a copy of the License at
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> http://www.apache.org/licenses/LICENSE-2.0
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> Unless required by applicable law or agreed to in writing,
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> software distributed under the License is distributed on an
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
> 2013-05-01 12:27:44,895 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> KIND, either express or implied. See the License for the
> 2013-05-01 12:27:44,896 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> specific language governing permissions and limitations
> 2013-05-01 12:27:44,896 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> under the License.
> 2013-05-01 12:27:44,896 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> Schema upgrade from 2.2.14 to 3.0;
> 2013-05-01 12:27:44,896 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host` ADD COLUMN `hypervisor_version` varchar(32) COMMENT
> 'hypervisor version' AFTER hypervisor_type
> 2013-05-01 12:27:44,986 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`hypervisor_capabilities` ( `id` bigint unsigned NOT
> NULL auto_increment, `hypervisor_type` varchar(32) NOT NULL,
> `hypervisor_version` varchar(32), `max_guests_limit` bigint unsigned
> DEFAULT 50, `security_group_enabled` int(1) unsigned DEFAULT 1 COMMENT
> 'Is security group supported', PRIMARY KEY (`id`) ) ENGINE=InnoDB
> AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
> 2013-05-01 12:27:45,001 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('XenServer', 'default', 50, 1)
> 2013-05-01 12:27:45,002 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('XenServer', 'XCP 1.0', 50, 1)
> 2013-05-01 12:27:45,003 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('XenServer', '5.6', 50, 1)
> 2013-05-01 12:27:45,003 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('XenServer', '5.6 FP1', 50, 1)
> 2013-05-01 12:27:45,003 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('XenServer', '5.6 SP2', 50, 1)
> 2013-05-01 12:27:45,004 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('XenServer', '6.0', 50, 1)
> 2013-05-01 12:27:45,004 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('VMware', 'default', 128, 0)
> 2013-05-01 12:27:45,004 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('VMware', '4.0', 128, 0)
> 2013-05-01 12:27:45,005 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('VMware', '4.1', 128, 0)
> 2013-05-01 12:27:45,005 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('KVM', 'default', 50, 1)
> 2013-05-01 12:27:45,005 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('Ovm', 'default', 25, 1)
> 2013-05-01 12:27:45,010 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type,
> hypervisor_version, max_guests_limit, security_group_enabled) VALUES
> ('Ovm', '2.3', 25, 1)
> 2013-05-01 12:27:45,010 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`projects` ( `id` bigint unsigned NOT NULL
> auto_increment, `name` varchar(255) COMMENT 'project name',
> `display_text` varchar(255) COMMENT 'project name', `project_account_id`
> bigint unsigned NOT NULL, `domain_id` bigint unsigned NOT NULL,
> `created` datetime COMMENT 'date created', `removed` datetime COMMENT
> 'date removed', `state` varchar(255) NOT NULL COMMENT 'state of the
> project (Active/Inactive/Suspended)', PRIMARY KEY (`id`), CONSTRAINT
> `fk_projects__project_account_id` FOREIGN KEY(`project_account_id`)
> REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_projects__domain_id` FOREIGN KEY(`domain_id`) REFERENCES `domain`(`id`)
> ON DELETE CASCADE, INDEX `i_projects__removed`(`removed`) )
> ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:45,044 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`project_account` ( `id` bigint unsigned NOT NULL
> auto_increment, `account_id` bigint unsigned NOT NULL COMMENT'account
> id', `account_role` varchar(255) NOT NULL DEFAULT 'Regular' COMMENT
> 'Account role in the project (Owner or Regular)', `project_id` bigint
> unsigned NOT NULL COMMENT 'project id', `project_account_id` bigint
> unsigned NOT NULL, `created` datetime COMMENT 'date created', PRIMARY
> KEY (`id`), CONSTRAINT `fk_project_account__account_id` FOREIGN
> KEY(`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE,
> CONSTRAINT `fk_project_account__project_id` FOREIGN KEY(`project_id`)
> REFERENCES `projects`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_project_account__project_account_id` FOREIGN KEY(`project_account_id`)
> REFERENCES `account`(`id`) ON DELETE CASCADE, UNIQUE (`account_id`,
> `project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:45,070 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`project_invitations` ( `id` bigint unsigned NOT
> NULL auto_increment, `uuid` varchar(40), `project_id` bigint unsigned
> NOT NULL COMMENT 'project id', `account_id` bigint unsigned COMMENT
> 'account id', `domain_id` bigint unsigned COMMENT 'domain id', `email`
> varchar(255) COMMENT 'email', `token` varchar(255) COMMENT 'token',
> `state` varchar(255) NOT NULL DEFAULT 'Pending' COMMENT 'the state of the
> invitation', `created` datetime COMMENT 'date created', PRIMARY KEY
> (`id`), CONSTRAINT `fk_project_invitations__account_id` FOREIGN
> KEY(`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE,
> CONSTRAINT `fk_project_invitations__domain_id` FOREIGN KEY(`domain_id`)
> REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_project_invitations__project_id` FOREIGN KEY(`project_id`) REFERENCES
> `projects`(`id`) ON DELETE CASCADE, UNIQUE (`project_id`, `account_id`),
> UNIQUE (`project_id`, `email`), UNIQUE (`project_id`, `token`),
> CONSTRAINT `uc_project_invitations__uuid` UNIQUE (`uuid`) ) ENGINE=InnoDB
> DEFAULT CHARSET=utf8
> 2013-05-01 12:27:45,097 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`load_balancer_stickiness_policies` ( `id` bigint
> unsigned NOT NULL auto_increment, `uuid` varchar(40),
> `load_balancer_id` bigint unsigned NOT NULL, `name` varchar(255) NOT
> NULL, `description` varchar(4096) NULL COMMENT 'description',
> `method_name` varchar(255) NOT NULL, `params` varchar(4096) NOT NULL,
> `revoke` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT '1 is when rule is
> set for Revoke', PRIMARY KEY (`id`), CONSTRAINT
> `fk_load_balancer_stickiness_policies__load_balancer_id` FOREIGN
> KEY(`load_balancer_id`) REFERENCES `load_balancing_rules`(`id`) ON DELETE
> CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:45,132 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`template_swift_ref` ( `id` bigint unsigned NOT
> NULL auto_increment, `swift_id` bigint unsigned NOT NULL, `template_id`
> bigint unsigned NOT NULL, `created` DATETIME NOT NULL, `path`
> varchar(255), `size` bigint unsigned, `physical_size` bigint unsigned
> DEFAULT 0, PRIMARY KEY (`id`), CONSTRAINT
> `fk_template_swift_ref__swift_id` FOREIGN KEY
> `fk_template_swift_ref__swift_id` (`swift_id`) REFERENCES `swift` (`id`) ON
> DELETE CASCADE, INDEX `i_template_swift_ref__swift_id`(`swift_id`),
> CONSTRAINT `fk_template_swift_ref__template_id` FOREIGN KEY
> `fk_template_swift_ref__template_id` (`template_id`) REFERENCES
> `vm_template` (`id`), INDEX
> `i_template_swift_ref__template_id`(`template_id`) ) ENGINE=InnoDB
> AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
> 2013-05-01 12:27:45,156 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshots` DROP COLUMN `swift_name`
> 2013-05-01 12:27:45,193 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` DROP COLUMN `hostname`
> 2013-05-01 12:27:45,245 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` DROP COLUMN `token`
> 2013-05-01 12:27:45,277 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:45,310 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` ADD COLUMN `url` varchar(255) NOT NULL
> 2013-05-01 12:27:45,342 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` ADD COLUMN `key` varchar(255) NOT NULL COMMENT 'token
> for this user'
> 2013-05-01 12:27:45,374 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` ADD COLUMN `created` datetime COMMENT 'date the swift
> first signed on'
> 2013-05-01 12:27:45,425 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`swift` ADD CONSTRAINT `uc_swift__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:45,458 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'swift.enable', 'false', 'enable swift')
> 2013-05-01 12:27:45,458 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'max.project.user.vms', '20', 'The default
> maximum number of user VMs that can be deployed for a project')
> 2013-05-01 12:27:45,459 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'max.project.public.ips', '20', 'The
> default maximum number of public IPs that can be consumed by a project')
> 2013-05-01 12:27:45,459 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'max.project.templates', '20', 'The default
> maximum number of templates that can be deployed for a project')
> 2013-05-01 12:27:45,460 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'max.project.snapshots', '20', 'The default
> maximum number of snapshots that can be created for a project')
> 2013-05-01 12:27:45,460 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'max.project.volumes', '20', 'The default
> maximum number of volumes that can be created for a project')
> 2013-05-01 12:27:45,460 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.invite.required', 'false', 'If
> invitation confirmation is required when add account to project. Default
> value is false')
> 2013-05-01 12:27:45,461 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.invite.timeout', '86400',
> 'Invitation expiration time (in seconds). Default is 1 day - 86400 seconds')
> 2013-05-01 12:27:45,461 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'allow.user.create.projects', 'true', 'If
> regular user can create a project; true by default')
> 2013-05-01 12:27:45,462 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.email.sender', null, 'Sender of
> project invitation email (will be in the From header of the email).')
> 2013-05-01 12:27:45,462 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.smtp.host', null, 'SMTP hostname
> used for sending out email project invitations')
> 2013-05-01 12:27:45,467 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.smtp.password', null, 'Password
> for SMTP authentication (applies only if project.smtp.useAuth is true)')
> 2013-05-01 12:27:45,467 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.smtp.port', '465', 'Port the SMTP
> server is listening on')
> 2013-05-01 12:27:45,467 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.smtp.useAuth', null, 'If true, use
> SMTP authentication when sending emails')
> 2013-05-01 12:27:45,468 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults',
> 'DEFAULT', 'management-server', 'project.smtp.username', null, 'Username
> for SMTP authentication (applies only if project.smtp.useAuth is true)')
> 2013-05-01 12:27:45,468 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'cluster.memory.allocated.capacity.disablethreshold' ,
> .85, 'Percentage (as a value between 0 and 1) of memory utilization above
> which allocators will disable using the cluster for low memory available.
> Keep the corresponding notification threshold lower than this to be
> notified beforehand.')
> 2013-05-01 12:27:45,469 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'cluster.cpu.allocated.capacity.disablethreshold' ,
> .85, 'Percentage (as a value between 0 and 1) of cpu utilization above
> which allocators will disable using the cluster for low cpu available. Keep
> the corresponding notification threshold lower than this to be notified
> beforehand.')
> 2013-05-01 12:27:45,469 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'pool.storage.allocated.capacity.disablethreshold' ,
> .85, 'Percentage (as a value between 0 and 1) of allocated storage
> utilization above which allocators will disable using the pool for low
> allocated storage available.')
> 2013-05-01 12:27:45,470 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'pool.storage.capacity.disablethreshold' , .85,
> 'Percentage (as a value between 0 and 1) of storage utilization above which
> allocators will disable using the pool for low storage available.')
> 2013-05-01 12:27:45,470 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'zone.vlan.capacity.notificationthreshold' , .75,
> 'Percentage (as a value between 0 and 1) of Zone Vlan utilization above
> which alerts will be sent about low number of Zone Vlans.')
> 2013-05-01 12:27:45,470 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'cluster.localStorage.capacity.notificationthreshold'
> , .75, 'Percentage (as a value between 0 and 1) of local storage
> utilization above which alerts will be sent about low local storage
> available.')
> 2013-05-01 12:27:45,471 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server',
> 'zone.directnetwork.publicip.capacity.notificationthreshold' , .75,
> 'Percentage (as a value between 0 and 1) of Direct Network Public Ip
> Utilization above which alerts will be sent about low number of direct
> network public ips.')
> 2013-05-01 12:27:45,471 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT',
> 'management-server', 'zone.secstorage.capacity.notificationthreshold' ,
> .75, 'Percentage (as a value between 0 and 1) of secondary storage
> utilization above which alerts will be sent about low storage available.')
> 2013-05-01 12:27:45,472 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'custom.diskoffering.size.min', '1', 'Minimum size in
> GB for custom disk offering')
> 2013-05-01 12:27:45,472 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'custom.diskoffering.size.max', '1024', 'Maximum size
> in GB for custom disk offering')
> 2013-05-01 12:27:45,472 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'system.vm.random.password', 'false', 'Randomize
> system vm password the first time management server starts')
> 2013-05-01 12:27:45,477 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 'DEFAULT',
> 'management-server', 'network.securitygroups.defaultadding' , 'true', 'If
> true, the user VM would be added to the default security group by default')
> 2013-05-01 12:27:45,477 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set name =
> 'cluster.storage.allocated.capacity.notificationthreshold' , category =
> 'Alert' where name = 'storage.allocated.capacity.threshold'
> 2013-05-01 12:27:45,480 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set name =
> 'cluster.storage.capacity.notificationthreshold' , category = 'Alert' where
> name = 'storage.capacity.threshold'
> 2013-05-01 12:27:45,481 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set name =
> 'cluster.cpu.allocated.capacity.notificationthreshold' , category = 'Alert'
> where name = 'cpu.capacity.threshold'
> 2013-05-01 12:27:45,481 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set name =
> 'cluster.memory.allocated.capacity.notificationthreshold' , category =
> 'Alert' where name = 'memory.capacity.threshold'
> 2013-05-01 12:27:45,482 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set name =
> 'zone.virtualnetwork.publicip.capacity.notificationthreshold' , category =
> 'Alert' where name = 'public.ip.capacity.threshold'
> 2013-05-01 12:27:45,482 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set name =
> 'pod.privateip.capacity.notificationthreshold' , category = 'Alert' where
> name = 'private.ip.capacity.threshold'
> 2013-05-01 12:27:45,483 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain_router` ADD COLUMN `template_version` varchar(100)
> COMMENT 'template version' AFTER role
> 2013-05-01 12:27:45,531 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain_router` ADD COLUMN `scripts_version` varchar(100)
> COMMENT 'scripts version' AFTER template_version
> 2013-05-01 12:27:45,568 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`alert` ADD `cluster_id` bigint unsigned
> 2013-05-01 12:27:45,605 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user_statistics` ADD COLUMN `agg_bytes_received` bigint
> unsigned NOT NULL default '0'
> 2013-05-01 12:27:45,644 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user_statistics` ADD COLUMN `agg_bytes_sent` bigint unsigned
> NOT NULL default '0'
> 2013-05-01 12:27:45,701 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vm_instance` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:45,744 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vm_instance` ADD CONSTRAINT `uc_vm_instance_uuid` UNIQUE
> (`uuid`)
> 2013-05-01 12:27:46,189 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`async_job` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,230 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`async_job` ADD CONSTRAINT `uc_async__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:46,232 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.CloudStackAccountDaoImpl_EnhancerByCloudStack_61c90143
> 2013-05-01 12:27:46,235 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.OfferingDaoImpl_EnhancerByCloudStack_f6d3709d
> 2013-05-01 12:27:46,236 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.SMetaDaoImpl_EnhancerByCloudStack_137a6095
> 2013-05-01 12:27:46,236 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.MultipartMetaDaoImpl_EnhancerByCloudStack_fae2e354
> 2013-05-01 12:27:46,236 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.UserCredentialsDaoImpl_EnhancerByCloudStack_b47c2bb4
> 2013-05-01 12:27:46,236 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.CloudStackConfigurationDaoImpl_EnhancerByCloudStack_22ae7372
> 2013-05-01 12:27:46,237 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.BucketPolicyDaoImpl_EnhancerByCloudStack_7a48dd37
> 2013-05-01 12:27:46,237 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.SObjectItemDaoImpl_EnhancerByCloudStack_5e5b9500
> 2013-05-01 12:27:46,237 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.MHostMountDaoImpl_EnhancerByCloudStack_b35ec90f
> 2013-05-01 12:27:46,238 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_2546eb50
> 2013-05-01 12:27:46,238 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.MultiPartUploadsDaoImpl_EnhancerByCloudStack_e0bb907d
> 2013-05-01 12:27:46,238 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.SBucketDaoImpl_EnhancerByCloudStack_b1f7cd48
> 2013-05-01 12:27:46,238 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.SAclDaoImpl_EnhancerByCloudStack_24e6a5c4
> 2013-05-01 12:27:46,239 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.MultiPartPartsDaoImpl_EnhancerByCloudStack_acb5baff
> 2013-05-01 12:27:46,243 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.CloudStackSvcOfferingDaoImpl_EnhancerByCloudStack_ac0ba762
> 2013-05-01 12:27:46,243 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.SHostDaoImpl_EnhancerByCloudStack_4dd9619a
> 2013-05-01 12:27:46,244 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.CloudStackUserDaoImpl_EnhancerByCloudStack_300256e5
> 2013-05-01 12:27:46,244 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.persist.dao.SObjectDaoImpl_EnhancerByCloudStack_34b3d18b
> 2013-05-01 12:27:46,244 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.service.core.ec2.EC2Engine_EnhancerByCloudStack_8740b63b
> 2013-05-01 12:27:46,288 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,326 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain` ADD CONSTRAINT `uc_domain__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:46,368 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`account` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,406 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`account` ADD CONSTRAINT `uc_account__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:46,463 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`account` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,497 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,537 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user` ADD CONSTRAINT `uc_user__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:46,580 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`projects` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,617 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`projects` ADD CONSTRAINT `uc_projects__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:46,675 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`data_center` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,720 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`data_center` ADD CONSTRAINT `uc_data_center__uuid` UNIQUE
> (`uuid`)
> 2013-05-01 12:27:46,765 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,831 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host` ADD CONSTRAINT `uc_host__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:46,878 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host` ADD COLUMN `update_count` bigint unsigned NOT NULL
> DEFAULT 0 COMMENT 'atomic increase count making status update operation
> atomical'
> 2013-05-01 12:27:46,925 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vm_template` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:46,990 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vm_template` ADD CONSTRAINT `uc_vm_template__uuid` UNIQUE
> (`uuid`)
> 2013-05-01 12:27:47,035 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`disk_offering` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:47,099 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`disk_offering` ADD CONSTRAINT `uc_disk_offering__uuid`
> UNIQUE (`uuid`)
> 2013-05-01 12:27:47,145 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`networks` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:47,962 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`networks` ADD CONSTRAINT `uc_networks__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:48,008 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,061 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group` ADD CONSTRAINT `uc_security_group__uuid`
> UNIQUE (`uuid`)
> 2013-05-01 12:27:48,124 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`instance_group` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,167 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`instance_group` ADD CONSTRAINT `uc_instance_group__uuid`
> UNIQUE (`uuid`)
> 2013-05-01 12:27:48,210 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host_pod_ref` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,254 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host_pod_ref` ADD CONSTRAINT `uc_host_pod_ref__uuid` UNIQUE
> (`uuid`)
> 2013-05-01 12:27:48,317 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshots` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,355 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshots` ADD CONSTRAINT `uc_snapshots__uuid` UNIQUE
> (`uuid`)
> 2013-05-01 12:27:48,395 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshot_policy` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,431 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshot_policy` ADD CONSTRAINT `uc_snapshot_policy__uuid`
> UNIQUE (`uuid`)
> 2013-05-01 12:27:48,468 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshot_schedule` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,523 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`snapshot_schedule` ADD CONSTRAINT
> `uc_snapshot_schedule__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:48,567 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`volumes` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,614 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`volumes` ADD CONSTRAINT `uc_volumes__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:48,659 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vlan` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,721 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vlan` ADD CONSTRAINT `uc_vlan__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:48,764 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user_ip_address` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,814 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user_ip_address` ADD CONSTRAINT `uc_user_ip_address__uuid`
> UNIQUE (`uuid`)
> 2013-05-01 12:27:48,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`firewall_rules` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:48,906 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`firewall_rules` ADD CONSTRAINT `uc_firewall_rules__uuid`
> UNIQUE (`uuid`)
> 2013-05-01 12:27:48,965 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`cluster` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,011 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`cluster` ADD CONSTRAINT `uc_cluster__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,055 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,120 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD CONSTRAINT
> `uc_network_offerings__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,168 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,207 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`hypervisor_capabilities` ADD CONSTRAINT
> `uc_hypervisor_capabilities__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,249 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vpn_users` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,305 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vpn_users` ADD CONSTRAINT `uc_vpn_users__uuid` UNIQUE
> (`uuid`)
> 2013-05-01 12:27:49,342 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`event` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,398 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`event` ADD CONSTRAINT `uc_event__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,456 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`alert` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,518 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`alert` ADD CONSTRAINT `uc_alert__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,561 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`guest_os` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,606 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`guest_os` ADD CONSTRAINT `uc_guest_os__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,653 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`guest_os_category` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,693 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`guest_os_category` ADD CONSTRAINT
> `uc_guest_os_category__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,755 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`nics` ADD COLUMN `uuid` varchar(40)
> 2013-05-01 12:27:49,799 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`nics` ADD CONSTRAINT `uc_nics__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:49,843 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`op_host_capacity` ADD COLUMN `created` datetime
> 2013-05-01 12:27:49,887 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`op_host_capacity` ADD COLUMN `update_time` datetime
> 2013-05-01 12:27:49,928 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'apply.allocation.algorithm.to.pods', 'false', 'If
> true, deployment planner applies the allocation heuristics at pods first in
> the given datacenter during VM resource allocation')
> 2013-05-01 12:27:49,929 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'vm.user.dispersion.weight', 1, 'Weight for user
> dispersion heuristic (as a value between 0 and 1) applied to resource
> allocation during vm deployment. Weight for capacity heuristic will be (1 -
> weight of user dispersion)')
> 2013-05-01 12:27:49,930 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET description = '[''random'',
> ''firstfit'', ''userdispersing'', ''userconcentratedpod_random'',
> ''userconcentratedpod_firstfit''] : Order in which hosts within a cluster
> will be considered for VM/volume allocation.' WHERE name =
> 'vm.allocation.algorithm'
> 2013-05-01 12:27:49,930 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
> 2013-05-01 12:27:49,930 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> Usage db upgrade from 2.2.14 to 3.0;
> 2013-05-01 12:27:49,931 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
> 2013-05-01 12:27:49,931 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud_usage`.`usage_vpn_user` ( `zone_id` bigint unsigned
> NOT NULL, `account_id` bigint unsigned NOT NULL, `domain_id` bigint
> unsigned NOT NULL, `user_id` bigint unsigned NOT NULL, `user_name`
> varchar(32), `created` DATETIME NOT NULL, `deleted` DATETIME NULL )
> ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:49,977 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`user_statistics` ADD COLUMN `agg_bytes_received`
> bigint unsigned NOT NULL default '0'
> 2013-05-01 12:27:50,017 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`user_statistics` ADD COLUMN `agg_bytes_sent` bigint
> unsigned NOT NULL default '0'
> 2013-05-01 12:27:50,056 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_network` ADD COLUMN `agg_bytes_received` bigint
> unsigned NOT NULL default '0'
> 2013-05-01 12:27:50,093 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_network` ADD COLUMN `agg_bytes_sent` bigint
> unsigned NOT NULL default '0'
> 2013-05-01 12:27:50,129 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud_usage`.`usage_network` set agg_bytes_received =
> net_bytes_received + current_bytes_received, agg_bytes_sent =
> net_bytes_sent + current_bytes_sent
> 2013-05-01 12:27:50,130 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_vpn_user` ADD INDEX
> `i_usage_vpn_user__account_id`(`account_id`)
> 2013-05-01 12:27:50,186 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_vpn_user` ADD INDEX
> `i_usage_vpn_user__created`(`created`)
> 2013-05-01 12:27:50,223 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_vpn_user` ADD INDEX
> `i_usage_vpn_user__deleted`(`deleted`)
> 2013-05-01 12:27:50,260 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_ip_address` ADD COLUMN `is_system` smallint(1)
> NOT NULL default '0'
> 2013-05-01 12:27:50,297 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Premium', 'DEFAULT',
> 'management-server', 'usage.sanity.check.interval', null, 'Interval (in
> days) to check sanity of usage data')
> 2013-05-01 12:27:50,298 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`configuration` WHERE name='host.capacity.checker.wait'
> 2013-05-01 12:27:50,299 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`configuration` WHERE
> name='host.capacity.checker.interval'
> 2013-05-01 12:27:50,299 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'disable.extraction' , 'false', 'Flag for disabling
> extraction of template, isos and volumes')
> 2013-05-01 12:27:50,300 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'NetworkManager', 'router.check.interval' , '30', 'Interval (in seconds) to
> report redundant router status.')
> 2013-05-01 12:27:50,300 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_ingress_rule` RENAME TO
> `cloud`.`security_group_rule`
> 2013-05-01 12:27:50,318 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD COLUMN `type` varchar(10) default
> 'ingress' AFTER security_group_id
> 2013-05-01 12:27:50,360 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD COLUMN `uuid` varchar(40) AFTER id
> 2013-05-01 12:27:50,403 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD CONSTRAINT
> `uc_security_group_rule__uuid` UNIQUE (`uuid`)
> 2013-05-01 12:27:50,463 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD CONSTRAINT
> `fk_security_group_rule___security_group_id` FOREIGN KEY
> `fk_security_group_rule__security_group_id` (`security_group_id`)
> REFERENCES `security_group` (`id`) ON DELETE CASCADE
> 2013-05-01 12:27:50,497 INFO [utils.component.ComponentContext]
> (main:null) Configuring
> com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_b27150b0
> 2013-05-01 12:27:50,508 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD CONSTRAINT
> `fk_security_group_rule___allowed_network_id` FOREIGN KEY
> `fk_security_group_rule__allowed_network_id` (`allowed_network_id`)
> REFERENCES `security_group` (`id`) ON DELETE CASCADE
> 2013-05-01 12:27:50,565 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD INDEX
> `i_security_group_rule_network_id`(`security_group_id`)
> 2013-05-01 12:27:50,609 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`security_group_rule` ADD INDEX
> `i_security_group_rule_allowed_network`(`allowed_network_id`)
> 2013-05-01 12:27:50,653 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vm_template` ADD COLUMN `enable_sshkey` int(1) unsigned NOT
> NULL default 0 COMMENT 'true if this template supports sshkey reset'
> 2013-05-01 12:27:50,716 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vm_template` ADD COLUMN `sort_key` int(32) NOT NULL default
> 0 COMMENT 'sort key used for customising sort method'
> 2013-05-01 12:27:50,761 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`disk_offering` ADD COLUMN `sort_key` int(32) NOT NULL
> default 0 COMMENT 'sort key used for customising sort method'
> 2013-05-01 12:27:50,824 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`service_offering` ADD COLUMN `sort_key` int(32) NOT NULL
> default 0 COMMENT 'sort key used for customising sort method'
> 2013-05-01 12:27:50,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
> 2013-05-01 12:27:50,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---
> Resource State;
> 2013-05-01 12:27:50,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
> 2013-05-01 12:27:50,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`host` ADD COLUMN `resource_state` varchar(32) NOT NULL
> DEFAULT 'Enabled' COMMENT 'Is this host enabled for allocation for new
> resources'
> 2013-05-01 12:27:50,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`host` SET resource_state=allocation_state WHERE status !=
> 'PrepareForMaintenance' AND status != 'ErrorInMaintenance' AND status !=
> 'Maintenance'
> 2013-05-01 12:27:50,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`host` SET resource_state='PrepareForMaintenance',
> status='Disconnected' WHERE status = 'PrepareForMaintenance'
> 2013-05-01 12:27:50,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`host` SET resource_state='ErrorInMaintenance',
> status='Disconnected' WHERE status = 'ErrorInMaintenance'
> 2013-05-01 12:27:50,916 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`host` SET resource_state='Maintenance',
> status='Disconnected' WHERE status = 'Maintenance'
> 2013-05-01 12:27:50,916 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
> 2013-05-01 12:27:50,916 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---
> Storage network
> 2013-05-01 12:27:50,916 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
> 2013-05-01 12:27:50,917 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`networks` set guru_name='StorageNetworkGuru' where
> traffic_type='Storage'
> 2013-05-01 12:27:50,917 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set value=NULL where
> name='xen.storage.network.device1' and value='cloud-stor1'
> 2013-05-01 12:27:50,918 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`configuration` set value=NULL where
> name='xen.storage.network.device2' and value='cloud-stor2'
> 2013-05-01 12:27:50,918 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
> 2013-05-01 12:27:50,918 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> --NAAS;
> 2013-05-01 12:27:50,919 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
> 2013-05-01 12:27:50,919 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`ntwk_service_map` ( `id` bigint unsigned NOT NULL
> auto_increment, `network_id` bigint unsigned NOT NULL COMMENT
> 'network_id', `service` varchar(255) NOT NULL COMMENT 'service',
> `provider` varchar(255) COMMENT 'service provider', `created` datetime
> COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT
> `fk_ntwk_service_map__network_id` FOREIGN KEY(`network_id`) REFERENCES
> `networks`(`id`) ON DELETE CASCADE, UNIQUE (`network_id`, `service`) )
> ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:50,965 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`physical_network` ( `id` bigint unsigned NOT NULL
> AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40), `name` varchar(255)
> NOT NULL, `data_center_id` bigint unsigned NOT NULL COMMENT 'data center
> id that this physical network belongs to', `vnet` varchar(255), `speed`
> varchar(32), `domain_id` bigint unsigned COMMENT 'foreign key to domain
> id', `broadcast_domain_range` varchar(32) NOT NULL DEFAULT 'POD' COMMENT
> 'range of broadcast domain : POD/ZONE', `state` varchar(32) NOT NULL
> DEFAULT 'Disabled' COMMENT 'what state is this configuration in',
> `created` datetime COMMENT 'date created', `removed` datetime COMMENT
> 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT
> `fk_physical_network__data_center_id` FOREIGN KEY (`data_center_id`)
> REFERENCES `data_center`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_physical_network__domain_id` FOREIGN KEY(`domain_id`) REFERENCES
> `domain`(`id`), CONSTRAINT `uc_physical_networks__uuid` UNIQUE (`uuid`),
> INDEX `i_physical_network__removed`(`removed`) ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:50,987 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`physical_network_tags` ( `id` bigint unsigned NOT
> NULL AUTO_INCREMENT COMMENT 'id', `physical_network_id` bigint unsigned
> NOT NULL COMMENT 'id of the physical network', `tag` varchar(255) NOT
> NULL COMMENT 'tag', PRIMARY KEY (`id`), CONSTRAINT
> `fk_physical_network_tags__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE
> CASCADE, UNIQUE KEY(`physical_network_id`, `tag`) ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:51,004 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`physical_network_isolation_methods` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `physical_network_id`
> bigint unsigned NOT NULL COMMENT 'id of the physical network',
> `isolation_method` varchar(255) NOT NULL COMMENT 'isolation method(VLAN, L3
> or GRE)', PRIMARY KEY (`id`), CONSTRAINT
> `fk_physical_network_imethods__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE
> CASCADE, UNIQUE KEY(`physical_network_id`, `isolation_method`) )
> ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:51,021 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`physical_network_traffic_types` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40),
> `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical
> network', `traffic_type` varchar(32) NOT NULL COMMENT 'type of traffic
> going through this network', `xen_network_label` varchar(255) COMMENT
> 'The network name label of the physical device dedicated to this traffic on
> a XenServer host', `kvm_network_label` varchar(255) DEFAULT 'cloudbr0'
> COMMENT 'The network name label of the physical device dedicated to this
> traffic on a KVM host', `vmware_network_label` varchar(255) DEFAULT
> 'vSwitch0' COMMENT 'The network name label of the physical device dedicated
> to this traffic on a VMware host', `simulator_network_label` varchar(255)
> COMMENT 'The name labels needed for identifying the simulator',
> `ovm_network_label` varchar(255) COMMENT 'The network name label of the
> physical device dedicated to this traffic on a Ovm host', `vlan`
> varchar(255) COMMENT 'The vlan tag to be sent down to a VMware host',
> PRIMARY KEY (`id`), CONSTRAINT
> `fk_physical_network_traffic_types__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE
> CASCADE, CONSTRAINT `uc_traffic_types__uuid` UNIQUE (`uuid`), UNIQUE
> KEY(`physical_network_id`, `traffic_type`) ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:51,039 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`physical_network_service_providers` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40),
> `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical
> network', `provider_name` varchar(255) NOT NULL COMMENT 'Service Provider
> name', `state` varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'provider
> state', `destination_physical_network_id` bigint unsigned COMMENT 'id of
> the physical network to bridge to', `vpn_service_provided` tinyint(1)
> unsigned NOT NULL DEFAULT 0 COMMENT 'Is VPN service provided',
> `dhcp_service_provided` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'Is
> DHCP service provided', `dns_service_provided` tinyint(1) unsigned NOT
> NULL DEFAULT 0 COMMENT 'Is DNS service provided',
> `gateway_service_provided` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT
> 'Is Gateway service provided', `firewall_service_provided` tinyint(1)
> unsigned NOT NULL DEFAULT 0 COMMENT 'Is Firewall service provided',
> `source_nat_service_provided` tinyint(1) unsigned NOT NULL DEFAULT 0
> COMMENT 'Is Source NAT service provided', `load_balance_service_provided`
> tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'Is LB service provided',
> `static_nat_service_provided` tinyint(1) unsigned NOT NULL DEFAULT 0
> COMMENT 'Is Static NAT service provided',
> `port_forwarding_service_provided` tinyint(1) unsigned NOT NULL DEFAULT 0
> COMMENT 'Is Port Forwarding service provided',
> `user_data_service_provided` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT
> 'Is UserData service provided', `security_group_service_provided`
> tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'Is SG service provided',
> PRIMARY KEY (`id`), CONSTRAINT
> `fk_pnetwork_service_providers__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE
> CASCADE, CONSTRAINT `uc_service_providers__uuid` UNIQUE (`uuid`),
> UNIQUE KEY(`physical_network_id`, `provider_name`) ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:51,075 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`external_load_balancer_devices` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255)
> UNIQUE, `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the
> physical network in to which load balancer device is added',
> `provider_name` varchar(255) NOT NULL COMMENT 'Service Provider name
> corresponding to this load balancer device', `device_name` varchar(255)
> NOT NULL COMMENT 'name of the load balancer device', `capacity` bigint
> unsigned NOT NULL DEFAULT 0 COMMENT 'Capacity of the load balancer device',
> `device_state` varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'state
> (enabled/disabled/shutdown) of the device', `allocation_state`
> varchar(32) NOT NULL DEFAULT 'Free' COMMENT 'Allocation state
> (Free/Shared/Dedicated/Provider) of the device', `is_dedicated` int(1)
> unsigned NOT NULL DEFAULT 0 COMMENT '1 if device/appliance is provisioned
> for dedicated use only', `is_inline` int(1) unsigned NOT NULL DEFAULT 0
> COMMENT '1 if load balancer will be used in in-line configuration with
> firewall', `is_managed` int(1) unsigned NOT NULL DEFAULT 0 COMMENT '1 if
> load balancer appliance is provisioned and its life cycle is managed by by
> cloudstack', `host_id` bigint unsigned NOT NULL COMMENT 'host id
> coresponding to the external load balancer device', `parent_host_id`
> bigint unsigned COMMENT 'if the load balancer appliance is cloudstack
> managed, then host id on which this appliance is provisioned', PRIMARY
> KEY (`id`), CONSTRAINT `fk_external_lb_devices_host_id` FOREIGN KEY
> (`host_id`) REFERENCES `host`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_external_lb_devices_parent_host_id` FOREIGN KEY (`host_id`) REFERENCES
> `host`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_external_lb_devices_physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE
> CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:51,102 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`external_firewall_devices` ( `id` bigint unsigned
> NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255) UNIQUE,
> `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical
> network in to which firewall device is added', `provider_name`
> varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this
> firewall device', `device_name` varchar(255) NOT NULL COMMENT 'name of
> the firewall device', `device_state` varchar(32) NOT NULL DEFAULT
> 'Disabled' COMMENT 'state (enabled/disabled/shutdown) of the device',
> `is_dedicated` int(1) unsigned NOT NULL DEFAULT 0 COMMENT '1 if
> device/appliance meant for dedicated use only', `allocation_state`
> varchar(32) NOT NULL DEFAULT 'Free' COMMENT 'Allocation state
> (Free/Allocated) of the device', `host_id` bigint unsigned NOT NULL
> COMMENT 'host id coresponding to the external firewall device',
> `capacity` bigint unsigned NOT NULL DEFAULT 0 COMMENT 'Capacity of the
> external firewall device', PRIMARY KEY (`id`), CONSTRAINT
> `fk_external_firewall_devices__host_id` FOREIGN KEY (`host_id`) REFERENCES
> `host`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_external_firewall_devices__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE
> CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:51,126 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`network_external_lb_device_map` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255)
> UNIQUE, `network_id` bigint unsigned NOT NULL COMMENT ' guest network
> id', `external_load_balancer_device_id` bigint unsigned NOT NULL COMMENT
> 'id of external load balancer device assigned for this network',
> `created` datetime COMMENT 'Date from when network started using the
> device', `removed` datetime COMMENT 'Date till the network stopped using
> the device ', PRIMARY KEY (`id`), CONSTRAINT
> `fk_network_external_lb_devices_network_id` FOREIGN KEY (`network_id`)
> REFERENCES `networks`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_network_external_lb_devices_device_id` FOREIGN KEY
> (`external_load_balancer_device_id`) REFERENCES
> `external_load_balancer_devices`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB
> DEFAULT CHARSET=utf8
> 2013-05-01 12:27:51,486 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`network_external_firewall_device_map` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255)
> UNIQUE, `network_id` bigint unsigned NOT NULL COMMENT ' guest network
> id', `external_firewall_device_id` bigint unsigned NOT NULL COMMENT 'id
> of external firewall device assigned for this device', `created` datetime
> COMMENT 'Date from when network started using the device', `removed`
> datetime COMMENT 'Date till the network stopped using the device ',
> PRIMARY KEY (`id`), CONSTRAINT
> `fk_network_external_firewall_devices_network_id` FOREIGN KEY
> (`network_id`) REFERENCES `networks`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_network_external_firewall_devices_device_id` FOREIGN KEY
> (`external_firewall_device_id`) REFERENCES
> `external_firewall_devices`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:51,510 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`virtual_router_providers` ( `id` bigint unsigned
> NOT NULL auto_increment COMMENT 'id', `nsp_id` bigint unsigned NOT NULL
> COMMENT 'Network Service Provider ID', `uuid` varchar(40), `type`
> varchar(255) NOT NULL COMMENT 'Virtual router, or ElbVM', `enabled`
> int(1) NOT NULL COMMENT 'Enabled or disabled', `removed` datetime COMMENT
> 'date removed if not null', PRIMARY KEY (`id`), CONSTRAINT
> `fk_virtual_router_providers__nsp_id` FOREIGN KEY (`nsp_id`) REFERENCES
> `physical_network_service_providers` (`id`) ON DELETE CASCADE, CONSTRAINT
> `uc_virtual_router_providers__uuid` UNIQUE (`uuid`) ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:51,529 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain_router` ADD COLUMN `element_id` bigint unsigned NOT
> NULL COMMENT 'correlated virtual router provider ID' AFTER id
> 2013-05-01 12:27:51,591 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT INTO `cloud`.`sequence` (name, value) VALUES
> ('physical_networks_seq', 200)
> 2013-05-01 12:27:51,592 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`networks` ADD COLUMN `physical_network_id` bigint unsigned
> COMMENT 'physical network id that this configuration is based on' AFTER
> network_offering_id
> 2013-05-01 12:27:51,647 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`vlan` ADD COLUMN `physical_network_id` bigint unsigned NOT
> NULL COMMENT 'physical network id that this configuration is based on'
> 2013-05-01 12:27:51,689 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`op_dc_vnet_alloc` ADD COLUMN `physical_network_id` bigint
> unsigned NOT NULL COMMENT 'physical network the vnet belongs to'
> 2013-05-01 12:27:51,725 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user_ip_address` ADD COLUMN `physical_network_id` bigint
> unsigned NOT NULL COMMENT 'physical network id that this configuration is
> based on'
> 2013-05-01 12:27:51,794 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`networks` ADD COLUMN `restart_required` int(1) unsigned NOT
> NULL DEFAULT 0 COMMENT '1 if restart is required for the network'
> 2013-05-01 12:27:51,839 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`configuration` where name='cmd.wait'
> 2013-05-01 12:27:51,839 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` set value='true' where
> name='firewall.rule.ui.enabled'
> 2013-05-01 12:27:51,840 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`op_user_stats_log` ( `user_stats_id` bigint
> unsigned NOT NULL, `net_bytes_received` bigint unsigned NOT NULL default
> '0', `net_bytes_sent` bigint unsigned NOT NULL default '0',
> `current_bytes_received` bigint unsigned NOT NULL default '0',
> `current_bytes_sent` bigint unsigned NOT NULL default '0',
> `agg_bytes_received` bigint unsigned NOT NULL default '0',
> `agg_bytes_sent` bigint unsigned NOT NULL default '0', `updated` datetime
> COMMENT 'stats update timestamp', UNIQUE KEY (`user_stats_id`, `updated`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:51,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
> 2013-05-01 12:27:51,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
> Network offerings
> 2013-05-01 12:27:51,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
> 2013-05-01 12:27:51,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `sort_key` int(32) NOT NULL
> default 0 COMMENT 'sort key used for customising sort method'
> 2013-05-01 12:27:51,933 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `dedicated_lb_service` int(1)
> unsigned NOT NULL DEFAULT 1 COMMENT 'true if the network offering provides
> a dedicated load balancer for each network'
> 2013-05-01 12:27:51,984 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `redundant_router_service`
> int(1) unsigned NOT NULL DEFAULT 0 COMMENT 'true if the network offering
> provides the redundant router service'
> 2013-05-01 12:27:52,031 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `conserve_mode` int(1)
> unsigned NOT NULL DEFAULT 1 COMMENT 'Is this network offering is IP
> conserve mode enabled'
> 2013-05-01 12:27:52,096 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` MODIFY `name` varchar(64) COMMENT 'name
> of the network offering'
> 2013-05-01 12:27:52,143 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` MODIFY `unique_name` varchar(64) COMMENT
> 'unique name of the network offering'
> 2013-05-01 12:27:52,206 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` MODIFY `service_offering_id` bigint
> unsigned COMMENT 'service offering id that virtual router is tied to'
> 2013-05-01 12:27:52,219 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` DROP KEY `service_offering_id`
> 2013-05-01 12:27:52,282 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` DROP `concurrent_connections`
> 2013-05-01 12:27:52,327 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `state` char(32) COMMENT
> 'state of the network offering that has Disabled value by default'
> 2013-05-01 12:27:52,392 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `state`='Enabled'
> 2013-05-01 12:27:52,393 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `state`='Disabled' where
> `availability`='Unavailable'
> 2013-05-01 12:27:52,393 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `availability`='Optional' where
> `availability`='Unavailable'
> 2013-05-01 12:27:52,394 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `system_only`=0 where
> `traffic_type`='Guest'
> 2013-05-01 12:27:52,394 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `specify_vlan`=1 where
> `unique_name`='System-Guest-Network'
> 2013-05-01 12:27:52,395 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET
> `unique_name`='DefaultSharedNetworkOfferingWithSGService' where
> `unique_name`='System-Guest-Network'
> 2013-05-01 12:27:52,395 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET
> `unique_name`='DefaultIsolatedNetworkOfferingWithSourceNatService' where
> `unique_name`='DefaultVirtualizedNetworkOffering'
> 2013-05-01 12:27:52,396 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET
> `unique_name`='DefaultSharedNetworkOffering' where
> `unique_name`='DefaultDirectNetworkOffering'
> 2013-05-01 12:27:52,396 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET
> `name`='DefaultSharedNetworkOfferingWithSGService' where
> `name`='System-Guest-Network'
> 2013-05-01 12:27:52,397 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET
> `name`='DefaultIsolatedNetworkOfferingWithSourceNatService' where
> `name`='DefaultVirtualizedNetworkOffering'
> 2013-05-01 12:27:52,397 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET
> `name`='DefaultSharedNetworkOffering' where
> `name`='DefaultDirectNetworkOffering'
> 2013-05-01 12:27:52,398 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `guest_type`='Shared' where
> `guest_type`='Direct'
> 2013-05-01 12:27:52,399 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `guest_type`='Isolated' where
> `guest_type`='Virtual'
> 2013-05-01 12:27:52,399 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET `availability`='Optional' where
> `availability`='Required' and `guest_type`='Shared'
> 2013-05-01 12:27:52,400 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `elastic_ip_service` int(1)
> unsigned NOT NULL DEFAULT '0' COMMENT 'true if the network offering
> provides elastic ip service'
> 2013-05-01 12:27:52,614 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `elastic_lb_service` int(1)
> unsigned NOT NULL DEFAULT '0' COMMENT 'true if the network offering
> provides elastic lb service'
> 2013-05-01 12:27:52,660 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`network_offerings` ADD COLUMN `specify_ip_ranges` int(1)
> unsigned NOT NULL DEFAULT '0' COMMENT 'true if the network offering
> provides an ability to define ip ranges'
>
> 2013-05-01 12:27:52,723 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`networks` ADD COLUMN `specify_ip_ranges` int(1) unsigned NOT
> NULL DEFAULT '0' COMMENT 'true if the network provides an ability to define
> ip ranges'
> 2013-05-01 12:27:52,768 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` SET specify_ip_ranges=(SELECT specify_ip_ranges
> from `cloud`.`network_offerings` no where no.id=network_offering_id)
> 2013-05-01 12:27:52,769 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> insert into `cloud`.`network_offerings` (`name`, `unique_name`,
> `display_text`, `traffic_type`, `system_only`, `specify_vlan`, `default`,
> `availability`, `state`, `guest_type`, `created`, `userdata_service`,
> `dns_service`, `dhcp_service`) values ('DefaultIsolatedNetworkOffering',
> 'DefaultIsolatedNetworkOffering', 'Offering for Isolated networks with no
> Source Nat service', 'Guest', 0, 1, 1, 'Optional', 'Enabled', 'Isolated',
> now(), 1, 1, 1)
> 2013-05-01 12:27:52,770 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` set specify_ip_ranges=1 where name in
> ('System-Public-Network', 'System-Storage-Network',
> 'DefaultSharedNetworkOfferingWithSGService',
> 'DefaultSharedNetworkOffering', 'DefaultIsolatedNetworkOffering')
> 2013-05-01 12:27:52,770 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`ntwk_offering_service_map` ( `id` bigint unsigned
> NOT NULL auto_increment, `network_offering_id` bigint unsigned NOT NULL
> COMMENT 'network_offering_id', `service` varchar(255) NOT NULL COMMENT
> 'service', `provider` varchar(255) COMMENT 'service provider',
> `created` datetime COMMENT 'date created', PRIMARY KEY (`id`),
> CONSTRAINT `fk_ntwk_offering_service_map__network_offering_id` FOREIGN
> KEY(`network_offering_id`) REFERENCES `cloud`.`network_offerings`(`id`) ON
> DELETE CASCADE, UNIQUE (`network_offering_id`, `service`, `provider`) )
> ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:52,797 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`dc_storage_network_ip_range` ( `id` bigint unsigned
> NOT NULL UNIQUE AUTO_INCREMENT, `uuid` varchar(40), `start_ip` char(40)
> NOT NULL COMMENT 'start ip address', `end_ip` char(40) NOT NULL COMMENT
> 'end ip address', `vlan` int unsigned DEFAULT NULL COMMENT 'vlan the
> storage network on', `netmask` varchar(15) NOT NULL COMMENT 'netmask for
> storage network', `data_center_id` bigint unsigned NOT NULL, `pod_id`
> bigint unsigned NOT NULL COMMENT 'pod it belongs to', `network_id` bigint
> unsigned NOT NULL COMMENT 'id of corresponding network offering', PRIMARY
> KEY (`id`), CONSTRAINT `fk_storage_ip_range__network_id` FOREIGN KEY
> (`network_id`) REFERENCES `networks`(`id`), CONSTRAINT
> `fk_storage_ip_range__data_center_id` FOREIGN KEY (`data_center_id`)
> REFERENCES `data_center`(`id`), CONSTRAINT `fk_storage_ip_range__pod_id`
> FOREIGN KEY (`pod_id`) REFERENCES `host_pod_ref`(`id`), CONSTRAINT
> `uc_storage_ip_range__uuid` UNIQUE (`uuid`) ) ENGINE=InnoDB DEFAULT
> CHARSET=utf8
> 2013-05-01 12:27:52,849 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`op_dc_storage_network_ip_address` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key', `range_id` bigint
> unsigned NOT NULL COMMENT 'id of ip range in dc_storage_network_ip_range',
> `ip_address` char(40) NOT NULL COMMENT 'ip address', `mac_address`
> bigint unsigned NOT NULL COMMENT 'mac address for storage ips', `taken`
> datetime COMMENT 'Date taken', PRIMARY KEY (`id`), CONSTRAINT
> `fk_storage_ip_address__range_id` FOREIGN KEY (`range_id`) REFERENCES
> `dc_storage_network_ip_range`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB
> DEFAULT CHARSET=utf8
> 2013-05-01 12:27:52,866 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`event` ADD COLUMN `domain_id` bigint unsigned NOT NULL
> 2013-05-01 12:27:52,924 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`op_host_capacity` ADD COLUMN `capacity_state` varchar(32)
> NOT NULL DEFAULT 'Enabled'
> 2013-05-01 12:27:52,967 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`event` set account_id=1, user_id=1 where account_id=0 and
> user_id=0
> 2013-05-01 12:27:52,968 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`event` e set e.domain_id = (select acc.domain_id from
> `cloud`.`account` acc where acc.id = e.account_id) where e.domain_id = 0
> 2013-05-01 12:27:52,971 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> update `cloud`.`vm_template` set removed=now() where id=2
> 2013-05-01 12:27:52,971 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT INTO `cloud`.`vm_template` (id, unique_name, name, public, created,
> type, hvm, bits, account_id, url, checksum, enable_password, display_text,
> format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
> VALUES (5, 'centos56-x86_64-xen', 'CentOS 5.6(64-bit) no GUI
> (XenServer)', 1, now(), 'BUILTIN', 0, 64, 1, '
> http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2',
> '905cec879afd9c9d22ecc8036131a180', 0, 'CentOS 5.6(64-bit) no GUI
> (XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1)
> 2013-05-01 12:27:52,972 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE from `cloud`.`configuration` where name='firewall.rule.ui.enabled'
> 2013-05-01 12:27:52,973 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`resource_limit` WHERE domain_id = 1 AND account_id IS
> NULL
> 2013-05-01 12:27:52,973 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`networks` ADD COLUMN `acl_type` varchar(15) COMMENT 'ACL
> access type. Null for system networks, can be Account/Domain for Guest
> networks'
> 2013-05-01 12:27:53,053 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` SET acl_type='Domain' where guest_type is not
> null and shared=1
> 2013-05-01 12:27:53,054 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` SET acl_type='Account' where guest_type='Virtual'
> 2013-05-01 12:27:53,055 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` SET acl_type='Account' where guest_type='Direct'
> and shared=0
> 2013-05-01 12:27:53,056 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain_network_ref` ADD COLUMN `subdomain_access` int(1)
> unsigned COMMENT '1 if network can be accessible from the subdomain'
> 2013-05-01 12:27:53,104 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` SET specify_ip_ranges=(SELECT specify_ip_ranges
> FROM `cloud`.`network_offerings` no where no.id=network_offering_id)
> 2013-05-01 12:27:53,105 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`configuration` WHERE name='network.redundantrouter'
> 2013-05-01 12:27:53,106 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'xen.public.network.device'
> 2013-05-01 12:27:53,106 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'xen.storage.network.device1'
> 2013-05-01 12:27:53,107 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'xen.storage.network.device2'
> 2013-05-01 12:27:53,108 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'xen.private.network.device'
> 2013-05-01 12:27:53,109 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'xen.guest.network.device'
> 2013-05-01 12:27:53,110 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'vmware.private.vswitch'
> 2013-05-01 12:27:53,110 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'vmware.public.vswitch'
> 2013-05-01 12:27:53,111 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'vmware.guest.vswitch'
> 2013-05-01 12:27:53,112 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'ovm.public.network.device'
> 2013-05-01 12:27:53,113 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'ovm.private.network.device'
> 2013-05-01 12:27:53,114 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'ovm.guest.network.device'
> 2013-05-01 12:27:53,114 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'kvm.public.network.device'
> 2013-05-01 12:27:53,115 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'kvm.private.network.device'
> 2013-05-01 12:27:53,116 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name =
> 'kvm.guest.network.device'
> 2013-05-01 12:27:53,121 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`dc_storage_network_ip_range` ADD COLUMN `gateway`
> varchar(15) NOT NULL COMMENT 'gateway ip address'
> 2013-05-01 12:27:53,169 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`volumes` ADD COLUMN `last_pool_id` bigint unsigned
> 2013-05-01 12:27:53,215 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`volumes` SET `last_pool_id` = `pool_id`
> 2013-05-01 12:27:53,217 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`user_ip_address` ADD COLUMN `is_system` int(1) unsigned NOT
> NULL default '0'
> 2013-05-01 12:27:53,278 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`volumes` ADD COLUMN `update_count` bigint unsigned NOT NULL
> DEFAULT 0
> 2013-05-01 12:27:53,341 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`volumes` ADD INDEX `i_volumes__update_count`(`update_count`)
> 2013-05-01 12:27:53,386 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`firewall_rules` ADD COLUMN `type` varchar(10) NOT NULL
> DEFAULT 'USER'
> 2013-05-01 12:27:53,425 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud`.`account_details` ( `id` bigint unsigned NOT NULL
> auto_increment, `account_id` bigint unsigned NOT NULL COMMENT 'account
> id', `name` varchar(255) NOT NULL, `value` varchar(255) NOT NULL,
> PRIMARY KEY (`id`), CONSTRAINT `fk_account_details__account_id` FOREIGN
> KEY (`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE
> )ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:53,442 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DROP
> TABLE IF EXISTS `cloud_usage`.`usage_security_group`
> 2013-05-01 12:27:53,449 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> CREATE TABLE `cloud_usage`.`usage_security_group` ( `zone_id` bigint
> unsigned NOT NULL, `account_id` bigint unsigned NOT NULL, `domain_id`
> bigint unsigned NOT NULL, `vm_instance_id` bigint unsigned NOT NULL,
> `security_group_id` bigint unsigned NOT NULL, `created` DATETIME NOT
> NULL, `deleted` DATETIME NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-05-01 12:27:53,466 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_security_group` ADD INDEX
> `i_usage_security_group__account_id`(`account_id`)
> 2013-05-01 12:27:53,521 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_security_group` ADD INDEX
> `i_usage_security_group__created`(`created`)
> 2013-05-01 12:27:53,559 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud_usage`.`usage_security_group` ADD INDEX
> `i_usage_security_group__deleted`(`deleted`)
> 2013-05-01 12:27:53,595 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Usage' where name in
> ('usage.execution.timezone', 'usage.stats.job.aggregation.range',
> 'usage.stats.job.exec.time', 'enable.usage.server',
> 'direct.network.stats.interval', 'usage.sanity.check.interval',
> 'usage.aggregation.timezone')
> 2013-05-01 12:27:53,596 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`op_dc_vnet_alloc` ADD CONSTRAINT
> `fk_op_dc_vnet_alloc__data_center_id` FOREIGN KEY (`data_center_id`)
> REFERENCES `data_center`(`id`) ON DELETE CASCADE
> 2013-05-01 12:27:53,645 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> TABLE `cloud`.`domain` ADD COLUMN `type` varchar(255) NOT NULL DEFAULT
> 'Normal' COMMENT 'type of the domain - can be Normal or Project'
> 2013-05-01 12:27:53,689 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET name='vm.destroy.forcestop' where
> name='vm.destory.forcestop'
> 2013-05-01 12:27:53,689 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'vm.destroy.forcestop', 'false', 'On destroy,
> force-stop takes this value')
> 2013-05-01 12:27:53,690 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`configuration` where name='skip.steps'
> 2013-05-01 12:27:53,690 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'external.lb.default.capacity', '50', 'default number
> of networks permitted per external load balancer device')
> 2013-05-01 12:27:53,691 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'external.firewall.default.capacity', '50', 'default
> number of networks permitted per external load firewall device')
> 2013-05-01 12:27:53,691 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'resourcecount.check.interval', '0', 'Time (in
> seconds) to wait before retrying resource count check task. Default is 0
> which is to never run the task')
> 2013-05-01 12:27:53,692 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'AgentManager', 'secstorage.proxy', null, 'http proxy used by ssvm, in
> http://username:password@proxyserver:port format')
> 2013-05-01 12:27:53,692 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'AgentManager', 'secstorage.vm.mtu.size', '1500', 'MTU size (in Byte) of
> storage network in secondary storage vms')
> 2013-05-01 12:27:53,693 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'sortkey.algorithm', 'false', 'Sort algorithm for
> those who use sort key(template, disk offering, service offering, network
> offering), true means ascending sort while false means descending sort')
> 2013-05-01 12:27:53,693 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT',
> 'management-server', 'system.vm.default.hypervisor', null, 'Hypervisor type
> used to create system vm')
> 2013-05-01 12:27:53,694 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`network_offerings` SET display_text='Offering for Shared
> Security group enabled networks' where display_text='System-Guest-Network'
> 2013-05-01 12:27:53,694 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Secure' where name in
> ('alert.smtp.password', 'network.loadbalancer.haproxy.stats.auth',
> 'security.singlesignon.key', 'project.smtp.password')
> 2013-05-01 12:27:53,695 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os` set id = 158 where id = 141
> 2013-05-01 12:27:53,696 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os` set id = 159 where id = 142
> 2013-05-01 12:27:53,696 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os` set id = 160 where id = 143
> 2013-05-01 12:27:53,697 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_template` set guest_os_id = 158 where guest_os_id = 141
> 2013-05-01 12:27:53,697 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_template` set guest_os_id = 159 where guest_os_id = 142
> 2013-05-01 12:27:53,698 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_template` set guest_os_id = 160 where guest_os_id = 143
> 2013-05-01 12:27:53,698 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_instance` set guest_os_id = 158 where guest_os_id = 141
> 2013-05-01 12:27:53,699 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_instance` set guest_os_id = 159 where guest_os_id = 142
> 2013-05-01 12:27:53,700 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_instance` set guest_os_id = 160 where guest_os_id = 143
> 2013-05-01 12:27:53,700 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 158 where
> guest_os_id = 141
> 2013-05-01 12:27:53,701 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 159 where
> guest_os_id = 142
> 2013-05-01 12:27:53,701 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 160 where
> guest_os_id = 143
> 2013-05-01 12:27:53,702 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (143, 1, 'CentOS 6.0 (32-bit)')
> 2013-05-01 12:27:53,702 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (144, 1, 'CentOS 6.0 (64-bit)')
> 2013-05-01 12:27:53,702 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (145, 3, 'Oracle Enterprise Linux 5.6 (32-bit)')
> 2013-05-01 12:27:53,703 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (146, 3, 'Oracle Enterprise Linux 5.6 (64-bit)')
> 2013-05-01 12:27:53,703 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (147, 3, 'Oracle Enterprise Linux 6.0 (32-bit)')
> 2013-05-01 12:27:53,703 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (148, 3, 'Oracle Enterprise Linux 6.0 (64-bit)')
> 2013-05-01 12:27:53,704 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (149, 4, 'Red Hat Enterprise Linux 5.6 (32-bit)')
> 2013-05-01 12:27:53,704 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (150, 4, 'Red Hat Enterprise Linux 5.6 (64-bit)')
> 2013-05-01 12:27:53,705 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (151, 5, 'SUSE Linux Enterprise Server 10 SP3 (32-bit)')
> 2013-05-01 12:27:53,705 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (152, 5, 'SUSE Linux Enterprise Server 10 SP4 (64-bit)')
> 2013-05-01 12:27:53,706 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (153, 5, 'SUSE Linux Enterprise Server 10 SP4 (32-bit)')
> 2013-05-01 12:27:53,706 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (154, 5, 'SUSE Linux Enterprise Server 11 SP1 (64-bit)')
> 2013-05-01 12:27:53,706 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (155, 5, 'SUSE Linux Enterprise Server 11 SP1 (32-bit)')
> 2013-05-01 12:27:53,707 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (156, 10, 'Ubuntu 10.10 (32-bit)')
> 2013-05-01 12:27:53,707 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> INSERT IGNORE INTO `cloud`.`guest_os` (id, category_id, display_name)
> VALUES (157, 10, 'Ubuntu 10.10 (64-bit)')
> 2013-05-01 12:27:53,707 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`guest_os` SET category_id=4 where id=131
> 2013-05-01 12:27:53,708 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` n SET n.name=(CONCAT('guestNetworkForBasicZone_',
> (SELECT name from `cloud`.`data_center` d where d.id=n.data_center_id AND
> d.networktype='Basic'))) where n.name is null and n.traffic_type='Guest'
> 2013-05-01 12:27:53,708 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`networks` n SET
> n.display_text=(CONCAT('guestNetworkForBasicZone_', (SELECT name from
> `cloud`.`data_center` d where d.id=n.data_center_id AND
> d.networktype='Basic'))) where n.display_text is null and
> n.traffic_type='Guest'
> 2013-05-01 12:27:53,709 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET description='Bypass internal dns, use
> exetrnal dns1 and dns2' WHERE name='use.external.dns'
> 2013-05-01 12:27:53,709 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category='Alert' WHERE
> name='capacity.check.period'
> 2013-05-01 12:27:53,709 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`vm_instance` SET vnc_password = '' where removed is not null
> 2013-05-01 12:27:53,710 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`host_details` where name in
> ('storage.network.device1', 'storage.network.device2')
> 2013-05-01 12:27:53,710 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> UPDATE `cloud`.`configuration` SET category = 'Hidden' where name in
> ('secondary.storage.vm', 'xen.create.pools.in.pod', 'cloud.identifier',
> 'security.hash.key', 'router.ram.size')
> 2013-05-01 12:27:53,711 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
> DELETE FROM `cloud`.`host_details` where name in
> ('storage.network.device1', 'storage.network.device2')
> 2013-05-01 12:27:53,738 DEBUG [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Adding PhysicalNetwork 200 for Zone id 1
> 2013-05-01 12:27:53,739 WARN [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Statement is com.mysql.jdbc.JDBC4PreparedStatement@5f260643: INSERT INTO
> `cloud`.`physical_network` (id, uuid, data_center_id, vnet,
> broadcast_domain_range, state, name) VALUES
> (200,'cb65771b-731f-4a8c-94cf-00138b203252',1,null,'ZONE','Enabled','ZONE01-pNtwk200')
> 2013-05-01 12:27:53,741 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Skip adding public traffic type to zone id=1
> 2013-05-01 12:27:53,741 DEBUG [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Adding PhysicalNetwork traffic types
> 2013-05-01 12:27:53,742 DEBUG [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Adding PhysicalNetwork traffic types
> 2013-05-01 12:27:53,743 DEBUG [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Adding PhysicalNetwork traffic types
> 2013-05-01 12:27:53,744 DEBUG [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Adding PhysicalNetworkServiceProvider VirtualRouter
> 2013-05-01 12:27:53,749 DEBUG [upgrade.dao.Upgrade30xBase] (Timer-1:null)
> Adding PhysicalNetworkServiceProvider SecurityGroupProvider to the physical
> network id=200
> 2013-05-01 12:27:53,751 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Adding PhysicalNetwork to op_dc_vnet_alloc
> 2013-05-01 12:27:53,752 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Adding PhysicalNetwork to VLAN
> 2013-05-01 12:27:53,753 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Adding PhysicalNetwork to user_ip_address
> 2013-05-01 12:27:53,755 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Adding PhysicalNetwork to networks
> 2013-05-01 12:27:53,756 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Encrypting the data...
> 2013-05-01 12:27:53,756 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Encrypting Config values
> 2013-05-01 12:27:53,877 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Done encrypting Config values
> 2013-05-01 12:27:53,877 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Encrypting host details
> 2013-05-01 12:27:53,879 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Done encrypting host details
> 2013-05-01 12:27:53,879 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Encrypting vm_instance vnc_password
> 2013-05-01 12:27:53,888 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Done encrypting vm_instance vnc_password
> 2013-05-01 12:27:53,888 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Encrypting user keys
> 2013-05-01 12:27:53,891 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Done encrypting user keys
> 2013-05-01 12:27:53,891 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Encrypting vpn_users password
> 2013-05-01 12:27:53,892 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Done encrypting vpn_users password
> 2013-05-01 12:27:53,892 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Done encrypting the data
> 2013-05-01 12:27:53,892 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Dropping public_ip_address keys from `cloud`.`secondary_storage_vm` and
> console_proxy tables...
> 2013-05-01 12:27:54,004 DEBUG [upgrade.dao.DbUpgradeUtils] (Timer-1:null)
> Key public_ip_address is dropped successfully from the table
> secondary_storage_vm
> 2013-05-01 12:27:54,045 DEBUG [upgrade.dao.DbUpgradeUtils] (Timer-1:null)
> Key public_ip_address is dropped successfully from the table console_proxy
> 2013-05-01 12:27:54,045 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Updating System Vm template IDs
> 2013-05-01 12:27:54,047 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Updating XenSever System Vms
> 2013-05-01 12:27:54,048 WARN [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> 3.0.0 XenServer SystemVm template not found. XenServer hypervisor is not
> used, so not failing upgrade
> 2013-05-01 12:27:54,048 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null)
> Updating KVM System Vms
> 2013-05-01 12:27:54,049 DEBUG [db.Transaction.Transaction] (Timer-1:null)
> Rolling back the transaction: Time = 9161 Name = Upgrade; called by
> -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:263-DatabaseUpgradeChecker.check:358-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:50-TimerThread.mainLoop:534-TimerThread.run:484
> 2013-05-01 12:27:54,052 ERROR [utils.component.ComponentContext]
> (Timer-1:null) System integrity check failed. Refuse to startup
>
> ps aux shows no more java process running, so the whole management-server
> just stops after this line.
>
> === calalina.out log ==
> May 1, 2013 12:26:06 PM org.apache.catalina.startup.Catalina load
> WARNING: Can't load server.xml from
> /usr/share/cloudstack-management/conf/server.xml
> May 1, 2013 12:26:07 PM org.apache.catalina.startup.Catalina load
> WARNING: Can't load server.xml from
> /usr/share/cloudstack-management/conf/server.xml
> May 1, 2013 12:26:07 PM org.apache.catalina.startup.Catalina start
> SEVERE: Cannot start server. Server instance is not configured.
> May 1, 2013 12:27:20 PM org.apache.catalina.core.AprLifecycleListener init
> INFO: The APR based Apache Tomcat Native library which allows optimal
> performance in production environments was not found on the
> java.library.path:
> /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> May 1, 2013 12:27:21 PM org.apache.tomcat.util.net.NioSelectorPool
> getSharedSelector
> INFO: Using a shared selector for servlet write/read
> May 1, 2013 12:27:21 PM org.apache.coyote.http11.Http11NioProtocol init
> INFO: Initializing Coyote HTTP/1.1 on http-8080
> May 1, 2013 12:27:21 PM org.apache.tomcat.util.net.NioSelectorPool
> getSharedSelector
> INFO: Using a shared selector for servlet write/read
> May 1, 2013 12:27:21 PM org.apache.coyote.http11.Http11NioProtocol init
> INFO: Initializing Coyote HTTP/1.1 on http-7080
> May 1, 2013 12:27:21 PM org.apache.catalina.startup.Catalina load
> INFO: Initialization processed in 885 ms
> May 1, 2013 12:27:21 PM org.apache.catalina.core.StandardService start
> INFO: Starting service Catalina
> May 1, 2013 12:27:21 PM org.apache.catalina.core.StandardEngine start
> INFO: Starting Servlet Engine: Apache Tomcat/6.0.24
> May 1, 2013 12:27:21 PM org.apache.catalina.startup.HostConfig
> deployDirectory
> INFO: Deploying web application directory client
> INFO [web.context.ContextLoader] (main:) Root WebApplicationContext:
> initialization started
> INFO [context.support.XmlWebApplicationContext] (main:) Refreshing Root
> WebApplicationContext: startup date [Wed May 01 12:27:22 CEST 2013]; root
> of context hierarchy
> INFO [factory.xml.XmlBeanDefinitionReader] (main:) Loading XML bean
> definitions from class path resource [applicationContext.xml]
> INFO [factory.xml.XmlBeanDefinitionReader] (main:) Loading XML bean
> definitions from class path resource [componentContext.xml]
> INFO [factory.annotation.AutowiredAnnotationBeanPostProcessor] (main:)
> JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> INFO [context.support.XmlWebApplicationContext] (main:) Bean
> 'transactionContextBuilder' of type [class
> com.cloud.utils.db.TransactionContextBuilder] is not eligible for getting
> processed by all BeanPostProcessors (for example: not eligible for
> auto-proxying)
> INFO [context.support.XmlWebApplicationContext] (main:) Bean
> 'actionEventInterceptor' of type [class
> com.cloud.event.ActionEventInterceptor] is not eligible for getting
> processed by all BeanPostProcessors (for example: not eligible for
> auto-proxying)
> INFO [factory.support.DefaultListableBeanFactory] (main:)
> Pre-instantiating singletons in
> org.springframework.beans.factory.support.DefaultListableBeanFactory@4d5fc672:
> defining beans
> [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,componentContext,transactionContextBuilder,actionEventInterceptor,instantiatePostProcessor,onwireRegistry,messageSerializer,transportProvider,rpcProvider,eventBus,serviceOfferingDaoImpl,diskOfferingDaoImpl,dataCenterDaoImpl,hostPodDaoImpl,vlanDaoImpl,userDaoImpl,VMTemplateDaoImpl,hypervisorCapabilitiesDaoImpl,accountDaoImpl,accountDetailsDaoImpl,accountJoinDaoImpl,accountVlanMapDaoImpl,agentUpgradeDaoImpl,alertDaoImpl,asyncJobDaoImpl,asyncJobJoinDaoImpl,autoScalePolicyConditionMapDaoImpl,autoScalePolicyDaoImpl,autoScaleVmGroupDaoImpl,autoScaleVmGroupPolicyMapDaoImpl,autoScaleVmProfileDaoImpl,capacityDaoImpl,certificateDaoImpl,clusterDaoImpl,clusterDetailsDaoImpl,commandExecLogDaoImpl,conditionDaoImpl,consoleProxyDaoImpl,counterDaoImpl,dataCenterIpAddressDaoImpl,dataCenterJoinDaoImpl,dataCenterLinkLocalIpAddressDaoImpl,dataCenterVnetDaoImpl,dataStoreProviderDaoImpl,dcDetailsDaoImpl,engineDcDetailsDaoImpl,diskOfferingJoinDaoImpl,domainDaoImpl,domainRouterDaoImpl,domainRouterJoinDaoImpl,elasticLbVmMapDaoImpl,engineClusterDaoImpl,engineDataCenterDaoImpl,engineHostDaoImpl,engineHostPodDaoImpl,eventDaoImpl,eventJoinDaoImpl,externalFirewallDeviceDaoImpl,externalLoadBalancerDeviceDaoImpl,externalPublicIpStatisticsDaoImpl,firewallRulesCidrsDaoImpl,firewallRulesDaoImpl,guestOSCategoryDaoImpl,guestOSDaoImpl,highAvailabilityDaoImpl,hostDaoImpl,hostDetailsDaoImpl,engineHostDetailsDaoImpl,hostJoinDaoImpl,engineHostTagsDaoImpl,hostTagsDaoImpl,hostTransferMapDaoImpl,iPAddressDaoImpl,identityDaoImpl,imageDaoStoreDaoImpl,imageDataDaoImpl,imageDataStoreProviderDaoImpl,inlineLoadBalancerNicMapDaoImpl,instanceGroupDaoImpl,instanceGroupJoinDaoImpl,instanceGroupVMMapDaoImpl,itWorkDaoImpl,keystoreDaoImpl,lBStickinessPolicyDaoImpl,launchPermissionDaoImpl,loadBalancerDaoImpl,loadBalancerVMMapDaoImpl,managementServerHostDaoImpl,managementServerHostPeerDaoImpl,networkAccountDaoImpl,networkDaoImpl,networkDomainDaoImpl,networkExternalFirewallDaoImpl,networkExternalLoadBalancerDaoImpl,networkOfferingDaoImpl,networkOfferingServiceMapDaoImpl,networkOpDaoImpl,networkRuleConfigDaoImpl,networkServiceMapDaoImpl,nicDaoImpl,objectInDataStoreDaoImpl,ovsTunnelInterfaceDaoImpl,ovsTunnelNetworkDaoImpl,physicalNetworkDaoImpl,physicalNetworkIsolationMethodDaoImpl,physicalNetworkServiceProviderDaoImpl,physicalNetworkTagDaoImpl,physicalNetworkTrafficTypeDaoImpl,podVlanDaoImpl,podVlanMapDaoImpl,portForwardingRulesDaoImpl,primaryDataStoreDaoImpl,primaryDataStoreDetailsDaoImpl,privateIpDaoImpl,projectAccountDaoImpl,projectAccountJoinDaoImpl,projectDaoImpl,projectInvitationDaoImpl,projectInvitationJoinDaoImpl,projectJoinDaoImpl,regionDaoImpl,remoteAccessVpnDaoImpl,resourceCountDaoImpl,resourceLimitDaoImpl,resourceTagJoinDaoImpl,resourceTagsDaoImpl,routerNetworkDaoImpl,s3DaoImpl,sSHKeyPairDaoImpl,secondaryStorageVmDaoImpl,securityGroupDaoImpl,securityGroupJoinDaoImpl,securityGroupRuleDaoImpl,securityGroupRulesDaoImpl,securityGroupVMMapDaoImpl,securityGroupWorkDaoImpl,serviceOfferingJoinDaoImpl,site2SiteCustomerGatewayDaoImpl,site2SiteVpnConnectionDaoImpl,site2SiteVpnGatewayDaoImpl,snapshotDao2Impl,snapshotDaoImpl,snapshotPolicyDaoImpl,snapshotScheduleDaoImpl,stackMaidDaoImpl,staticRouteDaoImpl,storageNetworkIpAddressDaoImpl,storageNetworkIpRangeDaoImpl,storagePoolDaoImpl,storagePoolDetailsDaoImpl,storagePoolHostDaoImpl,storagePoolJoinDaoImpl,storagePoolWorkDaoImpl,swiftDaoImpl,syncQueueDaoImpl,syncQueueItemDaoImpl,templatePrimaryDataStoreDaoImpl,uploadDaoImpl,usageDaoImpl,usageEventDaoImpl,usageIPAddressDaoImpl,usageJobDaoImpl,usageLoadBalancerPolicyDaoImpl,usageNetworkDaoImpl,usageNetworkOfferingDaoImpl,usagePortForwardingRuleDaoImpl,usageSecurityGroupDaoImpl,usageStorageDaoImpl,usageVMInstanceDaoImpl,usageVPNUserDaoImpl,usageVolumeDaoImpl,userAccountDaoImpl,userAccountJoinDaoImpl,userIpv6AddressDaoImpl,userStatisticsDaoImpl,userStatsLogDaoImpl,userVmDetailsDaoImpl,userVmJoinDaoImpl,vMComputeTagDaoImpl,vMEntityDaoImpl,vMInstanceDaoImpl,vMNetworkMapDaoImpl,vMReservationDaoImpl,vMRootDiskTagDaoImpl,vMTemplateDetailsDaoImpl,vMTemplateHostDaoImpl,vMTemplatePoolDaoImpl,vMTemplateS3DaoImpl,vMTemplateSwiftDaoImpl,vMTemplateZoneDaoImpl,versionDaoImpl,virtualRouterProviderDaoImpl,vmRulesetLogDaoImpl,volumeDao2Impl,volumeDaoImpl,volumeHostDaoImpl,volumeJoinDaoImpl,volumeReservationDaoImpl,vpcDaoImpl,vpcGatewayDaoImpl,vpcOfferingDaoImpl,vpcOfferingServiceMapDaoImpl,vpnUserDaoImpl,userVmDaoImpl,portProfileDaoImpl,clusterVSMMapDaoImpl,encryptionSecretKeyChecker,StaticRoleBasedAPIAccessChecker,databaseIntegrityChecker,domainChecker,basicAgentAuthManager,MD5UserAuthenticator,LDAPUserAuthenticator,Ovs,SecurityGroupProvider,VirtualRouter,VpcVirtualRouter,elasticLoadBalancerElement,firstFitAllocator,randomAllocator,FirstFitRouting,LocalStoragePoolAllocator,FirstFitStoragePoolAllocator,UserConcentratedAllocator,useLocalForRootAllocator,garbageCollectingStoragePoolAllocator,randomStoragePoolAllocator,recreatableFencer,recreateHostAllocator,secondaryStorageVmDefaultAllocator,ConsoleProxyAllocator,ExteralIpAddressAllocator,hyervisorTemplateAdapter,clusterAlertAdapter,consoleProxyAlertAdapter,secondaryStorageVmAlertAdapter,clusterServiceServletAdapter,CheckOnAgentInvestigator,XenServerInvestigator,UserVmDomRInvestigator,ManagementIPSystemVMInvestigator,XenServerFencer,KVMFencer,OvmFencer,XcpServerDiscoverer,SecondaryStorageDiscoverer,KvmServerDiscoverer,HypervServerDiscoverer,OvmDiscoverer,dummyHostDiscoverer,UserDispersingPlanner,UserConcentratedPodPlanner,clusterBasedAgentLoadBalancerPlanner,StorageNetworkGuru,ExternalGuestNetworkGuru,PublicNetworkGuru,PodBasedNetworkGuru,ControlNetworkGuru,DirectNetworkGuru,DirectPodBasedNetworkGuru,OvsGuestNetworkGuru,PrivateNetworkGuru,XenServerGuru,KVMGuru,OvmGuru,HypervisorPlannerSelector,accountManagerImpl,managementServerImpl,storageManagerImpl,FirstFitPlanner,resourceManagerImpl,highAvailabilityManagerExtImpl,clusteredVirtualMachineManagerImpl,networkManagerImpl,networkModelImpl,configurationServerImpl,clusterManagerImpl,clusteredAgentManagerImpl,userVmManagerImpl,consoleProxyManagerImpl,securityGroupManagerImpl2,premiumSecondaryStorageManagerImpl,ipv6AddressManagerImpl,apiRateLimitServiceImpl,alertManagerImpl,asyncJobExecutorContextImpl,asyncJobManagerImpl,autoScaleManagerImpl,capacityManagerImpl,clusterFenceManagerImpl,configurationManagerImpl,dataStoreProviderManagerImpl,domainManagerImpl,downloadMonitorImpl,elasticLoadBalancerManagerImpl,entityManagerImpl,externalLoadBalancerUsageManagerImpl,externalNetworkDeviceManagerImpl,firewallManagerImpl,hypervisorGuruManagerImpl,identityServiceImpl,keystoreManagerImpl,loadBalancingRulesManagerImpl,networkACLManagerImpl,networkServiceImpl,networkUsageManagerImpl,oCFS2ManagerImpl,ovsTunnelManagerImpl,projectManagerImpl,queryManagerImpl,regionManagerImpl,regionServiceImpl,remoteAccessVpnManagerImpl,resourceLimitManagerImpl,rulesManagerImpl,s3ManagerImpl,site2SiteVpnManagerImpl,snapshotManagerImpl,snapshotSchedulerImpl,storageNetworkManagerImpl,swiftManagerImpl,syncQueueManagerImpl,taggedResourceManagerImpl,templateManagerImpl,upgradeManagerImpl,uploadMonitorImpl,usageServiceImpl,virtualNetworkApplianceManagerImpl,vpcManagerImpl,vpcVirtualNetworkApplianceManagerImpl,cloudZonesStartupProcessor,managementServerNode,actionEventUtils,agentMonitor,alertGenerator,apiDBUtils,apiDiscoveryServiceImpl,apiDispatcher,apiResponseHelper,apiServer,apiServlet,cloudOrchestrator,clusterRestService,consoleProxyServlet,dataCenterResourceManagerImpl,dataDisk,dataMotionServiceImpl,dataObjectManagerImpl,dataStoreManagerImpl,defaultEndPointSelector,defaultImageDataStoreProvider,defaultImageMotionStrategy,defaultPrimaryDataStoreProviderManagerImpl,defaultPrimaryDatastoreProviderImpl,eventUtils,hypervisorBasedSnapshot,hypervsiorHostEndPointRpcServer,iSCSI,ISO,imageDataFactoryImpl,imageDataManagerImpl,imageDataStoreHelper,imageDataStoreManagerImpl,imageFormatHelper,imageMotionServiceImpl,imageServiceImpl,iso,networkFileSystem,networkRestService,OVA,objectInDataStoreManagerImpl,podRestService,primaryDataStoreHelper,provisioningServiceImpl,QCOW2,registerCompleteServlet,rootDisk,snapshotDataFactoryImpl,snapshotServiceImpl,statsCollector,templateInstallStrategyImpl,unknown,usageEventUtils,userContextInitializer,VHD,vMEntityManagerImpl,virtualMachineEntityImpl,virtualMachineRestService,volumeDataFactoryImpl,volumeManagerImpl,volumeRestService,volumeServiceImpl,volumeTypeHelper,zoneRestService,databaseUpgradeChecker,configurationDaoImpl,niciraNvpDaoImpl,niciraNvpNicMappingDaoImpl,niciraNvpRouterMappingDaoImpl,NiciraNvpGuestNetworkGuru,NiciraNvp,userAuthenticators,securityCheckers,resourceDiscoverers,haInvestigators,haFenceBuilders,deploymentPlanners,podAllocators,hostAllocators,storagePoolAllocators,ipDeployers,dhcpProviders,networkGurus,networkElements,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0];
> root of factory hierarchy
> INFO [utils.component.ComponentContext] (main:) Setup Spring Application
> context
> INFO [cloud.serializer.GsonHelper] (main:) Default Builder inited.
> INFO [web.context.ContextLoader] (main:) Root WebApplicationContext:
> initialization completed in 10572 ms
> INFO [cloud.utils.LogUtils] (main:) log4j configuration found at
> /etc/cloudstack/management/log4j-cloud.xml
> INFO [factory.annotation.AutowiredAnnotationBeanPostProcessor] (main:)
> JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> May 1, 2013 12:27:33 PM org.apache.coyote.http11.Http11NioProtocol start
> INFO: Starting Coyote HTTP/1.1 on http-8080
> May 1, 2013 12:27:33 PM org.apache.jk.common.ChannelSocket init
> INFO: JK: ajp13 listening on /0.0.0.0:20400
> May 1, 2013 12:27:33 PM org.apache.jk.server.JkMain start
> INFO: Jk running ID=0 time=0/50 config=null
> May 1, 2013 12:27:33 PM org.apache.catalina.core.StandardService start
> INFO: Starting service Catalina7080
> May 1, 2013 12:27:33 PM org.apache.catalina.core.StandardEngine start
> INFO: Starting Servlet Engine: Apache Tomcat/6.0.24
> May 1, 2013 12:27:33 PM org.apache.catalina.startup.HostConfig
> deployDirectory
> INFO: Deploying web application directory awsapi
> INFO [factory.annotation.AutowiredAnnotationBeanPostProcessor]
> (catalina-exec-1:) JSR-330 'javax.inject.Inject' annotation found and
> supported for autowiring
> ERROR [cloud.api.ApiServlet] (catalina-exec-1:) unknown exception writing
> api response
> java.lang.NullPointerException
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:280)
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:143)
> at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:238)
> at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889)
> at
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721)
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2274)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:679)
> May 1, 2013 12:27:34 PM org.apache.catalina.core.ApplicationContext log
> INFO: Initializing Spring root WebApplicationContext
> May 1, 2013 12:27:34 PM org.springframework.web.context.ContextLoader
> initWebApplicationContext
> INFO: Root WebApplicationContext: initialization started
> May 1, 2013 12:27:34 PM
> org.springframework.context.support.AbstractApplicationContext
> prepareRefresh
> INFO: Refreshing Root WebApplicationContext: startup date [Wed May 01
> 12:27:34 CEST 2013]; root of context hierarchy
> May 1, 2013 12:27:34 PM
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader
> loadBeanDefinitions
> INFO: Loading XML bean definitions from class path resource
> [applicationContext.xml]
> May 1, 2013 12:27:36 PM
> org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider
> registerDefaultFilters
> INFO: JSR-330 'javax.inject.Named' annotation found and supported for
> component scanning
> May 1, 2013 12:27:42 PM
> org.springframework.beans.factory.support.DefaultListableBeanFactory
> registerBeanDefinition
> INFO: Overriding bean definition for bean 'componentContext': replacing
> [Generic bean: class [com.cloud.utils.component.ComponentContext];
> scope=singleton; abstract=false; lazyInit=false; autowireMode=0;
> dependencyCheck=0; autowireCandidate=true; primary=false;
> factoryBeanName=null; factoryMethodName=null; initMethodName=null;
> destroyMethodName=null; defined in URL
> [jar:file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/cloud-utils-4.1.0-SNAPSHOT.jar!/com/cloud/utils/component/ComponentContext.class]]
> with [Generic bean: class [com.cloud.utils.component.ComponentContext];
> scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0;
> autowireCandidate=true; primary=false; factoryBeanName=null;
> factoryMethodName=null; initMethodName=null; destroyMethodName=null;
> defined in class path resource [applicationContext.xml]]
> May 1, 2013 12:27:42 PM
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor
> <init>
> INFO: JSR-330 'javax.inject.Inject' annotation found and supported for
> autowiring
> May 1, 2013 12:27:42 PM
> org.springframework.context.support.AbstractApplicationContext$BeanPostProcessorChecker
> postProcessAfterInitialization
> INFO: Bean 'transactionContextBuilder' of type [class
> com.cloud.utils.db.TransactionContextBuilder] is not eligible for getting
> processed by all BeanPostProcessors (for example: not eligible for
> auto-proxying)
> May 1, 2013 12:27:42 PM
> org.springframework.beans.factory.support.DefaultListableBeanFactory
> preInstantiateSingletons
> INFO: Pre-instantiating singletons in
> org.springframework.beans.factory.support.DefaultListableBeanFactory@2b49959a:
> defining beans
> [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,EC2MainServlet,EC2Engine,s3Engine,serviceProvider,EC2RestServlet,bucketPolicyDaoImpl,multiPartUploadsDaoImpl,cloudStackAccountDaoImpl,cloudStackUserDaoImpl,MHostDaoImpl,SObjectDaoImpl,multiPartPartsDaoImpl,cloudStackSvcOfferingDaoImpl,MHostMountDaoImpl,SObjectItemDaoImpl,SBucketDaoImpl,offeringDaoImpl,userCredentialsDaoImpl,SAclDaoImpl,multipartMetaDaoImpl,SHostDaoImpl,cloudStackConfigurationDaoImpl,SMetaDaoImpl,componentContext,transactionContextBuilder,instantiatePostProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0];
> root of factory hierarchy
> log4j:WARN No appenders could be found for logger
> (com.cloud.utils.crypt.EncryptionSecretKeyChecker).
> log4j:WARN Please initialize the log4j system properly.
> log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for
> more info.
> ERROR [cloud.api.ApiServlet] (catalina-exec-2:) unknown exception writing
> api response
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> com.mysql.jdbc.JDBC4PreparedStatement@221e5f0: SELECT user.id,
> user.username, user.password, user.firstname, user.lastname,
> user.account_id, user.email, user.state, user.api_key, user.secret_key,
> user.created, user.removed, user.timezone, user.registration_token,
> user.is_registered, user.uuid FROM user WHERE user.id = 1 AND
> user.removed IS NULL
> at
> com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:979)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:956)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:917)
> at
> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:280)
> at
> com.cloud.user.AccountManagerImpl.getSystemUser(AccountManagerImpl.java:143)
> at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:238)
> at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889)
> at
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721)
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2274)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'user.uuid' in 'field list'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:976)
> ... 39 more
> INFO [utils.component.ComponentContext] (Timer-1:) Running
> SystemIntegrityChecker encryptionSecretKeyChecker
> WARN [utils.crypt.EncryptionSecretKeyChecker] (Timer-1:) Encryption
> already enabled, is check() called twice?
> INFO [utils.component.ComponentContext] (Timer-1:) Running
> SystemIntegrityChecker databaseIntegrityChecker
> INFO [cloud.upgrade.DatabaseIntegrityChecker] (Timer-1:) Grabbing lock to
> check for database integrity.
> INFO [cloud.upgrade.DatabaseIntegrityChecker] (Timer-1:) Performing
> database integrity check
> INFO [utils.component.ComponentContext] (Timer-1:) Running
> SystemIntegrityChecker managementServerNode
> INFO [utils.component.ComponentContext] (Timer-1:) Running
> SystemIntegrityChecker databaseUpgradeChecker
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:) Grabbing lock to
> check for database upgrade.
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:) DB version =
> 2.2.14.20120210102939 Code Version = 4.1.0-SNAPSHOT
> INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:) Database upgrade
> must be performed from 2.2.14.20120210102939 to 4.1.0-SNAPSHOT
> May 1, 2013 12:27:45 PM org.springframework.web.context.ContextLoader
> initWebApplicationContext
> INFO: Root WebApplicationContext: initialization completed in 10762 ms
> May 1, 2013 12:27:45 PM
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor
> <init>
> INFO: JSR-330 'javax.inject.Inject' annotation found and supported for
> autowiring
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.CloudStackAccountDaoImpl_EnhancerByCloudStack_61c90143
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.OfferingDaoImpl_EnhancerByCloudStack_f6d3709d
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.SMetaDaoImpl_EnhancerByCloudStack_137a6095
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.MultipartMetaDaoImpl_EnhancerByCloudStack_fae2e354
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.UserCredentialsDaoImpl_EnhancerByCloudStack_b47c2bb4
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.CloudStackConfigurationDaoImpl_EnhancerByCloudStack_22ae7372
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.BucketPolicyDaoImpl_EnhancerByCloudStack_7a48dd37
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.SObjectItemDaoImpl_EnhancerByCloudStack_5e5b9500
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.MHostMountDaoImpl_EnhancerByCloudStack_b35ec90f
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_2546eb50
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.MultiPartUploadsDaoImpl_EnhancerByCloudStack_e0bb907d
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.SBucketDaoImpl_EnhancerByCloudStack_b1f7cd48
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.SAclDaoImpl_EnhancerByCloudStack_24e6a5c4
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.MultiPartPartsDaoImpl_EnhancerByCloudStack_acb5baff
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.CloudStackSvcOfferingDaoImpl_EnhancerByCloudStack_ac0ba762
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.SHostDaoImpl_EnhancerByCloudStack_4dd9619a
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.CloudStackUserDaoImpl_EnhancerByCloudStack_300256e5
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.persist.dao.SObjectDaoImpl_EnhancerByCloudStack_34b3d18b
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.service.core.ec2.EC2Engine_EnhancerByCloudStack_8740b63b
> INFO [utils.component.ComponentContext] (main:) Configuring
> com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_b27150b0
> Log4j configuration from :
> /usr/share/cloudstack-management/conf/log4j-cloud.xml
> WARN [upgrade.dao.Upgrade30xBase] (Timer-1:) Statement is
> com.mysql.jdbc.JDBC4PreparedStatement@5f260643: INSERT INTO
> `cloud`.`physical_network` (id, uuid, data_center_id, vnet,
> broadcast_domain_range, state, name) VALUES
> (200,'cb65771b-731f-4a8c-94cf-00138b203252',1,null,'ZONE','Enabled','ZONE01-pNtwk200')
> WARN [upgrade.dao.Upgrade2214to30] (Timer-1:) 3.0.0 XenServer SystemVm
> template not found. XenServer hypervisor is not used, so not failing upgrade
> ERROR [utils.component.ComponentContext] (Timer-1:) System integrity check
> failed. Refuse to startup
>
>
> == apilog.log has ==
>
> 2013-05-01 12:27:33,393 INFO [cloud.api.ApiServer] (catalina-exec-1:null)
> 10.11.104.11 -- GET
> apiKey=RwG-nDfbVfvEMV_npXrVbcmHcJdF2quI6L9SqZfDXQ9q60nDLNL8AU3fivSzlIR6w8a8H_R3vhjWykneJms_Bw&command=listAsyncJobs
> &listall=true&response=json&signature=b8eL2iteVxY%2FDEL504FCnwARzSE%3D
> unknown exception writing api response
> 2013-05-01 12:27:44,041 INFO [cloud.api.ApiServer] (catalina-exec-2:null)
> 10.11.104.11 -- GET
> apiKey=RwG-nDfbVfvEMV_npXrVbcmHcJdF2quI6L9SqZfDXQ9q60nDLNL8AU3fivSzlIR6w8a8H_R3vhjWykneJms_Bw&command=listAsyncJobs
> &listall=true&response=json&signature=b8eL2iteVxY%2FDEL504FCnwARzSE%3D
> unknown exception writing api response
>
>
>
> Please let me know what might have gone wrong, and what to fix, so that I
> can restore the database from backup and attempt an upgrade again.
>
> Cheers,
> Shashi
>
>
>