Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6.14
-
None
Description
Server 10.6.14-MariaDB-1:10.6.14+maria~deb10-log
Incorrect value in slow_query table
MariaDB [mysql]> select * from slow_log order by query_time desc limit 1 \G |
*************************** 1. row ***************************
|
start_time: 2024-03-15 17:00:59.411381
|
user_host: root[root] @ [10.178.33.17]
|
query_time: 00:17:33.304882
|
lock_time: 00:00:00.000209
|
We can see thant query start at 2024-03-15 17:00:59.411381 and take 00:17:33.304882
So it should be finished at ~2024-03-15 17:18:XX:XXXXX
But
MariaDB [mysql]> select now();
|
+---------------------+
|
| now() |
|
+---------------------+
|
| 2024-03-15 17:03:18 |
|
+---------------------+
|
 |
1 row in set (0.000 sec)
|
|
Attachments
Issue Links
- is duplicated by
-
MDEV-11628 mysql.slow_log reports incorrect start time
- Closed