Is there a maximum # of albums in the database

Need help? Post your questions here.

Moderator: moderators

Is there a maximum # of albums in the database

Postby watzupdok » Sat Aug 24, 2019 9:35 pm

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.
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby G8DHE » Sun Aug 25, 2019 10:37 am

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!
Geoff G8DHE
Version 6.0 Beta 2
G8DHE
 
Posts: 66
Joined: Sun Nov 04, 2012 4:56 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Mon Aug 26, 2019 12:12 pm

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!
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Thu Aug 29, 2019 12:59 am

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!
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby G8DHE » Thu Aug 29, 2019 10:55 am

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.
Geoff G8DHE
Version 6.0 Beta 2
G8DHE
 
Posts: 66
Joined: Sun Nov 04, 2012 4:56 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Thu Aug 29, 2019 11:40 am

Love the Touch utility but not the problem here.

Thanks anyway!
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Sun Sep 01, 2019 9:56 pm

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!
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby G8DHE » Mon Sep 02, 2019 8:25 am

Have you tried restoring the "db.backup" folder to see if you have a corrupted database ?
Geoff G8DHE
Version 6.0 Beta 2
G8DHE
 
Posts: 66
Joined: Sun Nov 04, 2012 4:56 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Mon Sep 02, 2019 5:04 pm

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.
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby G8DHE » Mon Sep 02, 2019 5:47 pm

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 ?
Geoff G8DHE
Version 6.0 Beta 2
G8DHE
 
Posts: 66
Joined: Sun Nov 04, 2012 4:56 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Mon Sep 16, 2019 1:11 pm

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.
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby watzupdok » Thu Oct 31, 2019 7:24 pm

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. :D
watzupdok
 
Posts: 9
Joined: Mon Mar 02, 2015 3:14 pm

Re: Is there a maximum # of albums in the database

Postby G8DHE » Thu Oct 31, 2019 7:27 pm

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 ;-)
Geoff G8DHE
Version 6.0 Beta 2
G8DHE
 
Posts: 66
Joined: Sun Nov 04, 2012 4:56 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 12 guests