MythTVWeb - need to remove a rogue recording item

[mrkstate]

Had a situation in the middle of a recording.

Go the systems back up and running - now MythTvWeb interface shows the program is still recording (in the upcoming recordings page) - even though this process was interrupted. This has been since 5/1/2014.

Tried using the MythTvWeb interface to remove/edit - however - nothing I do removes this entry.

Do I need to remove entries in the database?

[wren337]

try the "optimize" script? apparently this will correct issues as well. I have seen recommendations to run this daily.

/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl

[mrkstate]

Thanks for the suggestion.

Had already tried that - before my post.

Suspect I have a database issue - data in one/more tables - without the corresponding data in another table.

If someone in the development community can tell me what sql's are run as part of the web process - I can review my database and take corrective action.

[rwagner]

No SQL is performed. Mythweb queries the backend directly, and the backend tells it it is recording. When the backend gets in this state, the only solution is to stop and start the backend.

[mrkstate]

Needed to reboot the server to apply a security patch. When the service came up - the issue was gone. Thanks !!