[mythtv-users] Database damage?
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...
More information about the mythtv-users