Hi mega_apps, Well, my first question may seem a bit obvious but, are you certain that an entity is present in the App Engine datastore with ipRange of 2398436100? Also it seems like your query is equivalent to an = query. x <= y and x >= y would be the same as x = y. Unless I'm misunderstanding the structure of your entities. What does a GeoIpBlock look like?
Cheers, Jeff On Wed, Jun 3, 2009 at 8:23 AM, mega_apps <[email protected]> wrote: > > Jeff, thanks for quick reply. > > >What is the ID of this application? > My app id is temptationads. > > >several of the GeoIpBlock entities have a value for a property which is > not of the expected type. > It seems that indexes are being build/rebuild and Data Viewer is not > crashing anymore. > > But it still doesn't work completely: > > SELECT * FROM GeoIpBlock where ipRange >= 50331648 and ipRange <= > 50331648 > > Produces 1 result now in production and dev > > SELECT * FROM GeoIpBlock where ipRange >= 2398436100 and ipRange <= > 2398436100 > > Produces _no_ results in production and 1 result in dev. > > Any ideas? > > > On Jun 2, 4:44 pm, "Jeff S (Google)" <[email protected]> wrote: > > Hi mega_apps, > > > > My first guess would be that one or several of the GeoIpBlock entities > have > > a value for a property which is not of the expected type. What is the ID > of > > this application? > > > > Thank you, > > > > Jeff > > > > On Sat, May 30, 2009 at 5:33 PM, mega_apps <[email protected]> wrote: > > > > > I am getting 500 errors when executing valid GQL queries to the > > > datastore using the Data Viewer: > > > > > SELECT * FROM GeoIpBlock where ipRange >= 0 > > > > > The same queries work fine in development. > > > > > I uploaded over 3,000,000 GeoIpBlock entities and had to purchase > > > additional Storage when growing indexes hit 1G. Could corrupted > > > indexes cause this? > > > > > . > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" 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/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
