<html>
<head>
<base href="https://bugs.webkit.org/" />
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_NEW "
title="NEW - Appscale query fails because of missing index"
href="https://bugs.webkit.org/show_bug.cgi?id=149609">149609</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Appscale query fails because of missing index
</td>
</tr>
<tr>
<th>Classification</th>
<td>Unclassified
</td>
</tr>
<tr>
<th>Product</th>
<td>WebKit
</td>
</tr>
<tr>
<th>Version</th>
<td>WebKit Local Build
</td>
</tr>
<tr>
<th>Hardware</th>
<td>Unspecified
</td>
</tr>
<tr>
<th>OS</th>
<td>Unspecified
</td>
</tr>
<tr>
<th>Status</th>
<td>NEW
</td>
</tr>
<tr>
<th>Severity</th>
<td>Normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>P2
</td>
</tr>
<tr>
<th>Component</th>
<td>Tools / Tests
</td>
</tr>
<tr>
<th>Assignee</th>
<td>webkit-unassigned@lists.webkit.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>aakash_jain@apple.com
</td>
</tr>
<tr>
<th>CC</th>
<td>lforschler@apple.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>