Hi!
I ran out of space on my server and I'm trying to clean up the database using the command:
delete from tc_positions where servertime < DATE(NOW() - INTERVAL 180 day)
However, I'm encountering the following error:
ERROR 3019 (HY000): 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 would greatly appreciate your help, regards!
It seems like you're out of disk space, as the error suggests.
Hi Anton!
In fact, I do that beacuse I ran out of space on my server, now Is there any way to clean the database out of space in this situation?
Thnaks for your help, regards!
You definitely won't clear it with this command.
Hi!
I ran out of space on my server and I'm trying to clean up the database using the command:
delete from tc_positions where servertime < DATE(NOW() - INTERVAL 180 day)However, I'm encountering the following error:
ERROR 3019 (HY000): 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 would greatly appreciate your help, regards!