Skip to content

Instantly share code, notes, and snippets.

@yuanying

yuanying/nova.vm.deleted.sql.diff

Created March 22, 2017 05:08
Show Gist options
  • Save yuanying/523cd2b0200bde0f2cede73127a70048 to your computer and use it in GitHub Desktop.
Save yuanying/523cd2b0200bde0f2cede73127a70048 to your computer and use it in GitHub Desktop.
Download ZIP
Differences of Nova database between vm alive and dead
Raw
nova.vm.deleted.sql.diff
--- nova.1.sql 2017-03-22 13:33:19.000000000 +0900
+++ nova.0.sql 2017-03-22 13:34:08.000000000 +0900
@@ -214,7 +214,7 @@
LOCK TABLES `block_device_mapping` WRITE;
/*!40000 ALTER TABLE `block_device_mapping` DISABLE KEYS */;
-INSERT INTO `block_device_mapping` VALUES ('2017-03-22 04:30:55','2017-03-22 04:31:04',NULL,1,'/dev/vda',0,NULL,'021cb653-9baa-46eb-8afc-6521fa7b8221',10,0,'{\"driver_volume_type\": \"iscsi\", \"connector\": {\"initiator\": \"iqn.1993-08.org.debian:01:8a32c33c9b41\", \"ip\": \"192.168.11.200\", \"platform\": \"x86_64\", \"host\": \"devstack\", \"os_type\": \"linux2\", \"multipath\": false}, \"serial\": \"021cb653-9baa-46eb-8afc-6521fa7b8221\", \"data\": {\"access_mode\": \"rw\", \"target_discovered\": false, \"encrypted\": false, \"qos_specs\": null, \"target_iqn\": \"iqn.2010-10.org.openstack:volume-021cb653-9baa-46eb-8afc-6521fa7b8221\", \"target_portal\": \"192.168.11.200:3260\", \"volume_id\": \"021cb653-9baa-46eb-8afc-6521fa7b8221\", \"target_lun\": 1, \"device_path\": \"/dev/disk/by-path/ip-192.168.11.200:3260-iscsi-iqn.2010-10.org.openstack:volume-021cb653-9baa-46eb-8afc-6521fa7b8221-lun-1\", \"auth_password\": \"thQ4sXMp9itdiiCJ\", \"auth_username\": \"6p9D9LADfoYzowN5Sp9e\", \"auth_method\": \"CHAP\"}}','4f63a203-fd09-4223-889d-225cd9eb70c6',0,'volume','volume',NULL,'disk','virtio',0,NULL);
+INSERT INTO `block_device_mapping` VALUES ('2017-03-22 04:30:55','2017-03-22 04:31:04','2017-03-22 04:33:49',1,'/dev/vda',0,NULL,'021cb653-9baa-46eb-8afc-6521fa7b8221',10,0,'{\"driver_volume_type\": \"iscsi\", \"connector\": {\"initiator\": \"iqn.1993-08.org.debian:01:8a32c33c9b41\", \"ip\": \"192.168.11.200\", \"platform\": \"x86_64\", \"host\": \"devstack\", \"os_type\": \"linux2\", \"multipath\": false}, \"serial\": \"021cb653-9baa-46eb-8afc-6521fa7b8221\", \"data\": {\"access_mode\": \"rw\", \"target_discovered\": false, \"encrypted\": false, \"qos_specs\": null, \"target_iqn\": \"iqn.2010-10.org.openstack:volume-021cb653-9baa-46eb-8afc-6521fa7b8221\", \"target_portal\": \"192.168.11.200:3260\", \"volume_id\": \"021cb653-9baa-46eb-8afc-6521fa7b8221\", \"target_lun\": 1, \"device_path\": \"/dev/disk/by-path/ip-192.168.11.200:3260-iscsi-iqn.2010-10.org.openstack:volume-021cb653-9baa-46eb-8afc-6521fa7b8221-lun-1\", \"auth_password\": \"thQ4sXMp9itdiiCJ\", \"auth_username\": \"6p9D9LADfoYzowN5Sp9e\", \"auth_method\": \"CHAP\"}}','4f63a203-fd09-4223-889d-225cd9eb70c6',1,'volume','volume',NULL,'disk','virtio',0,NULL);
/*!40000 ALTER TABLE `block_device_mapping` ENABLE KEYS */;
UNLOCK TABLES;
@@ -369,7 +369,7 @@
LOCK TABLES `compute_nodes` WRITE;
/*!40000 ALTER TABLE `compute_nodes` DISABLE KEYS */;
-INSERT INTO `compute_nodes` VALUES ('2017-03-22 02:55:36','2017-03-22 04:33:07',NULL,1,NULL,1,7889,39,1,2560,20,'QEMU',2000000,'{\"vendor\": \"Intel\", \"model\": \"cpu64-rhel6\", \"arch\": \"x86_64\", \"features\": [\"pge\", \"clflush\", \"sep\", \"syscall\", \"tsc\", \"vmx\", \"cmov\", \"fpu\", \"pat\", \"lm\", \"msr\", \"nx\", \"fxsr\", \"pae\", \"mmx\", \"cx8\", \"mce\", \"de\", \"mca\", \"pse\", \"pni\", \"abm\", \"popcnt\", \"apic\", \"sse\", \"lahf_lm\", \"sse2\", \"hypervisor\", \"cx16\", \"pse36\", \"mtrr\", \"x2apic\"], \"topology\": {\"cores\": 1, \"cells\": 1, \"threads\": 1, \"sockets\": 1}}',31,5329,19,0,1,'devstack',0,'192.168.11.200','[[\"i686\", \"qemu\", \"hvm\"], [\"i686\", \"kvm\", \"hvm\"], [\"x86_64\", \"qemu\", \"hvm\"], [\"x86_64\", \"kvm\", \"hvm\"]]','{\"nova_object.version\": \"1.1\", \"nova_object.changes\": [\"objects\"], \"nova_object.name\": \"PciDevicePoolList\", \"nova_object.data\": {\"objects\": []}, \"nova_object.namespace\": \"nova\"}','[]',NULL,'{\"num_task_None\": \"1\", \"io_workload\": \"0\", \"num_proj_8d24c84b36c447c1a3a7f3244005aeb6\": \"1\", \"num_instances\": \"1\", \"num_os_type_None\": \"1\", \"num_vm_active\": \"1\"}',NULL,'devstack',0,0,'47518fc0-8e5a-4cd3-8b2f-312e28e85a31',0);
+INSERT INTO `compute_nodes` VALUES ('2017-03-22 02:55:36','2017-03-22 04:34:08',NULL,1,NULL,1,7889,39,0,512,0,'QEMU',2000000,'{\"vendor\": \"Intel\", \"model\": \"cpu64-rhel6\", \"arch\": \"x86_64\", \"features\": [\"pge\", \"clflush\", \"sep\", \"syscall\", \"tsc\", \"vmx\", \"cmov\", \"fpu\", \"pat\", \"lm\", \"msr\", \"nx\", \"fxsr\", \"pae\", \"mmx\", \"cx8\", \"mce\", \"de\", \"mca\", \"pse\", \"pni\", \"abm\", \"popcnt\", \"apic\", \"sse\", \"lahf_lm\", \"sse2\", \"hypervisor\", \"cx16\", \"pse36\", \"mtrr\", \"x2apic\"], \"topology\": {\"cores\": 1, \"cells\": 1, \"threads\": 1, \"sockets\": 1}}',31,7377,39,0,0,'devstack',0,'192.168.11.200','[[\"i686\", \"qemu\", \"hvm\"], [\"i686\", \"kvm\", \"hvm\"], [\"x86_64\", \"qemu\", \"hvm\"], [\"x86_64\", \"kvm\", \"hvm\"]]','{\"nova_object.version\": \"1.1\", \"nova_object.changes\": [\"objects\"], \"nova_object.name\": \"PciDevicePoolList\", \"nova_object.data\": {\"objects\": []}, \"nova_object.namespace\": \"nova\"}','[]',NULL,'{}',NULL,'devstack',0,0,'47518fc0-8e5a-4cd3-8b2f-312e28e85a31',0);
/*!40000 ALTER TABLE `compute_nodes` ENABLE KEYS */;
UNLOCK TABLES;
@@ -581,7 +581,7 @@
KEY `instance_uuid_idx` (`instance_uuid`),
KEY `request_id_idx` (`request_id`),
CONSTRAINT `fk_instance_actions_instance_uuid` FOREIGN KEY (`instance_uuid`) REFERENCES `instances` (`uuid`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -590,7 +590,7 @@
LOCK TABLES `instance_actions` WRITE;
/*!40000 ALTER TABLE `instance_actions` DISABLE KEYS */;
-INSERT INTO `instance_actions` VALUES ('2017-03-22 04:30:56',NULL,NULL,1,'create','4f63a203-fd09-4223-889d-225cd9eb70c6','req-5e741c64-0fc5-46c9-bdd7-d1c3ed8d4d22','43da1529fe7a42f69bb1234aa124555f','8d24c84b36c447c1a3a7f3244005aeb6','2017-03-22 04:30:54',NULL,NULL,0);
+INSERT INTO `instance_actions` VALUES ('2017-03-22 04:30:56',NULL,NULL,1,'create','4f63a203-fd09-4223-889d-225cd9eb70c6','req-5e741c64-0fc5-46c9-bdd7-d1c3ed8d4d22','43da1529fe7a42f69bb1234aa124555f','8d24c84b36c447c1a3a7f3244005aeb6','2017-03-22 04:30:54',NULL,NULL,0),('2017-03-22 04:33:44',NULL,NULL,2,'delete','4f63a203-fd09-4223-889d-225cd9eb70c6','req-8c7984e5-657d-4f07-ae49-85c3d125e889','43da1529fe7a42f69bb1234aa124555f','8d24c84b36c447c1a3a7f3244005aeb6','2017-03-22 04:33:44',NULL,NULL,0);
/*!40000 ALTER TABLE `instance_actions` ENABLE KEYS */;
UNLOCK TABLES;
@@ -618,7 +618,7 @@
PRIMARY KEY (`id`),
KEY `action_id` (`action_id`),
CONSTRAINT `instance_actions_events_ibfk_1` FOREIGN KEY (`action_id`) REFERENCES `instance_actions` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -627,7 +627,7 @@
LOCK TABLES `instance_actions_events` WRITE;
/*!40000 ALTER TABLE `instance_actions_events` DISABLE KEYS */;
-INSERT INTO `instance_actions_events` VALUES ('2017-03-22 04:30:56','2017-03-22 04:31:11',NULL,1,'compute__do_build_and_run_instance',1,'2017-03-22 04:30:56','2017-03-22 04:31:11','Success',NULL,0,NULL,NULL);
+INSERT INTO `instance_actions_events` VALUES ('2017-03-22 04:30:56','2017-03-22 04:31:11',NULL,1,'compute__do_build_and_run_instance',1,'2017-03-22 04:30:56','2017-03-22 04:31:11','Success',NULL,0,NULL,NULL),('2017-03-22 04:33:44','2017-03-22 04:33:49',NULL,2,'compute_terminate_instance',2,'2017-03-22 04:33:44','2017-03-22 04:33:49','Success',NULL,0,NULL,NULL);
/*!40000 ALTER TABLE `instance_actions_events` ENABLE KEYS */;
UNLOCK TABLES;
@@ -662,7 +662,7 @@
LOCK TABLES `instance_extra` WRITE;
/*!40000 ALTER TABLE `instance_extra` DISABLE KEYS */;
-INSERT INTO `instance_extra` VALUES ('2017-03-22 04:30:55','2017-03-22 04:31:11',NULL,0,1,'4f63a203-fd09-4223-889d-225cd9eb70c6',NULL,'[]','{\"new\": null, \"old\": null, \"cur\": {\"nova_object.version\": \"1.1\", \"nova_object.name\": \"Flavor\", \"nova_object.data\": {\"disabled\": false, \"root_gb\": 20, \"name\": \"m1.small\", \"flavorid\": \"2\", \"deleted\": false, \"created_at\": null, \"ephemeral_gb\": 0, \"updated_at\": null, \"memory_mb\": 2048, \"vcpus\": 1, \"extra_specs\": {}, \"swap\": 0, \"rxtx_factor\": 1.0, \"is_public\": true, \"deleted_at\": null, \"vcpu_weight\": 0, \"id\": 5}, \"nova_object.namespace\": \"nova\"}}','{\"nova_object.version\": \"1.0\", \"nova_object.changes\": [\"vendor\", \"features\", \"model\", \"topology\", \"arch\", \"match\", \"mode\"], \"nova_object.name\": \"VirtCPUModel\", \"nova_object.data\": {\"vendor\": null, \"features\": [], \"mode\": null, \"model\": null, \"arch\": null, \"match\": \"exact\", \"topology\": {\"nova_object.version\": \"1.0\", \"nova_object.changes\": [\"cores\", \"threads\", \"sockets\"], \"nova_object.name\": \"VirtCPUTopology\", \"nova_object.data\": {\"cores\": 1, \"threads\": 1, \"sockets\": 1}, \"nova_object.namespace\": \"nova\"}}, \"nova_object.namespace\": \"nova\"}',NULL);
+INSERT INTO `instance_extra` VALUES ('2017-03-22 04:30:55','2017-03-22 04:33:48','2017-03-22 04:33:48',1,1,'4f63a203-fd09-4223-889d-225cd9eb70c6',NULL,'[]','{\"new\": null, \"old\": null, \"cur\": {\"nova_object.version\": \"1.1\", \"nova_object.name\": \"Flavor\", \"nova_object.data\": {\"disabled\": false, \"root_gb\": 20, \"name\": \"m1.small\", \"flavorid\": \"2\", \"deleted\": false, \"created_at\": null, \"ephemeral_gb\": 0, \"updated_at\": null, \"memory_mb\": 2048, \"vcpus\": 1, \"extra_specs\": {}, \"swap\": 0, \"rxtx_factor\": 1.0, \"is_public\": true, \"deleted_at\": null, \"vcpu_weight\": 0, \"id\": 5}, \"nova_object.namespace\": \"nova\"}}','{\"nova_object.version\": \"1.0\", \"nova_object.changes\": [\"vendor\", \"features\", \"model\", \"topology\", \"arch\", \"match\", \"mode\"], \"nova_object.name\": \"VirtCPUModel\", \"nova_object.data\": {\"vendor\": null, \"features\": [], \"mode\": null, \"model\": null, \"arch\": null, \"match\": \"exact\", \"topology\": {\"nova_object.version\": \"1.0\", \"nova_object.changes\": [\"cores\", \"threads\", \"sockets\"], \"nova_object.name\": \"VirtCPUTopology\", \"nova_object.data\": {\"cores\": 1, \"threads\": 1, \"sockets\": 1}, \"nova_object.namespace\": \"nova\"}}, \"nova_object.namespace\": \"nova\"}',NULL);
/*!40000 ALTER TABLE `instance_extra` ENABLE KEYS */;
UNLOCK TABLES;
@@ -849,7 +849,7 @@
LOCK TABLES `instance_info_caches` WRITE;
/*!40000 ALTER TABLE `instance_info_caches` DISABLE KEYS */;
-INSERT INTO `instance_info_caches` VALUES ('2017-03-22 04:30:55','2017-03-22 04:32:12',NULL,1,'[{\"profile\": {}, \"ovs_interfaceid\": \"d34fd289-ccff-498f-abf2-6fc6605b994c\", \"preserve_on_delete\": false, \"network\": {\"bridge\": \"br-int\", \"subnets\": [{\"ips\": [{\"meta\": {}, \"version\": 6, \"type\": \"fixed\", \"floating_ips\": [], \"address\": \"2001:db8::4\"}], \"version\": 6, \"meta\": {}, \"dns\": [], \"routes\": [], \"cidr\": \"2001:db8::/64\", \"gateway\": {\"meta\": {}, \"version\": 6, \"type\": \"gateway\", \"address\": \"2001:db8::2\"}}, {\"ips\": [{\"meta\": {}, \"version\": 4, \"type\": \"fixed\", \"floating_ips\": [], \"address\": \"172.24.4.3\"}], \"version\": 4, \"meta\": {}, \"dns\": [], \"routes\": [], \"cidr\": \"172.24.4.0/24\", \"gateway\": {\"meta\": {}, \"version\": 4, \"type\": \"gateway\", \"address\": \"172.24.4.1\"}}], \"meta\": {\"injected\": false, \"tenant_id\": \"8d24c84b36c447c1a3a7f3244005aeb6\", \"mtu\": 1450}, \"id\": \"e41871b5-8c0d-4652-8fbb-600d64468c59\", \"label\": \"public\"}, \"devname\": \"tapd34fd289-cc\", \"vnic_type\": \"normal\", \"qbh_params\": null, \"meta\": {}, \"details\": {\"port_filter\": true, \"ovs_hybrid_plug\": true}, \"address\": \"fa:16:3e:37:a0:8e\", \"active\": true, \"type\": \"ovs\", \"id\": \"d34fd289-ccff-498f-abf2-6fc6605b994c\", \"qbg_params\": null}]','4f63a203-fd09-4223-889d-225cd9eb70c6',0);
+INSERT INTO `instance_info_caches` VALUES ('2017-03-22 04:30:55','2017-03-22 04:33:47','2017-03-22 04:33:48',1,'[]','4f63a203-fd09-4223-889d-225cd9eb70c6',1);
/*!40000 ALTER TABLE `instance_info_caches` ENABLE KEYS */;
UNLOCK TABLES;
@@ -903,7 +903,7 @@
PRIMARY KEY (`id`),
KEY `instance_uuid` (`instance_uuid`),
CONSTRAINT `instance_system_metadata_ibfk_1` FOREIGN KEY (`instance_uuid`) REFERENCES `instances` (`uuid`)
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -912,7 +912,7 @@
LOCK TABLES `instance_system_metadata` WRITE;
/*!40000 ALTER TABLE `instance_system_metadata` DISABLE KEYS */;
-INSERT INTO `instance_system_metadata` VALUES ('2017-03-22 04:30:55',NULL,NULL,1,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_os_distro','ubuntu',0),('2017-03-22 04:30:55',NULL,NULL,2,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_min_ram','0',0),('2017-03-22 04:30:55',NULL,NULL,3,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_min_disk','20',0),('2017-03-22 04:30:55',NULL,NULL,4,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_base_image_ref','',0);
+INSERT INTO `instance_system_metadata` VALUES ('2017-03-22 04:30:55',NULL,'2017-03-22 04:33:48',1,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_os_distro','ubuntu',1),('2017-03-22 04:30:55',NULL,'2017-03-22 04:33:48',2,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_min_ram','0',2),('2017-03-22 04:30:55',NULL,'2017-03-22 04:33:48',3,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_min_disk','20',3),('2017-03-22 04:30:55',NULL,'2017-03-22 04:33:48',4,'4f63a203-fd09-4223-889d-225cd9eb70c6','image_base_image_ref','',4),('2017-03-22 04:33:46',NULL,'2017-03-22 04:33:48',6,'4f63a203-fd09-4223-889d-225cd9eb70c6','clean_attempts','1',6);
/*!40000 ALTER TABLE `instance_system_metadata` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1100,7 +1100,7 @@
LOCK TABLES `instances` WRITE;
/*!40000 ALTER TABLE `instances` DISABLE KEYS */;
-INSERT INTO `instances` VALUES ('2017-03-22 04:30:55','2017-03-22 04:31:11',NULL,1,NULL,'43da1529fe7a42f69bb1234aa124555f','8d24c84b36c447c1a3a7f3244005aeb6','','','',0,NULL,NULL,1,'active',2048,1,'myinstancefromvolume','devstack',NULL,'r-zk46g0n7',NULL,'2017-03-22 04:31:11',NULL,'myInstanceFromVolume','myInstanceFromVolume',NULL,0,NULL,'devstack',5,NULL,'4f63a203-fd09-4223-889d-225cd9eb70c6',NULL,'/dev/vda',NULL,NULL,'True',NULL,NULL,NULL,0,0,0,0,20,0,NULL,'devstack',0,NULL,0,NULL);
+INSERT INTO `instances` VALUES ('2017-03-22 04:30:55','2017-03-22 04:33:48','2017-03-22 04:33:48',1,NULL,'43da1529fe7a42f69bb1234aa124555f','8d24c84b36c447c1a3a7f3244005aeb6','','','',0,NULL,NULL,0,'deleted',2048,1,'myinstancefromvolume','devstack',NULL,'r-zk46g0n7',NULL,'2017-03-22 04:31:11','2017-03-22 04:33:48','myInstanceFromVolume','myInstanceFromVolume',NULL,0,NULL,'devstack',5,NULL,'4f63a203-fd09-4223-889d-225cd9eb70c6',NULL,'/dev/vda',NULL,NULL,'True',NULL,NULL,NULL,0,0,0,0,20,0,NULL,'devstack',1,NULL,1,NULL);
/*!40000 ALTER TABLE `instances` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1471,7 +1471,7 @@
LOCK TABLES `quota_usages` WRITE;
/*!40000 ALTER TABLE `quota_usages` DISABLE KEYS */;
-INSERT INTO `quota_usages` VALUES ('2017-03-22 04:30:55','2017-03-22 04:30:56',NULL,1,'8d24c84b36c447c1a3a7f3244005aeb6','instances',1,0,NULL,0,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55','2017-03-22 04:30:56',NULL,2,'8d24c84b36c447c1a3a7f3244005aeb6','ram',2048,0,NULL,0,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55','2017-03-22 04:30:56',NULL,3,'8d24c84b36c447c1a3a7f3244005aeb6','cores',1,0,NULL,0,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55','2017-03-22 04:30:55',NULL,4,'8d24c84b36c447c1a3a7f3244005aeb6','security_groups',1,0,0,0,'43da1529fe7a42f69bb1234aa124555f');
+INSERT INTO `quota_usages` VALUES ('2017-03-22 04:30:55','2017-03-22 04:33:49',NULL,1,'8d24c84b36c447c1a3a7f3244005aeb6','instances',0,0,NULL,0,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55','2017-03-22 04:33:49',NULL,2,'8d24c84b36c447c1a3a7f3244005aeb6','ram',0,0,NULL,0,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55','2017-03-22 04:33:49',NULL,3,'8d24c84b36c447c1a3a7f3244005aeb6','cores',0,0,NULL,0,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55','2017-03-22 04:30:55',NULL,4,'8d24c84b36c447c1a3a7f3244005aeb6','security_groups',1,0,0,0,'43da1529fe7a42f69bb1234aa124555f');
/*!40000 ALTER TABLE `quota_usages` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1532,7 +1532,7 @@
KEY `reservations_uuid_idx` (`uuid`),
KEY `reservations_deleted_expire_idx` (`deleted`,`expire`),
CONSTRAINT `reservations_ibfk_1` FOREIGN KEY (`usage_id`) REFERENCES `quota_usages` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -1541,7 +1541,7 @@
LOCK TABLES `reservations` WRITE;
/*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
-INSERT INTO `reservations` VALUES ('2017-03-22 04:30:55',NULL,'2017-03-22 04:30:56',1,'9c273566-71af-4a48-9435-0e96c33063d7',1,'8d24c84b36c447c1a3a7f3244005aeb6','instances',1,'2017-03-23 04:30:55',1,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55',NULL,'2017-03-22 04:30:56',2,'81e8ca81-9f01-457a-b4fd-f9e624b1c1d6',2,'8d24c84b36c447c1a3a7f3244005aeb6','ram',2048,'2017-03-23 04:30:55',2,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55',NULL,'2017-03-22 04:30:56',3,'2308c355-8514-4c3e-b535-6e4ec1ad82bc',3,'8d24c84b36c447c1a3a7f3244005aeb6','cores',1,'2017-03-23 04:30:55',3,'43da1529fe7a42f69bb1234aa124555f');
+INSERT INTO `reservations` VALUES ('2017-03-22 04:30:55',NULL,'2017-03-22 04:30:56',1,'9c273566-71af-4a48-9435-0e96c33063d7',1,'8d24c84b36c447c1a3a7f3244005aeb6','instances',1,'2017-03-23 04:30:55',1,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55',NULL,'2017-03-22 04:30:56',2,'81e8ca81-9f01-457a-b4fd-f9e624b1c1d6',2,'8d24c84b36c447c1a3a7f3244005aeb6','ram',2048,'2017-03-23 04:30:55',2,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:30:55',NULL,'2017-03-22 04:30:56',3,'2308c355-8514-4c3e-b535-6e4ec1ad82bc',3,'8d24c84b36c447c1a3a7f3244005aeb6','cores',1,'2017-03-23 04:30:55',3,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:33:44',NULL,'2017-03-22 04:33:49',4,'c776a64e-0084-46b9-91e8-23d3253f06c9',1,'8d24c84b36c447c1a3a7f3244005aeb6','instances',-1,'2017-03-23 04:33:44',4,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:33:44',NULL,'2017-03-22 04:33:49',5,'f29afb65-bfef-4eb4-8419-482fe2a387ba',2,'8d24c84b36c447c1a3a7f3244005aeb6','ram',-2048,'2017-03-23 04:33:44',5,'43da1529fe7a42f69bb1234aa124555f'),('2017-03-22 04:33:44',NULL,'2017-03-22 04:33:49',6,'49c8ef4a-6d92-4565-ab0d-21e94e7f8791',3,'8d24c84b36c447c1a3a7f3244005aeb6','cores',-1,'2017-03-23 04:33:44',6,'43da1529fe7a42f69bb1234aa124555f');
/*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1790,7 +1790,7 @@
LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
-INSERT INTO `services` VALUES ('2017-03-22 02:54:27',NULL,NULL,1,'0.0.0.0','nova-osapi_compute',NULL,0,0,0,NULL,NULL,0,9),('2017-03-22 02:54:27',NULL,NULL,3,'0.0.0.0','nova-metadata',NULL,0,0,0,NULL,NULL,0,9),('2017-03-22 02:55:21','2017-03-22 04:33:16',NULL,5,'devstack','nova-conductor','conductor',588,0,0,NULL,'2017-03-22 04:33:16',0,9),('2017-03-22 02:55:24','2017-03-22 04:33:12',NULL,7,'devstack','nova-scheduler','scheduler',587,0,0,NULL,'2017-03-22 04:33:12',0,9),('2017-03-22 02:55:32','2017-03-22 04:33:10',NULL,8,'devstack','nova-consoleauth','consoleauth',586,0,0,NULL,'2017-03-22 04:33:10',0,9),('2017-03-22 02:55:36','2017-03-22 04:33:12',NULL,9,'devstack','nova-compute','compute',586,0,0,NULL,'2017-03-22 04:33:12',0,9);
+INSERT INTO `services` VALUES ('2017-03-22 02:54:27',NULL,NULL,1,'0.0.0.0','nova-osapi_compute',NULL,0,0,0,NULL,NULL,0,9),('2017-03-22 02:54:27',NULL,NULL,3,'0.0.0.0','nova-metadata',NULL,0,0,0,NULL,NULL,0,9),('2017-03-22 02:55:21','2017-03-22 04:34:06',NULL,5,'devstack','nova-conductor','conductor',593,0,0,NULL,'2017-03-22 04:34:06',0,9),('2017-03-22 02:55:24','2017-03-22 04:34:02',NULL,7,'devstack','nova-scheduler','scheduler',592,0,0,NULL,'2017-03-22 04:34:02',0,9),('2017-03-22 02:55:32','2017-03-22 04:34:00',NULL,8,'devstack','nova-consoleauth','consoleauth',591,0,0,NULL,'2017-03-22 04:34:00',0,9),('2017-03-22 02:55:36','2017-03-22 04:34:02',NULL,9,'devstack','nova-compute','compute',591,0,0,NULL,'2017-03-22 04:34:02',0,9);
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3746,4 +3746,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2017-03-22 4:33:19
+-- Dump completed on 2017-03-22 4:34:08
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment