This means that our query planner could not run the given query efficiently (using zigzag merge join) with the indexes available. Currently this can happen if you pull a lot of results or if the data being queried is especially inefficient for the given query. Given that this error is data dependent it can be hard to reproduce or know when it will happen. We are working to remove this restriction, but in the mean time you should add a composite index that contains the properties you are querying on (or if you're clever you can use a subset of those properties, I would avoid more than one multivalued property). For more information about why this happens you can watch some IO talks:
http://www.youtube.com/watch?v=tx5gdoNpcZM http://www.youtube.com/watch?v=ofhEyDBpngM On Fri, Jun 11, 2010 at 11:00 PM, Ravi <[email protected]> wrote: > Hi Google Team, > > All these days our application was working fine and we have not > changed any datastore index or codebase of our application. > Everyday we upload new set of data to our application. Today also we > have uploaded new set of data but today after uploading the data we > are getting very strange exception as below: > > com.google.appengine.api.datastore.DatastoreNeedIndexException: The > built-in indices are not efficient enough for this query and your > data. Please add a composite index for this query.. An index is > missing but we are unable to tell you which one due to a bug in the > App Engine SDK. If your query only contains equality filters you most > likely need a composite index on all the properties referenced in > those filters. > > We are worried after seeing the above exception, we dont have any > complex queries, all the queries contain equals to filter (==). > We tested the same set of data and query in our development > environment, it is working fine. > For testing purpose, we uploaded the same set of data to our other > testing appengine applcation, it is working fine there also. > > Only in our production system, we are getting > DatastoreNeedIndexException. > > Could you please confirm is there any problem with the datastore > indexing. > Data stored in our production datastore is more than 0.5 GB, will > thee be any problem in indexing if there is high amount of data. > > Application ID: bigpaisa2.appspot.com > Latest application version: http://061102.latest.bigpaisa2.appspot.com > - In this version DatastoreNeedIndexException is occuring. > > Please help us as soon as possible. > > Thanks, > Ravi > > -- > 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]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- 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.
