Server Side Cursor "Commands out of sync"

MySQL database connector for Python programming

Brought to you by: adustman

Server Side Cursor "Commands out of sync"

Forum: Open Discussion

Creator: Dave Marples

Created: 2006-11-02

Updated: 2012-09-19

Dave Marples - 2006-11-02

Hi, I seem to be having a problem using an SSDictCursor in 1.2.1P2. When I try and perform a select query it falls over immediately after completing the SELECT but before values are returned. The error returned is;

self.query("SHOW WARNINGS")
_mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now")

Looking at the code it seems to me that the issue is trying to perform a SHOW WARNINGS while a query is in flight. By placing a return () in show_warnings() in connections.py I can make the problem go away.

Thanks in advance for any help or advice on this. For the time being I can survive with the kludge in connections.py but I suspect I'm doing something wrong and this isn't a real issue...

DAVE

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andy Dustman - 2006-11-03
  
  Known problem fixed in 1.2.2 beta series that only affects SSCursors (and SSDictCursors).
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.