Usually, Plesk has the issue of deleting, renaming, or updating an email when that email has a lot of emails, GB in emails. That happens sometimes because the email was hacked and you have thousands of emails in queue. Ok, whatever the reason this is the way to delete the email, BE AWARE that DO NOT DO THIS if you don't have experience with databases and Linux administration. Because if you don't follow the instructions, you can crash the complete mail server, even the COMPLETE server.
Login SSH with the root user
cd /var/qmail/mailnames
ls -la
you will get the list of directories of the emails, ex: if the mail is "
[email protected]" the folder name will be "user1"
let's delete the folder with this command:
DOUBLE CHECK THE FOLDER NAME IS THE ONE THAT IS RELATED TO THE EMAIL YOU WANT TO DELETE
rm -rf user1
this process can take some time depending on the mailbox size.
Once finished we have to delete the email from the database. for this type this command:
plesk db
use psa;
Now we have to locate the ID of the email account, type:
select * from mail;
You will get the list of the emails created in the server, so locate the ID of the email you want to delete. ex: 25
to delete that email record type this (I'll use the ID 25 for example) and REPLACE the 25 with the ID of the email you want to delete:
DOUBLE-CHECK THAT THE ID IS THE CORRECT ONE
delete from email where id='25';
BINGO!! the email has been deleted from the server. Reload your Plesk panel and you won't see the email anymore. Therefore, you will be able to create that again.