[Webkit-unassigned] [Bug 202547] New: WebSQL dies after switching to other apps

[bugzilla-daemon at webkit.org]

https://bugs.webkit.org/show_bug.cgi?id=202547

            Bug ID: 202547
           Summary: WebSQL dies after switching to other apps
           Product: WebKit
           Version: Safari 12
          Hardware: iPhone / iPad
                OS: iOS 13
            Status: NEW
          Severity: Blocker
          Priority: P2
         Component: New Bugs
          Assignee: webkit-unassigned at lists.webkit.org
          Reporter: roger.versluis at fieldcap.ca

WebSQL becomes unresponsive when Safari is re-openen after other app usage.

This bug is most noticeable and easily reproduced on the iPhone or iPad, but I haven't been able to reproduce it on any other platform yet.

Make sure you enable WebSQL in the experimental settings.

On the device in Safari open the following URL:
https://rogerfar.github.io/ios-websql-bug/

This will open WebSQL, create a database and table, and every second attempt to read from it. It logs the results in a container on screen.

If everything goes correct it will show:
create
read
done
read
done
....

This will continue indefinitely.

Now hit the home button to put Safari in the background and do some other things, open the camera, browse the news etc, just to make sure we're allocating memory away from Safari.

Re-open safari, the 1 second timer will start back up, but now you notice that it will only show:

read
read
read
read
read
read

At this point WebSQL has become unresponsive, querying will result in no result nor error result. To get WebSQL responsive again the page has to be refreshed.

I verified that this is happening on iOS 13 but not on iOS 12.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.webkit.org/pipermail/webkit-unassigned/attachments/20191003/c5450f27/attachment-0001.html>