Rails ActiveRecord Transaction does not finish

Question

Hi everyone, I have a Transaction for a batch insert/update block and all of sudden it stopped working. The are no errors or exception risen and it seems like Rails stops just before the end of the Transaction blog so the methods does not return. I restarted both MySQL and the system but still.

Answer 1

It seems it was the delayed option of the thinking sphinx indexing that caused the problem.