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