Sample Header Ad - 728x90

MySQL Error Code 3019 (Undo Error Log, no space left)

0 votes
1 answer
1876 views
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