[MDEV-4683] query start_time not reset when going to sleep. Created: 2013-06-19  Updated: 2013-07-02  Resolved: 2013-07-02

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3, 5.5.31
Fix Version/s: 10.0.4, 5.5.32

Type: Bug Priority: Major
Reporter: Alex Light Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Attachments: File fix-sleep.patch     File fix-sleep.patch    

 Description   

After executing a query when entering sleep the start time is not reset. So processlist show the time since the last query started not since the start of the sleep.



 Comments   
Comment by Alex Light [ 2013-06-19 ]

a fix

Comment by Alex Light [ 2013-06-19 ]

updated patch to remove unnessecary second call to set_time

Comment by Jeremy Cole [ 2013-06-20 ]

This is a pretty good bug and seems to have existed for a very very long time. It does not seem to affect wait_timeout as that is set completely separately as part of vio. This would primarily affect DBAs (visibility) and idle-connection killers that many sites have deployed.

Comment by Alex Light [ 2013-06-20 ]

final version of the patch. Does this look right to all of you?

Generated at Thu Feb 08 06:58:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.