SQLitePCL.pretty.SQLiteException error

[dsal 1]

I found a thread on this error from January, but I thought I would start a new thread since the issue may not be the same.  I normally run Emby as a service, but the service has started eating all the memory on my server, so I switched over to running it at startup instead.  That worked initially, but after a recent reboot, Emby is throwing an exception on startup.  I'll attach the log, but I am getting the same I/O error mentioned in the previous thread.  I've run a scan on my drive and I don't have any errors, and everything else is running fine on this server.  Any ideas on what I can try to get Emby starting again?  I did reboot the server, but that did not solve the issue.  Log attached.

 

Thanks.

server-63640919312.txt

[Luke 42083]

hi @@dsal, make sure your drive isn't out of space. You can try going here and renaming the file:

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

Then start up the server. This may resolve it but unfortunately your users will be wiped out. Have you been backing them up?

 

This error generally will happen due to any of the following:

• hard drive failure
• drive out of space
• database file corrupted due to abruptly terminating the server process, e.g. due to power loss or entire machine crashing

Let us know if this helps. Thanks.

[dsal 1]

Hard drive is not failing and it is a raid 1 FYI.  drive has plenty of of space (600gb).  renamed the old users.db and started it back up - a new users.db file was created but remained 0 bytes in size.  Any chance this could be a permissions issue?

[Happy2Play 9783]

Can you post another log.

[dsal 1]

This log was with a missing users.db file.

server-63640927645.txt

[Happy2Play 9783]

Not sure as that is the exact same error.  Is this the post you referenced before?

 

Probably not as it is a different OS.

Edited September 13, 2017 by Happy2Play

[dsal 1]

Yes - the logs look the same.  So not sure what to make of that - but I just made that one fresh with no users.db and I witnessed the file being created - so I don't think it's an error on my part of posting the wrong log.  Here's the post I was looking at earlier:

 

https://emby.media/community/index.php?/topic/43228-sqlitepclprettysqliteexception-error/

[Happy2Play 9783]

Don't know if it will make a difference but have tried restarting everything?

[dsal 1]

I can't restart this server right now, as it is in production for some other services.  But I have restarted it three times in the past several days without getting past this error.  I'll try uninstalling and reinstalling emby server and see if that helps.

[dsal 1]

I uninstalled it and got a couple of errors.  It could not remove bdinfo.dll, and then failed on fanart.json (access denied), and then on activity.db (access denied).  Uninstall completed.  Reran setup and now it's working again.  I'll post back here if it fails after a reboot (which is what happened last time).  My user database was intact FYI.

[Happy2Play 9783]

I can't restart this server right now, as it is in production for some other services.  But I have restarted it three times in the past several days without getting past this error.  I'll try uninstalling and reinstalling emby server and see if that helps.

 

I guess in theory it is a issue on the Windows machine as that is where Emby is installed and all the databases reside.

 

I guess you could test removing the current data folder and restarting server to see if they rebuild.  If they do then you know something in that folder is causing the issue.

[Happy2Play 9783]

I uninstalled it and got a couple of errors.  It could not remove bdinfo.dll, and then failed on fanart.json (access denied), and then on activity.db (access denied).  Uninstall completed.  Reran setup and now it's working again.  I'll post back here if it fails after a reboot (which is what happened last time).  My user database was intact FYI.

 

That is fairly common as some things tend to hang of some system.  That is why updates sometimes fail on some system.

 

But glad it is working again.

Edited September 14, 2017 by Happy2Play

[Luke 42083]

I know you said you ran a hard drive scan but the fact that it's not working one minute then working again sounds like a random I/O failure to me.

[dsal 1]

It was consistent.  Wouldn't work no matter how many times I started it, and then after uninstalling/reinstalling, it worked.  I doubt it was a random i/o failure.