Comment 3 for bug 1948916

Revision history for this message
Jan Wasilewski (janwasilewski) wrote :

Unfortunately or fortunately this problem was not observed during DB sync phase, we executed our upgrade procedure on top of three environments and this problem was visible only in one environment, when we realized that one from three mysql galera nodes is out of cluster. Then we started to dig more and we found such issue there.

I also collected table schema from working nodes, it seems everything is working there correctly, but difference in size is observed:

mysql> describe quota_usages;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | YES | | NULL | |
| id | int | NO | PRI | NULL | auto_increment |
| project_id | varchar(255) | YES | MUL | NULL | |
| resource | varchar(300) | YES | | NULL | |
| in_use | int | NO | | NULL | |
| reserved | int | NO | | NULL | |
| until_refresh | int | YES | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql> describe reservations;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | YES | MUL | NULL | |
| id | int | NO | PRI | NULL | auto_increment |
| uuid | varchar(36) | NO | | NULL | |
| usage_id | int | YES | MUL | NULL | |
| project_id | varchar(255) | YES | MUL | NULL | |
| resource | varchar(255) | YES | | NULL | |
| delta | int | NO | | NULL | |
| expire | datetime | YES | | NULL | |
| allocated_id | int | YES | MUL | NULL | |
+--------------+--------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

I need to mention that mysql version is the same for all of the galera nodes.