Sync \ Database Error Continued

[hogger69]

Original Post #9038

Recently whenever I try to sync my cell phone or tablet with the Database\Library on my PC an error message pops up on my PC saying "The database seems to be corrupted. Attempt to fix it?"

If I click on yes it appears to fix the database, however when I try to initiate a sync I am confronted with the same message.

If I click on no
Application Error

Application throw an exception Could not retrieve data
"SELECT Songs.*
FROM Songs
WHERE ( Songs.TrackType in (0,4,3) ) AND Songs.Rating>=76 AND Songs.Rating<=85" : database disk image is malformed (11, 11)
Would you like to restart MediaMonkey in Safe mode?

And i am given the usual choices "Restart", "Restart In Safe mode", or "Continue"
I have also tried Database Management and checked all maintenance options to no avail.

Any suggestions, I am a little apprehensive about "Clear Database" and "Reset Settings" options as my Library is pretty extensive, and yes I do have backups.

Hogger69

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Still Happening

I have done clean installs on both android devices as well as a clean install of MMW, nothing seems to fix the issue, I have had very brief intervals where sync works properly but very short and infrequent. A crasz loq was sent C33D0000 and i included an explanation linking to this post. I have the same issue now syncing via USB and WiFi, sometimes I can plug the android device into the PC and it will update or sync on its own in the background, but if I initiate the sync through the android device the PC MMW freezes with the corrupt database error. The android devices are a Samsung S23Ultra and a Blackview Tab 16pro, I included the PC breakdown in #9038. I have captured a new DebView log and will submit it when asked.

Thanks
Hogger69

[Lowlander]

Please see: https://www.mediamonkey.com/support/kno ... malformed/

[hogger69]

I have tried this, you rebuilt the database by hand a while back and it didn't work. I am more than willing to help figure out this bug as I have 3 Gold Licenses and have been using the program for years without anything like this happening. I have a large database which has been meticulously organized to my liking and I do not wish to lose all this work.
Here is the latest debug report, I have quoted the name "Sync / Database Error" or #9038 in the crash reports I was able to edit when the freeze/crash allowed.



Thanks
Hogger69

[Lowlander]

Generally malformed is an indication that the drive the database is on may start to fail. Particularly if it keeps occurring. However as you have a ticket open, please use it to resolve.

[hogger69]

The previous support ticket #9038 shows locked so I am responding here.
I have tried restoring the database from a saved back up and the problem persists.
I have tried repairing the database and the problem persists.
I have moved the DB to another drive and the problem persists. Running on a Samsung SSD 980 1TB
I have reinstalled on both android devices and on the PC as well, imported the database as well as an older back up of the
database problem persists.

I am trying to attach a copy of the dbgview log but it wont let me post the url to onedrive even if I put spaces in it


Thanks
Hogger69

[Lowlander]

It shows that you closed it. I reopened it for you.