Your message dated Thu, 14 Jul 2022 17:22:15 +0000 with message-id <[email protected]> and subject line Bug#1014523: fixed in strawberry 1.0.5-2 has caused the Debian Bug report #1014523, regarding strawberry: Fails to index a few songs to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 1014523: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1014523 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: strawberry Version: 1.0.5-1 Severity: normal X-Debbugs-Cc: [email protected] 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 row<br />Failed 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&M with the San Francisco Symphony, Metallica, S&M with the San Francisco Symphonyartist, 1, 1, 1999, -1, Rock, 0, , Metallica, , 0, , Metallica_id, S&M with the San Francisco Symphony_id, , 0, 150674000000, 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-double3 3.3.8-2 ii libgcc-s1 12.1.0-2 ii libgdk-pixbuf-2.0-0 2.42.8+dfsg-1 ii libglib2.0-0 2.72.2-2 ii libgnutls30 3.7.6-2 ii libgpod4 0.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 libqt5core5a 5.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 libqt5x11extras5 5.15.4-2 ii libsqlite3-0 3.38.5-1 ii libstdc++6 12.1.0-2 ii libtag1v5 1.12-1 ii libvlc5 3.0.17.4-4 ii libx11-6 2:1.7.5-1 Versions of packages strawberry recommends: ii gstreamer1.0-alsa 1.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
--- End Message ---
--- Begin Message ---Source: strawberry Source-Version: 1.0.5-2 Done: Peter Blackman <[email protected]> We believe that the bug you reported is fixed in the latest version of strawberry, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Peter Blackman <[email protected]> (supplier of updated strawberry package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Format: 1.8 Date: Thu, 14 Jul 2022 16:00:00 +0000 Source: strawberry Architecture: source Version: 1.0.5-2 Distribution: unstable Urgency: medium Maintainer: Peter Blackman <[email protected]> Changed-By: Peter Blackman <[email protected]> Closes: 1014523 Changes: strawberry (1.0.5-2) unstable; urgency=medium . * Fix msgfmt errors * Add lintian overrides * Fix for invalid ctime (Closes: #1014523) * Include import from Clementine script (needs sqlite3) Checksums-Sha1: b6b6a6e4241a9a97f9aa9bd8f68400331b04b419 2239 strawberry_1.0.5-2.dsc 665c42d31895a51f24acbbf1f9c01ffd9aa6e663 10876 strawberry_1.0.5-2.debian.tar.xz 4e71e3e9b7fbdf9c4ef91e4f958d7656f6e1e94b 9800 strawberry_1.0.5-2_source.buildinfo Checksums-Sha256: c2a25327951f03041298f78c65d32a0398fab0f7c05bd391e0f9717220aaf460 2239 strawberry_1.0.5-2.dsc 49f7643d4bfe0b9d47c5df9a2ad1d697e4722d4ac81558b80a82326ae8f6155e 10876 strawberry_1.0.5-2.debian.tar.xz c2e88e85511aa85e7e564958d525fded45083dd096c10c1b5be4b17a61912d56 9800 strawberry_1.0.5-2_source.buildinfo Files: 8eac8a3de0206a010d490e31a7b086f0 2239 sound optional strawberry_1.0.5-2.dsc 42f0c60a4525820f8bc9ef091a10d50e 10876 sound optional strawberry_1.0.5-2.debian.tar.xz 068be6e5099963904e6aa0e58c2a889b 9800 sound optional strawberry_1.0.5-2_source.buildinfo -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEd8lhnEnWos3N8v+qQoMEoXSNzHoFAmLQTIAACgkQQoMEoXSN zHrqkQ/+LXYvBAmQbNJP/oGHsNEj7aXuJUQtXQTtn/7x5vY9omiYT4EXf8Uii/WY ChTNLSsZX/Fj/worYq0Nn2dbdpWs9HOGTUt5VdJK++313XVEpoTDSry8Mjvizin4 r9oJxfuN9oB0nHzXYo/0WncTCHySQgPJLdfkBBdJvcW7cBQM5j2ym2G5GXe5+hzf aSFP1RiaG5B71+T+GWuigAhbb0eqVnXBEfWxDdthGk/u10i1VFc+48TqdDpCO4/I VigTC77IOUUgjy+p1VmvogUw2StBvAQFAi4ZSbxGH98VkRpZv0J1bBxGMeWCa4dT fpWDxMpUJ49IGzNaG7BmmxntRZmYeY7FgxuIjO+tjaaXbEH2zUNPLgxilN9ZWsXD vhd9C/xqpI6rkBpXMzG+O3q3nv6lFg0jtwtSdw4Ye4Nr+yqw3Zz/Q8LAjiq1zPK9 qa7bpqg2t0og29OIPhzq+n/833KrK7Y8ACvXoCkvTg68mWiWDGlpezHIbgl77ijT 0PYmBcJjSNXEomGNcPL0dgwmrxhL5Sdxd6ona0EiUHBWmv8jUsWOBotkvTu2qLm0 qj6r7uHjtHDYpLv4QdH3fIk6/aToA6GjIt0SMfFYwStmuZ3ALHC62lhXZZY5tfuG qfmTftvGyN1KRbn6ypskw6X8kwsyJE5YNfvmrCUwP8qYn40m7zQ= =rWDI -----END PGP SIGNATURE-----
--- End Message ---
