Bug#1014523: strawberry: Fails to index a few songs
On 09/07/2022 10:57, Peter B wrote: Hi Alberto, If you can supply an mp3 file that causes this problem, that would really help. You could email me directly if you don't want to attach it to this bug report. Cheers, Peter Forget the above. Please just post the output of stat for the problem files. And what filesystem is used, ie EXT4?
Bug#1014523: strawberry: Fails to index a few songs
Hi Alberto, If you can supply an mp3 file that causes this problem, that would really help. You could email me directly if you don't want to attach it to this bug report. Cheers, Peter
Bug#1014523: strawberry: Fails to index a few songs
Hi Alberto, One more thought, assuming there is nothing useful so far in the database deleting the sql file ~/.local/share/strawberry/strawberry/strawberry.db and allowing strawberry to recreate it, might help Cheers, Peter
Bug#1014523: strawberry: Fails to index a few songs
raised upstream at https://forum.strawberrymusicplayer.org/topic/679/fails-to-index-a-few-songs
Bug#1014523: strawberry: Fails to index a few songs
On 07/07/2022 16:11, Alberto Fuentes wrote: Package: strawberry Version: 1.0.5-1 Severity: normal X-Debbugs-Cc: paj...@gmail.com Dear Maintainer, When i try to index my music collection i get this error Unable to execute SQL query: NOT NULL constraint failed: songs.ctime Unable to fetch rowFailed query: INSERT INTO songs (title, album, artist, albumartist, track, disc, year, originalyear, genre, compilation, composer, performer, grouping, comment, lyrics, artist_id, album_id, song_id, beginning, length, bitrate, samplerate, bitdepth, source, directory_id, url, filetype, filesize, mtime, ctime, unavailable, fingerprint, playcount, skipcount, lastplayed, lastseen, compilation_detected, compilation_on, compilation_off, compilation_effective, art_automatic, art_manual, effective_albumartist, effective_originalyear, cue_path, rating) VALUES (The Ecstacy Of Gold, S with the San Francisco Symphony, Metallica, S with the San Francisco Symphonyartist, 1, 1, 1999, -1, Rock, 0, , Metallica, , 0, , Metallica_id, S with the San Francisco Symphony_id, , 0, 15067400, 320, 44100, -1, 2, 1, file:///home/pajaro/Music/onerandomsong.mp3, 8, 6029210, 1335652082, , 0, , 0, 0, -1, 1657206086, 0_detected, 0_on, 0_off, 0_effective, , , Metallica, 1999, , -1) And the then indexing stops It happened with a few songs and i try removing them, but then another diffrent song fails `$ stats /home/pajaro/Music/onerandomsong.mp3` Give proper values for the file. I dont know what can be happening here Hi Alberto, Please state exactly what you did to experience this problem. I cannot find 'index' or 'indexing' in the menus or command line options. Did you mean a Collection Scan? There's nothing much I can do here without being able to reproduce. Please check obvious things like disc space in the home partition and invalid mp3 files. It would be interesting to know if the same problem occurs with upstream's build. https://files.strawberrymusicplayer.org/strawberry_1.0.5-bookworm_amd64.deb or Clementine which is similar https://tracker.debian.org/pkg/clementine Problems can also be reported at https://forum.strawberrymusicplayer.org/category/5/technical-help Cheers, Peter
Bug#1014523: strawberry: Fails to index a few songs
Package: strawberry Version: 1.0.5-1 Severity: normal X-Debbugs-Cc: paj...@gmail.com Dear Maintainer, When i try to index my music collection i get this error Unable to execute SQL query: NOT NULL constraint failed: songs.ctime Unable to fetch rowFailed query: INSERT INTO songs (title, album, artist, albumartist, track, disc, year, originalyear, genre, compilation, composer, performer, grouping, comment, lyrics, artist_id, album_id, song_id, beginning, length, bitrate, samplerate, bitdepth, source, directory_id, url, filetype, filesize, mtime, ctime, unavailable, fingerprint, playcount, skipcount, lastplayed, lastseen, compilation_detected, compilation_on, compilation_off, compilation_effective, art_automatic, art_manual, effective_albumartist, effective_originalyear, cue_path, rating) VALUES (The Ecstacy Of Gold, S with the San Francisco Symphony, Metallica, S with the San Francisco Symphonyartist, 1, 1, 1999, -1, Rock, 0, , Metallica, , 0, , Metallica_id, S with the San Francisco Symphony_id, , 0, 15067400, 320, 44100, -1, 2, 1, file:///home/pajaro/Music/onerandomsong.mp3, 8, 6029210, 1335652082, , 0, , 0, 0, -1, 1657206086, 0_detected, 0_on, 0_off, 0_effective, , , Metallica, 1999, , -1) And the then indexing stops It happened with a few songs and i try removing them, but then another diffrent song fails `$ stats /home/pajaro/Music/onerandomsong.mp3` Give proper values for the file. I dont know what can be happening here -- System Information: Debian Release: bookworm/sid APT prefers testing APT policy: (990, 'testing'), (500, 'unstable-debug'), (500, 'testing-debug'), (500, 'stable-updates'), (500, 'stable-security'), (500, 'unstable'), (500, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 5.18.0-2-amd64 (SMP w/4 CPU threads; PREEMPT) Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE Locale: LANG=es_ES.UTF-8, LC_CTYPE=es_ES.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages strawberry depends on: ii gstreamer1.0-plugins-base 1.20.3-2 ii gstreamer1.0-plugins-good 1.20.3-1 ii libasound2 1.2.6.1-2+b1 ii libc6 2.33-7 ii libcdio19 2.1.0-3 ii libchromaprint1 1.5.1-2+b1 ii libfftw3-double33.3.8-2 ii libgcc-s1 12.1.0-2 ii libgdk-pixbuf-2.0-0 2.42.8+dfsg-1 ii libglib2.0-02.72.2-2 ii libgnutls30 3.7.6-2 ii libgpod40.8.3-16 ii libgstreamer-plugins-base1.0-0 1.20.3-2 ii libgstreamer1.0-0 1.20.3-1 ii libmtp9 1.1.19-1 ii libprotobuf23 3.12.4-1+b3 ii libpulse0 15.0+dfsg1-4+b1 ii libqt5concurrent5 5.15.4+dfsg-3 ii libqt5core5a5.15.4+dfsg-3 ii libqt5dbus5 5.15.4+dfsg-3 ii libqt5gui5 5.15.4+dfsg-3 ii libqt5network5 5.15.4+dfsg-3 ii libqt5sql5 5.15.4+dfsg-3 ii libqt5sql5-sqlite 5.15.4+dfsg-3 ii libqt5widgets5 5.15.4+dfsg-3 ii libqt5x11extras55.15.4-2 ii libsqlite3-03.38.5-1 ii libstdc++6 12.1.0-2 ii libtag1v5 1.12-1 ii libvlc5 3.0.17.4-4 ii libx11-62:1.7.5-1 Versions of packages strawberry recommends: ii gstreamer1.0-alsa1.20.3-2 ii gstreamer1.0-pulseaudio 1.20.3-1 Versions of packages strawberry suggests: ii gstreamer1.0-plugins-bad 1.20.3-1 ii gstreamer1.0-plugins-ugly 1.20.3-1 -- no debconf information