Comment 3 for bug 356789

Revision history for this message
Mario Limonciello (superm1) wrote : Re: [Bug 356789] Re: Upcoming recordings not displaying unless recording in progress

So then that looks like possible database corruption. Repair/optimize your
tables, clean up the logs, and try again..

On Tue, Apr 7, 2009 at 00:31, daveisfera <email address hidden> wrote:

> df says that I have almost 900G available, so there should be plenty of
> space to record things.
>
> Here's the last few lines of output in the mythbackend log:
>
> 2009-04-06 21:49:58.484 Scheduled 0 items in 1.1 = 1.12 match + 0.01 place
> 2009-04-06 21:49:58.487 Seem to be woken up by USER
> 2009-04-06 21:49:58.421 DB Error
> (StorageGroup::CheckAllStorageGroupDirs()):
> Query was:
> SELECT groupname, dirname FROM storagegroup WHERE hostname = 'JohansenDVR';
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
>
> 2009-04-06 21:50:04.803 DB Error (Error in JobQueue::GetJobs(), Unable to
> query list of Jobs in Queue.):
> Query was:
> SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags,
> j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime,
> j.schedruntime FROM jobqueue j, recorded r WHERE j.chanid = r.chanid AND
> j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
>
> 2009-04-06 21:50:31.219 MainServer::HandleAnnounce Monitor
> 2009-04-06 21:50:31.230 adding: JohansenDVR as a client (events: 0)
> 2009-04-06 21:50:31.232 MainServer::HandleAnnounce Monitor
> 2009-04-06 21:50:31.233 adding: JohansenDVR as a client (events: 1)
> 2009-04-06 21:51:14.696 AutoExpire: CalcParams(): Max required Free Space:
> 1.0 GB w/freq: 15 min
> 2009-04-06 22:07:14.948 AutoExpire: CalcParams(): Max required Free Space:
> 1.0 GB w/freq: 15 min
> 2009-04-06 22:22:14.993 AutoExpire: CalcParams(): Max required Free Space:
> 1.0 GB w/freq: 15 min
>
> --
> Upcoming recordings not displaying unless recording in progress
> https://bugs.launchpad.net/bugs/356789
> You received this bug notification because you are a member of Mythbuntu
> Developers, which is subscribed to Mythbuntu.
>

--
Mario Limonciello
<email address hidden>
Sent from Austin, Texas, United States