MySQL Forums
Forum List  »  InnoDB

Undo Log Error : No more space left over in system tablespace
Posted by: Tim White
Date: June 12, 2018 11:43AM

Hi,

I've a perl DBI application that truncates an innodb table. We've run this code daily for a year or more under various mysql versions.

Execution of 'DELETE from mailinglog' throws the below output error message,

'18/06/12 12:28 @ [97489] @ 201806121227 @ Runner.pl main:: [# 210] @ DBD::mysql::st execute failed: Undo Log error: No more space left over in system tablespace for allocating UNDO log pages. Please add new data file to the tablespace or check if filesystem is full or enable auto-extension for the tablespace at pgm line 306.

This is 5.7.22 running on a virtualized gentoo linux boxen. There is a ton of free disk space. I am guessing the entire table is written to undo logs and we are running over some limit. Advice on a quick solution would be welcome.

Options: ReplyQuote


Subject
Views
Written By
Posted
Undo Log Error : No more space left over in system tablespace
154
June 12, 2018 11:43AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.