Thanks! I removed stuck indexes. However, I still get errors on 'order by updated_at' even 'order by updated_at desc' sometimes.
- Kazuho On Fri, Sep 18, 2009 at 11:05 AM, Jeff S (Google) <j...@google.com> wrote: > Hi Kazuho, > > I've set the state of the stuck indexes to error for twitrackbacktest so > that they can be removed. I'm still looking into possible issues in > echofonsync. > > Thank you, > > Jeff > > On Fri, Sep 18, 2009 at 10:23 AM, Kazuho Okui <kaz...@gmail.com> wrote: >> >> Hi >> >> I have 2 instance. >> >> app_id: twitrackbacktest >> >> Indexing stuck. Building / deleting index stuck. it takes almost 2weeks. >> >> >> app_id: echofonsync >> >> index of 'updated_at' is somehow broken. Following query always >> returns datastore_errors.timeout >> >> SELECT * FROM Users ORDER BY updated_at >> >> related query also causes error even I re-create index. >> >> SELECT * FROM User ORDER BY updated_at,device_token >> >> It's very odd, but if I add 'desc' to updated_at, it works. >> >> SELECT * FROM User ORDER BY updated_at desc >> >> Other indexes works fine. >> >> SELECT * FROM User ORDER BY user_id >> SELECT * FROM User ORDER BY username >> ... >> >> >> - Kazuho >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---