Re: DBD::mysql bug (Was: commit fails on reconnect under DBD::mysql)

[Jochen Wiedmann]

Please try the following patch, to be found in
DBD::mysql 2.1006:

--- dbdimp.c~   Thu Dec 13 09:58:07 2001
+++ dbdimp.c    Thu Dec 27 18:45:25 2001
@@ -1951,6 +1951,15 @@
     /* Other error */
     return FALSE;
   }
+
+  if (DBIc_has(imp_dbh, DBIcf_AutoCommit)) {
+    /* We never reconnect if AutoCommit is turned off.
+     * Otherwise we might get an inconsistent transaction
+     * state.
+     */
+    return FALSE;
+  }
+
   if (!_MyLogin(imp_dbh)) {
     do_error(h, mysql_errno(&imp_dbh->mysql), mysql_error(&imp_dbh->mysql));
     return FALSE;