Bug #94826 MYSQL community server fails to start leaving nothing in logs
Submitted: 29 Mar 2019 5:03 Modified: 7 Feb 2020 7:05
Reporter: Surya Prakash Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Logging Severity:S2 (Serious)
Version:8.0.15 OS:Windows (10)
Assigned to: CPU Architecture:Other (x64)
Tags: no events, no log, server crash, windows

[29 Mar 2019 5:03] Surya Prakash
The server keeps failing to start. It leaves nothing in logs or windows event viewer. I have not tested on the other OS but similar behavior may be observed.
I was lucky to also find the reason behind it. It was crashing at startup if the location we provided for 'secure-file-priv' in my.ini file is not live. This could happen in case one updates this setting to load data from a portable device that may not be connected all the time.

In either case, this could happen if the provided location is incorrect as well. In case of crash, the server should leave behind something in logs or event viewer.

How to repeat:
1 - Connect a USB or any portable device and update its location for 'secure-file-priv' setting in my.ini file.
2 - Restart the server. It will start failing leaving no clue in logs.

Or one may simply provide an incorrect path in 'secure-file-priv'

Suggested fix:
- Ignore the path, even if it is not correct or live and bring server up anyways.
- Add a trace in logs about the path being non-existent.
[29 Mar 2019 8:05] Surya Prakash
How to repeat:
1.a - Remove the USB

[It was missed in the original bug report]
[29 Mar 2019 9:31] MySQL Verification Team
Hello Surya,

Thank you for the report.
Observed issue only on windows(Win7 on my test box) where as on OL observed that with --log-error-verbosity=3 error message was logged to the error log.

[29 Mar 2019 9:50] Surya Prakash
Hi Umesh,

Thank you for taking this up so quickly. Since I discovered the "cure" by chance only, it is no more blocking me :-) But the issue remains a serious one considering it may leave developers on win boxes frustrated with lot of dev time wasted.

I'll follow the issue for when it will be available in a patch. Feel free to let me know if I can be of any help.

Thank you again!
[7 Feb 2020 7:05] Erlend Dahl
Fixed in 8.0.18 under the heading of