[mythtv-users] Database damage?

Mike Hodson mystica at gmail.com
Sun Feb 14 10:06:05 UTC 2021


On Sun, Feb 14, 2021, 02:23 Stephen Worthington <stephen_agent at jsw.gen.nz>
wrote:

> On Sun, 14 Feb 2021 08:35:44 +0100, you wrote:
>
>
> Yes, but any time mythbackend crashes, there is the possibility it did
> it in the middle of a database operation.  So there is the possibility
> that a table is crashed.  A worse but virtually impossible to detect
> error is also possible, where it updated one table (eg recorded) but
> failed to update the matching data in another table (eg
> recordedprogram, recordedseek).


Does this operation not exist within a START TRANSACTION ... COMMIT
statement?
If not,why not?

A transaction in this case would completely eliminate the error you propose.

Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210214/afd4a789/attachment.htm>


More information about the mythtv-users mailing list