Hi Denya, Your indexes should be fixed now. -Nick Johnson
On Mon, Sep 21, 2009 at 3:30 PM, Denya <[email protected]> wrote: > Hey, is there anybody there? > I can't understand, why my queries fails. > > app-id: classificators-ru > > Query: > SELECT * FROM KladrStreetRecord WHERE name = 'Грузинская Б.' > > Returns one record with city_code = '77000000000' (type 'string') > > Query: > SELECT * FROM KladrStreetRecord WHERE city_code = '77000000000' AND name = > 'Грузинская Б.' > > Returns none. > > WTF?!?!? > > > On Sun, Sep 20, 2009 at 10:56 PM, Denya <[email protected]> wrote: > >> Tried to delete indexes -- after 5h status became <<Error>>.Cool, and what? >> :) I want to rebuild some of them. >> >> Now i make vacuum_indexes again and they are <<Deleting>> now... And how much >> time it take? >> >> BTW, i decide to rebuild indexes (delete and create it again) cause there >> were magic problems with data fetching. >> >> Query SELECT * FROM KladrStreetRecord WHERE name = 'Gruz' >> returned records, where name = 'Gruz', ok >> >> Query SELECT * FROM KladrStreetRecord WHERE name >= 'Gruz' >> returned records, where name = 'Gruzaa', 'Gruzzz', but no 'Gruz'. >> >> This is just example, but really some of records disappeared, when i make >> query with inequality. >> >> >> On Fri, Sep 18, 2009 at 2:43 PM, Nick Johnson (Google) < >> [email protected]> wrote: >> >>> Hi Denya, >>> Your index is still building. Please email us back if it's been >24 hours >>> and hasn't built yet. >>> >>> -Nick Johnson >>> >>> >>> On Fri, Sep 18, 2009 at 9:11 AM, Denya <[email protected]> wrote: >>> >>>> At all, we've got stuked indexes...Hey, anybody can help us? We're >>>> waitin' for indexes > 5h. >>>> Yesterday indexes for the same db was built in 5min >>>> >>>> >>>> >>> >>> >>> -- >>> Nick Johnson, Developer Programs Engineer, App Engine >>> Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration >>> Number: 368047 >>> >>> >>> >> > > > > -- Nick Johnson, Developer Programs Engineer, App Engine Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number: 368047 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
