Hi Kazuho Okui, Which queries are giving you errors? It looks like you have an index on updated_at which is ascending and if there are no other filters in your query with updated_at descending then the single property indexes (there are two for each indexed property, one ascending, one descending) should be able to support this query. What is the specific error that you are seeing?
Thank you, Jeff On Wed, Sep 30, 2009 at 10:02 AM, Kazuho Okui <kaz...@gmail.com> wrote: > > 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 <kaz...@gmail.com> 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 <kaz...@gmail.com> 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) <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 -~----------~----~----~----~------~----~------~--~---
