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":
# 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?
