[mythtv-users] Need help debugging python bindings

[Jack Perveiler]

>   Do you know what type of database engine you are using in MySQL for the "
>> mythconverg" data base. I only ask this as a long while ago a user had the
>> "InnoDB" engine instead of the usual "MyISAM". Apparently "InnoDB" supported
>> database roll-back so every jamu write to the data base was being rolled
>> back.
>>
>
> You are correct, I'm using InnoDB.
>
>
>>      Now this was fixed a long time ago in the Python bindings (since
>> Mythtv 0.22+fixes) but I wonder if this is related as no other users do not
>> seem to have this issue.
>>
>
> I'm betting you're right here too.  I put breakpoints in the bindings and
> stopped just before the the execute for the update.  If I evaluate the
> string the connect is about to execute (ie the "UPDATE ...") and try it in
> the mysql client then it works ok.  The bindings don't work however.
>
> Tonight I'll try and alter the table back to myisam and see if that helps.
>
>
>
I converted the table to MyISAM and things now work correctly.  Looks like
you were right about the InnoDB aspect.

Where do you want to go from here?  I'm guessing you can probably reproduce
this on your own at this point.  Alternatively I'm happy to try any
patches/ideas you might have.

--Jack
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100602/6e585e9c/attachment.htm>