[mythtv-users] no seek table after upgrade to 0.27

Michael Watson michael at thewatsonfamily.id.au
Wed Aug 21 06:08:40 UTC 2013


On 21/08/2013 3:53 PM, Mark Perkins wrote:
> //snip//  it appears that the seek table on existing recordings are wiped.
> //snip//
>
> //snip//
> Table './mythconverg/recordedseek' is marked as crashed and last
> (automatic?) repair failed
>
> 2013-08-21 14:27:55.483170 E  DB Error (delta position map insert):
> Query was:
> INSERT INTO recordedseek (chanid, starttime, mark, type, offset)  VALUES (
> :CHANID , :STARTTIME , :MARK , :TYPE , :OFFSET ) Bindings were:
> :CHANID=1022, :MARK=48996, :OFFSET=1959840, :STARTTIME=2013-08-20T22:25:00Z,
> :TYPE=33
> Driver error was [2/1064]:
> QMYSQL: Unable to execute query
> Database error was:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near ':CHANID ,
> :STARTTIME , :MARK , :TYPE , :OFFSET )' at line 1
> //snip//
>
> RESOLVED (I think)
> Ran the following command which appears to have resolved the missing seek
> entries.
>      mysqlcheck --auto-repair -A -u mythtv -pmysqlpassword
>
> Mark.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
I think the preferred command is "optimize_mythdb.pl".
(On a ubuntu system, it is located in 
"/usr/share/doc/mythtv-backend/contrib/maintenance/"




More information about the mythtv-users mailing list