[mythtv-users] mythjobqueue DB error

[Richard Shaw]

On Wed, May 21, 2008 at 11:43 PM, Blammo <blammo.doh at gmail.com> wrote:
> On Tue, Apr 15, 2008 at 2:36 PM, Michael T. Dean
> <mtdean at thirdcontact.com> wrote:
>> On 04/14/2008 11:23 PM, Richard Shaw wrote:
>>> Column 'recdir' cannot be null
>
>> Sounds like you have a broken storage groups configuration.  What do you
>> get with:
>>
>> SELECT * FROM storagegroup;
>
> Same problem:
>
> Query was:
> INSERT INTO inuseprograms  (chanid, starttime, recusage, hostname,
> lastupdatetime,  rechost, recdir )  VALUES  ('1121',
> '2008-05-21T21:38:00', 'flagger', 'backend1', '2008-05-21T21:38:12',
> 'tuners', NULL);
> Driver error was [2/1048]:
> QMYSQL3: Unable to execute query
> Database error was:
> Column 'recdir' cannot be null
>
>
> mysql> select * from storagegroup;
> +----+-----------+-----------------------+---------------+
> | id | groupname | hostname              | dirname       |
> +----+-----------+-----------------------+---------------+
> |  1 | Default   | backend1              | /raid/myth/tv |
>
> Which is correct.. that's MBE with local disk space.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

I've also recently verified that I do not get this error when run from
the MBE, only from the slave BE.

Richard