search for: locked_object

...t often hangs while trying to query Join Table Columns, but not exclusively. My schema has 3 main tables, and 2 intermediate join tables. A habtm B and B habtm C. I''ve ruled out any kind of resource contention on my database. For oracle people, v$lock shows nothing for my sid and v$locked_object is empty. I thought that maybe adding a pause so ruby could catch up on its garbage collecting might help, so I added a Kernel.sleep 1 every 100 or so queries. This made it seem like it worked better, but I could still get it to fail, so I might be imagining any improvement. I have plenty...