Scan Media Library failing for days @ about 50%

[cmcv 3]

Hi my library scan has been failing for days & I cant work out why.

 

It only says the below.... I am also unsure how to add the log file from the help - log section

 

 

1-10 of 2199

 

Scan media library failed.

7 minutes ago

unknown error No transaction is active on this connection

Scan media library failed.

2 hours ago

unknown error No transaction is active on this connection

Scan media library failed.

8 hours ago

unknown error No transaction is active on this connection

Scan media library failed.

20 hours ago

unknown error No transaction is active on this connection

Scan media library failed.

a day ago

unknown error No transaction is active on this connection

Scan media library failed.

a day ago

unknown error No transaction is active on this connection

Scan media library failed.

2 days ago

unknown error No transaction is active on this connection

Scan media library failed.

2 days ago

unknown error No transaction is active on this connection

Scan media library failed.

3 days ago

unknown error No transaction is active on this connection

Scan media library failed.

3 days ago

unknown error No transaction is active on this connection

[Luke 37395]

Hi, instructions on posting log files can be found here:

 

http://emby.media/community/index.php?/topic/739-how-to-report-a-problem/

 

Thanks.

[cmcv 3]

Hi Luke

 

This is the log file.server-63587024115.txt

[Luke 37395]

2015-12-29 23:51:01.1133 Error SqliteProviderInfoRepository: Failed to save provider info:
*** Error Report ***
Version: 3.0.5800.1
Command line: C:\Users\Chris Acer Pc\AppData\Roaming\MediaBrowser-Server\System\MediaBrowser.ServerApplication.exe
Operating system: Microsoft Windows NT 6.1.7601 Service Pack 1
Processor count: 4
64-Bit OS: False
64-Bit Process: False
Program data path: C:\Users\Chris Acer Pc\AppData\Roaming\MediaBrowser-Server
Application Path: C:\Users\Chris Acer Pc\AppData\Roaming\MediaBrowser-Server\System\MediaBrowser.ServerApplication.exe
disk I/O error
disk I/O error
System.Data.SQLite.SQLiteException
  at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
  at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
  at System.Data.SQLite.SQLiteDataReader.NextResult()
  at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
  at MediaBrowser.Server.Implementations.Persistence.SqliteProviderInfoRepository.<SaveMetadataStatus>d__8.MoveNext()

Of particular interest is

disk I/O error
disk I/O error

You might want to run windows chkdsk to try and scan for disk errors.

[cmcv 3]

Hi Luke.

Thanks on a second go it has found errors in a bad cluster & is replacing them. Hopefully this fixes it, I will let you know.

 

Scan media library failed.

9 minutes ago

database disk image is malformed database disk image is malformed

 

 

going to try on a different drive & see how it goes.

Edited December 30, 2015 by cmcv

[revengineer 128]

I think I have resolved this in the past by deleting the library.db file in the data folder and then rescanning. To be on the safe side, you can rename the file rather than deleting it.

[theniteow1 25]

 

Hi Luke.

 

Thanks on a second go it has found errors in a bad cluster & is replacing them. Hopefully this fixes it, I will let you know.

 

Scan media library failed.

9 minutes ago

database disk image is malformed database disk image is malformed

 

 

going to try on a different drive & see how it goes.

 

 

Bad sectors can be a sign of imminent drive failure.  I'd recommend backing up your files immediately, and possibly looking at drive replacement.  Don't want to loose all your hard work you have put into your media collection.

[revengineer 128]

Bad sectors can be a sign of imminent drive failure.  I'd recommend backing up your files immediately, and possibly looking at drive replacement.  Don't want to loose all your hard work you have put into your media collection.

Not necessarily. I have had a number of drives that worked stably for a long time with a few bad sectors. I do agree that a backup of the media library is advised. It seems that chkdsk fixed his immediate errors. Now he is left with a corrupt database file. The only way I have found to correct this issue is to delete the library.db files and recreate it with a rescan.

[Happy2Play 8448]

Not necessarily. I have had a number of drives that worked stably for a long time with a few bad sectors. I do agree that a backup of the media library is advised. It seems that chkdsk fixed his immediate errors. Now he is left with a corrupt database file. The only way I have found to correct this issue is to delete the library.db files and recreate it with a rescan.

There are several topics on Malformed database errors and it is not always the library.db.