maria-discuss team mailing list archive

[Elena Stepanova <elenst@xxxxxxxxxxxxxxxx>]

Hi Reindl,

On 22.08.2015 13:20, Reindl Harald wrote:
> i was flooded once again with mcron-mails "ERROR 144 (HY000) at line 1:
> Table './asterisk/cdr' is marked as crashed and last (automatic?) repair
> failed"
>
> well, because mariadb creates such temp files and don't remove them
> which makes myisam-recover-options = "FORCE" useless

Please check https://mariadb.atlassian.net/browse/MDEV-8475, it's 
probably the same problem that you are experiencing. If so, it's fixed 
in 10.1.6.

Regards,
/E

> -rw-rw---- 1 mysql mysql 0 2015-08-21 13:47 cdr.TMM
>
> MariaDB [asterisk]> optimize table cdr;
> +--------------+----------+----------+------------------------------------------------------------------------+
>
> | Table        | Op       | Msg_type | Msg_text
>                                        |
> +--------------+----------+----------+------------------------------------------------------------------------+
>
> | asterisk.cdr | optimize | error    | Can't create new tempfile:
> '/Volumes/dune/mysql_data/asterisk/cdr.TMM' |
> | asterisk.cdr | optimize | status   | Operation failed
>                                        |
> +--------------+----------+----------+------------------------------------------------------------------------+
>
>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp