search

mixxxdj / mixxx

Mixxx is Free DJ software that gives you everything you need to perform live mixes.
http://mixxx.org
Other
4.4k stars 1.26k forks source link

2.3 fails on initializing a new database #9672

Closed mixxxbot closed 2 years ago

mixxxbot commented 2 years ago

Reported by: jikstra Date: 2019-06-11T15:56:59Z Status: Won't Fix Importance: Undecided Launchpad Issue: lp1832372

I'm on commit d5f3db46f7c72daddd9acb6de28862f19af8b440 and tried to start/use mixxx 2.3 from a new config, so i removed ~/.mixx and started mixxx but it failed with the error "Migration path for upgrading database schema from version 28 to version 29 is missing".

```
$ rm -rf ~/.mixxx && ./mixxx --logLevel debug
Debug [Main]: Could not find drkonqi in search paths: ("/home/kerle/Apps/mixxx", "/usr/lib/qt/libexec", "/usr/lib")
Info [Main]: LibFaadLoader - Successfully loaded library "libfaad.so"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "aif"
Info [Main]: SoundSourceProxy -   1 : "libsndfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "aiff"
Info [Main]: SoundSourceProxy -   1 : "libsndfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "caf"
Info [Main]: SoundSourceProxy -   1 : "libsndfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "flac"
Info [Main]: SoundSourceProxy -   2 : "Xiph.org libFLAC"
Info [Main]: SoundSourceProxy -   1 : "libsndfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "it"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "m4a"
Info [Main]: SoundSourceProxy -   2 : "Nero FAAD2"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "med"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "mod"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "mp3"
Info [Main]: SoundSourceProxy -   2 : "MAD: MPEG Audio Decoder"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "mp4"
Info [Main]: SoundSourceProxy -   2 : "Nero FAAD2"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "ogg"
Info [Main]: SoundSourceProxy -   2 : "Xiph.org OggVorbis"
Info [Main]: SoundSourceProxy -   1 : "libsndfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "okt"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "opus"
Info [Main]: SoundSourceProxy -   2 : "Xiph.org libopusfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "s3m"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "stm"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "wav"
Info [Main]: SoundSourceProxy -   1 : "libsndfile"
Info [Main]: SoundSourceProxy - SoundSource providers for file extension "xm"
Info [Main]: SoundSourceProxy -   2 : "MODPlug"
Warning [Main]: Icon theme "ubuntu-mono-dark" not found.
Warning [Main]: Icon theme "gnome" not found.
Debug [Main]: "Mixxx" "2.3.0-alpha-pre" "(git master r6836; built on: Jun 11 2019 @ 17:49:57; flags: asan=0 battery=1 buildtime=1 bulk=1 color=0 coreaudio=0 faad=1 ffmpeg=0 hid=1 hss1394=0 lilv=1 localecompare=1 macappstore=0 mad=1 mediafoundation=0 modplug=1 optimize=native opus=1 perftools=0 perftools_profiler=0 profiling=0 qt_sqlite_plugin=0 qtkeychain=0 shoutcast=1 test=False tsan=0 ubsan=0 verbose=1 vinylcontrol=1 wv=0)" is starting...
Debug [Main]: Compile time library versions:
Debug [Main]: Qt: 5.12.3
Debug [Main]: libshout: 2.4.2
Debug [Main]: PortAudio: 1246720 PortAudio V19.6.0-devel, revision 396fe4b6699ae929d3a685b3ef8a7e97396139a4
Debug [Main]: RubberBand: 1.8.2
Debug [Main]: SoundTouch: 2.1.2
Debug [Main]: TagLib: 1.11.1
Debug [Main]: ChromaPrint: 1.4.3
Debug [Main]: Vorbis: Xiph.Org libVorbis 1.3.6
Debug [Main]: libsndfile: libsndfile-1.0.28
Debug [Main]: FLAC: 1.3.2
Debug [Main]: libmp3lame: 3.100
Debug [Main]: QStandardPaths::writableLocation(HomeLocation): "/home/kerle"
Debug [Main]: QStandardPaths::writableLocation(DataLocation): "/home/kerle/.local/share/Mixxx"
Debug [Main]: QCoreApplication::applicationDirPath() "/home/kerle/Apps/mixxx"
Debug [Main]: Loading resources from  "/home/kerle/Apps/mixxx/res/"
Debug [Main]: ConfigObject: Could not read "/home/kerle/.mixxx/mixxx.cfg"
Debug [Main]: No version number in configuration file. Setting to 2.3.0-alpha-pre
Info [Main]: BroadcastSettings - Profiles folder doesn't exist. Creating it.
Info [Main]: BroadcastSettings - No profiles found. Creating default profile.
Debug [Main]: Loading resources from  "/home/kerle/Apps/mixxx/res/"
Debug [Main]: Found and will use default keyboard preset "/home/kerle/Apps/mixxx/res/keyboard/de_DE.kbd.cfg"
Debug [Main]: Loading resources from  "/home/kerle/Apps/mixxx/res/"
Debug [Main]: Loading translations for locale "de_DE" from translations folder "/home/kerle/Apps/mixxx/res/translations/" : success
Debug [Main]: Loading resources from  "/home/kerle/Apps/mixxx/res/"
Debug [Main]: ConfigObject: Could not read "/home/kerle/.mixxx/sandbox.cfg"
Debug [Main]: Compressor attack per frame:  0.000408163 decay per frame:  4.08163e-05
Debug [Main]: JACK client name set
ALSA lib pcm_dsnoop.c:638:(snd_pcm_dsnoop_open) unable to open slave
ALSA lib pcm_dmix.c:1108:(snd_pcm_dmix_open) unable to open slave
ALSA lib pcm.c:2564:(snd_pcm_open_noupdate) Unknown PCM cards.pcm.rear
ALSA lib pcm.c:2564:(snd_pcm_open_noupdate) Unknown PCM cards.pcm.center_lfe
ALSA lib pcm.c:2564:(snd_pcm_open_noupdate) Unknown PCM cards.pcm.side
connect(2) call to /dev/shm/jack-1000/default/jack_0 failed (err=Datei oder Verzeichnis nicht gefunden)
attempt to connect to server failed
connect(2) call to /dev/shm/jack-1000/default/jack_0 failed (err=Datei oder Verzeichnis nicht gefunden)
attempt to connect to server failed
ALSA lib pcm_oss.c:377:(_snd_pcm_oss_open) Unknown field port
ALSA lib pcm_oss.c:377:(_snd_pcm_oss_open) Unknown field port
ALSA lib pcm_usb_stream.c:486:(_snd_pcm_usb_stream_open) Invalid type for card
ALSA lib pcm_usb_stream.c:486:(_snd_pcm_usb_stream_open) Invalid type for card
ALSA lib pcm_dmix.c:1108:(snd_pcm_dmix_open) unable to open slave
connect(2) call to /dev/shm/jack-1000/default/jack_0 failed (err=Datei oder Verzeichnis nicht gefunden)
attempt to connect to server failed
Debug [Main]: EngineNetworkStream - addWorker: worker added
Debug [Main]: EngineNetworkStream - worker slots used: "1 out of 16"
Debug [Main]: BroadcastManager - addConnection: created connection for profile "Connection 1"
Debug [Main]: WARNING: AudioInput already registered!
Debug [Main]: WARNING: AudioInput already registered!
Info [Main]: DbConnection - Available drivers for database connections: ("QIBASE", "QSQLITE", "QSQLITE3", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7", "QTDS", "QTDS7")
Debug [Main]: DbConnection - Opening database connection "MIXXX-1" QSqlDatabase(driver="QSQLITE", database="/home/kerle/.mixxx/mixxxdb.sqlite", host="localhost", port=-1, user="mixxx", open=false)
Info [Main]: DbConnectionPool - Cloned thread-local database connection "MIXXX-1" QSqlDatabase(driver="QSQLITE", database="/home/kerle/.mixxx/mixxxdb.sqlite", host="localhost", port=-1, user="mixxx", open=true)
Info [Main]: MixxxMainWindow - Connecting to database
Debug [Main]: DbConnectionPooled - Found thread-local database connection "MIXXX-1" QSqlDatabase(driver="QSQLITE", database="/home/kerle/.mixxx/mixxxdb.sqlite", host="localhost", port=-1, user="mixxx", open=true)
Info [Main]: MixxxMainWindow - Initializing or upgrading database schema
Info [Main]: SettingsDAO - Failed to prepare query: Returning default value "" for "mixxx.schema.version"
Info [Main]: SchemaManager - Upgrading database schema from version 0 to version 29
Debug [Main]: SchemaManager - Loading database schema migrations from ":/schema.xml"
Info [Main]: SchemaManager - Upgrading to database schema to version 1 : "The base schema for the Mixxx SQLITE database."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 1
Info [Main]: SchemaManager - Upgrading to database schema to version 2 : "Add a header_parsed integer column to the library to indicate when a\n      track's tags have been parsed."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 2
Info [Main]: SchemaManager - Upgrading to database schema to version 3 : "Change the location column to be a an integer. Change comment to be\n      varchar(256) and album/artist/title to be varchar(64)."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 3
Info [Main]: SchemaManager - Upgrading to database schema to version 4 : "Add file type column."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 4
Info [Main]: SchemaManager - Upgrading to database schema to version 5 : "Add needs_verification column to library hashes table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 5
Info [Main]: SchemaManager - Upgrading to database schema to version 6 : "Added a ReplayGain Column."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 6
Info [Main]: SchemaManager - Upgrading to database schema to version 7 : "Add timesplayed and rating column. Reset header state."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 7
Info [Main]: SchemaManager - Upgrading to database schema to version 8 : "Added iTunes tables"
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 8
Info [Main]: SchemaManager - Upgrading to database schema to version 9 : "Tables for Traktor library feature"
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 9
Info [Main]: SchemaManager - Upgrading to database schema to version 10 : "Playlist and crate locks"
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 10
Info [Main]: SchemaManager - Upgrading to database schema to version 11 : "Tables for Rhythmbox library feature"
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 11
Info [Main]: SchemaManager - Upgrading to database schema to version 12 : "Add beats column to library table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 12
Info [Main]: SchemaManager - Upgrading to database schema to version 13 : "Add position column to Rhythmbox, iTunes, and Traktor playlist tables."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 13
Info [Main]: SchemaManager - Upgrading to database schema to version 14 : "Add composer column to library table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 14
Info [Main]: SchemaManager - Upgrading to database schema to version 15 : "Add datetime_added to playlists tracks."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 15
Info [Main]: SchemaManager - Upgrading to database schema to version 16 : "Add track analysis table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 16
Info [Main]: SchemaManager - Upgrading to database schema to version 17 : "Add columns for BPM lock and a sub-version string for beats."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 17
Info [Main]: SchemaManager - Upgrading to database schema to version 18 : "Add keys column to library table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 18
Info [Main]: SchemaManager - Upgrading to database schema to version 19 : "Add key_id column to library table for caching the global key. Default to\n      INVALID."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 19
Info [Main]: SchemaManager - Upgrading to database schema to version 20 : "Crates in AutoDJ queue (for automated random-track selection)."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 20
Info [Main]: SchemaManager - Upgrading to database schema to version 21 : "Add grouping and album_artist column to library table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 21
Info [Main]: SchemaManager - Upgrading to database schema to version 22 : "Add grouping and album_artist column to itunes_library table."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 22
Info [Main]: SchemaManager - Upgrading to database schema to version 23 : "Add directories table"
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 23
Info [Main]: SchemaManager - Upgrading to database schema to version 24 : "Add cover art support. Default source is UNKNOWN and default type is NONE."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 24
Info [Main]: SchemaManager - Upgrading to database schema to version 25 : "Add full replay gain support including peak amplitude. The default\n      value for the peak amplitude is \"undefined\", represented by any\n      negative value. The internal constant for \"undefined\" is -1.0."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 25
Info [Main]: SchemaManager - Upgrading to database schema to version 26 : "Add new column \"tracktotal\" column that stores the total number of\n      tracks as a string. The total number of tracks will be reloaded\n      from the corresponding file upon first access when encountering\n      the default value."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 26
Info [Main]: SchemaManager - Upgrading to database schema to version 27 : "Add cue color support. Default color is #FF0000."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 27
Info [Main]: SchemaManager - Upgrading to database schema to version 28 : "Reset replay gain info for all FLAC files after fixing a decoding bug in version 2.1.0."
Debug [Main]: SqlTransaction - Started new SQL database transaction on "MIXXX-1"
Debug [Main]: SqlTransaction - Committed SQL database transaction on "MIXXX-1"
Info [Main]: SchemaManager - Upgraded database schema to version 28
Critical [Main]: DEBUG ASSERT: "revisionMap.contains(nextVersion)" in function SchemaManager::Result SchemaManager::upgradeToSchemaVersion(const QString&, int) at src/database/schemamanager.cpp:140
Critical [Main]: SchemaManager - Migration path for upgrading database schema from version 28 to version 29 is missing
```
mixxxbot commented 2 years ago

Commented by: uklotzde Date: 2019-06-11T16:29:46Z

Your build seems to be inconsistent and contains an old version of the database schema resources:

If this doesn't help try a complete rebuild.

mixxxbot commented 2 years ago

Commented by: jikstra Date: 2019-06-12T01:57:26Z

Okay somehow the res folder was out of sync, git reset --hard HEAD fixed that. But recompiling (scons -j 8) doesn't fix it, also not sure how to clean everything of scons as it seems to do some caching? How can I do a complete rebuild without throwing away the whole folder?

mixxxbot commented 2 years ago

Commented by: jikstra Date: 2019-06-12T02:09:28Z

Ah got it. scons --clean, tried scons -C but that does something different. Thanks!

mixxxbot commented 2 years ago

Issue closed with status Won't Fix.