[mythtv-users] No recordings

[Mark Perkins]

On 26 March 2017 9:49:13 PM Daryl McDonald <darylangela at gmail.com> wrote:

> On Sun, Mar 26, 2017 at 1:12 AM, Stephen Worthington <
> stephen_agent at jsw.gen.nz> wrote:
>
>> On Sat, 25 Mar 2017 23:41:01 -0400, you wrote:
>>
>> >Earlier this evening I mistkenly deleted a movie, so I went to deleted
>> >recordings and undeleted it and when I went to esc  from there mythtv
>> froze
>> >up with thin images of two different screens. Being on my way out I
>> >switched inputs so the family could watch live TV, and I would wait
>> >patiently for Myth, three hours later it's still frozen so I did the ctl +
>> >alt + screen shot + R E I S U B 9 (individually) and then the box
>> rebooted,
>> >but now Myth sees videos but no recordings, I can see that they are still
>> >on my drives, do I need to use a database backup so Myth can find these
>> >again? or is there a better idea? I'm using Myth 0.28  fixes on n Ubuntu
>> >16.04 combined FE/BE desktop.  TIA  Daryl
>>
>> Run optimize_mythdb - you probably have some crashed database tables
>> that need to be repaired.
>> ___________________________________
>>
>
> Thanks for the suggestion, here are the last three line from running "
> optimize_mythdb.pl":
> DBD::mysql::db do failed: Invalid default value for 'starttime' at
> /usr/local/bin/optimize_mythdb.pl line 38.
> DBD::mysql::db do failed: Invalid default value for 'starttime' at
> /usr/local/bin/optimize_mythdb.pl line 42.
> Defragmented: filemarkup
>
> Is there further action I should take? Still no recordings show, although
> it does show "78% used and 387.52 GB free"
>
>
>
Maybe post the whole output of the optimize_mythdb.pl run. I would be interested to see the output against recorded, recordedseek and program tables as a minimum.

The line 38 error relates to the recordedseek table. The line 42 error relates to the program table.

Would be worth reviewing and / or posting your back end log from before the lock up through to the reboot. It might help pin down what or where the error is.

Are you able to record or watch live TV at the moment or is that failed too? Is your program guide working? Restoring a recent backup may be the fastest to get up and running again (as it seems your database is suffering at least some corruption based on the error messages) although you lose anything since last backup and lose the opportunity to fix whatever is broken. But if you are offline you may rather prefer to just get back to functioning even if the cost is losing a few days worth of recordings.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170326/7fe127cd/attachment.html>