I'm trying to remove some data to get some extra free space, but running the "DELETE FROM table ..." query gives me this error:
> Error Code: 3019 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
I found this:
https://stackoverflow.com/questions/42628687/undo-log-error-no-more-space-left-over-in-system-tablespace-for-allocating-undo
The recommend to run this query:
ALTER UNDO TABLESPACE tablespace_name SET INACTIVE;
But it gives me an Error Code: 1064
MySQL version: 5.7.31
Asked by Enrique
(101 rep)
Aug 20, 2020, 08:55 PM
Last activity: Apr 9, 2025, 11:00 AM
Last activity: Apr 9, 2025, 11:00 AM