Skip to content

Instantly share code, notes, and snippets.

@rnewman
Created August 6, 2015 02:14
Show Gist options
  • Save rnewman/b7aeabd11fb973068d93 to your computer and use it in GitHub Desktop.
Save rnewman/b7aeabd11fb973068d93 to your computer and use it in GitHub Desktop.
Startup race in browser DB.
2015-08-05 19:13:13.859 [Info] [Profile.swift:177] init(localName:app:): New profile. Removing old account data.
2015-08-05 19:13:13.868 [Debug] [BrowserDB.swift:73] init(filename:secretKey:files:): Initializing BrowserDB.
2015-08-05 19:13:13.869 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update tableList version 1.
2015-08-05 19:13:13.874 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create tableList version 1
2015-08-05 19:13:13.875 [Debug] [SwiftData.swift:125] transaction: Op in transaction succeeded. Committing.
2015-08-05 19:13:13.876 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update favicons version 0.
2015-08-05 19:13:13.877 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create favicons version 0
2015-08-05 19:13:13.878 [Debug] [SwiftData.swift:125] transaction: Op in transaction succeeded. Committing.
2015-08-05 19:13:13.879 [Info] [BrowserTable.swift:73] init(version:): SQLite version: 3.8.8.3 (3008008).
2015-08-05 19:13:13.879 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update BROWSER version 7.
2015-08-05 19:13:13.882 [Debug] [BrowserDB.swift:379] tablesExist: 0 tables exist. Expected 6
2015-08-05 19:13:13.882 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create BROWSER version 7
2015-08-05 19:13:13.883 [Debug] [BrowserTable.swift:267] create(_:version:): Creating 11 tables, views, and indices.
2015-08-05 19:13:13.886 [Debug] [SwiftData.swift:125] transaction: Op in transaction succeeded. Committing.
2015-08-05 19:13:13.888 [Info] [SQLiteHistory.swift:780] onRemovedAccount(): Clearing history metadata after account removal.
2015-08-05 19:13:13.888 [Debug] [SwiftData.swift:125] transaction: Op in transaction succeeded. Committing.
2015-08-05 19:13:13.888 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update clients version 1.
2015-08-05 19:13:13.888 [Debug] [SwiftData.swift:125] transaction: Op in transaction succeeded. Committing.
2015-08-05 19:13:13.890 [Error] [SwiftData.swift:421] executeQuery(_:factory:withArgs:): SQL error: The database file is busy database is locked.
2015-08-05 19:13:13.890 [Error] [SwiftData.swift:421] executeQuery(_:factory:withArgs:): SQL error: The database file is busy database is locked.
2015-08-05 19:13:13.891 [Error] [SwiftData.swift:316] init(filename:flags:key:prevKey:): Unable to encrypt database
2015-08-05 19:13:13.891 [Debug] [BrowserDB.swift:195] createOrUpdate: Couldn't create or update clients.
2015-08-05 19:13:13.891 [Debug] [BrowserDB.swift:196] createOrUpdate: Attempting to move browser.db to another location.
2015-08-05 19:13:13.894 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create clients version 1
2015-08-05 19:13:13.895 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tableList for SQL INSERT INTO tableList (name, version) VALUES (?,?).
2015-08-05 19:13:13.895 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:13.895 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update tabs version 2.
2015-08-05 19:13:13.897 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create tabs version 2
2015-08-05 19:13:13.898 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tableList for SQL INSERT INTO tableList (name, version) VALUES (?,?).
2015-08-05 19:13:13.898 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:13.899 [Debug] [BrowserDB.swift:195] createOrUpdate: Couldn't create or update tabs.
2015-08-05 19:13:13.899 [Debug] [BrowserDB.swift:196] createOrUpdate: Attempting to move browser.db to another location.
2015-08-05 19:13:13.899 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create tabs version 2
2015-08-05 19:13:13.900 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tableList for SQL INSERT INTO tableList (name, version) VALUES (?,?).
2015-08-05 19:13:13.900 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:13.900 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update commands version 1.
2015-08-05 19:13:13.904 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create commands version 1
2015-08-05 19:13:13.904 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tableList for SQL INSERT INTO tableList (name, version) VALUES (?,?).
2015-08-05 19:13:13.905 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:13.905 [Debug] [BrowserDB.swift:195] createOrUpdate: Couldn't create or update commands.
2015-08-05 19:13:13.905 [Debug] [BrowserDB.swift:196] createOrUpdate: Attempting to move browser.db to another location.
2015-08-05 19:13:13.905 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create commands version 1
2015-08-05 19:13:13.906 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tableList for SQL INSERT INTO tableList (name, version) VALUES (?,?).
2015-08-05 19:13:13.906 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:13.906 [Info] [SQLiteRemoteClientsAndTaEbrsror Doma.in=org.msozillaw iCfode=1 "SQL error to:r missi2ng data5base no3 such t]able :o tnaRbs"e UserInfo=0x7faem62e7f600 o{vNSLocaleizedDesdcriptioAnc=SQLc oerruorn or mtiss(ing) :database no suCch tablle: taebs}a
ring clients and tabs after account removal.
2015-08-05 19:13:13.906 [Error] [SwiftData.swift:400] executeChange(_:withErrAorr Dogmain=orgs.mozilla Code=1 "SQL error or m:iss)i:n g dSaQtabLase no seurcrh otabrle: clients" UserInfo=0x7fae62d11ee0 {NSLocalizedDescription:=SQ L errSor or mQissing Ldataba see nro such rtoable: clri ents}o
r missing database no such table: tabs for SQL DELETE FROM tabs.
2015-08-05 19:13:13.907 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: clients for SQL DELETE FROM clients.
2015-08-05 19:13:13.907 [Debug] [SQLiteRemoteClientsAndTabs.swift:32] doWipe: Wipe failed: SQL error or missing database no such table: clients
2015-08-05 19:13:13.907 [Debug] [SwiftData.swift:125] transaction: Op in transaction succeeded. Committing.
[DEBUG] Did open IPv4 listening socket 9
[DEBUG] Did open IPv6 listening socket 10
[INFO] GCDWebServer started on port 52921 and reachable at http://localhost:52921/
2015-08-05 19:13:14.157 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tabs for SQL DELETE FROM tabs WHERE client_guid IS ?.
2015-08-05 19:13:14.157 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:14.162 [Error] [SwiftData.swift:421] executeQuery(_:factory:withArgs:): SQL error: SQL error or missing database no such table: bookmarks.
2015-08-05 19:13:14.163 [Error] [BrowserViewController.swift:1205] tabManager(_:didSelectedTabChange:previous:): Error getting bookmark status: nil.
2015-08-05 19:13:14.193 [Error] [SwiftData.swift:421] executeQuery(_:factory:withArgs:): SQL error: SQL error or missing database no such table: view_history_id_favicon.
2015-08-05 19:13:14.193 [Debug] [DeferredDBOperation.swift:91] main(): Modified rows: 0.
2015-08-05 19:13:14.236 [Debug] [SyncStateMachine.swift:51] clearStateFromPrefs: Clearing all Sync prefs.
2015-08-05 19:13:14.237 [Debug] [State.swift:332] clearFromPrefs: No key label; nothing to remove from keychain.
2015-08-05 19:13:14.238 [Debug] [Profile.swift:515] beginTimedSyncs(): Starting sync timer.
2015-08-05 19:13:14.238 [Debug] [BrowserViewController.swift:238] loadQueuedTabs(): Loading queued tabs.
2015-08-05 19:13:14.238 [Info] [BrowserTable.swift:73] init(version:): SQLite version: 3.8.8.3 (3008008).
2015-08-05 19:13:14.238 [Debug] [BrowserDB.swift:142] createOrUpdate: Create or update BROWSER version 7.
2015-08-05 19:13:14.244 [Debug] [BrowserDB.swift:379] tablesExist: 0 tables exist. Expected 6
2015-08-05 19:13:14.244 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create BROWSER version 7
2015-08-05 19:13:14.244 [Debug] [BrowserTable.swift:267] create(_:version:): Creating 11 tables, views, and indices.
2015-08-05 19:13:14.246 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: main.favicons for SQL CREATE VIEW IF NOT EXISTS view_favicons_widest AS SELECT favicon_sites.siteID AS siteID, favicons.id AS iconID, favicons.url AS iconURL, favicons.date AS iconDate, favicons.type AS iconType, MAX(favicons.width) AS iconWidth FROM favicon_sites, favicons WHERE favicon_sites.faviconID = favicons.id GROUP BY siteID .
2015-08-05 19:13:14.246 [Error] [BrowserTable.swift:79] run(_:sql:args:): Error running SQL in BrowserTable. Optional("SQL error or missing database no such table: main.favicons")
2015-08-05 19:13:14.246 [Error] [BrowserTable.swift:80] run(_:sql:args:): SQL was CREATE VIEW IF NOT EXISTS view_favicons_widest AS SELECT favicon_sites.siteID AS siteID, favicons.id AS iconID, favicons.url AS iconURL, favicons.date AS iconDate, favicons.type AS iconType, MAX(favicons.width) AS iconWidth FROM favicon_sites, favicons WHERE favicon_sites.faviconID = favicons.id GROUP BY siteID
2015-08-05 19:13:14.246 [Debug] [BrowserDB.swift:95] createTable(_:table:): Creation failed.
2015-08-05 19:13:14.246 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:14.247 [Debug] [BrowserDB.swift:195] createOrUpdate: Couldn't create or update BROWSER.
2015-08-05 19:13:14.247 [Debug] [BrowserDB.swift:196] createOrUpdate: Attempting to move browser.db to another location.
2015-08-05 19:13:14.247 [Debug] [BrowserDB.swift:92] createTable(_:table:): Try create BROWSER version 7
2015-08-05 19:13:14.247 [Debug] [BrowserTable.swift:267] create(_:version:): Creating 11 tables, views, and indices.
2015-08-05 19:13:14.251 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: main.favicons for SQL CREATE VIEW IF NOT EXISTS view_favicons_widest AS SELECT favicon_sites.siteID AS siteID, favicons.id AS iconID, favicons.url AS iconURL, favicons.date AS iconDate, favicons.type AS iconType, MAX(favicons.width) AS iconWidth FROM favicon_sites, favicons WHERE favicon_sites.faviconID = favicons.id GROUP BY siteID .
2015-08-05 19:13:14.251 [Error] [BrowserTable.swift:79] run(_:sql:args:): Error running SQL in BrowserTable. Optional("SQL error or missing database no such table: main.favicons")
2015-08-05 19:13:14.251 [Error] [BrowserTable.swift:80] run(_:sql:args:): SQL was CREATE VIEW IF NOT EXISTS view_favicons_widest AS SELECT favicon_sites.siteID AS siteID, favicons.id AS iconID, favicons.url AS iconURL, favicons.date AS iconDate, favicons.type AS iconType, MAX(favicons.width) AS iconWidth FROM favicon_sites, favicons WHERE favicon_sites.faviconID = favicons.id GROUP BY siteID
2015-08-05 19:13:14.252 [Debug] [BrowserDB.swift:95] createTable(_:table:): Creation failed.
2015-08-05 19:13:14.252 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
2015-08-05 19:13:14.255 [Error] [SwiftData.swift:421] executeQuery(_:factory:withArgs:): SQL error: SQL error or missing database no such table: queue.
2015-08-05 19:13:14.255 [Debug] [DeferredDBOperation.swift:91] main(): Modified rows: 0.
2015-08-05 19:13:14.255 [Debug] [BrowserViewController.swift:243] loadQueuedTabs(): Queue. Count: 0.
2015-08-05 19:13:14.256 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: queue for SQL DELETE FROM queue.
2015-08-05 19:13:14.256 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
[DEBUG] Did open connection on socket 14
[DEBUG] Did connect
[DEBUG] Did start background task
[DEBUG] Connection received 351 bytes on socket 14
[DEBUG] Connection aborted with status code 405 on socket 14
[DEBUG] Connection sent 113 bytes on socket 14
[DEBUG] Did close connection on socket 14
[VERBOSE] [::1c1e:ceba:0:0:52921] ::1452:19c4:753b:93:52922 405 "GET /about/home/" (351 | 113)
2015-08-05 19:13:14.564 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: tabs for SQL DELETE FROM tabs WHERE client_guid IS ?.
2015-08-05 19:13:14.564 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
[DEBUG] Did open connection on socket 17
[DEBUG] Connection received 301 bytes on socket 17
[DEBUG] Connection aborted with status code 405 on socket 17
[DEBUG] Connection sent 113 bytes on socket 17
[DEBUG] Did close connection on socket 17
[VERBOSE] [::1c1e:cebb:0:0:52921] ::1452:19c4:753b:93:52923 405 "GET /favicon.ico" (301 | 113)
2015-08-05 19:13:15.570 [Debug] [BrowserViewController.swift:238] loadQueuedTabs(): Loading queued tabs.
2015-08-05 19:13:15.571 [Error] [SwiftData.swift:421] executeQuery(_:factory:withArgs:): SQL error: SQL error or missing database no such table: queue.
2015-08-05 19:13:15.571 [Debug] [DeferredDBOperation.swift:91] main(): Modified rows: 0.
2015-08-05 19:13:15.571 [Debug] [BrowserViewController.swift:243] loadQueuedTabs(): Queue. Count: 0.
2015-08-05 19:13:15.571 [Error] [SwiftData.swift:400] executeChange(_:withArgs:): SQL error: SQL error or missing database no such table: queue for SQL DELETE FROM queue.
2015-08-05 19:13:15.571 [Debug] [SwiftData.swift:132] transaction: Op in transaction failed. Rolling back.
[DEBUG] Did disconnect
[DEBUG] Did end background task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment