FAQ  •  Register  •  Login

Problem with library after deleting some physical files

<<

ehrepli

Serviio newbie

Posts: 16

Joined: Fri Mar 30, 2012 10:21 pm

Location: France

Post Mon Jan 12, 2015 7:18 pm

Problem with library after deleting some physical files

Hi

Since a few weeks ago, Serviio does not seem to update the library whenever I delete some physical files. Adding works fine, but removing does not. Even if I move the file to a different folder, the library will show the new one within minutes, but the old one will still show (of course when you try to play it, it's not found).

I see this error in the log when I force refresh but i don't know if it will be related.

  Code:
2015-01-12 20:07:18,364 DEBUG [ActionsServerResource] Action with name 'forceLibraryRefresh' was requested
2015-01-12 20:07:18,382 WARN  [LibraryAdditionsCheckerThread] An error occured while scanning for item to be added, will continue
org.serviio.db.dao.PersistenceException: Cannot mark Repository with id 3 as scanned
        at org.serviio.library.dao.RepositoryDAOImpl.markRepositoryAsScanned(RepositoryDAOImpl.java:173)
        at org.serviio.library.local.service.RepositoryService.markRepositoryAsScanned(RepositoryService.java:114)
        at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:84)
Caused by: java.sql.SQLNonTransientConnectionException: Connection closed by unknown interrupt.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
        at org.serviio.library.dao.RepositoryDAOImpl.markRepositoryAsScanned(RepositoryDAOImpl.java:171)
        ... 2 more
Caused by: java.sql.SQLException: Connection closed by unknown interrupt.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 13 more
Caused by: ERROR 08000: Connection closed by unknown interrupt.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at org.apache.derby.iapi.util.InterruptStatus.setInterrupted(Unknown Source)
        at org.apache.derby.iapi.util.InterruptStatus.throwIf(Unknown Source)
        at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.checkCancellationFlag(Unknown Source)
        at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown Source)
        at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source)
        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
        at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
        at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
        at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source)
        at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
        at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Mon Jan 12, 2015 8:34 pm

Re: Problem with library after deleting some physical files

Delete normally takes about 1 hour to be done in the database
<<

ehrepli

Serviio newbie

Posts: 16

Joined: Fri Mar 30, 2012 10:21 pm

Location: France

Post Mon Jan 12, 2015 9:55 pm

Re: Problem with library after deleting some physical files

Some of the files are still there after days, I can't figure out why.

I've renamed the folder from where i've removed some files and seems to have triggered a rescan and now looks ok.
I will delete some more files later to see if it updates ok now.
<<

ehrepli

Serviio newbie

Posts: 16

Joined: Fri Mar 30, 2012 10:21 pm

Location: France

Post Wed Jan 28, 2015 9:47 pm

Re: Problem with library after deleting some physical files

Well, I'm still having this issue, removed files stay in the library for ever. I don't know how to make them go away.
<<

zip

User avatar

Serviio developer / Site Admin

Posts: 17215

Joined: Sat Oct 24, 2009 12:24 pm

Location: London, UK

Post Wed Jan 28, 2015 10:25 pm

Re: Problem with library after deleting some physical files

Are you using 1.5? Did you try Force refresh?
<<

ehrepli

Serviio newbie

Posts: 16

Joined: Fri Mar 30, 2012 10:21 pm

Location: France

Post Wed Feb 04, 2015 8:44 am

Re: Problem with library after deleting some physical files

I'm using 1.4.1.2 and I've tried Force Refresh to no avail.
I don't get an update notification, I didn't know there was a 1.5 available, will look for it and update.
<<

ehrepli

Serviio newbie

Posts: 16

Joined: Fri Mar 30, 2012 10:21 pm

Location: France

Post Wed Feb 04, 2015 9:25 pm

Re: Problem with library after deleting some physical files

Ok, after the update, 1.5 seems to delete files from the library correctly.

Thanks!!

Return to Serviio Support & Help

Who is online

Users browsing this forum: No registered users and 6 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.