After over 12h of build time, an index over 500,000 entities (200MB of
data) finished building right after I submitted a message for
moderation, asking for help (did somebody at Google do something ?).
(App: 911pagers).
However, the index that was built is incorrect. Indeed, the same GQL
query (e.g. in the admin console) returns different result depending
on whether it has an "order by" statement or not.
SELECT * FROM MessageS where number = '[004548018]'
SELECT * FROM MessageS where number = '[004548018]' order by id
asc
The first query returns 4 results, the second query only 2.
The index in question is:
<datastore-index kind="MessageS" ancestor="false" source="auto">
<property name="number" direction="asc"/>
<property name="id" direction="asc"/>
</datastore-index>
I will delete the index and force a rebuild, but I'll give 6 hours to
Google people to look at it if they want to debug something. You can
contact me directly if needed.
Thanks.
--
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.
