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 <[email protected]> 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 [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 -~----------~----~----~----~------~----~------~--~---
