[mythtv-users] Scheduler mythdb.cpp:192 (DBError) - DB Error (AddNewRecords):

[Mike Holden]

Brian J. Murrell wrote:
> Never mind.  This looks like it was just a simple lack of enough
> free
> space in /var/tmp to carry out what is probably some temporary table
> build operation or something.
>
> Freeing up some space seems to have allowed the reschedule to
> complete.

You might want to consider configuring mysql to use a "proper"
directory for its tempfiles, rather than (/var)/tmp, otherwise this
is just going to occur again. My vague recollection is that this is
used by MythTV during scheduling, and the more rules/programs you
have, the more space you need.

I added the following 2 lines to my /etc/my.cnf, after creating the
appropriate directory with the right permissions, and then restarted
mysql:

slave_load_tmpdir = /var/lib/mysql/tmpdir
tmpdir = /var/lib/mysql/tmpdir

The temporary files are now created in the same directory area as my
main permanent database files.
-- 
Mike Holden

http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts