[sqlalchemy] Re: records not appearing for a short period of time

2009-09-03 Thread Michael Bayer
Daniel wrote: So if there were five child_life_cycle records in the database and three had values for doneProcessing and the other two didn't then I would expect to get a 2 back from my query and not transition. However, I'm finding that in some cases (when I look in my logs) the query will

[sqlalchemy] Re: records not appearing for a short period of time

2009-09-03 Thread dwatrous
I am using InnoDB for transactional support. I also have a timeLifeCycleInitialized field for each life cycle record and a timeLifeCycleTransitioned for the parent record. I have verified that the child records have existed for minutes to hours and have shown up in previous queries, so it's not