138014 2014-10-23 12:08:47 -0700 In home screen WebApps websql do not response after standyby under IOS 8 2014-10-23 14:44:21 -0700 1 1 1 Unclassified WebKit WebKit Misc. 528+ (Nightly build) iPhone / iPad Unspecified RESOLVED INVALID P2 Major --- 1 mail webkit-unassigned ap oldest_to_newest 1043796 0 240361 mail 2014-10-23 12:08:47 -0700 Created attachment 240361 It's the same as in the file from the link I made a WebApp and added it to the home screen. I started it from there. The WebApp uses PouchDB which uses WebSQL. Every time I go to Standby and resumed. The database function don't work. I tested it with a page which only creates one database and give out the rows. After standby it don't work. Under IOS 6.1.6 with an iPod touch 4 32 GB it worked. What happens on the page: * On startup a PouchDB database and a webSQL database will created. (PouchDB uses websql as underlying database) * on button click it gives out - the PouchDB adapters - The rows from the websql database - the info from the PouchDB database The PouchDB adapters should not include IndexDB. Steps to Reproduce: * Go to http://shdev.github.io/playground/websql.html * add this page to the home screen * start it from the home screen * click the button, three lines appear like descripted above * standby * resume Expected Results: I would expect there are again 3 lines, like under IOS 6.1.6 Actual Results: There is only the one line from the PouchDB adapters Version: IOS 8.0.2, IOS 8.1 (both iPhone and iPad) Notes: I also tried it without PouchDB the same result. I only use PouchDB to see if something change on the adapters or maybe they use another approach to use the database. If you have question please contact me. Configuration: iPhone 4s 16 GB, iPad 3 16 GB 1043838 1 ap 2014-10-23 14:44:06 -0700 This is an issue outside WebKit. It is tracked by Apple internally as rdar://problem/18042389. Closing as INVALID since it's not a WebKit bug. Thank you for the report! 240361 2014-10-23 12:08:47 -0700 2014-10-23 12:08:47 -0700 It's the same as in the file from the link websql.html text/html 2636 mail PCFET0NUWVBFIGh0bWw+CjxodG1sPgo8aGVhZD4KCTx0aXRsZT5EQiBUZXN0PC90aXRsZT4KCTxN RVRBIEhUVFAtRVFVSVY9ImNvbnRlbnQtdHlwZSIgQ09OVEVOVD0idGV4dC9odG1sOyBjaGFyc2V0 PXV0Zi04Ij4KCQk8bWV0YSBuYW1lPSJ2aWV3cG9ydCIgY29udGVudD0id2lkdGg9ZGV2aWNlLXdp ZHRoLCBpbml0aWFsLXNjYWxlPTEuMCAsIHVzZXItc2NhbGFibGUgPSBubyI+CgkJPCEtLSBCb290 c3RyYXAgLS0+CgkJPG1ldGEgbmFtZT0iYXBwbGUtbW9iaWxlLXdlYi1hcHAtY2FwYWJsZSIgY29u dGVudD0ieWVzIiAvPgoJCTxtZXRhIG5hbWU9ImFwcGxlLXRvdWNoLWZ1bGxzY3JlZW4iIGNvbnRl bnQ9InllcyI+CgkJPG1ldGEgbmFtZT0iYXBwbGUtbW9iaWxlLXdlYi1hcHAtc3RhdHVzLWJhci1z dHlsZSIgY29udGVudD0iYmxhY2siPgoJPC9oZWFkPgoJPGJvZHk+CgkJPGRpdj5QbGVhc2UgY2xp Y2sgb24gIkRCIGNoZWNrIiwgZXZlcnkgdGhpbmcgaXMgZmluZSwgaWYgdGhyZWUgbGluZXMgYXBw ZWFyLiBQbGVhc2UgYWRkIHRoaXMgcGFnZSB0byB0aGUgaG9tZSBzY3JlZW4uIFN0YXJ0IHRoZSBw YWdlIGZyb20gdGhlcmUuIENsaWNrIHRoZSBidXR0b24gYWdhaW4uIEVudGVyIHN0YW5kYnkgYnkg Y2xpY2tpbmcgdGhlIGhhcmR3YXJlIGJ1dHRvbi4gUmVzdW1lIHRoZSBwYWdlLiBDbGljayBvbiB0 aGUgYnV0dG9uLiBIb3cgbWFueSBsaW5lcyBhcHBlYXI/IDxhIGhyZWY9Imh0dHA6Ly9zdGFja292 ZXJmbG93LmNvbS9xdWVzdGlvbnMvMjY0NTU4MzAvaW9zLTgtd2ViYXBwLXdlYnNxbC1hZnRlci1z dGFuZGJ5LWlzLW5vdC1yZXNwb25kaW5nIj5BbnN3ZXIgb24gU3RhY2tvdmVyZmxvdzwvYT48L2Rp dj4KCQkKCQk8YnV0dG9uIGNsYXNzPSJjaGVjayI+REIgY2hlY2s8L2J1dHRvbj4KCQk8IS0tIDxi dXR0b24gY2xhc3M9InJlc2V0Ij5EQiByZXNldDwvYnV0dG9uPiAtLT4KCQk8ZGl2IGNsYXNzPSJj b250ZW50Ij48L2Rpdj4KCQk8c2NyaXB0IHNyYz0iaHR0cDovL2NvZGUuanF1ZXJ5LmNvbS9qcXVl cnktMS4xMS4wLm1pbi5qcyI+PC9zY3JpcHQ+CgkJPHNjcmlwdCBzcmM9Imh0dHBzOi8vZ2l0aHVi LmNvbS9kYWxlaGFydmV5L3BvdWNoZGIvcmVsZWFzZXMvZG93bmxvYWQvMy4wLjYvcG91Y2hkYi0z LjAuNi5taW4uanMiPjwvc2NyaXB0PgoJCTxzY3JpcHQ+IAoJCQoJCQoJCWQgPSBQb3VjaERCKCd0 ZXN0MjMnKTsKCQlpbmZvRnVuYyA9IGZ1bmN0aW9uKGEsYikgewoJCQlpZiAoISFiKSB7CgkJCQkk KCcuY29udGVudCcpLmFwcGVuZCgkKCc8ZGl2PjwvZGl2PicpLnRleHQoJ1BvdWNoREIgREIgaW5m bzogJyArIEpTT04uc3RyaW5naWZ5KGIpKSkKCQkJfSBlbHNlIHsKCQkJCSQoJy5jb250ZW50Jyku YXBwZW5kKCQoJzxkaXY+PC9kaXY+JykudGV4dCgnUG91Y2hEQiBEQiBpbmZvIGVycm9yJykpOwoJ CQl9CgkJfTsKCQkKCQl2YXIgZGIgPSBvcGVuRGF0YWJhc2UoJ3Rlc3Q0MicsICcxLjAnLCAnJywg MiAqIDEwMjQgKiAxMDI0KTsKCQlkYi50cmFuc2FjdGlvbihmdW5jdGlvbiAodHgpIHsKCQkJY29u c29sZS5kZWJ1ZygnU3RhcnQgdHJhbnNhY3Rpb24nKTsKCQkJdHguZXhlY3V0ZVNxbCgnQ1JFQVRF IFRBQkxFIGZvbyAoaWQsIHRleHQpJyk7CgkJCWNvbnNvbGUuZGVidWcoJ1RhYmxlIENyZWF0ZWQn KTsKCQl9KTsKCQlkYi50cmFuc2FjdGlvbihmdW5jdGlvbiAodHgpIHsKCQkJdHguZXhlY3V0ZVNx bCgnREVMRVRFIEZST00gZm9vJyk7CgkJCWNvbnNvbGUuZGVidWcoJ3RydW5jYXRlJyk7CgkJCXR4 LmV4ZWN1dGVTcWwoJ0lOU0VSVCBJTlRPIGZvbyAoaWQsIHRleHQpIFZBTFVFUyAoMSwgIjEiKScp OwoJCQljb25zb2xlLmRlYnVnKCdpbnNlcnRlZCAxJyk7CgkJfSk7CgkJCgkJJCgnYnV0dG9uLnJl c2V0JykuY2xpY2soZnVuY3Rpb24oKSB7CgkJCWRiID0gb3BlbkRhdGFiYXNlKCd0ZXN0NDInLCAn MS4wJywgJycsIDIgKiAxMDI0ICogMTAyNCk7CgkJCWRiMiA9IG9wZW5EYXRhYmFzZSgndGVzdDQy JywgJzEuMCcsICcnLCAyICogMTAyNCAqIDEwMjQpOwoJCX0pOwoJCQoJCSQoJ2J1dHRvbi5jaGVj aycpLmNsaWNrKGZ1bmN0aW9uKCkgewoJCQlkYi50cmFuc2FjdGlvbihmdW5jdGlvbiAodHgpIHsK CQkJCXR4LmV4ZWN1dGVTcWwoJ1NFTEVDVCAqIEZST00gZm9vJywgW10sIGZ1bmN0aW9uICh0eCwg cmVzdWx0cykgewoJCQkJCXZhciBsZW4gPSByZXN1bHRzLnJvd3MubGVuZ3RoLCBpOwoJCQkJCWZv ciAoaSA9IDA7IGkgPCBsZW47IGkrKykgewoJCQkJCQkkKCcuY29udGVudCcpLmFwcGVuZCgkKCc8 ZGl2PjwvZGl2PicpLnRleHQoJ1dlYlNRTDogJyArIHJlc3VsdHMucm93cy5pdGVtKGkpLnRleHQp KQoJCQkJCX0KCQkJCX0pOwoJCQkJY29uc29sZS5kZWJ1Zygnc2VsZWN0Jyk7CgkJCX0pOwoJCQkK CQkJYWRhcHRlcnMgPSAnJzsKCQkJZm9yKCBhIGluIFBvdWNoREIuYWRhcHRlcnMpIHsKCQkJCWFk YXB0ZXJzID0gYWRhcHRlcnMgKyBhICsgJywnOwoJCQl9CgkJCSQoJy5jb250ZW50JykuYXBwZW5k KCQoJzxkaXY+PC9kaXY+JykudGV4dCgnUG91Y2ggREIgQWRhcHRlcnM6ICcgKyBhZGFwdGVycykp CgkJCWQuaW5mbyhpbmZvRnVuYyk7CgkJCQoJCQkKCQkJCgoKCQl9KTsKCQk8L3NjcmlwdD4KCTwv Ym9keT4KPC9odG1sPgo=