Hi Natalie,
On Thu, Aug 6, 2009 at 4:05 PM, Natalie Gordon<[email protected]> wrote:
>
> 1. How do I delete indexes? I removed all but 3 indices for a class in
> the index.yaml file. I uploaded this last night but there are still 9
> indices shown as serving in the dashboard (none are marked for
> deletion).
You need to run "appcfg.py vacuum_indexes".
>
> 2. The following behaviour started occuring last night (we've been
> live for a couple of weeks). I believe it started when I introduced a
> new (unrelated) index on the table. The following code has not changed
> in months. The following code is called for a user's inbox and sent
> mail. Now these non-deterministically return records.
>
> In debugging this I changed both DESC to ASC and uploaded it. Only the
> from_member query returned all the records. The other returned none. I
> uploaded it again sorted on a different date field and the other query
> returned records. The data hasn't changed (all fields are non-null).
This is a variation on a known problem that affects a few apps. We're
looking into it, and we'll get it fixed as soon as possible.
-Nick Johnson
>
> @classmethod
> def get_mail_to_member(cls, member, limit=10, offset=0):
> return Mail.gql("WHERE to_member = :1 AND is_active_to_member
> = :2 ORDER BY sent_date DESC", member, True).fetch(limit,
> offset=offset)
>
> �...@classmethod
> def get_mail_from_member(cls, member, limit=10, offset=0):
> return Mail.gql("WHERE from_member = :1 AND
> is_active_from_member = :2 ORDER BY sent_date DESC", member,
> True).fetch(limit, offset=offset)
>
> Has anyone seen this before? I want to clear out all extraneous
> indices on this table (see question 1).
>
> Thanks!
> Natalie Gordon
> http://lenguajero.com
> >
>
--
Nick Johnson, Developer Programs Engineer, App Engine
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
