MySQL Forums
Forum List  »  Connector/Python

Re: help needed
Posted by: Jose Israel Gomez Delgado
Date: October 25, 2024 09:57PM

Without details on the type of query you are running I could guess that you may be hitting one of the two below issues:

- A timeout that can be workaround with connection_timeout parameter,
read about the Connector/Python Connection Arguments here: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
And about how it could be related to your issue here: https://dev.mysql.com/doc/refman/8.4/en/error-lost-connection.html

- If your query relates with big chunks of information like in BLOB fields, transported in packets, set max_allowed_packet on MySQL server to increase the size of packets and may reduce the number of it.
You can read about this and other issues related to disconnections here: https://dev.mysql.com/doc/refman/8.4/en/gone-away.html

Options: ReplyQuote


Subject
Written By
Posted
October 25, 2024 01:52PM
Re: help needed
October 25, 2024 09:57PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.