[mythtv-users] mythjobqueue DB error
Richard Shaw
hobbes1069 at gmail.com
Wed Apr 16 04:01:23 UTC 2008
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
More information about the mythtv-users
mailing list