137503 2014-10-07 15:34:32 -0700 [iOS] WebSQL operations are not performed after device is locked 2015-05-19 13:10:59 -0700 1 1 1 Unclassified WebKit WebCore Misc. 420+ iPhone / iPad iOS 8.0 RESOLVED FIXED http://media.brehaut.net/files/ios8-websql-bug.html InRadar P2 Normal --- 1 andrew dbates ap beidson dbates dev+webkit oliver sit webkit-bug-importer oldest_to_newest 1040149 0 andrew 2014-10-07 15:34:32 -0700 On a device running iOS8 (8.0.2), and a web app (includes <meta name="apple-mobile-web-app-capable" content="yes" />) is saved to the homescreen, if the device is locked (via timeout or the sleep/wake button), when the device is unlocked again, the application's websql connection is non-responsive until the application is backgrounded and relaunched. To reproduce: * visit http://media.brehaut.net/files/ios8-websql-bug.html in mobile Safari * tap the 'test db' link; an alert should appear stating 'in transaction'. * lock the screen * unlock the screen * tap the 'test db' link again. within mobile Safari proper this should again raise the alert dialog. * save the app to the home screen. * tap the 'test db' link; an alert should appear stating 'in transaction'. * lock the screen * unlock the screen * tap the 'test db' link again. the alert should never be raised. * background the app and relaunch at this point and it should behave correctly again. The javascript executed by the link is basically: openDatabase("test", "1.0", "test", 1 * 1024 * 1024).transaction(function (tx) { alert("in transaction"); }); Running the same thing from any web app via a connected web inspector should produce the same results. 1040203 1 ap 2014-10-07 21:49:10 -0700 Not sure if this is the same as <rdar://problem/18042389> (the link only works for Apple employees) 1044137 2 240456 dbates 2014-10-25 13:31:07 -0700 Created attachment 240456 [Web Archive] ios8-websql-bug.html Web archive of <http://media.brehaut.net/files/ios8-websql-bug.html> as it appeared on 10/25/2014. 1046833 3 dbates 2014-11-06 09:28:28 -0800 <rdar://problem/18894598> 1092339 4 dbates 2015-05-06 15:09:06 -0700 (In reply to comment #3) > <rdar://problem/18894598> Disregard this radar. It doesn't cover the issue mentioned in this bug, which is specific to showing a modal dialog. 1092341 5 webkit-bug-importer 2015-05-06 15:09:42 -0700 <rdar://problem/20844952> 1093203 6 dbates 2015-05-08 09:28:47 -0700 I'm unable to reproduce this issue using the attached test case in shipping iOS 8.3 (12F70) on an iPhone 5s. I can confirm that this bug reproduces in iOS 8.0.2 (12A405) on an iPhone 5. 1093204 7 252723 dbates 2015-05-08 09:35:48 -0700 Created attachment 252723 Manual test 1093258 8 dbates 2015-05-08 12:00:56 -0700 Committed r184002: <http://trac.webkit.org/changeset/184002> 1095988 9 sit 2015-05-19 12:09:47 -0700 Hey Guys and first off all excuse me for interrupting! I'm writing you from germany relating to this WebKit issue. We have an application in the german iOS Appstore. Today one of the users who downloaded that application called the support hotline from our company and said, that he is not able to use our application. It is a Cordova/Hybrid one. After our support assistent talked to him over half an our he forwarded that problem to us, the programmers. We tried very much till now, but we are not able to exactly tell where the problem is. We build an application for hunters who are able to report hunted animals with that. Therefore we guide them step by step through the report. On iPhone 5S with iOS 8.3 (12F70) we get a database error message. The iPhone 5S users are not possible to report their hunted animals because there is an issue. All other Devices are fine with that version. We started debugging this evening, i'll keep you up to date. If you need further information, or the name from the application (maybe you can test it?!) write me an E-Mail to sithys@me.com Greetings from Germany! Christoph Schimanski 1096012 10 beidson 2015-05-19 13:10:59 -0700 (In reply to comment #9) > Hey Guys and first off all excuse me for interrupting! I'm writing you from > germany relating to this WebKit issue. > > We have an application in the german iOS Appstore. Today one of the users > who downloaded that application called the support hotline from our company > and said, that he is not able to use our application. It is a Cordova/Hybrid > one. > > After our support assistent talked to him over half an our he forwarded that > problem to us, the programmers. We tried very much till now, but we are not > able to exactly tell where the problem is. > > We build an application for hunters who are able to report hunted animals > with that. Therefore we guide them step by step through the report. On > iPhone 5S with iOS 8.3 (12F70) we get a database error message. The iPhone > 5S users are not possible to report their hunted animals because there is an > issue. All other Devices are fine with that version. > > We started debugging this evening, i'll keep you up to date. If you need > further information, or the name from the application (maybe you can test > it?!) write me an E-Mail to sithys@me.com > > Greetings from Germany! > Christoph Schimanski Not sure why you commented in this bug. There's no indication that the issue you are seeing is what was reported here, and there won't be as many folks paying attention since the issue reported here has been resolved. You should file a new bug focused on only your issue. 240456 2014-10-25 13:31:07 -0700 2014-10-25 13:31:07 -0700 [Web Archive] ios8-websql-bug.html ios8-websql-bug_102514.webarchive application/x-webarchive 813 dbates YnBsaXN0MDDRAQJfEA9XZWJNYWluUmVzb3VyY2XVAwQFBgcICQoLDF8QFFdlYlJlc291cmNlRnJh bWVOYW1lXldlYlJlc291cmNlVVJMXxAPV2ViUmVzb3VyY2VEYXRhXxATV2ViUmVzb3VyY2VNSU1F VHlwZV8QG1dlYlJlc291cmNlVGV4dEVuY29kaW5nTmFtZVBfEDNodHRwOi8vbWVkaWEuYnJlaGF1 dC5uZXQvZmlsZXMvaW9zOC13ZWJzcWwtYnVnLmh0bWxPEQIUPCFET0NUWVBFIGh0bWw+PGh0bWw+ PGhlYWQ+CiAgIDx0aXRsZT5pT1M4IHdlYnNxbCBidWcgZXhhbXBsZTwvdGl0bGU+CiAgIDxtZXRh IG5hbWU9ImFwcGxlLW1vYmlsZS13ZWItYXBwLWNhcGFibGUiIGNvbnRlbnQ9InllcyI+CgogICA8 c2NyaXB0IGxhbmd1YWdlPSJqYXZhc2NyaXB0Ij4KICAgICBmdW5jdGlvbiB0ZXN0REIoKSB7CiAg ICAgICAgdmFyIGQgPSBvcGVuRGF0YWJhc2UoInRlc3QiLCAiMS4wIiwgCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgImFuIGVtcHR5IERCIHRvIHRlc3QgY29ubmVjdGl2aXR5IiwgCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgMSAqIDEwMjQgKiAxMDI0KQogICAgICAgIC50cmFuc2Fj dGlvbihmdW5jdGlvbiAodHgpIHsgCiAgICAgICAgICAgYWxlcnQoImluIHRyYW5zYWN0aW9uIik7 CiAgICAgICAgfSk7CiAgICAgfQogICA8L3NjcmlwdD4KIDwvaGVhZD4KCiA8Ym9keT4KIDxhIGhy ZWY9ImphdmFzY3JpcHQ6dGVzdERCKCk7Ij5UZXN0IERCPC9hPgogCgo8L2JvZHk+PC9odG1sPll0 ZXh0L2h0bWxVVVRGLTgACAALAB0AKAA/AE4AYAB2AJQAlQDLAuMC7QAAAAAAAAIBAAAAAAAAAA0A AAAAAAAAAAAAAAAAAALz 252723 2015-05-08 09:35:48 -0700 2015-05-08 11:57:22 -0700 Manual test bug-137503-20150508093429.patch text/plain 2381 dbates U3VidmVyc2lvbiBSZXZpc2lvbjogMTgzNzMyCmRpZmYgLS1naXQgYS9DaGFuZ2VMb2cgYi9DaGFu Z2VMb2cKaW5kZXggMmZmMTg4NTdlOTFlYmJhNWNkYjY1OTRjYWIzYWEyMzZjOGZmNTAyMS4uZjMz YTA2Y2UyNTExZTNmZGQ1M2FlZDZiM2E5YTQ3Y2EwZTJhMDdlNSAxMDA2NDQKLS0tIGEvQ2hhbmdl TG9nCisrKyBiL0NoYW5nZUxvZwpAQCAtMSwzICsxLDE1IEBACisyMDE1LTA1LTA4ICBEYW5pZWwg QmF0ZXMgIDxkYWJhdGVzQGFwcGxlLmNvbT4KKworICAgICAgICBXZWJTUUwgb3BlcmF0aW9ucyBh cmUgbm90IHBlcmZvcm1lZCBhZnRlciBkZXZpY2UgaXMgbG9ja2VkCisgICAgICAgIGh0dHBzOi8v YnVncy53ZWJraXQub3JnL3Nob3dfYnVnLmNnaT9pZD0xMzc1MDMKKyAgICAgICAgPHJkYXI6Ly9w cm9ibGVtLzIwODQ0OTUyPgorCisgICAgICAgIFJldmlld2VkIGJ5IE5PQk9EWSAoT09QUyEpLgor CisgICAgICAgIEFkZCBhIG1hbnVhbCB0ZXN0IHRvIGhlbHAgdmVyaWZ5IHRoYXQgd2UgZG8gbm90 IHJlZ3Jlc3MgdGhpcyBpc3N1ZS4KKworICAgICAgICAqIE1hbnVhbFRlc3RzL2lvcy9leGVjdXRl LXNxbC10cmFuc2FjdGlvbi1jYWxsYmFjay1hZnRlci1sb2NraW5nLXVubG9ja2luZy1kZXZpY2Ut aW4tZWFybGllci10cmFuc2FjdGlvbi5odG1sOiBBZGRlZC4KKwogMjAxNS0wNS0wMSAgTWFydGlu IFJvYmluc29uICA8bXJvYmluc29uQGlnYWxpYS5jb20+CiAKICAgICAgICAgVVNFKC4uLikgbWFj cm8gc2hvdWxkIGV4cGVjdCB1bnByZWZpeGVkIHZhcmlhYmxlcwpkaWZmIC0tZ2l0IGEvTWFudWFs VGVzdHMvaW9zL2V4ZWN1dGUtc3FsLXRyYW5zYWN0aW9uLWNhbGxiYWNrLWFmdGVyLWxvY2tpbmct dW5sb2NraW5nLWRldmljZS1pbi1lYXJsaWVyLXRyYW5zYWN0aW9uLmh0bWwgYi9NYW51YWxUZXN0 cy9pb3MvZXhlY3V0ZS1zcWwtdHJhbnNhY3Rpb24tY2FsbGJhY2stYWZ0ZXItbG9ja2luZy11bmxv Y2tpbmctZGV2aWNlLWluLWVhcmxpZXItdHJhbnNhY3Rpb24uaHRtbApuZXcgZmlsZSBtb2RlIDEw MDY0NAppbmRleCAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwLi41MzQ2 NjE1NTkyN2Q1NGI1NTFlMDUxNGQxNGU2YmY5YWE3Y2FlOWQxCi0tLSAvZGV2L251bGwKKysrIGIv TWFudWFsVGVzdHMvaW9zL2V4ZWN1dGUtc3FsLXRyYW5zYWN0aW9uLWNhbGxiYWNrLWFmdGVyLWxv Y2tpbmctdW5sb2NraW5nLWRldmljZS1pbi1lYXJsaWVyLXRyYW5zYWN0aW9uLmh0bWwKQEAgLTAs MCArMSwyNiBAQAorPCFET0NUWVBFIGh0bWw+Cis8aHRtbD4KKzxoZWFkPgorPG1ldGEgbmFtZT0i YXBwbGUtbW9iaWxlLXdlYi1hcHAtY2FwYWJsZSIgY29udGVudD0ieWVzIj4KKzxzY3JpcHQ+Citm dW5jdGlvbiBvcGVuRGF0YWJhc2VBbmRQZXJmb3JtVHJhbnNhY3Rpb24oY2FsbGJhY2spCit7Cisg ICAgdmFyIGRhdGFiYXNlID0gb3BlbkRhdGFiYXNlKCJhbGVydC1pbnNpZGUtc3FsLXRyYW5zYWN0 aW9uLWRhdGFiYXNlIiwgIjEuMCIsICJhbGVydC1pbnNpZGUtc3FsLXRyYW5zYWN0aW9uLWRhdGFi YXNlIiwgMSAqIDEwMjQgKiAxMDI0IC8qIGJ5dGVzICovKTsKKyAgICBkYXRhYmFzZS50cmFuc2Fj dGlvbihjYWxsYmFjayk7Cit9CisKK2Z1bmN0aW9uIHJ1blRlc3QoKQoreworICAgIG9wZW5EYXRh YmFzZUFuZFBlcmZvcm1UcmFuc2FjdGlvbihmdW5jdGlvbiAoc3FsVHJhbnNhY3Rpb24pIHsgYWxl cnQoIkxvY2sgdGhlIGRldmljZS4gVW5sb2NrIHRoZSBkZXZpY2UgYW5kIHByZXNzIE9LLiIpOyB9 KTsKKyAgICBvcGVuRGF0YWJhc2VBbmRQZXJmb3JtVHJhbnNhY3Rpb24oZnVuY3Rpb24gKHNxbFRy YW5zYWN0aW9uKSB7IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKCJyZXN1bHQiKS50ZXh0Q29udGVu dCA9ICJQQVNTIGRpZCBleGVjdXRlIFNRTFRyYW5zYWN0aW9uQ2FsbGJhY2sgY2FsbGJhY2siOyB9 KTsKK30KKword2luZG93Lm9ubG9hZCA9IHJ1blRlc3Q7Cis8L3NjcmlwdD4KKzwvaGVhZD4KKzxi b2R5PgorPHA+VGhpcyB0ZXN0IGNhbiBiZSB1c2VkIHRvIHZlcmlmeSB0aGF0IHdlIGV4ZWN1dGUg YSBTUUxUcmFuc2FjdGlvbkNhbGxiYWNrIGNhbGxiYWNrIGFmdGVyIGxvY2tpbmcgYW4gdW5sb2Nr aW5nIHRoZSBkZXZpY2UgZHVyaW5nIGFuIGVhcmxpZXIKK1NRTFRyYW5zYWN0aW9uQ2FsbGJhY2sg Y2FsbGJhY2sgdGhhdCBzaG93ZWQgYSBtb2RhbCBkaWFsb2cuIFlvdSBzaG91bGQgcnVuIHRoaXMg dGVzdCBib3RoIGluIFNhZmFyaSBvbiBpT1MgYW5kIGZyb20gYSBob21lIHNjcmVlbiB3ZWIgYXBw LjwvcD4KKzxkaXYgaWQ9InJlc3VsdCI+RkFJTCBkaWQgbm90IGV4ZWN1dGUgU1FMVHJhbnNhY3Rp b25DYWxsYmFjayBjYWxsYmFjazwvZGl2PgorPC9ib2R5PgorPC9odG1sPgo=