[mythtv-users] DB Error (MarkAsInUse) problems

Neil Salstrom salstrom at gmail.com
Sat Oct 8 20:57:12 UTC 2011


I just recently noticed that my frontend log is being flooded when
watching LiveTV with:

2011-10-08 13:44:31.012 DB Error (MarkAsInUse -- insert failed):
Query was:
INSERT INTO inuseprograms  (chanid,         starttime,  recusage,
hostname,   lastupdatetime, rechost,    recdir) VALUES  (?,       ?,
?, ?,   ?,   ?,   ?)
Bindings were:
:CHANID=1021, :HOSTNAME=htpc, :RECDIR=, :RECHOST=htpc, :RECUSAGE=player,
:STARTTIME=2011-10-08T13:44:30, :UPDATETIME=2011-10-08T13:44:31
Driver error was [2/1048]:
QMYSQL3: Unable to execute statement
Database error was:
Column 'recdir' cannot be null

I found some references to this posted several years ago however I
never did find a solution.  It seemed to be related to storage groups
at the time but I've not made any changes to these settings.  Here is
what I've got:

mysql> SELECT * FROM storagegroup;
+----+-------------+----------+-----------------------------------+
| id | groupname   | hostname | dirname                           |
+----+-------------+----------+-----------------------------------+
|  1 | Default     | htpc     | /video/                            |
|  2 | LiveTV      | htpc     | /livetv/                          |
| 15 | Screenshots | htpc     | /multimedia/metadata/Screenshots/ |
| 17 | Fanart      | htpc     | /multimedia/metadata/Fanart/      |
| 13 | Coverart    | htpc     | /multimedia/metadata/Coverart/    |
| 12 | Trailers    | htpc     | /multimedia/metadata/Trailers/    |
| 11 | Videos      | htpc     | /multimedia/video/                |
| 16 | Banners     | htpc     | /multimedia/metadata/Banners/     |
| 18 | DB Backups  | htpc     | /home/mythtv/server/mythtv.back/  |
+----+-------------+----------+-----------------------------------+
9 rows in set (0.00 sec)

mysql>

My mythtv version is:

mythtv at htpc:~$ mythfrontend --version
Please attach all output as a file in bug reports.
MythTV Version   : v0.24.1-89-g7713fdf-dirty
MythTV Branch    : fixes/0.24
Network Protocol : 63
Library API      : 0.24.20110804-1
QT Version       : 4.7.3
Options compiled in:
 linux release using_alsa using_jack using_oss using_pulse
using_backend using_bindings_perl using_bindings_python using_directfb
using_dvb using_frontend using_hdhomerun using_iptv using_libfftw3
using_lirc using_mheg using_opengl_video using_opengl_vsync
using_qtdbus using_qtwebkit using_v4l using_x11 using_xrandr using_xv
using_bindings_perl using_bindings_python using_mythtranscode
using_opengl using_vdpau using_ffmpeg_threads using_live using_mheg

Everything seems to be working but I don't want any issues to suddenly
pop up.  Suggestions?

Thanks,

Neil


More information about the mythtv-users mailing list