[mythtv-users] DB error, recordedmarkup table

Steve s019 at krans.org
Thu Sep 18 21:31:28 EDT 2003


On Wed, Sep 17, 2003 at 08:47:58PM -0500, Steve wrote:
> I'm getting the following message repeating on my mythbackend server:
> 
> ***
> 
> DB Error (position map insert):
> Query was:
> INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values (
> '9011', '20030917200000', 5091, 6, "2783651942");
> Driver error was [2/-1]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '9011-20030917200000-5091-6' for key 1
[..]

I didn't get any replies on this, so I tried to fix it by:

1. backup mythconverg db
2. try an error check with "mysqlrepair -p mythconverg", which came up OK.
3. dropped the recordedmarkup table, then recreated it empty.

mythbackend now appears to be working; no more of the above messages while
recording. Can someone describe what this table is used for?




More information about the mythtv-users mailing list