[mythtv-users] mythjobqueue DB error

[Richard Shaw]

On Tue, Apr 15, 2008 at 4:36 PM, Michael T. Dean
<mtdean at thirdcontact.com> 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?
>  >
>  > Thanks,
>  > Richard
>  >
>  > Technical info:
>  > Mythtv 0.21 lastest from Atrpms on F8 x86_64. (on both machines)
>
>  Sounds like you have a broken storage groups configuration.  What do you
>  get with:
>
>  SELECT * FROM storagegroup;
>
>  Mike

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.

Thanks,
Richard