MySQL Forums
Forum List  »  Connector/Python

pooled connection trauma
Posted by: Steven Childerley
Date: July 27, 2022 06:33AM

I hit an issue caused by the need to move to connection pools.
I was initially using Connector/Python 8.0.21 with mySQL server 5.6.10 however discovered that an exception would be thrown if I created the pool with pool_reset_session=True, when closing the connection, mysql.connector.errors.NotSupportedError: MySQL version 5.7.2 and earlier does not support COM_RESET_CONNECTION.
I was surprised by this as release notes say that this issue was fixed in Connector/Python 8.0.16

In moving to Connector/Python 8.0.29 the exception thrown, mentioned above, was fixed.
However I then found that my stored procedures would cause the following exception: mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax

Currently the only way around this replacement of stored procedures with normal queries.

Any thoughts on what I have described appreciated.

Options: ReplyQuote

Written By
pooled connection trauma
July 27, 2022 06:33AM

Sorry, you can't reply to this topic. It has been closed.

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.