Bug 149609 - Appscale query fails because of missing index
Summary: Appscale query fails because of missing index
Status: RESOLVED FIXED
Alias: None
Product: WebKit
Classification: Unclassified
Component: Tools / Tests (show other bugs)
Version: WebKit Local Build
Hardware: Unspecified Unspecified
: P2 Normal
Assignee: Aakash Jain
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-28 17:02 PDT by Aakash Jain
Modified: 2017-03-15 17:15 PDT (History)
4 users (show)

See Also:


Attachments
proposed patch (1.00 KB, patch)
2015-09-28 17:09 PDT, Aakash Jain
no flags Details | Formatted Diff | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Aakash Jain 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
Comment 1 Aakash Jain 2015-09-28 17:04:34 PDT
It is a regression from https://bugs.webkit.org/show_bug.cgi?id=149194
Comment 2 Aakash Jain 2015-09-28 17:09:47 PDT
Created attachment 262031 [details]
proposed patch
Comment 3 WebKit Commit Bot 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>
Comment 4 WebKit Commit Bot 2015-09-28 18:09:19 PDT
All reviewed patches have been landed.  Closing bug.