Hey guys, I've had a really hard time with this issue and I'm hoping you can tell me that I just have a caching issue (or something similar).
I have a system that manages related life cycle records. There is a one to many relationship between a parent life cycle and many child life cycles. Once all the child life cycles are marked as complete then the parent life cycle may transition to the next state. Here's an example. I have one parent life cycle that hasn't transitioned. Every few minutes I run a query against the database and essentially take a count of child records that aren't done processing. If that number is zero then I transition the parent life cycle to its next state. The query would look like this: "select count (*) from child_life_cycle where doneProcessing is null". By the way, the doneProcessing column is a int type and holds a unix epoch time stamp. 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 return zero (0) and then a few seconds later it will return the correct number of "2". Somehow those two records didn't show up in the query. They were masked. I'm running on: Windows server 2003 Python 2.5.2 SQLAlchemy 0.5.3 MySQL 5.1.34-community This is a high volume, highly concurrent system. The scenario I've described occurs once in every 50k to 100k transactions. This identical setup is running on many machines and all have experienced the same hiccup. Please let me know if there is a known bug or other sqlalchemy related issue that I should have in mind while troubleshooting. Thanks, Daniel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---