[Maria-discuss] WHY re TMM files never removed in 10.0.x

[Reindl Harald]

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"

-rw-rw---- 1 mysql mysql 0 2015-08-21 13:47 cdr.TMM

MariaDB [asterisk]> optimize table cdr;
+--------------+----------+----------+------------------------------------------------------------------------+

+--------------+----------+----------+------------------------------------------------------------------------+

+--------------+----------+----------+------------------------------------------------------------------------+

well, because mariadb creates such temp files and don't remove them which makes myisam-recover-options = "FORCE" useless | 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 |

signature.asc
Description: OpenPGP digital signature

_______________________________________________
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