Yo cloudstack users and devs!
A corrupt HDD caused my mysql cloud.sequence table to become corrupted
(misconfig didn't put mysql data dir on zfs). I have multiple cloudstack
installations though and am able to look at a valid sequence table example:
mysql> select * from sequence;
+-------------------------+-------+
| name | value |
+-------------------------+-------+
| checkpoint_seq | 1 |
| networks_seq | 218 |
| physical_networks_seq | 202 |
| private_mac_address_seq | 1 |
| public_mac_address_seq | 1 |
| storage_pool_seq | 200 |
| vm_instance_seq | 202 |
| vm_template_seq | 215 |
| volume_seq | 1 |
+-------------------------+-------+
9 rows in set (0.00 sec)
For my now corrupted cloudstack database, is there any way to glean the
appropriate values that I can use to repopulate the table? I'm hesitant
just copy the table from my valid instance for obvious reasons.
Any idea how I can recover the appropriate values for
physical_networks_seq, physical_networks_seq, storage_pool_seq,
vm_instance_seq, vm_template_seq?
Thanks in advance,
Z
|