MySQL Error Code 3019 (Undo Error Log, no space left) I'm trying to remove some data to get some extra free space, but running the &quot;DELETE FROM table ...&quot; 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
Is possible to TRUNCATE TABLE ? If yes, please try that.

Is MySQL server binary log enabled ? If YEs, Purge binarylogs &amp; then delete records.

Is MySQL Server enabled with general log or Audit Log ? If Yes, Purge general log

Check error log size &amp; path if needed purge it.


Note: Delete statement will not release space &amp; if your server is INNODB_FILE_PER_TABLE=OFF then TRUNCATE or DROP statement will also not reclaim the space