search

dolthub / doltpy

A Python API for Dolt
Apache License 2.0
56 stars 13 forks source link

unknown error: row read wait bigger than connection timeout #111

Open KIC opened 3 years ago

KIC commented 3 years ago

More complicated queries result in a timeout:

engine.execute("SELECT o.symbol, coalesce(max(y.eod), '1900-01-06') - INTERVAL 5 DAY FROM optionable o LEFT OUTER JOIN yahoo y on y.symbol = o.symbol GROUP BY o.symbol")

result in:

Traceback (most recent call last):
  File ".venv/lib/python3.7/site-packages/mysql/connector/connection_cext.py", line 489, in cmd_query
    raw_as_string=raw_as_string)
_mysql_connector.MySQLInterfaceError: unknown error: row read wait bigger than connection timeout
oscarbatori commented 3 years ago

@KIC apologies for the delayed response. This is a Dolt performance issue, rather than a Doltpy issue per se, though we could increase the timeout on the connector, or expose that configuration to the user in case they want to execute longer running queries.

Do you have any idea how long this took? Did you try running the query directly via dolt sql?