Bug #93715 | MySQL Server Crash (Access Violation) whilst reading from Information_schema | ||
---|---|---|---|
Submitted: | 21 Dec 2018 10:26 | Modified: | 23 Apr 2019 13:29 |
Reporter: | Pete Dishman | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.7.24 | OS: | Windows |
Assigned to: | CPU Architecture: | x86 |
[21 Dec 2018 10:26]
Pete Dishman
[12 Mar 2019 14:49]
MySQL Verification Team
Hi, Thank you for your bug report. However, in order to verify the bug, we need to be able to repeat it. So, see if you can repeat the bug by manually running the following query: SELECT Id, User, Host, db, Command, Time, State, SUBSTRING(Info, 1, 200) AS Info FROM information_schema.PROCESSLIST WHERE Command NOT IN('Sleep', 'Daemon', 'Binlog Dump') AND User NOT IN('event_scheduler', 'system user') AND Id <> CONNECTION_ID() AND Time >= 3; If you are able to repeat the bug by crashing the above query, can you then send us just the output from : SELECT * FROM information_schema.processlist; So, that we can try to repeat it. Thanks in advance.
[13 Mar 2019 8:51]
Pete Dishman
That query is running every few seconds on the server(s) in question so it's not causing the crash on it's own. We've had some more reports of this crash on a couple of other servers, but I haven't seen the details for those yet. Will update here when I do
[13 Mar 2019 14:39]
MySQL Verification Team
Hi, We will be grateful if you manage to catch the processlist that causes the crash.
[14 Apr 2019 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".