[mythtv-users] Resolved: !!NoTrans: SQL Error: Table

[Dick Steffens]

On 12/12/2016 04:53 PM, Hika van den Hoven wrote:
> Hoi Dick,
>
> Tuesday, December 13, 2016, 1:00:06 AM, you wrote:
>
>> On 12/12/2016 03:48 PM, Hika van den Hoven wrote:
>>>> Try running it from the home directory and just to make sure create
>>>> that mythconverg directory there before you run it. Also check what
>>>> temp directory is set in my.conf. It should be set to /tmp or
>>>> /var/tmp. The variable is tmpdir so:
>>>> tmpdir = /tmp/
>> I find /etc/mysql/my.cnf, and it has
>> tmpdir          = /tmp
>
>>>> Oh and if you create that mythconverg directory create rw rights to
>>>> the world in there.
>> drwxrwxrwx  2 rsteff rsteff     4096 Dec 12 15:43 mythconverg
>
> mysql>> repair table program;
>> +---------------------+--------+----------+--------------------------------------------------------+
>> | Table               | Op     | Msg_type |
>> Msg_text                                               |
>> +---------------------+--------+----------+--------------------------------------------------------+
>> | mythconverg.program | repair | error    | Can't create new tempfile:
>> './mythconverg/program.TMD' |
>> | mythconverg.program | repair | status   | Operation
>> failed                                       |
>> +---------------------+--------+----------+--------------------------------------------------------+
>> 2 rows in set (0.00 sec)
> Does that file exist in /var/lib/mysql/mythconverg ? If so, can you
> delete. But you first should stop both mysql and any program using it
> like your backend and then restart it.

Yes, program.TMD did exist in /var/lib/mysql/mythconverg. Following your 
instructions to stop the backend and mysql, I deleted said file. Then I 
restarted mysql, and the backend. Then I logged into mysql and ran 
repair table program; again. This time, instead of coming back with an 
error message in 0:00 sec, I had a blank line for a couple of minutes. 
Then I got a lot of lines like this one:

| mythconverg.program | repair | warning  | Duplicate key for record at 
54335624 against record at 15112272               |

followed by these lines:

| mythconverg.program | repair | warning  | Number of rows changed from 
1393 to 314594                                    |
| mythconverg.program | repair | status   | OK |
+---------------------+--------+----------+-------------------------------------------------------------------------------+
2793 rows in set (40.45 sec)

I went back to MythWeb and my schedules are there again.

Thank you for your help.

-- 
Regards,

Dick Steffens