This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I've been using Lightspeed a little while now, and have been really pleased. I need to use the Consistent Read ability with Amazon SimpleDB, so I upgraded to 3.11 The following code was working fine before I upgraded:
Using uow As DataAccess.DataAccess.ConfigurationDataUnitOfWork = ConfigurationsContext.CreateUnitOfWork() Do While .MagicCookie.Length = 0 .MagicCookie = CreateMagicCookieValue() ' check that it's unique
Dim Matches = From m In uow.MagicCookies Where m.MagicCookie = .MagicCookie Select m Take 1 If Matches.Count > 0 Then ' its not unique, try again .MagicCookie = String.Empty End If Loop ... End Using After the upgrade it gets stuck in a loop, always finding matches. Using wireshark I had a look at the request being sent to Amazon (is there an easier way to do this?) and found the following: Action=Select&SelectExpression=SELECT%20%0D%0ACOUNT%28%2A%29%0D%0AFROM%20CGMMagicCookies%0D%0A%0D%0A&AWSAccessKeyId=**************&SignatureVersion=2&SignatureMethod=HmacSHA256&Timestamp=2010-08-31T12%3A21%3A22.212Z&Version=2009-04-15&Signature=************************* This appears to be performing a count of the whole domain not searching to see how many matched the WHERE part of my query. I've tried the 31st Aug nightly build, but no joy. I'm sure this code was working fine before the upgrade... Any suggestions? TIA, Alex
|
|
|
|
|
Apologies for this. We made some changes to the way LightSpeed handled the Where-Skip/Take-Count combination in 3.11, and these seem to have caused an issue in the SimpleDB provider. I've committed a candidate fix which should address your issue, and this will be included in the 3 August nightly build, available from about 1500 GMT. Please let us know if you still see the problem with the new nightly build, and thanks for letting us know about this. |
|
|
|
