Hi Denya, The problem was due to a known bug with composite indexes that very rarely causes them to become out of date for some records. You can use your app as normal - it's unlikely to recur.
-Nick Johnson On Mon, Sep 21, 2009 at 4:43 PM, Denya <[email protected]> wrote: > 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 >> >> >> > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
