Contstantly Corrupt Database Messages - So Frustrating

Hi All,

I thought I would vent my frustration here in the hope of some workable solutions.

What is up with EP corrupting databases and needing to reformat the drive? Here is my latest scenario…yes I have had this many times now and thought I had created the workflows to prevent.

I have not linked my Prime 4 with internal 1TB SSD (Formatted to EXFAT) to my computer for a while. It has been playing fine (Still does in fact). Today I wanted to load up a few crates that I have been working on. Started EP analysed the Serato Cretes and as this was happening I get the message that the Prime 4 Drive is corrupt and needs rebuilding…NO WAY I thought. I have not ejected incorrectly and only recently rebuilt after the last time (Yes I now have a second copy of the database on my PC for safety).

I ejected the drive and the P4 loaded back up with the database…working and playing music???

I ran Chkdsk and it did find a couple of errors and said it fixed them. I went back into EP. Like other times it was fine for a bit and then…“Your database is corrupt and needs rebuilding or formatting”. WHY???

More to the point why is it so easy for this to happen? This is a mission critical element and should be prioritized to make as robust as possible so we can rely on it.

I have read as many posts on this as I can handle so clearly is an issue for many…WHY? The normal response seems to be “yes the drive may look idle but may be caching and this caused the error” (or similar) - Well I did not eject improperly and it was idle…it just reported it corrupt?

I love my P4 and wanted the standalone capability, but am now seriously thinking I should have stuck with Serato (which I also love) as I have not ever had these errors and is far more user friendly in library management…not to mention beat grid management and cue imports from MIK etc.

Dennon seriously need to step up and offer endorsed workflow solutions and recovery options built in. I have a full time job and this is a hobby and side hustle…But if it were my bread and butter I don’t think I could trust it. I woudl appreciate some comments on this as I know I am not alone and frankly the 2 hours it will take to format and rebuild is just not on - and its estimated 2 hours as I got burnt already and have another copy…the first time took me many more hours.

Anyhow, rant over and I look forward to the replies and suggestions so we can expand on this together and get some real workable solutions that are practical in the field as I have NEVER experienced such corruption of drives in all my years of PC ownership (which are many).

1 Like

There’s this feature request for an anti-corruption update https://denondjforum.com/t/automatically-use-backup-database-auto-repair/21703? Adding likes to it might make denon forget about it slightly slower than an unliked suggestion.

If you vote for it now, denon might include it in firmware in 2023. It’s too late for me, I’ve sold off both my prime SC5000s and prime x1800. I lost trust in the Coming Soon some time ago and More recently I’ve lost trust in the Just Around The Corner timescale too. It’s like the mate you leant half a’onths wages to, 3 years ago and every week he says he’ll definitely pay you back in a month. Three years on you just give up totally on ever seeing a buck of it ever again and you just stop asking cos you know what they’re going to say.

I’ve not suffered from a corrupt database and that’s with over 100 paid gigs every year and I owned primes for 3 years. Some defining points or maybe completely nothing to do with its:

I didn’t use many crates - I had a massive crate (135 thousand tracks) called main library, then I had monthly top up crates called “April 2020” or “May 2020” and so on.

I didn’t use playlists - I just thought about what I wanted to play , live on the night

I didn’t fudge about with my files. Any music I added went into new crates (“May 2020”) I never added new songs to old crates. Once a file or folder was saved in a particular place, it stayed forever in that particular place. I didn’t let my Prime drives get touched by any other DJ software or editor software, only windows and engine prime

I never used shop bought external hard drives - I bought external casings and choose an internal hard drive carefully - ones with huge write caches specifically.

I set windows settings for the external drive to be “Safe but slow” rather than “Faster but you damn well better remember to eject usb safely or your data is history” mode

I don’t know if any of the above M.O. helped avoid corrupt database messages or not.

1 Like

Thanks for that shared frustration…I have liked the suggested feature request (here’s hoping).

How can they not address this?

Database integrity is critically important to operation of the hardware…not to mention a massive drain on time.

I guess for now I will format AGAIN and rebuild…Grrrrr

This issue seems to be reported more commonly with the Prime 4 built in storage.

I have not had the same problem with the Sc5000m and I use a 4TB SSD and a 500gb SSD.

Perhaps you want to abandon the internal bay and just stick that drive in a nice casing and use like that.

To be honest, to me the internal ssd feature in the Prime4 is more hassle than anything.

I don’t see the pros only cons. Such as the one you are having.

In the same way they haven’t addressed the other issues. The addressing solution will be coming soon and just around the corner - forever. It’s Denons seamless loop of side-stepping the answers. Which is why I sold my prime set up. Trust lost

I must say, I’ve never had a corrupt Engine Prime database. SQLlite may not be very robust, but that’s my personal take on this.

And yes, it can be very frustrating, of course. You could try a repair mentioned in another topic and see if that gives you most of the data back. But a 3-2-1 backup method is key in any computer related situations.

Perhaps this extra information might start building a profile of the cohort of paying customers that are having the database issues.

OS? Windows or MacOS

Prime Gear ? 5000 or 4

Internal Storage Bay used? Yes or No

Type of drive - HHD or SSD

I agree. So many parameters. Perhaps adding: Import from DJ-app x-y-z etc.

I think you’re on the right track stating SC5000 and external SSD gives the least problems.

However, I’ve had the Prime4 here and used it with an internal Samsung SSD without issues. Same SSD now testing in a Prime2. No issues putting it through its paces.

The most common causes of corrupt databases is: removing a drive while it’s not ejected/unmounted

now we all know that right?

What most don’t realize is: when you switch your Prime 4 from computer connected to stand alone mode, you are effectively disconnecting the drive. Without a proper eject in EP and/or unmount from the desktop this will lead to database corruption.

I’ve seen almost all Prime 4 users do this when I assisted them over TeamViewer, so safe to say this is from my experience the number 1 cause of database corruption.

The same thing for when you Power down any Prime gear (SC5000/Prime4 etc) eject the drive (even the internal drive!) before you power down. Better to be safe than sorry.

I’m on SC5000 for more then 3 years now. Always had 2Tb drives connected to my Primes (current collection almost 110K of tracks) and I’ve yet have to experience my first database corruption. I agree Denon DJ should build in some safeguards, but it’s easily avoidable.

I’ll show in my next Ask Me Anything stream how you can simply backup your Prime databases and restore them.

oh I almost forgot, my tools automatically maintain 4 level of backups of the EP databases.

If I had a prime 4 , I will stay clear of the internal bay.

Or just use it for cold storage of less frequent used tracks!

The current process of adding music to it is super tedious.

Wait till the kids have gone to bed

All house hold chores are done.

Mrs is happy.

Connect laptop to prime 4

reboot to controller mode.

Add music etc…

close engine prime,

eject Prime4 (and pray it ejects properly),

then unplug Prime 4 USB,

then do another reboot

image

My preferred work flow is sitting on a recliner,

a cup of coffee :coffee:,

laptop on my thighs,

external hard drive plugged directly into laptop

Watching TV, eyes on the kids

download new tunes

Analyse

Poking around my library to my hearts content

And knowing fully well that once I unplug the drive it will work on my prime gear.

1 Like

I wonder if the sc6000 may have the same issue SSD’s are not cheap and a 1tb is the better part of £100, and to buy that only for it to be problematic would be very frustrating. The idea of having built in storage is great but the kinks need addressing.

Where there are cheap SSDs around , the really good branded ones are more expensive and might not get purchased by everyone due to cost.