214597 2020-07-21 09:11:01 -0700 Frequent Network error messages: "ResourceLoadStatisticsDatabaseStore::topPrevalentResourceWithUserInteractionDaysSinceUserInteractionStatement query failed to step, error message: no more rows available" 2020-07-21 12:10:30 -0700 1 1 1 Unclassified WebKit WebKit Misc. WebKit Nightly Build Unspecified Unspecified RESOLVED FIXED InRadar P2 Normal --- 1 katherine_cheney katherine_cheney bfulgham cdumez wilander oldest_to_newest 1673459 0 katherine_cheney 2020-07-21 09:11:01 -0700 These network errors have been appearing since switching to the ITP SQLite store. 1673460 1 katherine_cheney 2020-07-21 09:11:26 -0700 rdar://65884740 1673490 2 404832 katherine_cheney 2020-07-21 10:19:22 -0700 Created attachment 404832 Patch 1673506 3 404832 wilander 2020-07-21 10:47:10 -0700 Comment on attachment 404832 Patch r=me if EWS is happy. 1673560 4 ews-feeder 2020-07-21 12:10:30 -0700 Committed r264670: <https://trac.webkit.org/changeset/264670> All reviewed patches have been landed. Closing bug and clearing flags on attachment 404832. 404832 2020-07-21 10:19:22 -0700 2020-07-21 12:10:30 -0700 Patch bug-214597-20200721101921.patch text/plain 4890 katherine_cheney U3VidmVyc2lvbiBSZXZpc2lvbjogMjY0NjA3CmRpZmYgLS1naXQgYS9Tb3VyY2UvV2ViS2l0L0No YW5nZUxvZyBiL1NvdXJjZS9XZWJLaXQvQ2hhbmdlTG9nCmluZGV4IDI5N2Y5MjFmYTRjNjdkZjkx YTM4YjU0ZmNjM2M1OTRkZDY4ZjRkYTAuLmY4YjdkNjRmN2U2ZjAyOTFkNjI4OWUyOTEzZjVkYzVl MTU5NjJlZjcgMTAwNjQ0Ci0tLSBhL1NvdXJjZS9XZWJLaXQvQ2hhbmdlTG9nCisrKyBiL1NvdXJj ZS9XZWJLaXQvQ2hhbmdlTG9nCkBAIC0xLDMgKzEsMjAgQEAKKzIwMjAtMDctMjEgIEthdGUgQ2hl bmV5ICA8a2F0aGVyaW5lX2NoZW5leUBhcHBsZS5jb20+CisKKyAgICAgICAgRnJlcXVlbnQgTmV0 d29yayBlcnJvciBtZXNzYWdlczogIlJlc291cmNlTG9hZFN0YXRpc3RpY3NEYXRhYmFzZVN0b3Jl Ojp0b3BQcmV2YWxlbnRSZXNvdXJjZVdpdGhVc2VySW50ZXJhY3Rpb25EYXlzU2luY2VVc2VySW50 ZXJhY3Rpb25TdGF0ZW1lbnQgcXVlcnkgZmFpbGVkIHRvIHN0ZXAsIGVycm9yIG1lc3NhZ2U6IG5v IG1vcmUgcm93cyBhdmFpbGFibGUiCisgICAgICAgIGh0dHBzOi8vYnVncy53ZWJraXQub3JnL3No b3dfYnVnLmNnaT9pZD0yMTQ1OTcKKyAgICAgICAgPHJkYXI6Ly82NTg4NDc0MD4KKworICAgICAg ICBSZXZpZXdlZCBieSBOT0JPRFkgKE9PUFMhKS4KKworICAgICAgICBXZSBzaG91bGQgbm90IGxv ZyBhbiBlcnJvciBtZXNzYWdlIHdoZW4gbm8gcm93cyBhcmUgcmV0dXJuZWQgd2hlbiBydW5uaW5n CisgICAgICAgIHRlbGVtZXRyeSBxdWVyaWVzLCBiZWNhdXNlIHRoaXMgaXMgbm90IGFuIGVycm9y LgorCisgICAgICAgICogTmV0d29ya1Byb2Nlc3MvQ2xhc3NpZmllci9SZXNvdXJjZUxvYWRTdGF0 aXN0aWNzRGF0YWJhc2VTdG9yZS5jcHA6CisgICAgICAgIChXZWJLaXQ6OmdldE1lZGlhbk9mUHJl dmFsZW50UmVzb3VyY2VzV2l0aFVzZXJJbnRlcmFjdGlvbik6CisgICAgICAgIChXZWJLaXQ6OlJl c291cmNlTG9hZFN0YXRpc3RpY3NEYXRhYmFzZVN0b3JlOjpnZXRUb3BQcmV2ZWxlbnRSZXNvdXJj ZURheXNTaW5jZVVJIGNvbnN0KToKKyAgICAgICAgUmVtb3ZlIHVubmVjZXNzYXJ5IGVycm9yIGxv Z2dpbmcgYW5kIG9ubHkgY2hlY2sgZm9yIHRlbGVtZXRyeSByZXN1bHRzIGlmIHRoZQorICAgICAg ICBxdWVyeSByZXR1cm5zIGEgcm93LgorCiAyMDIwLTA3LTIwICBEYXZpZCBLaWx6ZXIgIDxkZGtp bHplckBhcHBsZS5jb20+CiAKICAgICAgICAgV2ViUGFnZVByb3h5SWRlbnRpZmllciBwYXJhbWV0 ZXIgb2YgV2ViUGFnZVByb3h5OjpDcmVhdGVOZXdQYWdlKCkgc2hvdWxkIG5vdCBiZSBPcHRpb25h bApkaWZmIC0tZ2l0IGEvU291cmNlL1dlYktpdC9OZXR3b3JrUHJvY2Vzcy9DbGFzc2lmaWVyL1Jl c291cmNlTG9hZFN0YXRpc3RpY3NEYXRhYmFzZVN0b3JlLmNwcCBiL1NvdXJjZS9XZWJLaXQvTmV0 d29ya1Byb2Nlc3MvQ2xhc3NpZmllci9SZXNvdXJjZUxvYWRTdGF0aXN0aWNzRGF0YWJhc2VTdG9y ZS5jcHAKaW5kZXggNjA1MjM2YWE2NTY0NjU1ZjM4MThlMWM3NDA0ZDYwNDljNjUxYTkwOS4uNTRh NmQ5OGYxMmVjMTVmNTI5NjQwZGI1YTY5N2VhNmQ1YzY5OWIzYSAxMDA2NDQKLS0tIGEvU291cmNl L1dlYktpdC9OZXR3b3JrUHJvY2Vzcy9DbGFzc2lmaWVyL1Jlc291cmNlTG9hZFN0YXRpc3RpY3NE YXRhYmFzZVN0b3JlLmNwcAorKysgYi9Tb3VyY2UvV2ViS2l0L05ldHdvcmtQcm9jZXNzL0NsYXNz aWZpZXIvUmVzb3VyY2VMb2FkU3RhdGlzdGljc0RhdGFiYXNlU3RvcmUuY3BwCkBAIC0xMDM5LDEw ICsxMDM5LDggQEAgc3RhdGljIHVuc2lnbmVkIGdldE1lZGlhbk9mUHJldmFsZW50UmVzb3VyY2Vz V2l0aFVzZXJJbnRlcmFjdGlvbihTUUxpdGVEYXRhYmFzZSYKICAgICB9CiAKICAgICAvLyBTdGVw Ci0gICAgaWYgKG1lZGlhbkRheXNTaW5jZVVJU3RhdGVtZW50LnN0ZXAoKSAhPSBTUUxJVEVfUk9X KSB7Ci0gICAgICAgIFJFTEVBU0VfTE9HX0VSUk9SKE5ldHdvcmssICJSZXNvdXJjZUxvYWRTdGF0 aXN0aWNzRGF0YWJhc2VTdG9yZTo6Z2V0TWVkaWFuT2ZQcmV2YWxlbnRSZXNvdXJjZXNXaXRoVXNl ckludGVyYWN0aW9uLCBlcnJvciBtZXNzYWdlOiAlIiBQVUJMSUNfTE9HX1NUUklORywgZGF0YWJh c2UubGFzdEVycm9yTXNnKCkpOworICAgIGlmIChtZWRpYW5EYXlzU2luY2VVSVN0YXRlbWVudC5z dGVwKCkgIT0gU1FMSVRFX1JPVykKICAgICAgICAgcmV0dXJuIDA7Ci0gICAgfQogCiAgICAgZG91 YmxlIHJhd1NlY29uZHMgPSBtZWRpYW5EYXlzU2luY2VVSVN0YXRlbWVudC5nZXRDb2x1bW5Eb3Vi bGUoMCk7CiAgICAgV2FsbFRpbWUgd2FsbFRpbWUgPSBXYWxsVGltZTo6ZnJvbVJhd1NlY29uZHMo cmF3U2Vjb25kcyk7CkBAIC0xMDY4LDE0ICsxMDY2LDEyIEBAIHN0YXRpYyB1bnNpZ25lZCBnZXRN ZWRpYW5PZlByZXZhbGVudFJlc291cmNlc1dpdGhVc2VySW50ZXJhY3Rpb24oU1FMaXRlRGF0YWJh c2UmCiAgICAgfQogCiAgICAgLy8gU3RlcAotICAgIGlmIChsb3dlck1lZGlhbkRheXNTaW5jZVVJ U3RhdGVtZW50LnN0ZXAoKSAhPSBTUUxJVEVfUk9XKSB7Ci0gICAgICAgIFJFTEVBU0VfTE9HX0VS Uk9SKE5ldHdvcmssICJSZXNvdXJjZUxvYWRTdGF0aXN0aWNzRGF0YWJhc2VTdG9yZTo6Z2V0TWVk aWFuT2ZQcmV2YWxlbnRSZXNvdXJjZXNXaXRoVXNlckludGVyYWN0aW9uLCBlcnJvciBtZXNzYWdl OiAlIiBQVUJMSUNfTE9HX1NUUklORywgZGF0YWJhc2UubGFzdEVycm9yTXNnKCkpOwotICAgICAg ICByZXR1cm4gMDsKKyAgICBpZiAobG93ZXJNZWRpYW5EYXlzU2luY2VVSVN0YXRlbWVudC5zdGVw KCkgPT0gU1FMSVRFX1JPVykgeworICAgICAgICBkb3VibGUgcmF3U2Vjb25kc0xvd2VyID0gbG93 ZXJNZWRpYW5EYXlzU2luY2VVSVN0YXRlbWVudC5nZXRDb2x1bW5Eb3VibGUoMCk7CisgICAgICAg IFdhbGxUaW1lIHdhbGxUaW1lTG93ZXIgPSBXYWxsVGltZTo6ZnJvbVJhd1NlY29uZHMocmF3U2Vj b25kc0xvd2VyKTsKKyAgICAgICAgcmV0dXJuICgod2FsbFRpbWVMb3dlciA8PSBXYWxsVGltZSgp ID8gMCA6IHN0ZDo6Zmxvb3IoKFdhbGxUaW1lOjpub3coKSAtIHdhbGxUaW1lTG93ZXIpIC8gMjRf aCkpICsgbWVkaWFuKSAvIDI7CiAgICAgfQotCi0gICAgZG91YmxlIHJhd1NlY29uZHNMb3dlciA9 IGxvd2VyTWVkaWFuRGF5c1NpbmNlVUlTdGF0ZW1lbnQuZ2V0Q29sdW1uRG91YmxlKDApOwotICAg IFdhbGxUaW1lIHdhbGxUaW1lTG93ZXIgPSBXYWxsVGltZTo6ZnJvbVJhd1NlY29uZHMocmF3U2Vj b25kc0xvd2VyKTsKLSAgICByZXR1cm4gKCh3YWxsVGltZUxvd2VyIDw9IFdhbGxUaW1lKCkgPyAw IDogc3RkOjpmbG9vcigoV2FsbFRpbWU6Om5vdygpIC0gd2FsbFRpbWVMb3dlcikgLyAyNF9oKSkg KyBtZWRpYW4pIC8gMjsKKyAgICByZXR1cm4gMDsKIH0KIAogdW5zaWduZWQgUmVzb3VyY2VMb2Fk U3RhdGlzdGljc0RhdGFiYXNlU3RvcmU6OmdldE51bWJlck9mUHJldmFsZW50UmVzb3VyY2VzKCkg Y29uc3QKQEAgLTExMjgsMTUgKzExMjQsMTIgQEAgdW5zaWduZWQgUmVzb3VyY2VMb2FkU3RhdGlz dGljc0RhdGFiYXNlU3RvcmU6OmdldFRvcFByZXZlbGVudFJlc291cmNlRGF5c1NpbmNlVUkKICAg ICB9CiAgICAgCiAgICAgLy8gU3RlcAotICAgIGlmICh0b3BQcmV2YWxlbnRSZXNvdXJjZVdpdGhV c2VySW50ZXJhY3Rpb25EYXlzU2luY2VVc2VySW50ZXJhY3Rpb25TdGF0ZW1lbnQuc3RlcCgpICE9 IFNRTElURV9ST1cpIHsKLSAgICAgICAgUkVMRUFTRV9MT0dfRVJST1IoTmV0d29yaywgIlJlc291 cmNlTG9hZFN0YXRpc3RpY3NEYXRhYmFzZVN0b3JlOjp0b3BQcmV2YWxlbnRSZXNvdXJjZVdpdGhV c2VySW50ZXJhY3Rpb25EYXlzU2luY2VVc2VySW50ZXJhY3Rpb25TdGF0ZW1lbnQgcXVlcnkgZmFp bGVkIHRvIHN0ZXAsIGVycm9yIG1lc3NhZ2U6ICUiIFBVQkxJQ19MT0dfU1RSSU5HLCBtX2RhdGFi YXNlLmxhc3RFcnJvck1zZygpKTsKLSAgICAgICAgcmV0dXJuIDA7CisgICAgaWYgKHRvcFByZXZh bGVudFJlc291cmNlV2l0aFVzZXJJbnRlcmFjdGlvbkRheXNTaW5jZVVzZXJJbnRlcmFjdGlvblN0 YXRlbWVudC5zdGVwKCkgPT0gU1FMSVRFX1JPVykgeworICAgICAgICBkb3VibGUgcmF3U2Vjb25k cyA9IHRvcFByZXZhbGVudFJlc291cmNlV2l0aFVzZXJJbnRlcmFjdGlvbkRheXNTaW5jZVVzZXJJ bnRlcmFjdGlvblN0YXRlbWVudC5nZXRDb2x1bW5Eb3VibGUoMCk7CisgICAgICAgIFdhbGxUaW1l IHdhbGxUaW1lID0gV2FsbFRpbWU6OmZyb21SYXdTZWNvbmRzKHJhd1NlY29uZHMpOworICAgICAg ICByZXR1cm4gd2FsbFRpbWUgPD0gV2FsbFRpbWUoKSA/IDAgOiBzdGQ6OmZsb29yKChXYWxsVGlt ZTo6bm93KCkgLSB3YWxsVGltZSkgLyAyNF9oKTsKICAgICB9Ci0gICAgCi0gICAgZG91YmxlIHJh d1NlY29uZHMgPSB0b3BQcmV2YWxlbnRSZXNvdXJjZVdpdGhVc2VySW50ZXJhY3Rpb25EYXlzU2lu Y2VVc2VySW50ZXJhY3Rpb25TdGF0ZW1lbnQuZ2V0Q29sdW1uRG91YmxlKDApOwotICAgIFdhbGxU aW1lIHdhbGxUaW1lID0gV2FsbFRpbWU6OmZyb21SYXdTZWNvbmRzKHJhd1NlY29uZHMpOwotICAg IAotICAgIHJldHVybiB3YWxsVGltZSA8PSBXYWxsVGltZSgpID8gMCA6IHN0ZDo6Zmxvb3IoKFdh bGxUaW1lOjpub3coKSAtIHdhbGxUaW1lKSAvIDI0X2gpOworICAgIHJldHVybiAwOwogfQogCiBz dGF0aWMgdW5zaWduZWQgZ2V0TWVkaWFuT2ZQcmV2YWxlbnRSZXNvdXJjZVdpdGhvdXRVc2VySW50 ZXJhY3Rpb24oU1FMaXRlRGF0YWJhc2UmIGRhdGFiYXNlLCB1bnNpZ25lZCBidWNrZXRTaXplLCBQ cmV2YWxlbnRSZXNvdXJjZURhdGFiYXNlVGVsZW1ldHJ5OjpTdGF0aXN0aWMgc3RhdGlzdGljLCB1 bnNpZ25lZCBudW1iZXJPZlByZXZhbGVudFJlc291cmNlc1dpdGhvdXRVSSkK