Thank you, Nick.Now it works. What was the problem?
Can i hope that the problem doesn't recur? What happens if I delete and then re-create indexes? It is very strange thing. 2009/9/21 Nick Johnson (Google) <[email protected]> > 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 -~----------~----~----~----~------~----~------~--~---
