maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

Am 22.08.2015 um 14:37 schrieb Elena Stepanova:
> 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.

sounds similar

this really needs to be fixed in 10.0.x and was introduced with 10.0.x

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