Bug #91805 Kernel segfault in mysql libssl
Submitted: 26 Jul 2018 15:27 Modified: 3 Jan 21:01
Reporter: Doug Pedrick Email Updates:
Status: Unsupported Impact on me:
None 
Category:Connector / Python Severity:S1 (Critical)
Version:8.0.11 OS:Linux (AWS Linux)
Assigned to: Assigned Account CPU Architecture:x86

[26 Jul 2018 15:27] Doug Pedrick
Description:
Python 3.6.5, using a cherry py web server front end, and MySQL 5.7 backend.  With 8.0.11 after a few minutes of heavy load the process segfaults:

kernel: [154772.269554] python3[22456]: segfault at 1e8 ip 00007fcdd6887f47 sp 00007fcd8afbfd60 error 4 in libssl.so.1.0.0[7fcdd6860000+65000]

The interesting thing is that I am not using SSL to the database (nor HTTPS to the web server).  SSL should not be in play anywhere.

Revert to 2.1.16 and it works fine.

How to repeat:
The SQL being used is a very simple select.  Nothing odd, other than the cursor's connection, which is weakly referenced, apparently gets GC'd every so often, but that's a different issue.

If I restart the server after it dies, it'll handle a few dozen requests and then segfault again.

Suggested fix:
For now, reverting back to 2.1.16, although that is not officially supported on Python 3.6, but at least it does not segfault.
[20 May 2022 8:03] Nuno Mariz
Thank you for the bug report.

Can you test using the latest version of Connector/Python (8.0.29)?
If the issue persists, can you provide some sample code so we can reproduce the problem?
[3 Jan 21:01] Oscar Pacheco
Thank you for taking the time to report a problem.  Unfortunately, you are not using a current version of the product you reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/

If you can reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open".  Again, thank you for your continued support of MySQL. 

It's always appreciated if you provide some sample code when possible.

Regards.