Comment 1 for bug 1671043

Steven Hardy (shardy) wrote :

One thing I did notice too is we've got a possible mismatch between longtext for resource.properties_data and blob (not longblob) for event.resource_properties:

MariaDB [heat]> describe resource_properties;
ERROR 1146 (42S02): Table 'heat.resource_properties' doesn't exist
MariaDB [heat]> describe resource;
+---------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| uuid | varchar(36) | YES | UNI | NULL | |
| nova_instance | varchar(255) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| action | varchar(255) | YES | | NULL | |
| status | varchar(255) | YES | | NULL | |
| status_reason | longtext | YES | | NULL | |
| stack_id | varchar(36) | NO | MUL | NULL | |
| rsrc_metadata | longtext | YES | | NULL | |
| properties_data | longtext | YES | | NULL | |
| engine_id | varchar(36) | YES | | NULL | |
| atomic_key | int(11) | YES | | NULL | |
| needed_by | longtext | YES | | NULL | |
| requires | longtext | YES | | NULL | |
| replaces | int(11) | YES | | NULL | |
| replaced_by | int(11) | YES | | NULL | |
| current_template_id | int(11) | YES | MUL | NULL | |
| properties_data_encrypted | tinyint(1) | YES | | NULL | |
| root_stack_id | varchar(36) | YES | MUL | NULL | |
| rsrc_prop_data_id | int(11) | YES | MUL | NULL | |
+---------------------------+--------------+------+-----+---------+----------------+
22 rows in set (0.01 sec)

MariaDB [heat]> describe event;
+------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| uuid | varchar(36) | YES | UNI | NULL | |
| stack_id | varchar(36) | NO | MUL | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| resource_action | varchar(255) | YES | | NULL | |
| resource_status | varchar(255) | YES | | NULL | |
| resource_name | varchar(255) | YES | | NULL | |
| physical_resource_id | varchar(255) | YES | | NULL | |
| resource_status_reason | varchar(255) | YES | | NULL | |
| resource_type | varchar(255) | YES | | NULL | |
| resource_properties | blob | YES | | NULL | |
| rsrc_prop_data_id | int(11) | YES | MUL | NULL | |
+------------------------+--------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)