maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #02881
WHY re TMM files never removed in 10.0.x
-
To:
Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
-
Date:
Sat, 22 Aug 2015 12:20:46 +0200
-
Openpgp:
id=13540402D67A7F71C6E974EA866063CF7F780279; url=https://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
-
Organization:
the lounge interactive design
-
User-agent:
Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0
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
-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
|
+--------------+----------+----------+------------------------------------------------------------------------+
Attachment:
signature.asc
Description: OpenPGP digital signature
Follow ups
