Bug 164392 – SecurityError (DOM Exception 18): The operation is insecure - openDatabase / WebSQL

• Status: RESOLVED
• Resolution: WONTFIX
• Component: New Bugs

[zac spitzer]

Mobile Safari is randomly throwing this error on 10.0.2

https://stackoverflow.com/questions/39579598/operation-is-insecure-when-running-websql-in-xamarin-ios-webview

[Brady Eidson]

This isn't random: As suggested in the stack overflow thread, this is almost certainly due to size usage.

[zac spitzer]

Hey Brady,

I'm familiar with the issues around size parameters with WebSQL
https://bugs.webkit.org/show_bug.cgi?id=163578

However, I'm seeing this error occurring using a standard size of 5000000, it's never been an issue until 10.0.2

[zac spitzer]

If it is related to size usage, it's a very confusing error message

[Brady Eidson]

(In reply to comment #2)
> Hey Brady,
> 
> I'm familiar with the issues around size parameters with WebSQL
> https://bugs.webkit.org/show_bug.cgi?id=163578
> 
> However, I'm seeing this error occurring using a standard size of 5000000,
> it's never been an issue until 10.0.2

I'm not talking about the expected size parameter - I'm taking about actual usage.

(In reply to comment #3)
> If it is related to size usage, it's a very confusing error message

Definitely not defending the error message!

[zac spitzer]

Could you elaborate on what do you mean by usage, an INSERT? I'm only seeing the crash being thrown on openDatabase?

[Brent Fulgham]

We have removed WebSQL as a feature. We won't make further improvements to it.