Do DELETE instead of TRUNCATE when locks aren't acquired

Do DELETE instead of TRUNCATE when locks aren't acquired #27596