149609 2015-09-28 17:02:41 -0700 Appscale query fails because of missing index 2017-03-15 17:15:28 -0700 1 1 1 Unclassified WebKit Tools / Tests WebKit Local Build Unspecified Unspecified RESOLVED FIXED P2 Normal --- 1 aakash_jain aakash_jain ap commit-queue ddkilzer lforschler oldest_to_newest 1129115 0 aakash_jain 2015-09-28 17:02:41 -0700 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 1129116 1 aakash_jain 2015-09-28 17:04:34 -0700 It is a regression from https://bugs.webkit.org/show_bug.cgi?id=149194 1129122 2 262031 aakash_jain 2015-09-28 17:09:47 -0700 Created attachment 262031 proposed patch 1129133 3 262031 commit-queue 2015-09-28 18:09:14 -0700 Comment on attachment 262031 proposed patch Clearing flags on attachment: 262031 Committed r190300: <http://trac.webkit.org/changeset/190300> 1129134 4 commit-queue 2015-09-28 18:09:19 -0700 All reviewed patches have been landed. Closing bug. 262031 2015-09-28 17:09:47 -0700 2015-09-28 18:09:14 -0700 proposed patch patch-index1 text/plain 1029 aakash_jain SW5kZXg6IFRvb2xzL0NoYW5nZUxvZwo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09Ci0tLSBUb29scy9DaGFuZ2VMb2cJKHJl dmlzaW9uIDE5MDI5NykKKysrIFRvb2xzL0NoYW5nZUxvZwkod29ya2luZyBjb3B5KQpAQCAtMSwz ICsxLDEyIEBACisyMDE1LTA5LTI4ICBBYWthc2ggSmFpbiAgPGFha2FzaF9qYWluQGFwcGxlLmNv bT4KKworICAgICAgICBBcHBzY2FsZSBxdWVyeSBmYWlscyBiZWNhdXNlIG9mIG1pc3NpbmcgaW5k ZXgKKyAgICAgICAgaHR0cHM6Ly9idWdzLndlYmtpdC5vcmcvc2hvd19idWcuY2dpP2lkPTE0OTYw OQorCisgICAgICAgIFJldmlld2VkIGJ5IE5PQk9EWSAoT09QUyEpLgorCisgICAgICAgICogUXVl dWVTdGF0dXNTZXJ2ZXIvaW5kZXgueWFtbDogQWRkZWQgdGhlIHJlcXVpcmVkIGluZGV4LgorCiAy MDE1LTA5LTI4ICBCcmVudCBGdWxnaGFtICA8YmZ1bGdoYW1AYXBwbGUuY29tPgogCiAgICAgICAg IFtXaW5dIEFsbG93IFdpbmRvd3MgdG8gcnVuIHRlc3Qtd2Via2l0cHkgd2l0aG91dCBDeWd3aW4K SW5kZXg6IFRvb2xzL1F1ZXVlU3RhdHVzU2VydmVyL2luZGV4LnlhbWwKPT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQotLS0g VG9vbHMvUXVldWVTdGF0dXNTZXJ2ZXIvaW5kZXgueWFtbAkocmV2aXNpb24gMTkwMjg4KQorKysg VG9vbHMvUXVldWVTdGF0dXNTZXJ2ZXIvaW5kZXgueWFtbAkod29ya2luZyBjb3B5KQpAQCAtNTYs NiArNTYsMTMgQEAgaW5kZXhlczoKIAogLSBraW5kOiBRdWV1ZVN0YXR1cwogICBwcm9wZXJ0aWVz OgorICAtIG5hbWU6IGJvdF9pZAorICAtIG5hbWU6IHF1ZXVlX25hbWUKKyAgLSBuYW1lOiBkYXRl CisgICAgZGlyZWN0aW9uOiBkZXNjCisKKy0ga2luZDogUXVldWVTdGF0dXMKKyAgcHJvcGVydGll czoKICAgLSBuYW1lOiBtZXNzYWdlCiAgIC0gbmFtZTogcXVldWVfbmFtZQogICAtIG5hbWU6IGRh dGUK