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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp