Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
-
None
Description
I got the usual error in case of corrupted table:
[ERROR] mysqld.exe: Table 'general_log' is marked as crashed and should be repaired.
The same on slow_log
If I run mysqlcheck --repair --all-databases -u root -p I get the following list of checked tables:
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
As you can see the problem is that general_log and slow_log are skipped (are not present in the list) and are not repaired.
I've to manually run "repair table general_log; repair table slow_log;" to get these tables repaired.
Tested version: 10.2.14 and 10.3.9