Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Description
Testcase may be slightly sporadic.
SET GLOBAL slow_query_log=ON; |
SET GLOBAL log_output='TABLE'; |
SET slow_query_log=ON; |
SET long_query_time=0.000001; |
SET @@time_zone="+01:00"; |
SET TIMESTAMP=1; |
SET @@time_zone='+02:00'; |
SELECT * FROM mysql.slow_log; |
Leads to:
|
10.8.0 bc57ff7cf79504a198d4752b4748340a4afd886c (Optimized) |
10.8.0-opt>SELECT * FROM mysql.slow_log;
|
ERROR 1194 (HY000): Table 'slow_log' is marked as crashed and should be repaired
|
|
10.8.0 bc57ff7cf79504a198d4752b4748340a4afd886c (Debug) |
2021-11-18 10:23:49 4 [ERROR] mysqld: Table 'slow_log' is marked as crashed and should be repaired
|
Bug confirmed present in:
MariaDB: 10.2.42 (dbg), 10.2.42 (opt), 10.3.33 (dbg), 10.3.33 (opt), 10.4.23 (dbg), 10.4.23 (opt), 10.5.14 (dbg), 10.5.14 (opt), 10.6.6 (dbg), 10.6.6 (opt), 10.7.2 (dbg), 10.7.2 (opt), 10.8.0 (dbg), 10.8.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.36 (dbg), 5.7.36 (opt), 8.0.27 (dbg), 8.0.27 (opt)