SQLiteException database disk image is malformed

[KidNamedCudi 5]

I am getting this same error whenever I look at my media on any client. My TV library isn't being shown and I can't get to any episodes however my Movies library is working fine. I also have been dealing with Emby constantly crashing on me. Can someone provide some insight on the issue and what steps I can take to resolution it would be very helpful! I attached the logs containing the exact error.

 

More information on my setup

 

 

 

server-63609217787.txt

Edited September 12, 2016 by KidNamedCudi

[Luke 42081]

Somehow your users database has become corrupted. That could have been due to a power failure, disk failure, other hardware failure, or any other number of reasons. You're going to have to delete the file

C:\Users\Server\AppData\Roaming\Emby-Server\\data\users.db

But unfortunately this will also mean starting with an empty user database.

[KidNamedCudi 5]

Awesome that fixed the issue. Would this also be what was causing the server to crash as well?

 

Probably should invest in a battery back up. We have been having some wicked storms recently.

[Luke 42081]

Yes this could definitely cause crashes

[KidNamedCudi 5]

So I got some new RAM in my box so I am hoping that solves my crashing issue. However, I think some crashes before I updated the RAM caused some more Malformed Disk Image errors. Can you let me know what I need to do to resolve these? I assume its deleting another db file just unsure which one(s).

[Happy2Play 9782]

You will need to post another/current log.

[KidNamedCudi 5]

Is there a way to attach a file in a reply? I am not seeing any options.

 

Here is a snippet of the log 

2016-09-15 08:53:11.9038 Info HttpClient: HttpClientManager GET: https://connect.emby.media/service/ServerAuthorizations?serverId=0888a89aed522b1b9d10962a5c543186
2016-09-15 08:54:05.5189 Info TaskManager: IntervalTrigger fired for task: Download missing subtitles
2016-09-15 08:54:05.5189 Info TaskManager: Queueing task SubtitleScheduledTask
2016-09-15 08:54:05.5189 Info TaskManager: Executing Download missing subtitles
2016-09-15 08:54:05.5189 Info TaskManager: IntervalTrigger fired for task: Convert media
2016-09-15 08:54:05.5189 Info TaskManager: Queueing task SyncConvertScheduledTask
2016-09-15 08:54:05.5539 Info TaskManager: IntervalTrigger fired for task: Organize new media files
2016-09-15 08:54:05.5539 Info TaskManager: Queueing task OrganizerScheduledTask
2016-09-15 08:54:08.4059 Error TaskManager: Error
	*** Error Report ***
	Version: 3.0.7100.0
	Command line: C:\Users\Server\AppData\Roaming\Emby-Server\System\MediaBrowser.ServerApplication.exe
	Operating system: Microsoft Windows NT 6.1.7601 Service Pack 1
	Processor count: 8
	64-Bit OS: True
	64-Bit Process: True
	Program data path: C:\Users\Server\AppData\Roaming\Emby-Server
	Application Path: C:\Users\Server\AppData\Roaming\Emby-Server\System\MediaBrowser.ServerApplication.exe
	database disk image is malformed
	database disk image is malformed
	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.Read()
	   at MediaBrowser.Server.Implementations.Persistence.SqliteItemRepository.GetItemList(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.AddChildrenToList(Dictionary`2 result, Boolean includeLinkedChildren, Boolean recursive, Func`2 filter)
	   at MediaBrowser.Controller.Entities.Folder.AddChildrenToList(Dictionary`2 result, Boolean includeLinkedChildren, Boolean recursive, Func`2 filter)
	   at MediaBrowser.Controller.Entities.Folder.GetRecursiveChildren(Func`2 filter, Boolean includeLinkedChildren)
	   at MediaBrowser.Providers.MediaInfo.SubtitleScheduledTask.<Execute>d__3.MoveNext()
	--- End of stack trace from previous location where exception was thrown ---
	   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
	   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
	   at MediaBrowser.Common.Implementations.ScheduledTasks.ScheduledTaskWorker.<ExecuteInternal>d__b.MoveNext()

[Happy2Play 9782]

 

Is there a way to attach a file in a reply? I am not seeing any options.

 

Just click the "More Reply Options" at the bottom.

[KidNamedCudi 5]

Gotcha thanks. I attached them.

server-63609560528.txt

[Happy2Play 9782]

Don't see "database disk image is malformed" in that attached log.

[Happy2Play 9782]

But from the image above "Library Scan" failed it would point to your Library.db.

[KidNamedCudi 5]

Sorry thought that one had a recent one. Here is one.

server-63609526381.txt

[Happy2Play 9782]

To me it points to your library.db.

[KidNamedCudi 5]

Just rename it and refresh my library and we should be good?

[Happy2Play 9782]

Yep rename or delete.  A library scan will rebuild it.