cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicolas Lamirault (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-2182) Upgrade from 2.2.14 to 4.1.0 failed
Date Thu, 25 Apr 2013 09:36:15 GMT
Nicolas Lamirault created CLOUDSTACK-2182:
---------------------------------------------

             Summary: Upgrade from 2.2.14 to 4.1.0 failed
                 Key: CLOUDSTACK-2182
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2182
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
    Affects Versions: 4.1.0
            Reporter: Nicolas Lamirault
             Fix For: 4.1.0


2013-04-25 11:01:54,984 DEBUG [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Running upgrade Upgrade2214to30 to upgrade from 2.2.14-3.0.0 to 3.0.0
2013-04-25 11:01:54,992 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-2214to30.sql
2013-04-25 11:01:54,996 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Schema upgrade from 2.2.14 to 3.0;
2013-04-25 11:01:54,996 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`host` ADD COLUMN `hypervisor_version` varchar(32) COMMENT 'hypervisor version' AFTER hypervisor_type 
2013-04-25 11:01:55,333 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-04-25 11:01:55,442 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-04-25 11:01:55,443 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-04-25 11:01:55,444 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-04-25 11:01:55,445 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-04-25 11:01:55,445 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-04-25 11:01:55,446 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-04-25 11:01:55,447 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-04-25 11:01:55,448 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-04-25 11:01:55,448 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-04-25 11:01:55,449 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-04-25 11:01:55,450 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-04-25 11:01:55,450 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-04-25 11:01:55,451 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-04-25 11:01:55,613 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-04-25 11:01:55,754 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-04-25 11:01:56,005 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-04-25 11:01:56,241 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-04-25 11:01:56,301 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshots` DROP COLUMN `swift_name` 
2013-04-25 11:01:56,495 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` DROP COLUMN `hostname` 
2013-04-25 11:01:56,660 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` DROP COLUMN `token` 
2013-04-25 11:01:56,832 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:01:56,878 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `url` varchar(255) NOT NULL 
2013-04-25 11:01:56,923 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `key` varchar(255) NOT NULL COMMENT 'token for this user' 
2013-04-25 11:01:56,967 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `created` datetime COMMENT 'date the swift first signed on' 
2013-04-25 11:01:57,020 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD CONSTRAINT `uc_swift__uuid` UNIQUE (`uuid`) 
2013-04-25 11:01:59,924 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'swift.enable', 'false', 'enable swift') 
2013-04-25 11:01:59,934 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-04-25 11:01:59,977 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-04-25 11:02:00,037 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-04-25 11:02:00,038 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-04-25 11:02:00,039 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-04-25 11:02:00,040 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-04-25 11:02:00,040 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-04-25 11:02:00,041 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-04-25 11:02:00,042 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-04-25 11:02:00,042 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-04-25 11:02:00,043 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-04-25 11:02:00,044 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-04-25 11:02:00,044 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-04-25 11:02:00,045 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-04-25 11:02:00,046 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-04-25 11:02:00,046 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-04-25 11:02:00,047 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-04-25 11:02:00,047 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-04-25 11:02:00,048 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-04-25 11:02:00,049 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-04-25 11:02:00,049 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-04-25 11:02:00,050 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-04-25 11:02:00,051 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-04-25 11:02:00,051 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-04-25 11:02:00,052 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-04-25 11:02:00,053 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-04-25 11:02:00,053 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-04-25 11:02:00,054 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'cluster.storage.capacity.notificationthreshold' , category = 'Alert' where name = 'storage.capacity.threshold'  
2013-04-25 11:02:00,055 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-04-25 11:02:00,055 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-04-25 11:02:00,056 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-04-25 11:02:00,057 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-04-25 11:02:00,058 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain_router` ADD COLUMN `template_version` varchar(100) COMMENT 'template version' AFTER role 
2013-04-25 11:02:00,174 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-04-25 11:02:00,335 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`alert` ADD `cluster_id` bigint unsigned 
2013-04-25 11:02:00,442 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user_statistics` ADD COLUMN `agg_bytes_received` bigint unsigned NOT NULL default '0' 
2013-04-25 11:02:00,647 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user_statistics` ADD COLUMN `agg_bytes_sent` bigint unsigned NOT NULL default '0' 
2013-04-25 11:02:00,909 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vm_instance` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:01,127 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vm_instance` ADD CONSTRAINT `uc_vm_instance_uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:01,266 ERROR [cloud.api.ApiServer] (ApiServer-1:null) Unhandled exception, 
com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@606876f6: 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.ApiServer.handle(ApiServer.java:281)
        at org.apache.http.protocol.HttpService.doService(HttpService.java:375)
        at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:290)
        at com.cloud.api.ApiServer$WorkerTask.run(ApiServer.java:957)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
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:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        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)
        ... 27 more
2013-04-25 11:02:01,389 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`async_job` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:01,670 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`async_job` ADD CONSTRAINT `uc_async__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:01,815 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:01,906 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain` ADD CONSTRAINT `uc_domain__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:02,077 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`account` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:02,233 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`account` ADD CONSTRAINT `uc_account__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:03,230 ERROR [cloud.api.ApiServer] (ApiServer-2:null) Unhandled exception, 
com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@147c6703: 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.ApiServer.handle(ApiServer.java:281)
        at org.apache.http.protocol.HttpService.doService(HttpService.java:375)
        at org.apache.http.protocol.HttpService.handleRequest(HttpService.java:290)
        at com.cloud.api.ApiServer$WorkerTask.run(ApiServer.java:957)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
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:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        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)
        ... 27 more
2013-04-25 11:02:03,240 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud_usage`.`account` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:03,754 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:03,946 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user` ADD CONSTRAINT `uc_user__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:04,171 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`projects` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:04,336 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`projects` ADD CONSTRAINT `uc_projects__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:04,492 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`data_center` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:04,598 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`data_center` ADD CONSTRAINT `uc_data_center__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:04,757 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`host` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:04,986 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`host` ADD CONSTRAINT `uc_host__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:05,133 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-04-25 11:02:05,295 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vm_template` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:05,371 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vm_template` ADD CONSTRAINT `uc_vm_template__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:05,536 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:05,620 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`disk_offering` ADD CONSTRAINT `uc_disk_offering__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:05,772 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`networks` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:05,897 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`networks` ADD CONSTRAINT `uc_networks__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:06,058 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`security_group` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:06,271 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`security_group` ADD CONSTRAINT `uc_security_group__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:06,409 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`instance_group` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:06,511 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`instance_group` ADD CONSTRAINT `uc_instance_group__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:06,654 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`host_pod_ref` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:06,819 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`host_pod_ref` ADD CONSTRAINT `uc_host_pod_ref__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:06,998 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshots` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:07,137 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshots` ADD CONSTRAINT `uc_snapshots__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:07,279 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshot_policy` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:07,371 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshot_policy` ADD CONSTRAINT `uc_snapshot_policy__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:07,571 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshot_schedule` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:07,800 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshot_schedule` ADD CONSTRAINT `uc_snapshot_schedule__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:07,955 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`volumes` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:08,083 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`volumes` ADD CONSTRAINT `uc_volumes__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:08,305 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vlan` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:08,494 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vlan` ADD CONSTRAINT `uc_vlan__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:08,655 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user_ip_address` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:09,377 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user_ip_address` ADD CONSTRAINT `uc_user_ip_address__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:09,557 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`firewall_rules` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:09,860 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`firewall_rules` ADD CONSTRAINT `uc_firewall_rules__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:10,048 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`cluster` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:10,290 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`cluster` ADD CONSTRAINT `uc_cluster__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:10,473 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`network_offerings` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:10,641 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`network_offerings` ADD CONSTRAINT `uc_network_offerings__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:10,830 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:10,916 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`hypervisor_capabilities` ADD CONSTRAINT `uc_hypervisor_capabilities__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:11,128 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vpn_users` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:11,276 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vpn_users` ADD CONSTRAINT `uc_vpn_users__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:11,449 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`event` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:11,763 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`event` ADD CONSTRAINT `uc_event__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:11,939 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`alert` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:12,042 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`alert` ADD CONSTRAINT `uc_alert__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:12,266 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`guest_os` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:12,437 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`guest_os` ADD CONSTRAINT `uc_guest_os__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:12,597 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`guest_os_category` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:12,663 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`guest_os_category` ADD CONSTRAINT `uc_guest_os_category__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:12,839 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`nics` ADD COLUMN `uuid` varchar(40) 
2013-04-25 11:02:13,023 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`nics` ADD CONSTRAINT `uc_nics__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:13,254 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`op_host_capacity` ADD COLUMN `created` datetime 
2013-04-25 11:02:13,404 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`op_host_capacity` ADD COLUMN `update_time` datetime 
2013-04-25 11:02:13,623 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-04-25 11:02:13,624 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-04-25 11:02:13,626 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-04-25 11:02:13,626 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-04-25 11:02:13,626 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Usage db upgrade from 2.2.14 to 3.0;
2013-04-25 11:02:13,626 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-04-25 11:02:13,626 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-04-25 11:02:13,696 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-04-25 11:02:13,808 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-04-25 11:02:14,551 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-04-25 11:02:14,723 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-04-25 11:02:14,985 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-04-25 11:02:14,986 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-04-25 11:02:15,161 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud_usage`.`usage_vpn_user` ADD INDEX `i_usage_vpn_user__created`(`created`) 
2013-04-25 11:02:15,382 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud_usage`.`usage_vpn_user` ADD INDEX `i_usage_vpn_user__deleted`(`deleted`) 
2013-04-25 11:02:15,598 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-04-25 11:02:15,740 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-04-25 11:02:15,741 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`configuration` WHERE name='host.capacity.checker.wait' 
2013-04-25 11:02:15,742 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`configuration` WHERE name='host.capacity.checker.interval' 
2013-04-25 11:02:15,743 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-04-25 11:02:15,743 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-04-25 11:02:15,744 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`security_ingress_rule` RENAME TO `cloud`.`security_group_rule` 
2013-04-25 11:02:15,782 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-04-25 11:02:15,965 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`security_group_rule` ADD COLUMN `uuid` varchar(40) AFTER id 
2013-04-25 11:02:16,039 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`security_group_rule` ADD CONSTRAINT `uc_security_group_rule__uuid` UNIQUE (`uuid`) 
2013-04-25 11:02:16,255 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-04-25 11:02:16,444 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-04-25 11:02:16,645 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-04-25 11:02:16,795 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-04-25 11:02:16,950 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-04-25 11:02:17,422 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-04-25 11:02:17,527 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-04-25 11:02:17,628 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-04-25 11:02:17,723 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
2013-04-25 11:02:17,723 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --- Resource State;
2013-04-25 11:02:17,723 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
2013-04-25 11:02:17,723 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-04-25 11:02:17,955 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-04-25 11:02:17,956 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`host` SET resource_state='PrepareForMaintenance', status='Disconnected' WHERE status = 'PrepareForMaintenance' 
2013-04-25 11:02:17,956 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`host` SET resource_state='ErrorInMaintenance', status='Disconnected' WHERE status = 'ErrorInMaintenance' 
2013-04-25 11:02:17,957 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`host` SET resource_state='Maintenance', status='Disconnected' WHERE status = 'Maintenance' 
2013-04-25 11:02:17,958 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
2013-04-25 11:02:17,958 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --- Storage network
2013-04-25 11:02:17,958 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ---;
2013-04-25 11:02:17,958 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`networks` set guru_name='StorageNetworkGuru' where traffic_type='Storage' 
2013-04-25 11:02:17,959 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set value=NULL where name='xen.storage.network.device1' and value='cloud-stor1' 
2013-04-25 11:02:17,960 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set value=NULL where name='xen.storage.network.device2' and value='cloud-stor2' 
2013-04-25 11:02:17,960 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-04-25 11:02:17,960 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --NAAS;
2013-04-25 11:02:17,960 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-04-25 11:02:17,960 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-04-25 11:02:18,037 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-04-25 11:02:18,223 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-04-25 11:02:18,311 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-04-25 11:02:18,385 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-04-25 11:02:18,562 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-04-25 11:02:18,651 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-04-25 11:02:18,789 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-04-25 11:02:18,853 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-04-25 11:02:19,041 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-04-25 11:02:19,163 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-04-25 11:02:19,376 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-04-25 11:02:19,597 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT INTO `cloud`.`sequence` (name, value) VALUES ('physical_networks_seq', 200) 
2013-04-25 11:02:19,598 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-04-25 11:02:19,802 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-04-25 11:02:19,891 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-04-25 11:02:20,035 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-04-25 11:02:20,720 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-04-25 11:02:20,862 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`configuration` where name='cmd.wait' 
2013-04-25 11:02:20,863 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` set value='true' where name='firewall.rule.ui.enabled' 
2013-04-25 11:02:20,864 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-04-25 11:02:20,969 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-04-25 11:02:20,969 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Network offerings
2013-04-25 11:02:20,969 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --;
2013-04-25 11:02:20,969 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-04-25 11:02:21,126 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-04-25 11:02:21,267 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-04-25 11:02:21,383 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-04-25 11:02:21,555 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`network_offerings` MODIFY `name` varchar(64) COMMENT 'name of the network offering' 
2013-04-25 11:02:21,709 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-04-25 11:02:21,891 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-04-25 11:02:21,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`network_offerings` DROP KEY `service_offering_id` 
2013-04-25 11:02:21,928 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`network_offerings` DROP `concurrent_connections` 
2013-04-25 11:02:22,106 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-04-25 11:02:22,250 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `state`='Enabled' 
2013-04-25 11:02:22,251 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `state`='Disabled' where `availability`='Unavailable' 
2013-04-25 11:02:22,252 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `availability`='Optional' where `availability`='Unavailable' 
2013-04-25 11:02:22,252 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `system_only`=0 where `traffic_type`='Guest' 
2013-04-25 11:02:22,253 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `specify_vlan`=1 where `unique_name`='System-Guest-Network' 
2013-04-25 11:02:22,254 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `unique_name`='DefaultSharedNetworkOfferingWithSGService' where `unique_name`='System-Guest-Network' 
2013-04-25 11:02:22,255 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `unique_name`='DefaultIsolatedNetworkOfferingWithSourceNatService' where `unique_name`='DefaultVirtualizedNetworkOffering' 
2013-04-25 11:02:22,255 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `unique_name`='DefaultSharedNetworkOffering' where `unique_name`='DefaultDirectNetworkOffering' 
2013-04-25 11:02:22,256 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `name`='DefaultSharedNetworkOfferingWithSGService' where `name`='System-Guest-Network' 
2013-04-25 11:02:22,257 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `name`='DefaultIsolatedNetworkOfferingWithSourceNatService' where `name`='DefaultVirtualizedNetworkOffering' 
2013-04-25 11:02:22,257 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `name`='DefaultSharedNetworkOffering' where `name`='DefaultDirectNetworkOffering' 
2013-04-25 11:02:22,258 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `guest_type`='Shared' where `guest_type`='Direct' 
2013-04-25 11:02:22,259 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `guest_type`='Isolated' where `guest_type`='Virtual' 
2013-04-25 11:02:22,260 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`network_offerings` SET `availability`='Optional' where `availability`='Required' and `guest_type`='Shared' 
2013-04-25 11:02:22,260 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-04-25 11:02:22,390 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-04-25 11:02:22,518 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-04-25 11:02:22,692 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-04-25 11:02:22,861 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-04-25 11:02:22,863 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-04-25 11:02:22,863 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-04-25 11:02:22,864 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-04-25 11:02:22,968 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-04-25 11:02:23,088 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-04-25 11:02:23,225 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE  `cloud`.`event` ADD COLUMN `domain_id` bigint unsigned NOT NULL 
2013-04-25 11:02:23,416 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE  `cloud`.`op_host_capacity` ADD COLUMN `capacity_state` varchar(32) NOT NULL DEFAULT 'Enabled' 
2013-04-25 11:02:23,549 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-04-25 11:02:23,550 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-04-25 11:02:23,551 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`vm_template` set removed=now() where id=2 
2013-04-25 11:02:23,552 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-04-25 11:02:23,553 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE from `cloud`.`configuration` where name='firewall.rule.ui.enabled' 
2013-04-25 11:02:23,553 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`resource_limit` WHERE domain_id = 1 AND account_id IS NULL 
2013-04-25 11:02:23,554 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-04-25 11:02:23,729 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`networks` SET acl_type='Domain' where guest_type is not null and shared=1 
2013-04-25 11:02:23,730 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`networks` SET acl_type='Account' where guest_type='Virtual' 
2013-04-25 11:02:23,731 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`networks` SET acl_type='Account' where guest_type='Direct' and shared=0 
2013-04-25 11:02:23,733 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-04-25 11:02:23,842 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-04-25 11:02:23,844 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`configuration` WHERE name='network.redundantrouter' 
2013-04-25 11:02:23,844 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'xen.public.network.device' 
2013-04-25 11:02:23,845 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'xen.storage.network.device1' 
2013-04-25 11:02:23,846 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'xen.storage.network.device2' 
2013-04-25 11:02:23,847 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'xen.private.network.device' 
2013-04-25 11:02:23,847 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'xen.guest.network.device' 
2013-04-25 11:02:23,848 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'vmware.private.vswitch' 
2013-04-25 11:02:23,849 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'vmware.public.vswitch' 
2013-04-25 11:02:23,849 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'vmware.guest.vswitch' 
2013-04-25 11:02:23,850 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'ovm.public.network.device' 
2013-04-25 11:02:23,851 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'ovm.private.network.device' 
2013-04-25 11:02:23,851 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'ovm.guest.network.device' 
2013-04-25 11:02:23,852 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'kvm.public.network.device' 
2013-04-25 11:02:23,853 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'kvm.private.network.device' 
2013-04-25 11:02:23,853 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category = 'Hidden' WHERE name = 'kvm.guest.network.device' 
2013-04-25 11:02:23,854 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-04-25 11:02:24,028 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`volumes` ADD COLUMN `last_pool_id` bigint unsigned 
2013-04-25 11:02:24,213 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`volumes` SET `last_pool_id` = `pool_id` 
2013-04-25 11:02:24,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-04-25 11:02:24,822 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`volumes` ADD COLUMN `update_count` bigint unsigned NOT NULL DEFAULT 0 
2013-04-25 11:02:25,610 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`volumes` ADD INDEX `i_volumes__update_count`(`update_count`) 
2013-04-25 11:02:26,122 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`firewall_rules` ADD COLUMN `type` varchar(10) NOT NULL DEFAULT 'USER' 
2013-04-25 11:02:26,395 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-04-25 11:02:26,526 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DROP TABLE IF EXISTS `cloud_usage`.`usage_security_group` 
2013-04-25 11:02:26,558 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-04-25 11:02:26,698 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-04-25 11:02:26,873 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud_usage`.`usage_security_group` ADD INDEX `i_usage_security_group__created`(`created`) 
2013-04-25 11:02:27,184 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud_usage`.`usage_security_group` ADD INDEX `i_usage_security_group__deleted`(`deleted`) 
2013-04-25 11:02:27,436 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-04-25 11:02:27,438 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-04-25 11:02:27,562 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-04-25 11:02:27,684 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET name='vm.destroy.forcestop' where name='vm.destory.forcestop' 
2013-04-25 11:02:27,686 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-04-25 11:02:27,687 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`configuration` where name='skip.steps' 
2013-04-25 11:02:27,688 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-04-25 11:02:27,688 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-04-25 11:02:27,689 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-04-25 11:02:27,690 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-04-25 11:02:27,691 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-04-25 11:02:27,692 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-04-25 11:02:27,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-04-25 11:02:27,693 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-04-25 11:02:27,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-04-25 11:02:27,695 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os` set id = 158 where id = 141 
2013-04-25 11:02:27,696 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os` set id = 159 where id = 142 
2013-04-25 11:02:27,697 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os` set id = 160 where id = 143 
2013-04-25 11:02:27,698 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_template` set guest_os_id = 158 where guest_os_id = 141 
2013-04-25 11:02:27,698 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_template` set guest_os_id = 159 where guest_os_id = 142 
2013-04-25 11:02:27,699 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_template` set guest_os_id = 160 where guest_os_id = 143 
2013-04-25 11:02:27,700 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_instance` set guest_os_id = 158 where guest_os_id = 141 
2013-04-25 11:02:27,701 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_instance` set guest_os_id = 159 where guest_os_id = 142 
2013-04-25 11:02:27,702 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_instance` set guest_os_id = 160 where guest_os_id = 143 
2013-04-25 11:02:27,702 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 158 where guest_os_id = 141 
2013-04-25 11:02:27,703 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 159 where guest_os_id = 142 
2013-04-25 11:02:27,704 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os_hypervisor` set guest_os_id = 160 where guest_os_id = 143 
2013-04-25 11:02:27,705 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-04-25 11:02:27,706 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-04-25 11:02:27,707 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-04-25 11:02:27,708 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-04-25 11:02:27,708 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-04-25 11:02:27,709 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-04-25 11:02:27,710 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-04-25 11:02:27,711 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-04-25 11:02:27,711 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-04-25 11:02:27,712 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-04-25 11:02:27,713 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-04-25 11:02:27,714 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-04-25 11:02:27,714 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-04-25 11:02:27,715 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-04-25 11:02:27,716 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-04-25 11:02:27,717 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`guest_os` SET category_id=4 where id=131 
2013-04-25 11:02:27,717 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-04-25 11:02:27,718 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-04-25 11:02:27,719 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-04-25 11:02:27,720 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`configuration` SET category='Alert' WHERE name='capacity.check.period' 
2013-04-25 11:02:27,721 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE `cloud`.`vm_instance` SET vnc_password = '' where removed is not null 
2013-04-25 11:02:27,722 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`host_details` where name in ('storage.network.device1', 'storage.network.device2') 
2013-04-25 11:02:27,723 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-04-25 11:02:27,724 DEBUG [utils.db.ScriptRunner] (Timer-1:null) DELETE FROM `cloud`.`host_details` where name in ('storage.network.device1', 'storage.network.device2') 
2013-04-25 11:02:27,767 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back the transaction: Time = 32783 Name =  Upgrade; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:284-DatabaseUpgradeChecker.check:379-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:50-TimerThread.mainLoop:512-TimerThread.run:462
2013-04-25 11:02:27,769 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity check failed. Refuse to startup


The SQL request that the problem seems to be:
 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

works fine if i execute it from mysql client.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message