Bug 206770

Summary:

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

Product:

WebKit

Reporter:

Jason Lawrence <Lawrence.j>

Component:

New Bugs

Assignee:

Nobody <webkit-unassigned>

Status:

RESOLVED CONFIGURATION CHANGED

Severity:

Normal

CC:

tsavell, webkit-bot-watchers-bugzilla, webkit-bug-importer

Priority:

Keywords:

InRadar

Version:

WebKit Nightly Build

Hardware:

Unspecified

OS:

Unspecified

See Also:

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

Attachments:

Description	Flags
Update Test Expectations	none
Update Test Expectations	none

Description Jason Lawrence 2020-01-24 14:16:47 PST

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

Comment 1 Radar WebKit Bug Importer 2020-01-24 14:17:06 PST

<rdar://problem/58880903>

Comment 2 Alexey Proskuryakov 2020-01-27 22:55:01 PST

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.

Comment 3 Jason Lawrence 2020-01-28 11:03:20 PST

Created attachment 389034 [details]
Update Test Expectations

Comment 4 Jason Lawrence 2020-01-28 11:11:24 PST

Created attachment 389038 [details]
Update Test Expectations

Comment 5 Truitt Savell 2020-01-28 11:14:30 PST

Comment on attachment 389038 [details]
Update Test Expectations

Clearing flags on attachment: 389038

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

Comment 6 Truitt Savell 2020-01-28 15:17:45 PST

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

Comment 7 Ryan Haddad 2020-02-04 21:21:50 PST

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.