http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Two variations on what others said: if the session is like NH's, Load might never return null OR it might never go to the database twice for the same ID in the same session, so the session should be opened INSIDE the loop. http://ayende.com/4518/a-bug-that-drove-me-crazy#comment15http://ayende.com/4518/a-bug-that-drove-me-crazy#comment15Tue, 25 May 2010 16:32:03 GMT I know that NHibernate session does not sync its content with the DB unless you either commit the transaction or call its Flush method. I do not know if a RavenDB session acts in a similar way, but if it does, I see no transaction commit or flush, so your company was not deleted yet ... http://ayende.com/4518/a-bug-that-drove-me-crazy#comment14http://ayende.com/4518/a-bug-that-drove-me-crazy#comment14Tue, 25 May 2010 12:33:51 GMTWhat about transactions? http://ayende.com/4518/a-bug-that-drove-me-crazy#comment13http://ayende.com/4518/a-bug-that-drove-me-crazy#comment13Tue, 25 May 2010 11:06:18 GMT+1 for Mistertom, Steve Py and Markus Zywitza. ;-) http://ayende.com/4518/a-bug-that-drove-me-crazy#comment12http://ayende.com/4518/a-bug-that-drove-me-crazy#comment12Tue, 25 May 2010 05:38:59 GMTI think the session should be opened inside the for loop. http://ayende.com/4518/a-bug-that-drove-me-crazy#comment11http://ayende.com/4518/a-bug-that-drove-me-crazy#comment11Mon, 24 May 2010 21:51:57 GMTIf there is a Flushmode enumeration in the Raven Client API (similar to NHibernate) my answer would be that Flushmode is set to Never on the sessions you get back from your session factory. http://ayende.com/4518/a-bug-that-drove-me-crazy#comment10http://ayende.com/4518/a-bug-that-drove-me-crazy#comment10Mon, 24 May 2010 18:46:35 GMTDamn, my answer came to fast, truly newbie... http://ayende.com/4518/a-bug-that-drove-me-crazy#comment9http://ayende.com/4518/a-bug-that-drove-me-crazy#comment9Mon, 24 May 2010 13:10:58 GMTI'd like to jump in and say that it appears your test is missing a pre-condition. I think you should ensure "companies/1" exists in store1 and store2 before you delete it from store1, and poll store2 until timeout or it no longer exists. I'm not aware of the specific syntax for RavenDB [yet] but I am surprised that there is no query you can use to see if "companies/1" exists other than to load the company. I assume RavenDB will return null if the requested document is not found? http://ayende.com/4518/a-bug-that-drove-me-crazy#comment8http://ayende.com/4518/a-bug-that-drove-me-crazy#comment8Mon, 24 May 2010 12:33:06 GMTYeah, I was thinking cache too. http://ayende.com/4518/a-bug-that-drove-me-crazy#comment7http://ayende.com/4518/a-bug-that-drove-me-crazy#comment7Mon, 24 May 2010 11:53:10 GMTBut that's only because you hinted about it being about the session, I'd not have seen that - and I'm fairly sure I've done similar in NH before by accident! http://ayende.com/4518/a-bug-that-drove-me-crazy#comment6http://ayende.com/4518/a-bug-that-drove-me-crazy#comment6Mon, 24 May 2010 11:25:43 GMTCaching is the answer from my glance http://ayende.com/4518/a-bug-that-drove-me-crazy#comment5http://ayende.com/4518/a-bug-that-drove-me-crazy#comment5Mon, 24 May 2010 11:24:42 GMTMy guess would be along the lines of Rafal.. I don't know RavenDB but I'd guess there'd be a parameter available on Load() to ensure a clean hit to the document source. (I.e. NoCache) http://ayende.com/4518/a-bug-that-drove-me-crazy#comment4http://ayende.com/4518/a-bug-that-drove-me-crazy#comment4Mon, 24 May 2010 11:06:07 GMTif (company == null) is the bug if (company != null) is the correct thing you want to do. Those thing are can drive one crazy http://ayende.com/4518/a-bug-that-drove-me-crazy#comment3http://ayende.com/4518/a-bug-that-drove-me-crazy#comment3Mon, 24 May 2010 10:46:25 GMTIf loaded once successfully, the non-null object is cached by the session. http://ayende.com/4518/a-bug-that-drove-me-crazy#comment2http://ayende.com/4518/a-bug-that-drove-me-crazy#comment2Mon, 24 May 2010 10:23:15 GMTA session-level cache doesn't know that underlying data was deleted after it has been read for the first time? http://ayende.com/4518/a-bug-that-drove-me-crazy#comment1http://ayende.com/4518/a-bug-that-drove-me-crazy#comment1Mon, 24 May 2010 09:02:06 GMT