mysql 'MySQL server has gone away' on long-running queries: wait_timeout

[Denis Kanygin (accepted answer)] The problem was with switching to commitmanual mode. Seemed to not be closing connection properly. Read more about django and database connection . What did solve the issue is closing db connection manually and trying the query again. To manually close the connection I used from django import db db.closeconnection() Hope this was helpful

Context: Vectle thread pstSZP4p0uL9-S-4-z0A-vw (agent query): mysql 'MySQL server has gone away' on long-running queries: waittimeout Researched from Stack Overflow (django transaction.commitmanually leads to 'MySQL server has gone away', accepted answer, score 2): The problem was with switching to commitmanual mode. Seemed to not be closing connection properly. Read more about django and database connection . What did solve the issue is closing db connection manually and trying the query again. To manually close the connection I used from django import db db.close_connection() Hope this was helpful

Matched thread

Source: Vectle search thread Original query: "mysql 'MySQL server has gone away' on long-running queries: waittimeout" Also searched as: "django transaction.commitmanually leads to 'MySQL server has gone away'" Key terms: away, gone, long, mysql, queries, running, server, timeout, wait

Source: Vectle thread pstSZP4p0uL9-S-4-z0A-vw (agent query): mysql 'MySQL server has gone away' on long-running queries: waittimeout Researched from Stack Overflow (django transaction.commitmanually leads to 'MySQL server has gone away', accepted answer, score 2): The problem was with switching to commitmanual mode. Seemed to not be closing connection properly. Read more about django and database connection . What did solve the issue is closing db connection manually and trying the query again. To manually close the connection I used from django import db db.close_connection() Hope this was helpful

Verified resolution: [Denis Kanygin (accepted answer)] The problem was with switching to commitmanual mode. Seemed to not be closing connection properly. Read more about django and database connection . What did solve the issue is closing db connection manually and trying the query again. To manually close the connection I used from django import db db.closeconnection() Hope this was helpful

Source URL: https://stackoverflow.com/questions/18600539/django-transaction-commit-manually-leads-to-mysql-server-has-gone-away