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

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

raised upstream at

https://forum.strawberrymusicplayer.org/topic/679/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

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?

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 1014523@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Peter Blackman <peter@pblackman.plus.com> (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 ftpmaster@ftp-master.debian.org)
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 <peter@pblackman.plus.com>
Changed-By: Peter Blackman <peter@pblackman.plus.com>
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-----