sqlalchemy mysql segmentation fault on connect

Question

I have a piece of code that used to work fine until very recently:

from sqlalchemy import create_engine

engine = create_engine(
      'mysql+mysqldb://{}:{}@{}/{}'.format(
          user,
          password,
          hostname,
          database),
      echo=False,
      pool_recycle=300) # re-connect after 5 minutes

connection = engine.connect()

Now, it fails immediately with a segmentation fault. Has the syntax changed?

The server runs MySQL 5.7.19 and is definitely responding. My installation is sqlalchemy-1.2.4 and mysql-python-1.2.5. I'm using python 2.7.14.

Thanks for any help.

Felix · Accepted Answer · 2018-04-13 22:32:32Z

2

I have found a workaround using pymysql instead of mysqldb:

engine = create_engine(
      'mysql+pymysql://{}:{}@{}/{}'.format(
          user,
          password,
          hostname,
          database),
      echo=False,
      pool_recycle=300)

answered Apr 13, 2018 at 22:32

Felix

7492 gold badges14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlalchemy mysql segmentation fault on connect

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related