Duplicate record written to SongDiff table, looks like related to renaming file to duplicate

Description

15/09/2020 06.55.53:AEST:SongSave:handleFailedSaveErrors:SEVERE: Unable to save changes:E:\Jukebox Music\Persona Non Grata\Our Shade Of Sin (1)\Persona Non Grata - Our Shade Of Sin - 01 - The Heirs (Part 1).mp3 could not execute statement
org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
at org.hibernate.engine.spi.ActionQueue.executeInserts(ActionQueue.java:337)
at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:176)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at com.jthink.songkong.db.SongChangesCache.saveChangesMade(SongChangesCache.java:37)
at com.jthink.songkong.analyse.analyser.SongSave.call(SongSave.java:170)
at com.jthink.songkong.analyse.analyser.SongSaver.saveSongsToFile(SongSaver.java:465)
at com.jthink.songkong.analyse.analyser.SongSaver.saveChanges(SongSaver.java:230)
at com.jthink.songkong.analyse.analyser.SongSaver.call(SongSaver.java:204)
at com.jthink.songkong.analyse.analyser.SongSaver.call(SongSaver.java:51)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.DiscogsUpdateSongGroup.call(DiscogsUpdateSongGroup.java:148)
at com.jthink.songkong.analyse.analyser.DiscogsUpdateSongGroup.call(DiscogsUpdateSongGroup.java:28)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongMatcher.call(MusicBrainzSongMatcher.java:106)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongMatcher.call(MusicBrainzSongMatcher.java:35)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.DiscogsSongGroupMatcher.call(DiscogsSongGroupMatcher.java:87)
at com.jthink.songkong.analyse.analyser.DiscogsSongGroupMatcher.call(DiscogsSongGroupMatcher.java:27)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.processMetadataFailedToMatch(MusicBrainzMetadataMatcher.java:92)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.call(MusicBrainzMetadataMatcher.java:386)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.call(MusicBrainzMetadataMatcher.java:35)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.processUnmatched(MusicBrainzSongGroupMatcher3.java:183)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.doTask(MusicBrainzSongGroupMatcher3.java:91)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.call(MusicBrainzSongGroupMatcher.java:473)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.call(MusicBrainzSongGroupMatcher3.java:106)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.call(MusicBrainzSongGroupMatcher3.java:20)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.submitSetOfSongsAsNewSongGroup(MusicBrainzSongGroupMatcher.java:192)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.processFoldersContainingDuplicateSongs(MusicBrainzSongGroupMatcher.java:231)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.processUnmatched(MusicBrainzSongGroupMatcher1.java:108)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.doTask(MusicBrainzSongGroupMatcher1.java:451)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.call(MusicBrainzSongGroupMatcher.java:473)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.call(MusicBrainzSongGroupMatcher1.java:84)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.call(MusicBrainzSongGroupMatcher1.java:37)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
at java.base/java.lang.Thread.run(Thread.java:832)
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.SONGDIFF(RECNO) [1573, CAST(REPEAT('00', 5370) AS BINARY /* table: 70 id: 6112 */)]"; SQL statement:
insert into SongDiff (diff, recNo) values (?, ?) [23505-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:131)
at org.h2.mvstore.db.MVTable.addRow(MVTable.java:546)
at org.h2.command.dml.Insert.insertRows(Insert.java:180)
at org.h2.command.dml.Insert.update(Insert.java:132)
at org.h2.command.CommandContainer.update(CommandContainer.java:133)
at org.h2.command.Command.executeUpdate(Command.java:267)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:200)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:154)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 87 more
15/09/2020 06.55.53:AEST:Errors:addError:SEVERE: Adding Error:Unable to save changes: E:\Jukebox Music\Persona Non Grata\Our Shade Of Sin (1)\Persona Non Grata - Our Shade Of Sin - 01 - The Heirs (Part 1).mp3 could not execute statement
java.lang.Exception
at com.jthink.songkong.analyse.general.Errors.addError(Errors.java:28)
at com.jthink.songkong.analyse.analyser.SongSave.handleFailedSaveErrors(SongSave.java:420)
at com.jthink.songkong.analyse.analyser.SongSave.call(SongSave.java:221)
at com.jthink.songkong.analyse.analyser.SongSaver.saveSongsToFile(SongSaver.java:465)
at com.jthink.songkong.analyse.analyser.SongSaver.saveChanges(SongSaver.java:230)
at com.jthink.songkong.analyse.analyser.SongSaver.call(SongSaver.java:204)
at com.jthink.songkong.analyse.analyser.SongSaver.call(SongSaver.java:51)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.DiscogsUpdateSongGroup.call(DiscogsUpdateSongGroup.java:148)
at com.jthink.songkong.analyse.analyser.DiscogsUpdateSongGroup.call(DiscogsUpdateSongGroup.java:28)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongMatcher.call(MusicBrainzSongMatcher.java:106)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongMatcher.call(MusicBrainzSongMatcher.java:35)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.DiscogsSongGroupMatcher.call(DiscogsSongGroupMatcher.java:87)
at com.jthink.songkong.analyse.analyser.DiscogsSongGroupMatcher.call(DiscogsSongGroupMatcher.java:27)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.processMetadataFailedToMatch(MusicBrainzMetadataMatcher.java:92)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.call(MusicBrainzMetadataMatcher.java:386)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.call(MusicBrainzMetadataMatcher.java:35)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.processUnmatched(MusicBrainzSongGroupMatcher3.java:183)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.doTask(MusicBrainzSongGroupMatcher3.java:91)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.call(MusicBrainzSongGroupMatcher.java:473)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.call(MusicBrainzSongGroupMatcher3.java:106)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.call(MusicBrainzSongGroupMatcher3.java:20)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.submitSetOfSongsAsNewSongGroup(MusicBrainzSongGroupMatcher.java:192)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.processFoldersContainingDuplicateSongs(MusicBrainzSongGroupMatcher.java:231)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.processUnmatched(MusicBrainzSongGroupMatcher1.java:108)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.doTask(MusicBrainzSongGroupMatcher1.java:451)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.call(MusicBrainzSongGroupMatcher.java:473)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.call(MusicBrainzSongGroupMatcher1.java:84)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher1.call(MusicBrainzSongGroupMatcher1.java:37)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
at java.base/java.lang.Thread.run(Thread.java:832)
15/09/2020 06.55.53:AEST:FileRenamer:renameFilenameBasedOnMetadata:WARNING: New SubFolder/Filename Path is(1):Persona Non Grata\Our Shade Of Sin\Persona Non Grata - Our Shade Of Sin - 02 - The Heirs (Part 2).mp3
15/09/2020 06.55.53:AEST:SongSave:handleFailedSaveErrors:SEVERE: Unable to save changes:E:\Jukebox Music\Persona Non Grata\Our Shade Of Sin\Persona Non Grata - Our Shade Of Sin - 02 - The Heirs (Part 2).mp3 could not execute statement
org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
at org.hibernate.engine.spi.ActionQueue.executeInserts(ActionQueue.java:337)
at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:176)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at com.jthink.songkong.db.SongProcessedCache.save(SongProcessedCache.java:33)
at com.jthink.songkong.analyse.analyser.SongSave.call(SongSave.java:131)
at com.jthink.songkong.analyse.analyser.SongSaver.saveSongsToFile(SongSaver.java:465)
at com.jthink.songkong.analyse.analyser.SongSaver.saveChanges(SongSaver.java:230)
at com.jthink.songkong.analyse.analyser.SongSaver.call(SongSaver.java:204)
at com.jthink.songkong.analyse.analyser.SongSaver.call(SongSaver.java:51)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.DiscogsUpdateSongGroup.call(DiscogsUpdateSongGroup.java:148)
at com.jthink.songkong.analyse.analyser.DiscogsUpdateSongGroup.call(DiscogsUpdateSongGroup.java:28)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongMatcher.call(MusicBrainzSongMatcher.java:106)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongMatcher.call(MusicBrainzSongMatcher.java:35)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.DiscogsSongGroupMatcher.call(DiscogsSongGroupMatcher.java:87)
at com.jthink.songkong.analyse.analyser.DiscogsSongGroupMatcher.call(DiscogsSongGroupMatcher.java:27)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.processMetadataFailedToMatch(MusicBrainzMetadataMatcher.java:92)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.call(MusicBrainzMetadataMatcher.java:386)
at com.jthink.songkong.analyse.analyser.MusicBrainzMetadataMatcher.call(MusicBrainzMetadataMatcher.java:35)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at com.jthink.songkong.analyse.analyser.MainAnalyserService$EnsureIncreaseCountIfRunOnCallingThread.rejectedExecution(MainAnalyserService.java:101)
at java.base/java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:827)
at java.base/java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1357)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at com.jthink.songkong.analyse.analyser.MainAnalyserService.submit(MainAnalyserService.java:123)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.processUnmatched(MusicBrainzSongGroupMatcher3.java:183)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher3.doTask(MusicBrainzSongGroupMatcher3.java:91)
at com.jthink.songkong.analyse.analyser.MusicBrainzSongGroupMatcher.call(MusicBrainzSongGroupMatcher.java:473)

Activity

Show:
IJabz
September 15, 2020, 5:09 PM

Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.SONGDIFF(RECNO) [1573, CAST(REPEAT('00', 5370) AS BINARY /* table: 70 id: 6112 */)]"; SQL statement:
insert into SongDiff (diff, recNo) values (?, ?) [23505-199]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:131)
at org.h2.mvstore.db.MVTable.addRow(MVTable.java:546)
at org.h2.command.dml.Insert.insertRows(Insert.java:180)
at org.h2.command.dml.Insert.update(Insert.java:132)
at org.h2.command.CommandContainer.update(CommandContainer.java:133)
at org.h2.command.Command.executeUpdate(Command.java:267)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:200)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:154)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 87 more

IJabz
September 15, 2020, 5:20 PM
Edited

It either due to renaming files, or due to having duplicates of the file possibly duplicated internally at usad stage)

IJabz
October 28, 2020, 3:49 PM

Fixed, now protect against this happening by chekcing for songs that have already been processed at song save time.

Fixed

Reporter

IJabz

Labels

None

Forum Username

SKain

os

None

Components

Fix versions

Affects versions

Priority

Major
Configure