I am experiencing a very strange error with 1.2.1-p2, which I can also reproduce with 1.2.2. In a python script I wrote to load some data with the Django ORM, inserts begin to fail after a hundred rows or so. It is always some value between 100 and 125, maybe 105, maybe 119, etc. My script will keep going without an exception as if it were inserting. But when I check my database, there are only 100 or so rows in place, and no more inserts are going on. A check of show processlist shows that the connected process is sleeping rather than querying.
Any idea what this could be?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am experiencing a very strange error with 1.2.1-p2, which I can also reproduce with 1.2.2. In a python script I wrote to load some data with the Django ORM, inserts begin to fail after a hundred rows or so. It is always some value between 100 and 125, maybe 105, maybe 119, etc. My script will keep going without an exception as if it were inserting. But when I check my database, there are only 100 or so rows in place, and no more inserts are going on. A check of show processlist shows that the connected process is sleeping rather than querying.
Any idea what this could be?
Are you using transactions? Are you committing transactions?