features_sqlite r2349 "no such table: Library" for fresh ~/.mixxx
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mixxx |
Fix Released
|
High
|
RJ Skerry-Ryan |
Bug Description
This seems to result from some sql stmts failing when starting after deleting ~/.mixxx directory
Probably some bug with the table creation stuff?
Wish I could help debug this stuff. Unfortunately I don't know the code at all...
[...]
Debug: [Main]: Setting up LADSPA EnableEffect "0"
Debug: [Main]: Key string: "EnableEffect0"
Debug: [Main]: Setting up LADSPA EnableEffect "1"
Debug: [Main]: Key string: "EnableEffect1"
Debug: [Main]: Setting up LADSPA EnableEffect "2"
Debug: [Main]: Key string: "EnableEffect2"
[New Thread 0xb111bb70 (LWP 3426)]
Debug: [Main]: WLibrary:
Debug: [Main]: MixxxLibraryFea
Debug: [Main]: Library:
Debug: [Main]: WTrackTableView
[New Thread 0xb085ab70 (LWP 3427)]
Debug: [Main]: WLibrary:
Debug: [Main]: LibraryTableMod
[New Thread 0xb0059b70 (LWP 3428)]
Debug: [Main]: PlaylistDAO:
Debug: [Main]: getPlaylistIdFr
Debug: [Main]: PlaylistDAO:
Debug: [Main]: inserting playlist "Auto DJ" at position 0
Debug: [Main]: "INSERT INTO Playlists (name, position) VALUES (:name, :position)"
Debug: [Main]: QSqlError(-1, "Parameter count mismatch", "")
Debug: [Main]: PlaylistDAO:
Debug: [Main]: getPlaylistIdFr
Debug: [Main]: PlaylistTableMo
Debug: [Main]: "CREATE TEMPORARY VIEW 'playlist_-1' AS SELECT PlaylistTracks.
Debug: [Main]: WTrackTableView
[New Thread 0xaf7ccb70 (LWP 3429)]
Debug: [Main]: slotSearch() "" QThread(0x83e81e8, name = "Main")
Debug: [Main]: WTrackTableView
Debug: [Main]: Constructed LibraryScanner!!!
[New Thread 0xaefcbb70 (LWP 3430)]
[New Thread 0xadddbb70 (LWP 3431)]
Debug: [LibraryScanner 1]: LibraryHashDAO:
Debug: [LibraryScanner 1]: CueDAO::initialize LibraryScanner(
Debug: [LibraryScanner 1]: TrackDAO:
Debug: [LibraryScanner 1]: SELECT hash failed: QSqlError(-1, "Parameter count mismatch", "")
Debug: [LibraryScanner 1]: LibraryHashDAO:
Debug: [LibraryScanner 1]: Creating new dirhash failed: QSqlError(-1, "Parameter count mismatch", "")
Debug: [LibraryScanner 1]: created new hash 129085779
Debug: [LibraryScanner 1]: TrackCollection
Debug: [LibraryScanner 1]: TrackDAO:
Debug: [LibraryScanner 1]: Couldn't mark tracks in directory "/home/aki/Music" as needing verification. QSqlError(-1, "Parameter count mismatch", "")
Debug: [LibraryScanner 1]: Couldn't mark track "/home/
[New Thread 0xad5dab70 (LWP 3432)]
[New Thread 0xacdd9b70 (LWP 3433)]
[New Thread 0xac5d8b70 (LWP 3434)]
Debug: [MidiObject 1]: MidiMapping: Loading MIDI XML from "/home/
Debug: [MidiObject 1]: Could not open xml file: "/home/
Debug: [Main]: selectedAPI is: "ALSA"
Debug: [Main]: Setting qConfigPath from location in resourcePath commandline arg: "/opt/mixxx-
Debug: [Main]: Setting qConfigPath from location in resourcePath commandline arg: "/opt/mixxx-
Debug: [Main]: loadSettings: 1 0 ""
Debug: [Main]: slotApply crossfader: 1 ""
Debug: [Main]: BPM Scheme File ConfigKey not set or file missing... setting to "/home/
Debug: [Main]: BpmSchemes::readXML "/home/
Debug: [Main]: BPM Scheme: "/home/
Debug: [Main]: getting midi device list, size 0 and: ""
Debug: [Main]: SoundManager:
Debug: [Main]: VinylControlProxy: Unknown vinyl type ""
Debug: [Main]: Defaulting to Serato...
Debug: [Main]: Building timecode lookup tables...
Allocating 2097152 slots (8192Kb) for 20 bit timecode (Serato 2nd Ed., side A)
Debug: [Main]: Starting vinyl control xwax thread
[New Thread 0xab5d6b70 (LWP 3435)]
Debug: [Main]: Building timecode lookup tables...
Allocating 2097152 slots (8192Kb) for 20 bit timecode (Serato 2nd Ed., side A)
Debug: [Main]: Starting vinyl control xwax thread
[New Thread 0xaa5d4b70 (LWP 3437)]
Debug: [Main]: SoundDevicePort
Debug: [Main]: m_dSampleRate 44100
Debug: [Main]: iLatencyMSec: 64
Debug: [Main]: output channels: 2 | input channels: 0
Debug: [Main]: iLatencySamples: 5644
Debug: [Main]: iLatencyMSec: 64
Debug: [Main]: Opening stream with id 0
Debug: [Main]: Opened PortAudio stream successfully... starting
Debug: [Main]: Dynamically loaded PortAudio library!
[New Thread 0xa9dd3b70 (LWP 3438)]
Debug: [Main]: PortAudio: Started stream successfully
Debug: [Main]: iNumDevicesOpen
Debug: [Main]: iNumDevicesOpen
Debug: [Main]: TrackDAO::getTrack QThread(0x83e81e8, name = "Main") "qt_sql_
Debug: [Main]: QSqlError(1, "Unable to execute statement", "no such table: Library")
Debug: [Main]: TrackDAO::getTrack QThread(0x83e81e8, name = "Main") "qt_sql_
Debug: [Main]: QSqlError(1, "Unable to execute statement", "no such table: Library")
Debug: [Main]: Displaying mixxx
Debug: [Main]: Running Mixxx
Debug: [LibraryScanner 1]: QSqlError(-1, "Parameter count mismatch", "")
Debug: [LibraryScanner 1]: QSqlError(-1, "Parameter count mismatch", "")
Fatal: [LibraryScanner 1]: ASSERT: "trackLocationId >= 0" in file src/library/
Program received signal SIGABRT, Aborted.
[Switching to Thread 0xadddbb70 (LWP 3431)]
0xb7fe2422 in __kernel_vsyscall ()
(gdb)
Thanks!
Changed in mixxx: | |
status: | Fix Committed → In Progress |
status: | In Progress → Fix Released |
Could you remove ~/.mixxx again and give me a full copy of the log?
I recently added a schema.xml that the original schema is loaded from. If you haven't yet run `scons install' then it's possible that your binary can't find schema.xml.