[mythtv-users] mythjobqueue DB error

[Michael T. Dean]

On 04/16/2008 12:01 AM, Richard Shaw wrote:

>  On Tue, Apr 15, 2008 at 4:36 PM, Michael T. Dean wrote:
>
> > On 04/14/2008 11:23 PM, Richard Shaw wrote:
> >
> >> I've been offloading my comm flagging onto my desktop machine by
> >> running mythjobqueue on it which has worked well so far but I've
> >> seen this error several times and wondered if it was a real
> >> problem or not.
> >>
> >> 2008-04-14 22:19:13.079 DB Error (SetInUse):
> >> Query was:
> >> INSERT INTO inuseprograms  (chanid, starttime, recusage, hostname,
> >> lastupdatetime,  rechost, recdir )  VALUES  ('1501',
> >> '2008-04-13T17:30:00', 'flagger', 'hobbes.localdomain',
> >> '2008-04-14T22:19:13',  'calvin.localdomain', NULL);
> >> Driver error was [2/1048]:
> >> QMYSQL3: Unable to execute query
> >> Database error was:
> >> Column 'recdir' cannot be null
> >>
> >> I assume the the recdir stands for recording directory which I
> >> currently have setup on the MBE as /myth/mythtv. Is there any
> >> reason NULL is being used instead of that directory?
> >
> > Sounds like you have a broken storage groups configuration.  What
> > do you get with:
> >
> > SELECT * FROM storagegroup;
>
>  Run from the MBE:
>
>  mysql> SELECT * FROM storagegroup;
>  +----+-----------+--------------------+---------------+ | id |
>  groupname | hostname           | dirname       |
>  +----+-----------+--------------------+---------------+ |  3 |
>  Default   | calvin.localdomain | /myth/mythtv/ |
>  +----+-----------+--------------------+---------------+ 1 row in set
>  (0.00 sec)
>
>  Now I've been told that for transcoding I would need to have a
>  NFS/CIFS mount of the same location but as far as I know I don't for
>  comm flagging. Is that correct? I currently have that directory
>  mounted at /mnt/mythtv on my desktop.


You really should mount the filesystem at the same location on all 
hosts.  When Myth asks the host that recorded the file for its location, 
it returns the pathname that's appropriate for the recording host.  When 
the desktop looks there, it doesn't find the file.

If nothing else, though, the /mnt/mythtv/ directory should be in the 
Default storage group configured on the desktop machine.  (Though, I 
think even with that configuration, transcoding won't work properly.)

Mike