- Backend service could not start.
- Logs show error: "Table "recovery_group" is full"
- Metrics count exceeds the limit:
mysql> select count from data_property;
-----------
| count |
-----------
| 120153957 |
----------- 1 row in set (0.00 sec)
mysql> select count from data_variable;
---------
| count |
----------
| 3721836 |
----------
1 row in set (0.00 sec)
- SQL DB check runs successfully but does not resolve the issue
- Could not find any 'vstatus' or 'device' in the data_property table, therefore could not delete the inactive metrics from data_property and data_variable:
mysql> select count from data_variable where id in (select distinct variableid from data_property where name='vstatus' and value='inactive');
----------
count
----------
0
----------
1 row in set (0.00 sec)
mysql> select count from data_property where name='vstatus';
----------
count
----------
0
----------
1 row in set (0.00 sec)
mysql> select value,count count from data_property where name='device' group by value order by count desc;
Empty set (0.00 sec)
mysql> select name from data_property;
Empty set (0.00 sec)
mysql> select variableid from data_property;
Empty set (0.00 sec)
data_property table is missing the vstatus rows, which define the inactive and active metrics.
(THIS SHOULD ALWAYS BE DONE BY DELL SUPPORT)
- Used the data_property_flat table to recover the vstatus values and delete the inactive metrics from both data_variable and data_property tables:
mysql> select distinct vstatus from data_property_flat limit 10;
----------
vstatus
----------
NULL
active
inactive
----------
- Make sure the data_property_glat table can be used, the below command shows the valid ids:
select id form data_variable where id in (select id from data_property_flat where vstatus - 'inactive' ) limit 5;
- Use those ids to see if they have rows for all the columns in data_variable, which showed names and ids as well:
select * from data_variable where id =xxxxx; ( where xxxxx was a valid id that we found in the previous query's output)
Follow the below steps to delete inactive metrics using data_property_flat table:
1. Backup both data_variable and data_property tables:
create table data_variable_BACKUP like data_variable;
insert into data_variable_BACKUP select * from data_variable;
create table data_property_BACKUP like data_property;
insert into data_property_BACKUP select * from data_property;
2. Confirm we have the same count as both the backed up tables:
select count(1) from data_variable_BACKUP;
select count(1) from data_variable;
select count(1) from data_property_BACKUP;
select count(1) from data_property;
3. Delete the data_variable inactive metrics:
delete from data_variable where id in (select id from data_property_flat where vstatus='inactive');
4. Delete the inactive metrics in data_property (which might give the below error):
delete from data_property where variableid in (select id from data_property_flat where vstatus='inactive');
error: incorrect key file for table "./be13/data_property.MYI"; try to repair it
5. Repair the data_property table, verify that it is repaired, and then try to delete the inactive metrics again:
repair table data_property;
check table data_property;
delete from data_property where variableid in (select id from data_property_flat where vstatus='inactive');
6. Start the Backend service and make sure the errors are no longer seen on apg Backend logs
7. Drop the backup tables:
drop table data_property_BACKUP
drop table data_variable_BACKUP