Jeff, >Unless I'm misunderstanding the structure of > your entities. What does a GeoIpBlock look like?
class GeoIpBlock(db.Model): ipRange = db.ListProperty(int) locId = db.IntegerProperty(indexed=False) > 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? When I do following: SELECT * FROM GeoIpBlock where ipRange >= 2398436100 -note only one inequality I get first 1000 results, with the first result: Ip-1973013 [2398436096L, 2398436351L] 14997 Which is actually what I need... except that when I narrow it down and add second inequality I brake it, as: SELECT * FROM GeoIpBlock where ipRange >= 2398436100 and ipRange <= 2398436100 returns no results. Thanks, Sergiy. On Jun 3, 2:25 pm, "Jeff S (Google)" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
