You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Wei Zhou (JIRA)" <ji...@apache.org> on 2013/05/02 16:10:17 UTC
[jira] [Commented] (CLOUDSTACK-2182) Database upgrade from 2.2.14
to 4.1.0 failed
[ https://issues.apache.org/jira/browse/CLOUDSTACK-2182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13647555#comment-13647555 ]
Wei Zhou commented on CLOUDSTACK-2182:
--------------------------------------
Hi,
Is this because of the same reason to CLOUDSTACK-2303?
I am working on it, and will create a patch for it later.
> Database 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