[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