title: Python Mysql, "commands out of sync; you can't run this command now"
body: <p>I have a MySQL stored procedure that is executed from Python (wrapped in Django). I get the error "commands out of sync; you can't run this command now" when I try to execute the second statement. I cannot commit the transaction at this point. This is only an issue when I call a procedure. What to do?</p>
  
  <pre><code>cursor.callproc('my_mysql_procedure', [some_id,]) 
  result = cursor.fetchall()
  for r in result:
      do something
  
  cursor.execute("select * from some_table")
  result = cursor.fetchall()
  </code></pre>
  
  <p>EDIT: I've been asked to post the MySQL procedure. I have made it super-simple and I still see the same problem</p>
  
  <pre><code>delimiter $$
  create procedure my_mysql_procedure(p_page_id int)
      begin
  
          select 1
          from dual; 
  
      end$$
  delimiter ;
  </code></pre>