Subsonic Forum

For a few weeks now, everytime I rip a new CD, when I then scan for new albums, none are added and the number of albums doesn't increment neither.

No.
If your going to ask technical questions helps to give us some info. like Operating System, type of file system setup given that Subsonic works on all types of machines it sure helps!

G8DHE wrote:helps to give us some info. like Operating System, type of file system setup given that Subsonic works on all types of machines it sure helps!

Will do tonight!

Thanks!

Windows 10 Professional Version 1809
My files are on QNAP NAS
and I am running Subsonic version 6.1.5 (build 759abe) (premium licence)

Now that I recall, I've ripped various CDs on June 2nd but only one appears in the database

The "about subsonic" says that I have 0 artist, 0 albums, 62,837 songs
And, the last lines of my log from last nigt auto scans are:
[8/28/19 3:07:07 AM EDT] INFO MediaScannerService Scanned media library with 69750 entries.
[8/28/19 3:07:08 AM EDT] INFO MediaScannerService Scanned media library with 70000 entries.
[8/28/19 3:07:09 AM EDT] INFO MediaScannerService Scanned media library with 70250 entries.
[8/28/19 3:07:10 AM EDT] ERROR MediaScannerService Failed to scan media library.
[8/28/19 3:07:11 AM EDT] INFO PlaylistService Starting playlist import.
[8/28/19 3:07:11 AM EDT] INFO PlaylistService Completed playlist import.
[8/28/19 8:35:00 PM EDT] INFO PlayerDao Created player 39.
[8/28/19 8:35:00 PM EDT] INFO VersionService Resolved latest Subsonic final version to: 6.1.5
[8/28/19 8:35:00 PM EDT] INFO VersionService Resolved latest Subsonic beta version to: 6.1.beta2

Hope this could help

Thanks!

You may find that Windows is not seeing/reporting file changes as its on a remote system. I've had something similar happen occasionally and have just used a file Touch utility (TouchPro - http://www.jddesign.co.uk/products/touc ... uchpro.htm) to reset dates on all files and folders and its been happy again after this.

Love the Touch utility but not the problem here.

Thanks anyway!

Just in case somebody can help me with this problem, here are the lines of the log file when the error occurs.

[2019-09-01 17:37:50,652] INFO MediaScannerService - Scanned media library with 70250 entries.
[2019-09-01 17:37:51,264] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_128 in statement [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_128 in statement [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
at net.sourceforge.subsonic.dao.AbstractDao.update(AbstractDao.java:68)
at net.sourceforge.subsonic.dao.MediaFileDao.createOrUpdateMediaFile(MediaFileDao.java:165)
at net.sourceforge.subsonic.service.MediaFileService.updateChildren(MediaFileService.java:385)
at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:183)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:219)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:161)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:31)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:130)
Caused by: java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_128 in statement [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 12 more


Thanks!

Have you tried restoring the "db.backup" folder to see if you have a corrupted database ?

G8DHE wrote:Have you tried restoring the "db.backup" folder to see if you have a corrupted database ?

Doesn't seem to be the problem neither, unless the backup was also corrupted. I received the same error at the same point of the scan.

Thanks for the idea though.

What happens if you move the tracks in that folder elsewhere, it may be the tracks themselves that are causing the problem?
Are there any non-standard characters in the file name, that has been a problem in the past as well ?

G8DHE wrote:What happens if you move the tracks in that folder elsewhere, it may be the tracks themselves that are causing the problem?
Are there any non-standard characters in the file name, that has been a problem in the past as well ?

Didn't came back sooner because I was on vacation and wasn't my priority...

About your suggestion. I tried it before you even suggest it because that was my first thought on this problem and it didn't change anything. I moved all the files from the last one that appears in the library (including it). It's weird though, if the albums aren't there anymore, how can I receive the same error... It looks like the error is in the processing of the entries (indexing or any other process), not in the adding of the files. Cant it be possible?

Thanks again for your insight.

Just in case anybody is interested by this topic. I finally solved it.

As stated before by "G8DHE", it was a corrupted database. The problem is that the backup was also corrupted. So I eras the databas and rescan everything and everythin is working fine now.

If you ever run into the same problem, be sure to make a copy of your subsonic.script file, as this file contains some SQL commands necessary to rebuild your users, media folders and other parameters .

Thanks to G8DHE for the help on this one.

Yup over several years this has bitten me a couple of times, I now keep a copy in the standard monthly backups as well just incase