Ditto here: in the past I've forgotten to set Phusion Passenger's framework "spawn method" to conservative, which -- based on when my app initializes its DB connection -- yielded shared file descriptors across processes, resulting in that sort of error you just saw.
cheers, --jordan On Nov 3, 2009, at 10:19 AM, Dirkjan Bussink wrote: > > > On 3 Nov 2009, at 19:08, Gary wrote: > >> #<DataObjects::SQLError: Commands out of sync; you can't run this >> command now (code: 2014, sql state: HY000, query: ...) >> >> more frequently. Worse, it seems to be unable to recover gracefully, >> with subsequent DB calls failing in a similar manner. > > What kind of application do you have where you get these errors? Is > this in a Merb, Sinatra or another app? Are you doing things > multithreaded or not? > > And do you have a strack trace to see where it occurs? Whether it's > always when reading data, when writing, both or any other regularity > that you can find. > > One idea that springs to mind is that perhaps forking could be an > issue. If a main process connects to the database and then the child > processes fork, they could be sharing a connection perhaps and run > queries on that out of sync. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
