It seems a lot of errors occur in 'order by updated_at desc' now. 'order by updated_at' doesn't work for a week.
Any updates? On Sat, Sep 19, 2009 at 12:16 PM, Kazuho Okui <[email protected]> wrote: > 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) <[email protected]> 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 <[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 -~----------~----~----~----~------~----~------~--~---
