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)
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; properties' doesn't exist ------- ------- ------- +------ ------- -+----- -+----- +------ ---+--- ------- ------+ ------- ------- ------- +------ ------- -+----- -+----- +------ ---+--- ------- ------+ data_encrypted | tinyint(1) | YES | | NULL | | ------- ------- ------- +------ ------- -+----- -+----- +------ ---+--- ------- ------+
ERROR 1146 (42S02): Table 'heat.resource_
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_
| 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; ------- ------- ----+-- ------- -----+- -----+- ----+-- ------- +------ ------- ---+ ------- ------- ----+-- ------- -----+- -----+- ----+-- ------- +------ ------- ---+ resource_ id | varchar(255) | YES | | NULL | | status_ reason | varchar(255) | YES | | NULL | | ------- ------- ----+-- ------- -----+- -----+- ----+-- ------- +------ ------- ---+
+------
| 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_
| 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)