crash with fresh install (QSqlError 13)

Asked by daniel

Hi.
I have an instant crash here while trying to start mixxx 1.12-alpha (git master r4501)

archlinux_64 T64

[Ihr Datenbankschema konnte nicht auf Version 23 aktualisiert werden
Ihre Datei mixxxdb.sqlite ist möglicherweise beschädigt.
Versuchen Sie die Datei umzubenennen und Mixxx erneut zu starten.

Zum Beenden OK drücken.]

-> % mixxx
Debug [Main]: Mixxx "1.12.0-alpha" "(git master r4501; built on: Jul 2 2014 @ 22:45:50; flags: autodjcrates bulk hid mad optimize=4 qdebug shoutcast tuned vamp verbose vinylcontrol)" is starting...
Debug [Main]: Qt version is: 4.8.6
Debug [Main]: QDesktopServices::storageLocation(HomeLocation): "/home/daniel"
Debug [Main]: QDesktopServices::storageLocation(DataLocation): "/home/daniel/.local/share/data//Mixxx"
Debug [Main]: QCoreApplication::applicationDirPath() "/usr/bin"
Debug [Main]: ConfigObject: Could not read "/home/daniel/.mixxx/mixxx.cfg"
Debug [Main]: No version number in configuration file. Setting to 1.12.0-alpha
Debug [Main]: ConfigObject: Could not read "/home/daniel/.mixxx/sandbox.cfg"
Debug [Main]: Loading translations for locale "de_DE" from translations folder "/usr/share/mixxx/translations/" : success
Debug [Main]: Compressor attack per frame: 0.000408163 decay per frame: 4.08163e-05
Debug [Main]: PortAudio version: 1899 text: PortAudio V19-devel (built Jan 31 2014 21:19:35)
Debug [Main]: JACK client name set
ALSA lib pcm.c:2239:(snd_pcm_open_noupdate) Unknown PCM cards.pcm.rear
ALSA lib pcm.c:2239:(snd_pcm_open_noupdate) Unknown PCM cards.pcm.center_lfe
ALSA lib pcm.c:2239:(snd_pcm_open_noupdate) Unknown PCM cards.pcm.side
ALSA lib pcm_route.c:947:(find_matching_chmap) Found no matching channel map
ALSA lib pcm_route.c:947:(find_matching_chmap) Found no matching channel map
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]: RubberBand version 1.8.1
Debug [Main]: WARNING: AudioInput already registered!
Debug [Main]: RubberBand version 1.8.1
Debug [Main]: WARNING: AudioInput already registered!
Debug [Main]: RubberBand version 1.8.1
Debug [Main]: RubberBand version 1.8.1
Debug [Main]: RubberBand version 1.8.1
Debug [Main]: RubberBand version 1.8.1
Debug [Main]: RubberBand version 1.8.1
Debug [Main]: Available QtSQL drivers: ("QSQLITE", "QSQLITE3", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
Debug [Main]: DB status: "/home/daniel/.mixxx/mixxxdb.sqlite" = true
Debug [Main]: SchemaManager::upgradeToSchemaVersion upgrading 23 versions to version 23
Debug [Main]: Loading schema "/usr/share/mixxx/schema.xml"
Debug [Main]: Applying version 1 : "The base schema for the Mixxx SQLITE database."
Debug [Main]: SettingsDAO::setValue() failed "mixxx.schema.version" : QVariant(int, 1) QSqlError(13, "Der Datensatz konnte nicht abgeholt werden", "database or disk is full")
Debug [Main]: SettingsDAO::setValue() failed "mixxx.schema.min_compatible_version" : QVariant(QString, "1") QSqlError(13, "Der Datensatz konnte nicht abgeholt werden", "database or disk is full")
Debug [Main]: Committing transaction on "qt_sql_default_connection" result: true
Debug [Main]: Applying version 2 : "Add a header_parsed integer column to the library to indicate when a
      track's tags have been parsed."
Debug [Main]: SettingsDAO::setValue() failed "mixxx.schema.min_compatible_version" : QVariant(QString, "2") QSqlError(13, "Der Datensatz konnte nicht abgeholt werden", "database or disk is full")
Debug [Main]: Committing transaction on "qt_sql_default_connection" result: true
Debug [Main]: Applying version 3 : "Change the location column to be a an integer. Change comment to be
      varchar(256) and album/artist/title to be varchar(64)."
Debug [Main]: Failed query: "DROP TABLE library_old" QSqlError(13, "Der Datensatz konnte nicht abgeholt werden", "database or disk is full")
Debug [Main]: Failed to move from version 2 to version 3
Debug [Main]: Rolling back transaction on "qt_sql_default_connection" result: true

Question information

Language:
English Edit question
Status:
Answered
For:
Mixxx Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
daniel (mail-daniel) said :
#1

yeah, it's no bug.

after searching for that specific Sql-Error i found the solution:

/var is full

after cleaning all went smooth.
So a question: Is it possible to make that Error Message more…well, different? ;)

Revision history for this message
Daniel Schürmann (daschuer) said :
#2

I am glad the error is fixed now.

You are welcome to propose a patch or a pull request at gitHub.
http://www.mixxx.org/wiki/doku.php/bugfix_workflow

https://github.com/mixxxdj/mixxx/blob/4c9cda48faa28512408a90cfb51cb487787f7c49/src/library/trackcollection.cpp#L91
https://github.com/mixxxdj/mixxx/blob/4845e95acb542120191f309e050d785699730048/src/library/schemamanager.cpp#L117

We may handle this individual:
Debug [Main]: Failed query: "DROP TABLE library_old" QSqlError(13, "Der Datensatz konnte nicht abgeholt werden", "database or disk is full")

Thank you in advanced

Daniel

Can you help with this problem?

Provide an answer of your own, or ask daniel for more information if necessary.

To post a message you must log in.