Deleting a node does not delete URL alias

This issue is similar to #2551141. Here are the steps you need to implement to recreate the issue:

1. Create a node and use alias /test-node
2. Delete the node
3. Create a new node and use the alias /test-node
4. You will receive an error URL alias found

The alias should be deleted when the node is deleted.