Subsonic / crash & recovery

[killunit]

Hi,
I've had this happen me a number of times across subsonic version over the years...
When my PC has a power cut (for example) and when PC powers back on I get an error in browser accessing subsonic.

I can recover by deleting the "db" folder, but I'm more or less starting from scratch again.
I need to add back in my users and I need to re-scan my complete library which is time consuming.

Q1: Is there a better way to recover when this happens?

Following on form the query above, when subsonic is scanning my media library it seems to have issues and stalls - for extended periods of time - sometimes minutes, other times longer like over an hour.
I can sometimes kick it back into action by stopping & restarting subsonic from the Windows Taskbar Tray Icon.
- and I then must re-initiate the media library scan.

Q2: Whilst Q1 might negate the need for an answer to this, is there some way to track down the problem media files, and fix them myself?
the subsonic.log does not have enough data for me to achieve this. Is there extended logging params that can be enabled?
- fixing my media files might resolve this.

Many thanks for any help you can supply!

Running Subsonic on:
Windows 10
Java 8 (up to date)

[G8DHE]

Why do you not restore from the db.backup folder ? Or any standard backup you take of your machine and the db folder ?

[killunit]

Fair questions.

The db.backup folder is empty!

I do not currently do a machine backup.

Have you restored subsonic from machine backups?
wondering does it work if the subsonic app is open / active from a DB corruption perspective.
as in warm backup

Jason

[killunit]

I have setup some periodical backups of the subsonic folder (recursively)
daily , weekly, monthly using "Allway Sync" app.

Hopefully these backups will make recovery easier in the future...
Thanks,
Jason

[G8DHE]

Yes I have used both methods in the past, but not that frequently! Normally just see what the dates are on the files and restore from whichever is past the last additions to the database and pre- any problems!
I'm not totally sure what the internal backup timing is on Subsonic the file subsonic.backup in the db folder is normally quite recent but very small so may only be changes, the copies in the db.backup folder on my system currently dated 20190902. However my normal backup routines keep daily changes for the last month and then 3 previous monthly images for longer term problems.