Hello, I’m using SQLAlchemy (1.1.13) and SQLAlchemy-Utils (0.32.14) in the context of a Pyramid (1.9.1) web-browser, PyMySQL (0.7.11) as a driver, and mysql 5.6.3. I followed the Pyramid/Alchemy Cookiecutter <https://github.com/Pylons/pyramid-cookiecutter-alchemy> implementation.
On seemingly random requests (although all seem to be OPTIONS) I see the following exception in the server logs (see also this PyMySQL issue <https://github.com/PyMySQL/PyMySQL/issues/606>): 2017-09-28 18:13:17,765 ERROR [sqlalchemy.pool.QueuePool][b'uWSGIWorker1Core0'] Exception during reset or similar Traceback (most recent call last): File "/var/www/…/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context context) File "/var/www/…/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute cursor.execute(statement, parameters) File "/var/www/…/lib64/python3.6/site-packages/pymysql/cursors.py", line 166, in execute result = self._query(query) File "/var/www/…/lib64/python3.6/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/var/www/…/lib64/python3.6/site-packages/pymysql/connections.py", line 856, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/var/www/…/lib64/python3.6/site-packages/pymysql/connections.py", line 1057, in _read_query_result result.read() File "/var/www/…/lib64/python3.6/site-packages/pymysql/connections.py", line 1340, in read first_packet = self.connection._read_packet() File "/var/www/…/lib64/python3.6/site-packages/pymysql/connections.py", line 1001, in _read_packet % (packet_number, self._next_seq_id)) pymysql.err.InternalError: Packet sequence number wrong - got 102 expected 8 I see this error in different variations for the packet sequence. Any hint or tip to explain this issue is appreciated! Thank you! Jens -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
