How long will this take? Fixing just single index issue takes more than 2 weeks?
On Tue, Sep 22, 2009 at 11:28 PM, Kazuho Okui <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
