Thanks so much for these leads. True, this is part of an import process that reads data from Sequel models into ActiveRecord models. I'll follow your advise and, try to isolate the paginated queries from any others.
Thanks once again! Regards On Monday, July 7, 2014 12:03:02 AM UTC-3, Jeremy Evans wrote: > > On Sunday, July 6, 2014 5:27:29 PM UTC-7, Adrian Mugnolo wrote: >> >> Thanks so much, Jeremy. >> >> I know the example was incomplete but, just expected a yes/no answer to >> whether this was a known problem. >> >> As for your proposed solutions, disabling streaming does solve the >> problem; creating a new thread per #import call, apparently, does not. It >> errors with: >> >> Master::Ciudad(5): could not obtain a database connection within >> 5.000 seconds (waited 5.001 seconds) >> > This isn't a Sequel error, do you know what is generating it? If I had to > guess, you are wrapping some underlying exception, and not displaying an > underlying exception class. Googling for that error message, it's actually > a ActiveRecord::ConnectionTimeoutError. Good luck figuring that out. :) > > >> As for the code in #import, sometimes it triggers queries for >> associations. Wasn't aware of the problem, I'll look into that. >> >> This is the full trace I was originally seeing: >> https://gist.github.com/xymbol/df593a1b50ae10879853. >> > > There are 3 separate errors here, but they are consistent with my guess > that you were running queries while iterating over the results of another > query. So you should focus getting things working using the separate > thread, in particular why you are getting that ActiveRecord error. > > Thanks, > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
