indexes not working and transaction still left