[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>

> 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
If not,why not?

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

-------------- 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