[mythtv-users] When is the master BE not the master BE?

John Drescher drescherjm at gmail.com
Sun Oct 21 23:32:18 UTC 2007


> Digging around a little, I notice the housekeeping table:
>
> mysql> select * from housekeeping;
> +-------------------------------------+---------------------+
> | tag                                 | lastrun             |
> +-------------------------------------+---------------------+
> | LogClean                            | 2007-09-23 13:03:17 |
> | MythFillDB                          | 2007-09-22 12:02:44 |
> | JobQueueCleanup                     | 2007-01-28 08:20:13 |
> | JobQueueRecover-mammouth.foddy.home | 2007-09-22 15:27:45 |
> | JobQueueRecover-fodvo.foddy.home     | 2007-10-21 09:17:02 |
> | InUseProgramsCleanup                | 2007-01-28 08:20:13 |
> | JobQueueRecover-starfire.foddy.home | 2007-05-27 23:48:36 |
> | DailyCleanup                        | 2007-10-21 09:12:52 |
> | JobQueueRecover-pvrfe               | 2007-04-04 23:00:40 |
> | JobQueueRecover-mammouth            | 2007-10-20 15:47:49 |
> +-------------------------------------+---------------------+
> 10 rows in set (0.00 sec)
>
>
> The master is hostname is "mammouth", fodvo is a FE slave BE.
> Its possible early in the setup it might have been
> called "mammouth.foddy.home", fully qualified.
> Notice the duplicate entry of "JobQueueRecover" parameter.
> It also so happens that 9/22/2007 was the last time mythfilldatabase ran.
>

Here is what I have on this:

mysql> select * from housekeeping;
+----------------------+---------------------+
| tag                  | lastrun             |
+----------------------+---------------------+
| MythFillDB           | 2007-05-17 08:55:22 |
| LogClean             | 2007-05-07 16:20:10 |
| JobQueueCleanup      | 2006-12-03 16:30:56 |
| JobQueueRecover-jmd0 | 2007-05-17 20:31:00 |
| InUseProgramsCleanup | 2006-12-03 16:30:56 |
| JobQueueRecover-jmd1 | 2007-10-21 18:43:54 |
| DailyCleanup         | 2007-10-21 05:04:54 |
+----------------------+---------------------+
7 rows in set (0.01 sec)

jmd0 was the old retired master backend while the new machine is jmd1.
I believe my database
log ended on 5-17 as well as I only have entries for jmd0.

John


More information about the mythtv-users mailing list