RESOLVED FIXED149609
Appscale query fails because of missing index 
https://bugs.webkit.org/show_bug.cgi?id=149609
Summary Appscale query fails because of missing index
Aakash Jain
Reported 2015-09-28 17:02:41 PDT
AppScale logs have the following below stacktrace. We add to add the index accordingly. 33369 File "/var/apps/webkit-queues/app/handlers/queuestatus.py", line 65, in _fetch_statuses 33370 return statuses.order("-date").fetch(15) 33371 File "/root/appscale/AppServer/google/appengine/ext/db/__init__.py", line 2157, in fetch 33372 return list(self.run(limit=limit, offset=offset, **kwargs)) 33373 File "/root/appscale/AppServer/google/appengine/ext/db/__init__.py", line 2326, in next 33374 return self.__model_class.from_entity(self.__iterator.next()) 33375 File "/root/appscale/AppServer/google/appengine/datastore/datastore_query.py", line 2892, in next 33376 next_batch = self.__batcher.next() 33377 File "/root/appscale/AppServer/google/appengine/datastore/datastore_query.py", line 2754, in next 33378 return self.next_batch(self.AT_LEAST_ONE) 33379 File "/root/appscale/AppServer/google/appengine/datastore/datastore_query.py", line 2791, in next_batch 33380 batch = self.__next_batch.get_result() 33381 File "/root/appscale/AppServer/google/appengine/api/apiproxy_stub_map.py", line 615, in get_result 33382 return self.__get_result_hook(self) 33383 File "/root/appscale/AppServer/google/appengine/datastore/datastore_query.py", line 2543, in __query_result_hook 33384 yaml_index=yaml, xml_index=xml) 33385 NeedIndexError: Query requires an index 33386 The suggested index for this query is: 33387 - kind: QueueStatus 33388 properties: 33389 - name: bot_id 33390 - name: queue_name 33391 - name: date 33392 direction: desc
Attachments
proposed patch (1.00 KB, patch)
2015-09-28 17:09 PDT, Aakash Jain 		no flags
DetailsFormatted DiffDiff
View All Add attachment proposed patch, testcase, etc.
Aakash Jain
Comment 1 2015-09-28 17:04:34 PDT
It is a regression from https://bugs.webkit.org/show_bug.cgi?id=149194
Aakash Jain
Comment 2 2015-09-28 17:09:47 PDT
Created attachment 262031 [details] proposed patch
WebKit Commit Bot
Comment 3 2015-09-28 18:09:14 PDT
Comment on attachment 262031 [details] proposed patch Clearing flags on attachment: 262031 Committed r190300: <http://trac.webkit.org/changeset/190300>
WebKit Commit Bot
Comment 4 2015-09-28 18:09:19 PDT
All reviewed patches have been landed. Closing bug.
Note You need to log in before you can comment on or make changes to this bug.