Bug 206770 – [Mac wk2 Release] storage/websql/test-authorizer.html flaky timeout.

• Component: New Bugs
• Status: RESOLVED CONFIGURATION CHANGED

[Jason Lawrence]

storage/websql/test-authorizer.html 

Description:
This test is flaky timing out on Mac wk2 Release.

History:
https://results.webkit.org/?suite=layout-tests&test=storage%2Fwebsql%2Ftest-authorizer.html&version_name=Catalina&style=release

Diff:
--- /Volumes/Data/slave/catalina-release-tests-wk2/build/layout-test-results/storage/websql/test-authorizer-expected.txt
+++ /Volumes/Data/slave/catalina-release-tests-wk2/build/layout-test-results/storage/websql/test-authorizer-actual.txt
@@ -1,78 +1,6 @@
 CONSOLE MESSAGE: line 8: Web SQL is deprecated. Please use IndexedDB instead.
-This test tests the database authorizer.
-SQLITE_CREATE_TABLE statement succeeded.
-SQLITE_CREATE_INDEX statement succeeded.
-SQLITE_CREATE_TEMP_TABLE statement succeeded.
-SQLITE_CREATE_TEMP_TRIGGER statement succeeded.
-SQLITE_CREATE_TEMP_VIEW statement succeeded.
-SQLITE_CREATE_TRIGGER statement succeeded.
-SQLITE_CREATE_VIEW statement succeeded.
-SQLITE_CREATE_VTABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_VTABLE (FTS3) statement failed: could not prepare statement (23 not authorized)
-SQLITE_READ statement succeeded.
-SQLITE_SELECT statement succeeded.
-SQLITE_DELETE statement succeeded.
-SQLITE_INSERT statement succeeded.
-SQLITE_UPDATE statement succeeded.
-SQLITE_PRAGMA statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_TABLE statement succeeded.
-SQLITE_ALTER_TABLE statement succeeded.
-SQLITE_ALTER_INFO_TABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_INFO_TABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_INFO_TABLE statement failed: could not prepare statement (1 there is already another table or index with this name: __WebKitDatabaseInfoTable__)
-SQLITE_TRANSACTION statement failed: could not prepare statement (23 not authorized)
-SQLITE_ATTACH statement failed: could not prepare statement (23 not authorized)
-SQLITE_DETACH statement failed: could not prepare statement (23 not authorized)
-SQLITE_REINDEX statement succeeded.
-SQLITE_ANALYZE statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_INDEX statement succeeded.
-SQLITE_DROP_TEMP_TABLE statement succeeded.
-SQLITE_DROP_TEMP_TRIGGER statement succeeded.
-SQLITE_DROP_TEMP_VIEW statement succeeded.
-SQLITE_DROP_TRIGGER statement succeeded.
-SQLITE_DROP_VIEW statement succeeded.
-SQLITE_DROP_TABLE statement succeeded.
-Write transaction succeeded.
-SQLITE_CREATE_TABLE statement failed: could not prepare statement (1 not authorized)
-SQLITE_CREATE_TABLE statement succeeded.
-SQLITE_CREATE_INDEX statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_TEMP_TABLE statement failed: could not prepare statement (1 not authorized)
-SQLITE_CREATE_TEMP_TRIGGER statement failed: could not prepare statement (1 not authorized)
-SQLITE_CREATE_TEMP_VIEW statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_TRIGGER statement failed: could not prepare statement (1 not authorized)
-SQLITE_CREATE_VIEW statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_VTABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_VTABLE (FTS3) statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_INDEX statement succeeded.
-SQLITE_CREATE_TEMP_TABLE statement succeeded.
-SQLITE_CREATE_TEMP_TRIGGER statement succeeded.
-SQLITE_CREATE_TEMP_VIEW statement succeeded.
-SQLITE_CREATE_TRIGGER statement succeeded.
-SQLITE_CREATE_VIEW statement succeeded.
-SQLITE_CREATE_VTABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_CREATE_VTABLE (FTS3) statement failed: could not prepare statement (23 not authorized)
-SQLITE_READ statement succeeded.
-SQLITE_SELECT statement succeeded.
-SQLITE_DELETE statement failed: could not prepare statement (23 not authorized)
-SQLITE_INSERT statement failed: could not prepare statement (23 not authorized)
-SQLITE_UPDATE statement failed: could not prepare statement (23 not authorized)
-SQLITE_PRAGMA statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_TABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_TABLE statement failed: could not prepare statement (1 no such table: TestTable)
-SQLITE_ALTER_INFO_TABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_INFO_TABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_ALTER_INFO_TABLE statement failed: could not prepare statement (1 there is already another table or index with this name: __WebKitDatabaseInfoTable__)
-SQLITE_TRANSACTION statement failed: could not prepare statement (23 not authorized)
-SQLITE_ATTACH statement failed: could not prepare statement (23 not authorized)
-SQLITE_DETACH statement failed: could not prepare statement (23 not authorized)
-SQLITE_REINDEX statement failed: could not prepare statement (23 not authorized)
-SQLITE_ANALYZE statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_INDEX statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_TEMP_TABLE statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_TEMP_TRIGGER statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_TEMP_VIEW statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_TRIGGER statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_VIEW statement failed: could not prepare statement (23 not authorized)
-SQLITE_DROP_TABLE statement failed: could not prepare statement (23 not authorized)
-Read transactions succeeded.
+#PID UNRESPONSIVE - WebKitTestRunner (pid 37083)
+FAIL: Timed out waiting for notifyDone to be called
 
+#EOF
+#EOF

[Radar WebKit Bug Importer]

<rdar://problem/58880903>

[Alexey Proskuryakov]

This test used to pass on macOS, and to fail on iOS. After r252064, it started to flakily but frequently time out on iOS. It also started to infrequently time out on macOS around the same time.

[Jason Lawrence]

Created attachment 389034 [details]
Update Test Expectations

[Jason Lawrence]

Created attachment 389038 [details]
Update Test Expectations

[Truitt Savell]

Comment on attachment 389038 [details]
Update Test Expectations

Clearing flags on attachment: 389038

Committed r255264: <https://trac.webkit.org/changeset/255264>

[Truitt Savell]

Modified these expectations some more in https://trac.webkit.org/changeset/255317/webkit

[Ryan Haddad]

I skipped storage/websql tests on mac-wk2 to resolve https://bugs.webkit.org/show_bug.cgi?id=206627 (and removed these expectations as part of the change), so this can be closed.