Hi Oleg,

Sorry it took long, but I've just put your indexes into 'Error' state.
I think you should be able to vacuum them now.

Enjoy :)


On Wed, Aug 22, 2012 at 2:25 AM, Oleg Bashtenko <[email protected]> wrote:

> Oops. Thank you. Looks like that I forgot to remove one more inequality
> constraint. This query:
>
> com.googlecode.objectify.impl.QueryImpl{kind=Ticket,ancestor=,filter=
> activeEQUALtrue,filter=technicianKeyEQUALUser("tech"),filter=vipEQUALtrue,
> sort=techPriorityLevelASCENDING,limit=10}
>
> works OK, but this one
>
> com.googlecode.objectify.impl.QueryImpl{kind=Ticket,ancestor=,filter=
> activeEQUALtrue,filter=dueDateLESS_THAN_OR_EQUALTue Aug 21 17:15:44 UTC
> 2012,filter=dueDateNOT_EQUALnull,filter=technicianKeyEQUALUser("tech"),
> filter=vipEQUALtrue,sort=dueDateASCENDING,sort=techPriorityLevelASCENDING,
> limit=10}
>
> fails.
>
> As far as I understand, I have to define additional indices with {dueDate}
> field since I want to set an inequality filter on it, right? This should
> double the number of indices I have to define, but still fits the quota.
>
> Thank you for your help. Now the only my problem left is vacuuming those
> 220 stuck indices in datastore.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/google-appengine/-/dwxb_Sk3DogJ.
>
> 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.
>



-- 
Takashi Matsuo | Developers Advocate | [email protected]

-- 
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.

Reply via email to