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.

-- 
Regards,

Dirkjan Bussink

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to