On 10/04/18 04:30, Alex wrote:
> Hi,
>
> I need to delete some of the old entries from my txrep database as
> it's grown to 3GB, oops. When attempting to do this, it fails with
> "error 14":
>
do you have enough space for tmp tables ? What if you try to delete less data ?
Does mysqlcheck(1) spots anything wrong ?
Cheers
Giovanni
> # rpm -q mariadb
> mariadb-10.2.17-2.fc28.x86_64
>
> # ls -l
> total 3141664
> -rw-rw---- 1 mysql mysql 65 Oct 19 2017 db.opt
> -rw-rw---- 1 mysql mysql 2222 Oct 19 2017 txrep.frm
> -rw-rw---- 1 mysql mysql 3217031168 Oct 3 22:29 txrep.ibd
>
> MariaDB [txrepdb]> delete from txrep where last_hit <= '2018-01-01 00:00:00';
> ERROR 14 (HY000): Can't change size of file (Errcode: -1048710496
> "Internal error < 0 (Not system error)")
>
> Searches show this can happen when the filesystem is full, but it's
> not. Any ideas of what could be wrong? Maybe write the last, say, 120
> days to another database then rename it?
>
