[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