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

[Hika van den Hoven]

Hoi Dick,

Tuesday, December 13, 2016, 2:48:43 AM, you wrote:

> 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.

Good! But sloppy logging from mysql not giving the full path of the
offending file.

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens