Exception when trying to do a full/normal rescan

Post your Server Bug Report
KBanause
Posts: 13
Joined: 10 Jun 2016, 11:26
Has thanked: 1 time
Been thanked: 4 times

Exception when trying to do a full/normal rescan

Unread post by KBanause »

=========================================================================================
VERSION: MADSONIC 7.0.10390.a6fd24b.20190510.0829
SERVLET: JETTY
SERVER: CPU: Intel(R) Core(TM) i5-3320M | ARCH: X64 | MEMORY: 16GB | HDD: 4TB
OS: Debian 10.6
SYSTEM: SERVER on NOTEBOOK
INSTALLER: DEB
JAVA: openjdk version "11.0.8" 2020-07-14
BROWSER: CHROME 86.0.4240.111
CLIENT: Web
DESCRIPTION: Exception when trying to do a media rescan (normal or full)
REPRODUCIBLE: YES (for me)
=========================================================================================

Hi,

when I try to do full or normal rescan of my media folders I get the following exception in the log files and the scan failed:

[2020-10-23 21:37:07,220] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [update media_file set present=false, children_last_updated=? where id between ? and ? and last_scanned != ? and present]; integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
at org.madsonic.dao.AbstractDao.update(AbstractDao.java:89)
at org.madsonic.dao.MediaFileDao.markNonPresent(MediaFileDao.java:1129)
at org.madsonic.service.MediaScannerService.doFullScanLibrary(MediaScannerService.java:391)
at org.madsonic.service.MediaScannerService.access$200(MediaScannerService.java:65)
at org.madsonic.service.MediaScannerService$4.run(MediaScannerService.java:217)
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:824)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.index.IndexAVL.insert(Unknown Source)
at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.rollbackRow(Unknown Source)
at org.hsqldb.TransactionManager2PL.rollbackPartial(Unknown Source)
at org.hsqldb.TransactionManager2PL.rollbackAction(Unknown Source)
at org.hsqldb.Session.endAction(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 13 more

[2020-10-23 21:37:07,227] ERROR MediaScannerService - ERROR PreparedStatementCallback; SQL [update media_file set present=false, children_last_updated=? where id between ? and ? and last_scanned != ? and present]; integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [update media_file set present=false, children_last_updated=? where id between ? and ? and last_scanned != ? and present]; integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
at org.madsonic.dao.AbstractDao.update(AbstractDao.java:89)
at org.madsonic.dao.MediaFileDao.markNonPresent(MediaFileDao.java:1129)
at org.madsonic.service.MediaScannerService.doFullScanLibrary(MediaScannerService.java:391)
at org.madsonic.service.MediaScannerService.access$200(MediaScannerService.java:65)
at org.madsonic.service.MediaScannerService$4.run(MediaScannerService.java:217)
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:824)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
... 8 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_PRESENT
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.index.IndexAVL.insert(Unknown Source)
at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.rollbackRow(Unknown Source)
at org.hsqldb.TransactionManager2PL.rollbackPartial(Unknown Source)
at org.hsqldb.TransactionManager2PL.rollbackAction(Unknown Source)
at org.hsqldb.Session.endAction(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 13 more

The last time I have done a rescan was in September and that rescan was successful.

Is there a way to delete all scanned media information from the database before doing the rescan?
Post Reply