Python 3.6.9 MySQLdb.escape_string error "Segmentation fault (core dumped)"

[dytttf]

Python version:3.6.9

use docker like this command: docker run -it --rm python:3.6.9 bash

code:

>>> import MySQLdb
>>> MySQLdb.escape_string("1")
Segmentation fault (core dumped)

I want know why? and how to fix it.

[methane]

You need to provide a complete step to reproduce. You don't provide even how you did install this library.

[dytttf]

sorry..
pip install mysqlclient

[methane]

It is not a complete step to reproduce.

[dytttf]

(base) ➜  ~ docker run -it --rm python:3.6.9 bash
Unable to find image 'python:3.6.9' locally
3.6.9: Pulling from library/python
Digest: sha256:155be1db9d7752d866573910d5e44c906aefdc4dae852378274a733a20e8176d
Status: Downloaded newer image for python:3.6.9
root@09934731b82f:/# pip install mysqlclient
Collecting mysqlclient
  Downloading https://files.pythonhosted.org/packages/f4/f1/3bb6f64ca7a429729413e6556b7ba5976df06019a5245a43d36032f1061e/mysqlclient-1.4.2.post1.tar.gz (85kB)
     |████████████████████████████████| 92kB 193kB/s 
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/30/91/e0/2ee952bce05b1247807405c6710c6130e49468a5240ae27134
Successfully built mysqlclient
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.4.2.post1
root@09934731b82f:/# python
Python 3.6.9 (default, Jul 13 2019, 14:51:44) 
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb as m
>>> m.escape_string("1")
Segmentation fault (core dumped)

[methane]

Thanks, I can reproduce it. It may be a bug in MariaDB, but I don't know.

python:3.6.9 is using Debian 10 which is very young and I don't have debugging environment for it yet.
You can use python:3.6.9-stretch for a while.

$ docker run -it --rm python:3.6.9-stretch bash
...
Status: Downloaded newer image for python:3.6.9-stretch
root@86fcf85eff06:/# pip install mysqlclient
Collecting mysqlclient
  Downloading https://files.pythonhosted.org/packages/f4/f1/3bb6f64ca7a429729413e6556b7ba5976df06019a5245a43d36032f1061e/mysqlclient-1.4.2.post1.tar.gz (85kB)
     |████████████████████████████████| 92kB 13.9MB/s
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/30/91/e0/2ee952bce05b1247807405c6710c6130e49468a5240ae27134
Successfully built mysqlclient
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.4.2.post1
root@86fcf85eff06:/# python
Python 3.6.9 (default, Jul 13 2019, 15:04:38)
[GCC 6.3.0 20170516] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>> MySQLdb.escape_string("1")
b'1'

Anyway, you shouldn't use MySQLdb.escape_string(). Read the docstring.

[dytttf]

Ok, Thanks

[methane]

I filed an issue on MariaDB issue tracker. https://jira.mariadb.org/browse/MDEV-20116