· 6 years ago · Mar 29, 2019, 12:58 AM
12019-03-29 13:53:25.192615+1300 JC11[69391:1634395] [air.planck.jobcontroller.idempontent] init air.planck.jobcontroller.idempontent
22019-03-29 13:53:25.696965+1300 JC11[69391:1634395] Original plugin search paths: ("/Users/tomasfriml/Qt/Qt-DJ-5.12-iOS/plugins")
32019-03-29 13:53:26.209657+1300 JC11[69391:1634395] qrc:/SplashScreen.qml: No such file or directory
42019-03-29 13:53:26.382531+1300 JC11[69391:1634395] stale focus object QObject(0x0) , doing manual update
52019-03-29 13:53:26.405708+1300 JC11[69391:1634395] Local UUID: "{4d2ba9ab-f98d-4c38-9c99-4fc04f6efe54}"
6=================================================================
7Main Thread Checker: UI API called on a background thread: -[UIView layer]
8PID: 69391, TID: 1634628, Thread name: QSGRenderThread, Queue name: com.apple.root.default-qos.overcommit, QoS: 0
9Backtrace:
104 JC11 0x000000010455a989 _ZN11QIOSContext11makeCurrentEP16QPlatformSurface + 377
115 JC11 0x0000000109fa47b3 _ZN14QOpenGLContext11makeCurrentEP8QSurface + 467
126 JC11 0x0000000109cbe59f _ZN15QSGRenderThread3runEv + 399
137 JC11 0x000000010a7cecc0 _ZN14QThreadPrivate5startEPv + 816
148 libsystem_pthread.dylib 0x0000000117e6a305 _pthread_body + 126
159 libsystem_pthread.dylib 0x0000000117e6d26f _pthread_start + 70
1610 libsystem_pthread.dylib 0x0000000117e69415 thread_start + 13
172019-03-29 13:53:26.499788+1300 JC11[69391:1634628] [reports] Main Thread Checker: UI API called on a background thread: -[UIView layer]
18PID: 69391, TID: 1634628, Thread name: QSGRenderThread, Queue name: com.apple.root.default-qos.overcommit, QoS: 0
19Backtrace:
204 JC11 0x000000010455a989 _ZN11QIOSContext11makeCurrentEP16QPlatformSurface + 377
215 JC11 0x0000000109fa47b3 _ZN14QOpenGLContext11makeCurrentEP8QSurface + 467
226 JC11 0x0000000109cbe59f _ZN15QSGRenderThread3runEv + 399
237 JC11 0x000000010a7cecc0 _ZN14QThreadPrivate5startEPv + 816
248 libsystem_pthread.dylib 0x0000000117e6a305 _pthread_body + 126
259 libsystem_pthread.dylib 0x0000000117e6d26f _pthread_start + 70
2610 libsystem_pthread.dylib 0x0000000117e69415 thread_start + 13
27=================================================================
28Main Thread Checker: UI API called on a background thread: -[UIView contentScaleFactor]
29PID: 69391, TID: 1634628, Thread name: QSGRenderThread, Queue name: com.apple.root.default-qos.overcommit, QoS: 0
30Backtrace:
314 JC11 0x0000000109f5621a _ZNK7QWindow16devicePixelRatioEv + 90
325 JC11 0x0000000109d29164 _ZNK12QQuickWindow25effectiveDevicePixelRatioEv + 68
336 JC11 0x0000000109d28db9 _ZN19QQuickWindowPrivate16renderSceneGraphERK5QSize + 217
347 JC11 0x0000000109cbd84f _ZN15QSGRenderThread13syncAndRenderEv + 1295
358 JC11 0x0000000109cbe5cc _ZN15QSGRenderThread3runEv + 444
369 JC11 0x000000010a7cecc0 _ZN14QThreadPrivate5startEPv + 816
3710 libsystem_pthread.dylib 0x0000000117e6a305 _pthread_body + 126
3811 libsystem_pthread.dylib 0x0000000117e6d26f _pthread_start + 70
3912 libsystem_pthread.dylib 0x0000000117e69415 thread_start + 13
402019-03-29 13:53:26.873187+1300 JC11[69391:1634628] [reports] Main Thread Checker: UI API called on a background thread: -[UIView contentScaleFactor]
41PID: 69391, TID: 1634628, Thread name: QSGRenderThread, Queue name: com.apple.root.default-qos.overcommit, QoS: 0
42Backtrace:
434 JC11 0x0000000109f5621a _ZNK7QWindow16devicePixelRatioEv + 90
445 JC11 0x0000000109d29164 _ZNK12QQuickWindow25effectiveDevicePixelRatioEv + 68
456 JC11 0x0000000109d28db9 _ZN19QQuickWindowPrivate16renderSceneGraphERK5QSize + 217
467 JC11 0x0000000109cbd84f _ZN15QSGRenderThread13syncAndRenderEv + 1295
478 JC11 0x0000000109cbe5cc _ZN15QSGRenderThread3runEv + 444
489 JC11 0x000000010a7cecc0 _ZN14QThreadPrivate5startEPv + 816
4910 libsystem_pthread.dylib 0x0000000117e6a305 _pthread_body + 126
5011 libsystem_pthread.dylib 0x0000000117e6d26f _pthread_start + 70
5112 libsystem_pthread.dylib 0x0000000117e69415 thread_start + 13
522019-03-29 13:53:28.500535+1300 JC11[69391:1634395] [air.deviceidentifier] Device Identifier ( Line: 108 ): Found file: "vfs:/Devices/JC11/KnownDevices.xml"
532019-03-29 13:53:28.501019+1300 JC11[69391:1634395] [air.deviceidentifier] Device Identifier ( Line: 117 ): Couldn't open "vfs:/Devices/JC11/KnownDevices.xml"
542019-03-29 13:53:28.501362+1300 JC11[69391:1634395] [air.deviceidentifier] Device Identifier ( Line: 118 ): Current working dir: "/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Bundle/Application/EFB4280F-469A-4B74-B858-C18FAF9E88F1/JC11.app"
552019-03-29 13:53:28.503240+1300 JC11[69391:1634395] [air.deviceidentifier] Device Identifier ( Line: 122 ): Failed to load "vfs:/Devices/JC11/KnownDevices.xml" error: "unexpected end of file" at: 1 1
562019-03-29 13:53:28.523934+1300 JC11[69391:1634395] CoreAudio ( Line: 123 ): STOP()
572019-03-29 13:53:28.524073+1300 JC11[69391:1634395] CoreAudio ( Line: 87 ): START
582019-03-29 13:53:28.524187+1300 JC11[69391:1634395] CoreAudio ( Line: 99 ): STARTING
592019-03-29 13:53:28.535680+1300 JC11[69391:1634395] CoreAudio ( Line: 116 ): DEVICE HAS STARTED
602019-03-29 13:53:28.634414+1300 JC11[69391:1634395] CoreAudio ( Line: 123 ): STOP()
612019-03-29 13:53:28.638708+1300 JC11[69391:1634395] CoreAudio ( Line: 133 ): Checking is device is running
62AudioUnit::OSStatus::Error: -10879 (\377\377Õ)
632019-03-29 13:53:28.645592+1300 JC11[69391:1634395] CoreAudio ( Line: 142 ): Device no longer running
642019-03-29 13:53:28.645709+1300 JC11[69391:1634395] CoreAudio ( Line: 146 ): AudioIO removed
652019-03-29 13:53:28.654454+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
662019-03-29 13:53:28.666722+1300 JC11[69391:1634395] _analyzerApplicationPath "/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Bundle/Application/EFB4280F-469A-4B74-B858-C18FAF9E88F1/JC11.app/../../../Tools/OfflineAnalyzer/OfflineAnalyzer"
672019-03-29 13:53:28.693687+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
682019-03-29 13:53:28.735171+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
692019-03-29 13:53:28.735459+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
702019-03-29 13:53:28.735845+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
712019-03-29 13:53:28.737128+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
722019-03-29 13:53:28.740892+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
732019-03-29 13:53:28.742190+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
742019-03-29 13:53:28.742391+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
752019-03-29 13:53:28.742866+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
762019-03-29 13:53:28.743158+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
772019-03-29 13:53:28.744488+1300 JC11[69391:1634395] QUERY: SELECT 1
782019-03-29 13:53:28.745084+1300 JC11[69391:1634395] QUERY: SELECT 1
792019-03-29 13:53:28.751984+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
802019-03-29 13:53:28.753297+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
812019-03-29 13:53:28.746213+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
822019-03-29 13:53:28.757383+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
832019-03-29 13:53:28.767536+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
842019-03-29 13:53:28.767742+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
852019-03-29 13:53:28.767882+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
862019-03-29 13:53:28.768025+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
872019-03-29 13:53:28.769742+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
882019-03-29 13:53:28.771151+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
892019-03-29 13:53:28.771308+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
902019-03-29 13:53:28.771490+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
912019-03-29 13:53:28.771651+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
922019-03-29 13:53:28.777151+1300 JC11[69391:1634395] QUERY: SELECT 1
932019-03-29 13:53:28.777392+1300 JC11[69391:1634395] QUERY: SELECT 1
942019-03-29 13:53:28.778240+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
952019-03-29 13:53:28.778978+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
962019-03-29 13:53:28.781932+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
972019-03-29 13:53:28.793609+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
982019-03-29 13:53:28.793791+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
992019-03-29 13:53:28.793929+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
1002019-03-29 13:53:28.794099+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
1012019-03-29 13:53:28.798227+1300 JC11[69391:1634395] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
1022019-03-29 13:53:28.801028+1300 JC11[69391:1634395] QUERY: UPDATE Information SET id = ? , uuid = ? , schemaVersionMajor = ? , schemaVersionMinor = ? , schemaVersionPatch = ? , currentPlayedIndiciator = ? , lastRekordBoxLibraryImportReadCounter = ? WHERE id = ?
1032019-03-29 13:53:28.809356+1300 JC11[69391:1634395] QUERY: SELECT 1
1042019-03-29 13:53:28.812515+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
1052019-03-29 13:53:28.814148+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
1062019-03-29 13:53:28.814345+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
1072019-03-29 13:53:28.814507+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
1082019-03-29 13:53:28.815420+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1092019-03-29 13:53:28.819372+1300 JC11[69391:1634395] QUERY: CREATE TABLE Track ( [id] INTEGER, [playOrder] INTEGER, [length] INTEGER, [lengthCalculated] INTEGER, [bpm] INTEGER, [year] INTEGER, [path] TEXT, [filename] TEXT, [bitrate] INTEGER, [bpmAnalyzed] REAL, [trackType] INTEGER, [isExternalTrack] NUMERIC, [uuidOfExternalDatabase] TEXT, [idTrackInExternalDatabase] INTEGER, [idAlbumArt] INTEGER, [pdbImportKey] INTEGER, PRIMARY KEY ( [id] ) , UNIQUE ([path]), FOREIGN KEY ( [idAlbumArt] ) REFERENCES AlbumArt ( [id] ) ON DELETE RESTRICT)
1102019-03-29 13:53:28.821864+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_id ON Track ( id )
1112019-03-29 13:53:28.822976+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_path ON Track ( path )
1122019-03-29 13:53:28.824224+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_filename ON Track ( filename )
1132019-03-29 13:53:28.825208+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_isExternalTrack ON Track ( isExternalTrack )
1142019-03-29 13:53:28.826182+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_uuidOfExternalDatabase ON Track ( uuidOfExternalDatabase )
1152019-03-29 13:53:28.828180+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_idTrackInExternalDatabase ON Track ( idTrackInExternalDatabase )
1162019-03-29 13:53:28.829157+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Track_idAlbumArt ON Track ( idAlbumArt )
1172019-03-29 13:53:28.830494+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1182019-03-29 13:53:28.831026+1300 JC11[69391:1634395] QUERY: CREATE TABLE Information ( [id] INTEGER, [uuid] TEXT, [schemaVersionMajor] INTEGER, [schemaVersionMinor] INTEGER, [schemaVersionPatch] INTEGER, [currentPlayedIndiciator] INTEGER, [lastRekordBoxLibraryImportReadCounter] INTEGER, PRIMARY KEY ( [id] ) )
1192019-03-29 13:53:28.832226+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Information_id ON Information ( id )
1202019-03-29 13:53:28.833316+1300 JC11[69391:1634395] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
1212019-03-29 13:53:28.834560+1300 JC11[69391:1634395] QUERY: INSERT INTO Information ( id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
1222019-03-29 13:53:28.835861+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1232019-03-29 13:53:28.836618+1300 JC11[69391:1634395] QUERY: CREATE TABLE MetaData ( [id] INTEGER, [type] INTEGER, [text] TEXT, PRIMARY KEY ( [id], [type] ) , FOREIGN KEY ( [id] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
1242019-03-29 13:53:28.840535+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_id ON MetaData ( id )
1252019-03-29 13:53:28.841963+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_type ON MetaData ( type )
1262019-03-29 13:53:28.845904+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_MetaData_text ON MetaData ( text )
1272019-03-29 13:53:28.845023+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
1282019-03-29 13:53:28.848953+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1292019-03-29 13:53:28.849830+1300 JC11[69391:1634395] QUERY: CREATE TABLE MetaDataInteger ( [id] INTEGER, [type] INTEGER, [value] INTEGER, PRIMARY KEY ( [id], [type] ) , FOREIGN KEY ( [id] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
1302019-03-29 13:53:28.851126+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_id ON MetaDataInteger ( id )
1312019-03-29 13:53:28.852151+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_type ON MetaDataInteger ( type )
1322019-03-29 13:53:28.853166+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_MetaDataInteger_value ON MetaDataInteger ( value )
1332019-03-29 13:53:28.854196+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1342019-03-29 13:53:28.854838+1300 JC11[69391:1634395] QUERY: CREATE TABLE AlbumArt ( [id] INTEGER, [hash] TEXT, [albumArt] BLOB, PRIMARY KEY ( [id] ) )
1352019-03-29 13:53:28.855934+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_AlbumArt_id ON AlbumArt ( id )
1362019-03-29 13:53:28.856877+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_AlbumArt_hash ON AlbumArt ( hash )
1372019-03-29 13:53:28.857910+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1382019-03-29 13:53:28.858714+1300 JC11[69391:1634395] QUERY: CREATE TABLE CopiedTrack ( [trackId] INTEGER, [uuidOfSourceDatabase] TEXT, [idOfTrackInSourceDatabase] INTEGER, PRIMARY KEY ( [trackId] ) , FOREIGN KEY ( [trackId] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
1392019-03-29 13:53:28.860957+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_CopiedTrack_trackId ON CopiedTrack ( trackId )
1402019-03-29 13:53:28.862455+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1412019-03-29 13:53:28.863454+1300 JC11[69391:1634395] QUERY: CREATE TABLE List ( [id] INTEGER, [type] INTEGER, [title] TEXT, [path] TEXT, [isFolder] NUMERIC, [trackCount] INTEGER, [ordering] INTEGER, PRIMARY KEY ( [id], [type] ) )
1422019-03-29 13:53:28.864845+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_List_id ON List ( id )
1432019-03-29 13:53:28.865899+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_List_type ON List ( type )
1442019-03-29 13:53:28.867014+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_List_path ON List ( path )
1452019-03-29 13:53:28.871591+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_List_ordering ON List ( ordering )
1462019-03-29 13:53:28.873267+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS Playlist AS SELECT id, title FROM List WHERE type = 1
1472019-03-29 13:53:28.874755+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS Historylist AS SELECT id, title FROM List WHERE type = 2
1482019-03-29 13:53:28.876113+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS Preparelist AS SELECT id, title FROM List WHERE type = 3
1492019-03-29 13:53:28.877347+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS Crate AS SELECT id AS id, title AS title, path AS path FROM List WHERE type = 4
1502019-03-29 13:53:28.880888+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1512019-03-29 13:53:28.882053+1300 JC11[69391:1634395] QUERY: CREATE TABLE ListTrackList ( [id] INTEGER, [listId] INTEGER, [listType] INTEGER, [trackId] INTEGER, [trackIdInOriginDatabase] INTEGER, [databaseUuid] TEXT, [trackNumber] INTEGER, PRIMARY KEY ( [id] ) , FOREIGN KEY ( [listId], [listType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE, FOREIGN KEY ( [trackId] ) REFERENCES Track ( [id] ) ON DELETE CASCADE)
1522019-03-29 13:53:28.883423+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_listId ON ListTrackList ( listId )
1532019-03-29 13:53:28.887461+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_listType ON ListTrackList ( listType )
1542019-03-29 13:53:28.888742+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListTrackList_trackId ON ListTrackList ( trackId )
1552019-03-29 13:53:28.892657+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS PlaylistTrackList AS SELECT listId AS playlistId, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 1
1562019-03-29 13:53:28.895125+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS HistorylistTrackList AS SELECT listId AS historylistId, trackId, trackIdInOriginDatabase, databaseUuid, 0 AS date FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 2
1572019-03-29 13:53:28.899908+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS PreparelistTrackList AS SELECT listId AS playlistId, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 3
1582019-03-29 13:53:28.901558+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS CrateTrackList AS SELECT listId AS crateId, trackId AS trackId FROM ListTrackList AS ltl INNER JOIN List AS l ON l.id = ltl.listId AND l.type = ltl.listType WHERE ltl.listType = 4
1592019-03-29 13:53:28.903022+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Playlist INSTEAD OF DELETE ON Playlist FOR EACH ROW BEGIN DELETE FROM List WHERE type = 1 AND OLD.id = id AND OLD.title = title; END
1602019-03-29 13:53:28.904296+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Playlist INSTEAD OF UPDATE ON Playlist FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title WHERE id = OLD.id AND title = OLD.title ; END
1612019-03-29 13:53:28.905497+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Historylist INSTEAD OF DELETE ON Historylist FOR EACH ROW BEGIN DELETE FROM List WHERE type = 2 AND OLD.id = id AND OLD.title = title; END
1622019-03-29 13:53:28.906784+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Historylist INSTEAD OF UPDATE ON Historylist FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title WHERE id = OLD.id AND title = OLD.title ; END
1632019-03-29 13:53:28.908300+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Preparelist INSTEAD OF DELETE ON Preparelist FOR EACH ROW BEGIN DELETE FROM List WHERE type = 3 AND OLD.id = id AND OLD.title = title; END
1642019-03-29 13:53:28.909561+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Preparelist INSTEAD OF UPDATE ON Preparelist FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title WHERE id = OLD.id AND title = OLD.title ; END
1652019-03-29 13:53:28.911015+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_Crate INSTEAD OF DELETE ON Crate FOR EACH ROW BEGIN DELETE FROM List WHERE type = 4 AND OLD.id = id AND OLD.title = title AND OLD.path = path; END
1662019-03-29 13:53:28.912347+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_Crate INSTEAD OF UPDATE ON Crate FOR EACH ROW BEGIN UPDATE List SET id = NEW.id, title = NEW.title, path = NEW.path WHERE id = OLD.id AND title = OLD.title AND path = OLD.path ; END
1672019-03-29 13:53:28.913984+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Playlist INSTEAD OF INSERT ON Playlist FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 1, NEW.title, NEW.title || ";", 0, 0, NEW.id ) ; INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.id, 1, NEW.id, 1 ) ; END
1682019-03-29 13:53:28.915764+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Historylist INSTEAD OF INSERT ON Historylist FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 2, NEW.title, NEW.title || ";", 0, 0, NEW.id ) ; INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.id, 2, NEW.id, 2 ) ; END
1692019-03-29 13:53:28.917651+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Preparelist INSTEAD OF INSERT ON Preparelist FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 3, NEW.title, NEW.title || ";", 0, 0, NEW.id ) ; INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.id, 3, NEW.id, 3 ) ; END
1702019-03-29 13:53:28.919158+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_Crate INSTEAD OF INSERT ON Crate FOR EACH ROW BEGIN INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( NEW.id, 4, NEW.title, NEW.path, 0, 0, NEW.id ) ; END
1712019-03-29 13:53:28.920598+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_order_update_List AFTER INSERT ON List FOR EACH ROW WHEN NEW.ordering IS NULL BEGIN UPDATE List SET ordering = (SELECT IFNULL(MAX(ordering) + 1, 1) FROM List ) WHERE id = NEW.id AND type = NEW.type; END
1722019-03-29 13:53:28.922643+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_after_insert_List AFTER INSERT ON List FOR EACH ROW BEGIN UPDATE List SET trackCount = 0 WHERE id = NEW.id AND type = NEW.type AND trackCount IS NULL ;END
1732019-03-29 13:53:28.924171+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_track_added_to_ListTrackList AFTER INSERT ON ListTrackList FOR EACH ROW BEGIN UPDATE List SET trackCount = trackCount + 1 WHERE id = NEW.listId AND type = NEW.listType; END
1742019-03-29 13:53:28.925478+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_track_removed_from_ListTrackList AFTER DELETE ON ListTrackList FOR EACH ROW BEGIN UPDATE List SET trackCount = trackCount - 1 WHERE id = OLD.listId AND type = OLD.listType; END
1752019-03-29 13:53:28.929162+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_order_update_List AFTER INSERT ON List FOR EACH ROW WHEN NEW.ordering IS NULL BEGIN UPDATE List SET ordering = (SELECT IFNULL(MAX(ordering) + 1, 1) FROM List ) WHERE id = NEW.id AND type = NEW.type; END
1762019-03-29 13:53:28.929896+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_PlaylistTrackList INSTEAD OF DELETE ON PlaylistTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 1 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber; END
1772019-03-29 13:53:28.931443+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_PlaylistTrackList INSTEAD OF UPDATE ON PlaylistTrackList FOR EACH ROW BEGIN UPDATE ListTrackList SET listId = NEW.playlistId , trackId = NEW.trackId , trackIdInOriginDatabase = NEW.trackIdInOriginDatabase , databaseUuid = NEW.databaseUuid , trackNumber = NEW.trackNumber WHERE listType = 1 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber ; END
1782019-03-29 13:53:28.933267+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_PlaylistTrackList INSTEAD OF INSERT ON PlaylistTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) SELECT NEW.playlistId, 1, NEW.trackId, NEW.trackIdInOriginDatabase, NEW.databaseUuid, NEW.trackNumber FROM List AS l WHERE l.id = NEW.playlistId AND l.type = 1 AND l.isFolder = 0 ; END
1792019-03-29 13:53:28.935108+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_HistorylistTrackList INSTEAD OF DELETE ON HistorylistTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 2 AND OLD.historylistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid; END
1802019-03-29 13:53:28.935797+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
1812019-03-29 13:53:28.936444+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_HistorylistTrackList INSTEAD OF UPDATE ON HistorylistTrackList FOR EACH ROW BEGIN UPDATE ListTrackList SET listId = NEW.historylistId , trackId = NEW.trackId , trackIdInOriginDatabase = NEW.trackIdInOriginDatabase , databaseUuid = NEW.databaseUuid WHERE listType = 2 AND OLD.historylistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid ; END
1822019-03-29 13:53:28.937941+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_HistorylistTrackList INSTEAD OF INSERT ON HistorylistTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) SELECT NEW.historylistId, 2, NEW.trackId, NEW.trackIdInOriginDatabase, NEW.databaseUuid, 0 FROM List AS l WHERE l.id = NEW.historylistId AND l.type = 2 AND l.isFolder = 0 ; END
1832019-03-29 13:53:28.940954+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_PreparelistTrackList INSTEAD OF DELETE ON PreparelistTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 3 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber; END
1842019-03-29 13:53:28.942902+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_update_PreparelistTrackList INSTEAD OF UPDATE ON PreparelistTrackList FOR EACH ROW BEGIN UPDATE ListTrackList SET listId = NEW.playlistId , trackId = NEW.trackId , trackIdInOriginDatabase = NEW.trackIdInOriginDatabase , databaseUuid = NEW.databaseUuid , trackNumber = NEW.trackNumber WHERE listType = 3 AND OLD.playlistId = listId AND OLD.trackId = trackId AND OLD.trackIdInOriginDatabase = trackIdInOriginDatabase AND OLD.databaseUuid = databaseUuid AND OLD.trackNumber = trackNumber ; END
1852019-03-29 13:53:28.946405+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_PreparelistTrackList INSTEAD OF INSERT ON PreparelistTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) SELECT NEW.playlistId, 3, NEW.trackId, NEW.trackIdInOriginDatabase, NEW.databaseUuid, NEW.trackNumber FROM List AS l WHERE l.id = NEW.playlistId AND l.type = 3 AND l.isFolder = 0 ; END
1862019-03-29 13:53:28.959817+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_CrateTrackList INSTEAD OF DELETE ON CrateTrackList FOR EACH ROW BEGIN DELETE FROM ListTrackList WHERE listType = 4 AND OLD.crateId = listId AND OLD.trackId = trackId; END
1872019-03-29 13:53:28.962125+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_CrateTrackList INSTEAD OF INSERT ON CrateTrackList FOR EACH ROW BEGIN INSERT INTO ListTrackList ( listId, listType, trackId, trackIdInOriginDatabase, databaseUuid, trackNumber ) VALUES ( NEW.crateId, 4, NEW.trackId, 0, 0, 0 ) ; END
1882019-03-29 13:53:28.966035+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1892019-03-29 13:53:28.967193+1300 JC11[69391:1634395] QUERY: CREATE TABLE ListHierarchy ( [listId] INTEGER, [listType] INTEGER, [listIdChild] INTEGER, [listTypeChild] INTEGER, FOREIGN KEY ( [listId], [listType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE, FOREIGN KEY ( [listIdChild], [listTypeChild] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE)
1902019-03-29 13:53:28.968683+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listId ON ListHierarchy ( listId )
1912019-03-29 13:53:28.969949+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listType ON ListHierarchy ( listType )
1922019-03-29 13:53:28.971126+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listIdChild ON ListHierarchy ( listIdChild )
1932019-03-29 13:53:28.972273+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListHierarchy_listTypeChild ON ListHierarchy ( listTypeChild )
1942019-03-29 13:53:28.973599+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS CrateHierarchy AS SELECT listId AS crateId, listIdChild AS crateIdChild FROM ListHierarchy WHERE listType = 4 AND listTypeChild = 4
1952019-03-29 13:53:28.976493+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_CrateHierarchy INSTEAD OF DELETE ON CrateHierarchy FOR EACH ROW BEGIN DELETE FROM ListHierarchy WHERE listId = OLD.crateId AND listType = 4 AND listIdChild = OLD.crateIdChild AND listTypeChild = 4 ; END
1962019-03-29 13:53:28.980007+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_CrateHierarchy INSTEAD OF INSERT ON CrateHierarchy FOR EACH ROW BEGIN INSERT INTO ListHierarchy ( listId, listType, listIdChild, listTypeChild ) VALUES ( NEW.crateId, 4, NEW.crateIdChild, 4 ) ; END
1972019-03-29 13:53:28.982710+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
1982019-03-29 13:53:28.983785+1300 JC11[69391:1634395] QUERY: CREATE TABLE ListParentList ( [listOriginId] INTEGER, [listOriginType] INTEGER, [listParentId] INTEGER, [listParentType] INTEGER, FOREIGN KEY ( [listOriginId], [listOriginType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE, FOREIGN KEY ( [listParentId], [listParentType] ) REFERENCES List ( [id], [type] ) ON DELETE CASCADE)
1992019-03-29 13:53:28.988642+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listOriginId ON ListParentList ( listOriginId )
2002019-03-29 13:53:28.989840+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listOriginType ON ListParentList ( listOriginType )
2012019-03-29 13:53:28.990877+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listParentId ON ListParentList ( listParentId )
2022019-03-29 13:53:28.992111+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_ListParentList_listParentType ON ListParentList ( listParentType )
2032019-03-29 13:53:28.993963+1300 JC11[69391:1634395] QUERY: CREATE VIEW IF NOT EXISTS CrateParentList AS SELECT listOriginId AS crateOriginId, listParentId AS crateParentId FROM ListParentList WHERE listOriginType = 4 AND listParentType = 4
2042019-03-29 13:53:28.995296+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_delete_CrateParentList INSTEAD OF DELETE ON CrateParentList FOR EACH ROW BEGIN DELETE FROM ListParentList WHERE OLD.crateOriginId = listOriginId AND listOriginType = 4 AND OLD.crateParentId = listParentId AND listParentType = 4; END
2052019-03-29 13:53:28.997013+1300 JC11[69391:1634395] QUERY: CREATE TRIGGER IF NOT EXISTS trigger_insert_CrateParentList INSTEAD OF INSERT ON CrateParentList FOR EACH ROW BEGIN INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( NEW.crateOriginId, 4, NEW.crateParentId, 4 ) ; END
2062019-03-29 13:53:29.000731+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
2072019-03-29 13:53:29.001649+1300 JC11[69391:1634395] QUERY: CREATE TABLE InternalDatabase ( [uuid] TEXT, [name] TEXT, PRIMARY KEY ( [uuid] ) )
2082019-03-29 13:53:29.003211+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_InternalDatabase_uuid ON InternalDatabase ( uuid )
2092019-03-29 13:53:29.004773+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2102019-03-29 13:53:29.005833+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2112019-03-29 13:53:29.007035+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
2122019-03-29 13:53:29.007232+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2132019-03-29 13:53:29.007368+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
2142019-03-29 13:53:29.007952+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
2152019-03-29 13:53:29.008448+1300 JC11[69391:1634395] QUERY: CREATE TABLE PerformanceData ( [id] INTEGER, [isAnalyzed] NUMERIC, [isRendered] NUMERIC, [trackData] BLOB, [highResolutionWaveFormData] BLOB, [overviewWaveFormData] BLOB, [beatData] BLOB, [quickCues] BLOB, [loops] BLOB, [hasSeratoValues] NUMERIC, [hasRekordboxValues] NUMERIC, [hasTraktorValues] NUMERIC, PRIMARY KEY ( [id] ) )
2162019-03-29 13:53:29.010066+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_PerformanceData_id ON PerformanceData ( id )
2172019-03-29 13:53:29.011091+1300 JC11[69391:1634395] QUERY: SELECT COUNT(*) FROM sqlite_master WHERE ( type='table' OR type='view' ) AND name=?
2182019-03-29 13:53:29.011563+1300 JC11[69391:1634395] QUERY: CREATE TABLE Information ( [id] INTEGER, [uuid] TEXT, [schemaVersionMajor] INTEGER, [schemaVersionMinor] INTEGER, [schemaVersionPatch] INTEGER, [currentPlayedIndiciator] INTEGER, [lastRekordBoxLibraryImportReadCounter] INTEGER, PRIMARY KEY ( [id] ) )
2192019-03-29 13:53:29.011802+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
2202019-03-29 13:53:29.012659+1300 JC11[69391:1634395] QUERY: CREATE INDEX IF NOT EXISTS index_Information_id ON Information ( id )
2212019-03-29 13:53:29.013693+1300 JC11[69391:1634395] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
2222019-03-29 13:53:29.014238+1300 JC11[69391:1634395] QUERY: INSERT INTO Information ( id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
2232019-03-29 13:53:29.015216+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2242019-03-29 13:53:29.015557+1300 JC11[69391:1634395] QUERY: SELECT 1
2252019-03-29 13:53:29.015965+1300 JC11[69391:1634395] QUERY: SELECT 1
2262019-03-29 13:53:29.016348+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2272019-03-29 13:53:29.016819+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2282019-03-29 13:53:29.017985+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2292019-03-29 13:53:29.026717+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
2302019-03-29 13:53:29.026882+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2312019-03-29 13:53:29.027153+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
2322019-03-29 13:53:29.027327+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2332019-03-29 13:53:29.031466+1300 JC11[69391:1634395] QUERY: DELETE FROM Track
2342019-03-29 13:53:29.033887+1300 JC11[69391:1634395] QUERY: DELETE FROM MetaData
2352019-03-29 13:53:29.034601+1300 JC11[69391:1634395] QUERY: DELETE FROM MetaDataInteger
2362019-03-29 13:53:29.035277+1300 JC11[69391:1634395] QUERY: DELETE FROM AlbumArt
2372019-03-29 13:53:29.036097+1300 JC11[69391:1634395] QUERY: DELETE FROM CopiedTrack
2382019-03-29 13:53:29.036799+1300 JC11[69391:1634395] QUERY: DELETE FROM ListHierarchy
2392019-03-29 13:53:29.037499+1300 JC11[69391:1634395] QUERY: DELETE FROM ListParentList
2402019-03-29 13:53:29.038498+1300 JC11[69391:1634395] QUERY: DELETE FROM List WHERE type = ?
2412019-03-29 13:53:29.039930+1300 JC11[69391:1634395] QUERY: DELETE FROM ListTrackList WHERE listType = ?
2422019-03-29 13:53:29.040720+1300 JC11[69391:1634395] QUERY: DELETE FROM List WHERE type = ?
2432019-03-29 13:53:29.041660+1300 JC11[69391:1634395] QUERY: DELETE FROM ListTrackList WHERE listType = ?
2442019-03-29 13:53:29.042346+1300 JC11[69391:1634395] QUERY: DELETE FROM List WHERE type = ?
2452019-03-29 13:53:29.043548+1300 JC11[69391:1634395] QUERY: DELETE FROM ListTrackList WHERE listType = ?
2462019-03-29 13:53:29.044213+1300 JC11[69391:1634395] QUERY: DELETE FROM List WHERE type = ?
2472019-03-29 13:53:29.045733+1300 JC11[69391:1634395] QUERY: DELETE FROM ListTrackList WHERE listType = ?
2482019-03-29 13:53:29.046392+1300 JC11[69391:1634395] QUERY: DELETE FROM List WHERE type = ?
2492019-03-29 13:53:29.047584+1300 JC11[69391:1634395] QUERY: DELETE FROM ListTrackList WHERE listType = ?
2502019-03-29 13:53:29.048307+1300 JC11[69391:1634395] QUERY: DELETE FROM PerformanceData
2512019-03-29 13:53:29.049153+1300 JC11[69391:1634395] QUERY: SELECT 1
2522019-03-29 13:53:29.050559+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2532019-03-29 13:53:29.058671+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
2542019-03-29 13:53:29.058868+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2552019-03-29 13:53:29.059026+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
2562019-03-29 13:53:29.059227+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2572019-03-29 13:53:29.061508+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2582019-03-29 13:53:29.062905+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
2592019-03-29 13:53:29.063086+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2602019-03-29 13:53:29.063247+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
2612019-03-29 13:53:29.063398+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2622019-03-29 13:53:29.064174+1300 JC11[69391:1634395] QUERY: SELECT 1
2632019-03-29 13:53:29.064419+1300 JC11[69391:1634395] QUERY: SELECT 1
2642019-03-29 13:53:29.064817+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2652019-03-29 13:53:29.065486+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2662019-03-29 13:53:29.067895+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2672019-03-29 13:53:29.075851+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
2682019-03-29 13:53:29.076066+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2692019-03-29 13:53:29.076241+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
2702019-03-29 13:53:29.076428+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2712019-03-29 13:53:29.078072+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2722019-03-29 13:53:29.079438+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
2732019-03-29 13:53:29.079844+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2742019-03-29 13:53:29.080005+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
2752019-03-29 13:53:29.080164+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
2762019-03-29 13:53:29.080930+1300 JC11[69391:1634395] QUERY: SELECT 1
2772019-03-29 13:53:29.081139+1300 JC11[69391:1634395] QUERY: SELECT 1
2782019-03-29 13:53:29.081690+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2792019-03-29 13:53:29.082632+1300 JC11[69391:1634395] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
2802019-03-29 13:53:29.085161+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
2812019-03-29 13:53:29.106311+1300 JC11[69391:1634395] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE type = ? ORDER BY id ASC
2822019-03-29 13:53:29.158395+1300 JC11[69391:1634748] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE id = ? AND type = ?
2832019-03-29 13:53:29.163471+1300 JC11[69391:1634748] QUERY: PRAGMA journal_mode
2842019-03-29 13:53:29.173715+1300 JC11[69391:1634748] QUERY: PRAGMA journal_mode = PERSIST
2852019-03-29 13:53:29.173967+1300 JC11[69391:1634748] QUERY: PRAGMA journal_mode
2862019-03-29 13:53:29.174263+1300 JC11[69391:1634748] QUERY: PRAGMA foreign_keys = ON
2872019-03-29 13:53:29.174423+1300 JC11[69391:1634748] QUERY: SELECT uuid FROM Information WHERE id = ?
2882019-03-29 13:53:29.176229+1300 JC11[69391:1634748] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/itm.db' AS db1
2892019-03-29 13:53:29.185527+1300 JC11[69391:1634748] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/m.db' AS db2
2902019-03-29 13:53:29.194000+1300 JC11[69391:1634748] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/sm.db' AS db3
2912019-03-29 13:53:29.203691+1300 JC11[69391:1634748] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/fsm.db' AS db4
2922019-03-29 13:53:29.204225+1300 JC11[69391:1634395] [air.planck.database.collector] Invalid CollectionJob::Settings object
2932019-03-29 13:53:29.206390+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
2942019-03-29 13:53:29.217133+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode = PERSIST
2952019-03-29 13:53:29.217386+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
2962019-03-29 13:53:29.220320+1300 JC11[69391:1634748] QUERY: SELECT t.trackId AS TrackId2, 2 AS SourceDatabase, t.id, t.trackNumber FROM db2.ListTrackList AS t WHERE t.listType = ? AND t.listId IN ( SELECT id FROM db2.List WHERE path LIKE ? ESCAPE "\" ) ORDER BY trackNumber ASC
2972019-03-29 13:53:29.223724+1300 JC11[69391:1634748] QUERY: SELECT 1
2982019-03-29 13:53:29.224884+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
2992019-03-29 13:53:29.227598+1300 JC11[69391:1634751] QUERY: PRAGMA foreign_keys = ON
3002019-03-29 13:53:29.227834+1300 JC11[69391:1634751] QUERY: SELECT uuid FROM Information WHERE id = ?
3012019-03-29 13:53:29.229119+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
3022019-03-29 13:53:29.231899+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
3032019-03-29 13:53:29.232086+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
3042019-03-29 13:53:29.232210+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
3052019-03-29 13:53:29.232441+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
3062019-03-29 13:53:29.233470+1300 JC11[69391:1634395] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering FROM List INNER JOIN ListParentList AS j1 ON id = listOriginId AND type = listOriginType WHERE title = ? AND type = ? AND j1.listParentId = id
3072019-03-29 13:53:29.236808+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
3082019-03-29 13:53:29.237291+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode = PERSIST
3092019-03-29 13:53:29.237437+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
3102019-03-29 13:53:29.237720+1300 JC11[69391:1634751] QUERY: PRAGMA foreign_keys = ON
3112019-03-29 13:53:29.237862+1300 JC11[69391:1634751] QUERY: SELECT uuid FROM Information WHERE id = ?
3122019-03-29 13:53:29.239207+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
3132019-03-29 13:53:29.244166+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
3142019-03-29 13:53:29.244332+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
3152019-03-29 13:53:29.244464+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
3162019-03-29 13:53:29.244598+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
3172019-03-29 13:53:29.245413+1300 JC11[69391:1634395] QUERY: SELECT MAX(ordering) FROM List WHERE type = ?
3182019-03-29 13:53:29.246583+1300 JC11[69391:1634395] QUERY: SELECT 1
3192019-03-29 13:53:29.247064+1300 JC11[69391:1634395] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE type = ? AND ordering >= ? AND ordering <= ? ORDER BY ordering ASC
3202019-03-29 13:53:29.247296+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode = PERSIST
3212019-03-29 13:53:29.247534+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
3222019-03-29 13:53:29.247857+1300 JC11[69391:1634751] QUERY: PRAGMA foreign_keys = ON
3232019-03-29 13:53:29.248482+1300 JC11[69391:1634395] QUERY: UPDATE List SET ordering = ordering + ? WHERE type = ? AND ordering >= ?
3242019-03-29 13:53:29.248544+1300 JC11[69391:1634751] QUERY: SELECT uuid FROM Information WHERE id = ?
3252019-03-29 13:53:29.249310+1300 JC11[69391:1634751] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/itm.db' AS db1
3262019-03-29 13:53:29.249638+1300 JC11[69391:1634395] QUERY: SELECT MAX("id") FROM "List"
3272019-03-29 13:53:29.250464+1300 JC11[69391:1634395] QUERY: INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
3282019-03-29 13:53:29.254359+1300 JC11[69391:1634395] QUERY: SELECT EXISTS ( SELECT 1 FROM ListParentList WHERE listOriginId = ? AND listOriginType = ? AND listParentId = ? AND listParentType = ? ) AS entryExists
3292019-03-29 13:53:29.255517+1300 JC11[69391:1634395] QUERY: INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( ?, ?, ?, ? )
3302019-03-29 13:53:29.257891+1300 JC11[69391:1634751] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/m.db' AS db2
3312019-03-29 13:53:29.259237+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
3322019-03-29 13:53:29.265892+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode = PERSIST
3332019-03-29 13:53:29.266054+1300 JC11[69391:1634395] QUERY: PRAGMA journal_mode
3342019-03-29 13:53:29.266198+1300 JC11[69391:1634395] QUERY: PRAGMA foreign_keys = ON
3352019-03-29 13:53:29.266329+1300 JC11[69391:1634395] QUERY: SELECT uuid FROM Information WHERE id = ?
3362019-03-29 13:53:29.267324+1300 JC11[69391:1634395] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE id = ? AND type = ?
3372019-03-29 13:53:29.268331+1300 JC11[69391:1634395] QUERY: SELECT 1
3382019-03-29 13:53:29.268286+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
3392019-03-29 13:53:29.269798+1300 JC11[69391:1634395] QUERY: SELECT 1
3402019-03-29 13:53:29.276806+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode = PERSIST
3412019-03-29 13:53:29.277054+1300 JC11[69391:1634751] QUERY: PRAGMA journal_mode
3422019-03-29 13:53:29.277216+1300 JC11[69391:1634751] QUERY: PRAGMA foreign_keys = ON
3432019-03-29 13:53:29.277363+1300 JC11[69391:1634751] QUERY: SELECT uuid FROM Information WHERE id = ?
3442019-03-29 13:53:29.278158+1300 JC11[69391:1634751] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/sm.db' AS db3
3452019-03-29 13:53:29.285888+1300 JC11[69391:1634751] QUERY: ATTACH DATABASE '/Users/tomasfriml/Library/Developer/CoreSimulator/Devices/01BC6561-3D92-401F-9F41-33A8D3CC4435/data/Containers/Data/Application/800D08DE-1204-4F68-91B4-DBA3CECA3B7F/Documents/AIR Music Technology/JC11/Engine Library/fsm.db' AS db4
3462019-03-29 13:53:29.286717+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
3472019-03-29 13:53:29.294485+1300 JC11[69391:1634751] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering, 2 AS SourceDatabase, UPPER(title) AS v FROM db2.List INNER JOIN db2.ListParentList AS j1 ON id = listOriginId WHERE j1.listParentId = id AND type = ? ORDER BY v ASC
3482019-03-29 13:53:29.295832+1300 JC11[69391:1634751] QUERY: SELECT 1
3492019-03-29 13:53:29.323104+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
3502019-03-29 13:53:32.077123+1300 JC11[69391:1634751] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering, 2 AS SourceDatabase, UPPER(title) AS v FROM db2.List INNER JOIN db2.ListParentList AS j1 ON id = listOriginId WHERE j1.listParentId = id AND type = ? ORDER BY v ASC
3512019-03-29 13:53:32.099838+1300 JC11[69391:1634395] Case insensitive sorting unsupported in the posix collation implementation
3522019-03-29 13:53:32.100095+1300 JC11[69391:1634395] Numeric mode unsupported in the posix collation implementation
3532019-03-29 13:53:33.340159+1300 JC11[69391:1634395] QQmlExpression: Expression qrc:/Skins/EmbeddedCommon/EmbeddedMain.qml:223:3 depends on non-NOTIFYable properties:
3542019-03-29 13:53:33.340473+1300 JC11[69391:1634395] QQuickItem::transform
3552019-03-29 13:53:34.025638+1300 JC11[69391:1634395] Model size of -1 is less than 0
3562019-03-29 13:53:34.646610+1300 JC11[69391:1634395] Model size of -1 is less than 0
3572019-03-29 13:53:35.652636+1300 JC11[69391:1634395] Model size of -2 is less than 0
3582019-03-29 13:53:35.655968+1300 JC11[69391:1634395] Model size of -2 is less than 0
3592019-03-29 13:53:35.744574+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3602019-03-29 13:53:35.758017+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
3612019-03-29 13:53:35.758216+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3622019-03-29 13:53:35.758375+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
3632019-03-29 13:53:35.758524+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
3642019-03-29 13:53:35.761442+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3652019-03-29 13:53:35.763089+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
3662019-03-29 13:53:35.763257+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3672019-03-29 13:53:35.763941+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
3682019-03-29 13:53:35.764243+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
3692019-03-29 13:53:35.765418+1300 JC11[69391:1634749] QUERY: SELECT 1
3702019-03-29 13:53:35.765640+1300 JC11[69391:1634749] QUERY: SELECT 1
3712019-03-29 13:53:35.766089+1300 JC11[69391:1634749] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
3722019-03-29 13:53:35.767506+1300 JC11[69391:1634749] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
3732019-03-29 13:53:35.769340+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3742019-03-29 13:53:35.784423+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
3752019-03-29 13:53:35.784656+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3762019-03-29 13:53:35.784820+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
3772019-03-29 13:53:35.785167+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
3782019-03-29 13:53:35.789374+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3792019-03-29 13:53:35.792790+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
3802019-03-29 13:53:35.793082+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3812019-03-29 13:53:35.793249+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
3822019-03-29 13:53:35.793549+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
3832019-03-29 13:53:35.795263+1300 JC11[69391:1634749] QUERY: SELECT 1
3842019-03-29 13:53:35.795655+1300 JC11[69391:1634749] QUERY: SELECT 1
3852019-03-29 13:53:35.796244+1300 JC11[69391:1634749] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
3862019-03-29 13:53:35.796973+1300 JC11[69391:1634749] QUERY: SELECT schemaVersionMajor, schemaVersionMinor, schemaVersionPatch FROM Information WHERE id = ?
3872019-03-29 13:53:35.798544+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3882019-03-29 13:53:35.804131+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
3892019-03-29 13:53:35.804303+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
3902019-03-29 13:53:35.804437+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
3912019-03-29 13:53:35.804552+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
3922019-03-29 13:53:35.804967+1300 JC11[69391:1634749] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
3932019-03-29 13:53:35.805364+1300 JC11[69391:1634749] QUERY: UPDATE Information SET id = ? , uuid = ? , schemaVersionMajor = ? , schemaVersionMinor = ? , schemaVersionPatch = ? , currentPlayedIndiciator = ? , lastRekordBoxLibraryImportReadCounter = ? WHERE id = ?
3942019-03-29 13:53:35.807452+1300 JC11[69391:1634749] QUERY: SELECT 1
3952019-03-29 13:53:35.809698+1300 JC11[69391:1634749] QUERY: DELETE FROM List WHERE type = ? AND id NOT IN ( SELECT listId FROM ListTrackList WHERE listType = ? )
3962019-03-29 13:53:35.844231+1300 JC11[69391:1634749] QUERY: DELETE FROM List WHERE type = ? AND id NOT IN ( SELECT listId FROM ListTrackList WHERE listType = ? )
3972019-03-29 13:53:35.847680+1300 JC11[69391:1634749] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE type = ? ORDER BY id ASC
3982019-03-29 13:53:35.848755+1300 JC11[69391:1634749] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering FROM List INNER JOIN ListParentList AS j1 ON id = listOriginId AND type = listOriginType WHERE title = ? AND type = ? AND j1.listParentId = id
3992019-03-29 13:53:35.849675+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4002019-03-29 13:53:35.865167+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
4012019-03-29 13:53:35.865498+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4022019-03-29 13:53:35.865899+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
4032019-03-29 13:53:35.866114+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
4042019-03-29 13:53:35.867507+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4052019-03-29 13:53:35.875027+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
4062019-03-29 13:53:35.875344+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4072019-03-29 13:53:35.875511+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
4082019-03-29 13:53:35.875883+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
4092019-03-29 13:53:35.876608+1300 JC11[69391:1634749] QUERY: SELECT MAX(ordering) FROM List WHERE type = ?
4102019-03-29 13:53:35.877684+1300 JC11[69391:1634749] QUERY: SELECT 1
4112019-03-29 13:53:35.878172+1300 JC11[69391:1634749] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE type = ? AND ordering >= ? AND ordering <= ? ORDER BY ordering ASC
4122019-03-29 13:53:35.879040+1300 JC11[69391:1634749] QUERY: UPDATE List SET ordering = ordering + ? WHERE type = ? AND ordering >= ?
4132019-03-29 13:53:35.879758+1300 JC11[69391:1634749] QUERY: SELECT MAX("id") FROM "List"
4142019-03-29 13:53:35.880822+1300 JC11[69391:1634749] QUERY: INSERT INTO List ( id, type, title, path, isFolder, trackCount, ordering ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
4152019-03-29 13:53:35.883042+1300 JC11[69391:1634749] QUERY: SELECT EXISTS ( SELECT 1 FROM ListParentList WHERE listOriginId = ? AND listOriginType = ? AND listParentId = ? AND listParentType = ? ) AS entryExists
4162019-03-29 13:53:35.883602+1300 JC11[69391:1634749] QUERY: INSERT INTO ListParentList ( listOriginId, listOriginType, listParentId, listParentType ) VALUES ( ?, ?, ?, ? )
4172019-03-29 13:53:35.885457+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4182019-03-29 13:53:35.892098+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
4192019-03-29 13:53:35.893163+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4202019-03-29 13:53:35.893931+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
4212019-03-29 13:53:35.894487+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
4222019-03-29 13:53:35.895371+1300 JC11[69391:1634749] QUERY: SELECT 1
4232019-03-29 13:53:35.897192+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4242019-03-29 13:53:35.905606+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
4252019-03-29 13:53:35.905829+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4262019-03-29 13:53:35.906102+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
4272019-03-29 13:53:35.906248+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
4282019-03-29 13:53:35.909485+1300 JC11[69391:1634749] QUERY: SELECT 1
4292019-03-29 13:53:35.910603+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4302019-03-29 13:53:35.919436+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
4312019-03-29 13:53:35.919661+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4322019-03-29 13:53:35.919791+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
4332019-03-29 13:53:35.920114+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
4342019-03-29 13:53:35.920757+1300 JC11[69391:1634749] QUERY: SELECT 1
4352019-03-29 13:53:35.921714+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4362019-03-29 13:53:35.930983+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode = PERSIST
4372019-03-29 13:53:35.931333+1300 JC11[69391:1634749] QUERY: PRAGMA journal_mode
4382019-03-29 13:53:35.931753+1300 JC11[69391:1634749] QUERY: PRAGMA foreign_keys = ON
4392019-03-29 13:53:35.931959+1300 JC11[69391:1634749] QUERY: SELECT uuid FROM Information WHERE id = ?
4402019-03-29 13:53:35.932708+1300 JC11[69391:1634749] QUERY: SELECT 1
4412019-03-29 13:53:35.933253+1300 JC11[69391:1634749] QUERY: SELECT t.id, t.type, t.title, t.path, t.isFolder, t.trackCount, t.ordering FROM List as t WHERE id = ? AND type = ?
4422019-03-29 13:53:35.935376+1300 JC11[69391:1634749] QUERY: SELECT 1
4432019-03-29 13:53:37.624553+1300 JC11[69391:1634395] [air.planck.database.collector] Invalid CollectionJob::Settings object
4442019-03-29 13:53:37.625799+1300 JC11[69391:1634755] QUERY: ATTACH DATABASE '/Volumes/PHILLIP/Engine Library/m.db' AS db5
4452019-03-29 13:53:37.626591+1300 JC11[69391:1634752] QUERY: SELECT EXISTS(SELECT 1 FROM InternalDatabase WHERE UPPER( uuid ) = UPPER( ? ) ) AS entryExists
4462019-03-29 13:53:37.629051+1300 JC11[69391:1634395] QUERY: SELECT id, uuid, schemaVersionMajor, schemaVersionMinor, schemaVersionPatch, currentPlayedIndiciator, lastRekordBoxLibraryImportReadCounter FROM Information WHERE id = ?
4472019-03-29 13:53:37.641151+1300 JC11[69391:1634755] QUERY: ATTACH DATABASE '/Volumes/PHILLIP/Engine Library/sm.db' AS db6
4482019-03-29 13:53:37.651108+1300 JC11[69391:1634755] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering, 5 AS SourceDatabase, UPPER(title) AS v FROM db5.List INNER JOIN db5.ListParentList AS j1 ON id = listOriginId WHERE j1.listParentId = id AND type = ? ORDER BY v ASC
4492019-03-29 13:53:37.654135+1300 JC11[69391:1634755] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering, 5 AS SourceDatabase, UPPER(title) AS v FROM db5.List INNER JOIN db5.ListParentList AS j1 ON id = listOriginId WHERE j1.listParentId = id AND type = ? ORDER BY v ASC
4502019-03-29 13:53:37.658791+1300 JC11[69391:1634755] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering FROM List INNER JOIN ListParentList AS j1 ON id = listOriginId AND type = listOriginType WHERE j1.listParentId = id AND type = ? ORDER BY UPPER(title) ASC
4512019-03-29 13:53:37.664806+1300 JC11[69391:1634755] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering FROM List INNER JOIN ListParentList AS j1 ON id = listOriginId AND type = listOriginType WHERE j1.listParentId = id AND type = ? ORDER BY ordering ASC
4522019-03-29 13:53:37.666304+1300 JC11[69391:1634755] QUERY: SELECT id, type, title, path, isFolder, trackCount, ordering FROM List INNER JOIN ListParentList AS j1 ON id = listOriginId AND type = listOriginType WHERE j1.listParentId = id AND type = ? ORDER BY id DESC
4532019-03-29 13:53:37.668620+1300 JC11[69391:1634755] QUERY: SELECT j.id, 5 AS SourceDatabase, UPPER(j.title) AS v FROM db5.List AS j WHERE j.path = ? AND j.type = ? ORDER BY v ASC
4542019-03-29 13:53:37.671687+1300 JC11[69391:1634755] QUERY: SELECT j.id, j.type, j.title, j.path, j.isFolder, j.trackCount, j.ordering, 5 AS SourceDatabase, id AS v FROM db5.List AS j INNER JOIN db5.ListParentList AS cpl ON j.id = cpl.listOriginId AND j.type = cpl.listOriginType WHERE cpl.listParentId = ? AND cpl.listParentType = ? AND cpl.listParentId != cpl.listOriginId ORDER BY v DESC
4552019-03-29 13:53:38.450936+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
4562019-03-29 13:53:38.485158+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
4572019-03-29 13:53:38.492364+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()
4582019-03-29 13:53:38.499443+1300 JC11[69391:1634590] CoreAudio ( Line: 123 ): STOP()