[mythtv-users] Help needed with error in recordedseek table not fixed by optimize_mythdb

[stinga]

On 28/01/18 21:14, Craig Huff wrote:
> On Sun, Jan 28, 2018 at 3:03 PM, John Pilkington <J.Pilk at tesco.net 
> <mailto:J.Pilk at tesco.net>> wrote:
>
>     Restore from earlier backup?
>
>
> I found an earlier message on the mailing list by Michael Dean from 
> last February that pointed to a web link for myisam table maintenance. 
> The simple table check reported the same table with the same symptom, 
> along with one named #sql-5de_e6a.MYI as corrupted.  I suspect the 
> latter file is a mysql internal table and do not plan to touch it.  As 
> for the recordedseek table, the next step is to use myisamchk to 
> attempt a repair on it using the "easy safe repair" step.

Maybe unrelated... but.... I get issues with that sort of table name 
when mysql tmp disk space runs out.
My tmpdir in /etc/mysql/my.cnf was pointing to /tmp

[root at mythtv ~]# grep tmpdir /etc/mysql/my.cnf
tmpdir        = /tmp

I pointed it at
tmpdir        = /myth/tmp/

That resolved the issue... until /myth mount point gets low :-)


-- 
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv at wolf-rock.com  o
You need only two tools.        o /////
A hammer and duct tape. If it    /@   `\  /) ~
doesn't move and it should use  >  (O)  X<  ~  Fish!!
the hammer. If it moves and      `\___/'  \) ~
shouldn't, use the tape.           \\\
---------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180129/9cd8639c/attachment.html>