Bug 137503 – [iOS] WebSQL operations are not performed after device is locked

• Status: RESOLVED
• Resolution: FIXED
• Component: WebCore Misc.

[Andrew Brehaut]

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.

[Alexey Proskuryakov]

Not sure if this is the same as <rdar://problem/18042389> (the link only works for Apple employees)

[Daniel Bates]

Created attachment 240456 [details]
[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.

[Daniel Bates]

<rdar://problem/18894598>

[Daniel Bates]

(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.

[Radar WebKit Bug Importer]

<rdar://problem/20844952>

[Daniel Bates]

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.

[Daniel Bates]

Created attachment 252723 [details]
Manual test

[Daniel Bates]

Committed r184002: <http://trac.webkit.org/changeset/184002>

[Christopher Schimanski]

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 [e-mail] 

Greetings from Germany!
Christoph Schimanski

[Brady Eidson]

(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 [e-mail] 
> 
> 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.