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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Server 10.6.14-MariaDB-1:10.6.14+maria~deb10-log
Incorrect value in slow_query table {code:sql} 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 {code} 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 07:18:XX:XXXXX But {code} MariaDB [mysql]> select now(); +---------------------+ | now() | +---------------------+ | 2024-03-15 17:03:18 | +---------------------+ 1 row in set (0.000 sec) {code} |
Server 10.6.14-MariaDB-1:10.6.14+maria~deb10-log
Incorrect value in slow_query table {code:sql} 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 {code} 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 {code} MariaDB [mysql]> select now(); +---------------------+ | now() | +---------------------+ | 2024-03-15 17:03:18 | +---------------------+ 1 row in set (0.000 sec) {code} |
| Component/s | Server [ 13907 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link |
This issue is duplicated by |
Thanks for the report. It is the same as
MDEV-11628, fixed in 10.6.17.