Sync/database error

[Hogger]

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

[Lowlander]

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

[Hogger]

Thank you.

[Hogger]

I did what was suggested in the article, delete the MM.db file and force a rebuild of the database and all was well for a minute. It appears to be suffering from the same problem, I was a quarter of the way through a wireless sync when an error popped up on the PC stating that the database appears to be corrupt and if I would like to attempt to fix it, at which point the program crashes if yes is selected. The part that makes this annoying is that the sync operation is halted and cannot continue after the Windows version crashes.
Any other suggestions, I am really looking to maintain all the work I have put in to this library as far as star ratings and such.

thanks
Hogger69

[Lowlander]

This may indicate that the storage the database is on is failing.

What Build (Help > About) of MediaMonkey are you using?

[Hogger]

MediaMonkey Gold 2024.0.0.3082

Have been using this program for years and never had this problem before. I have also lost all my smart playlists for some reason, have all turned to "notsmart" playlists which don't even seem to be populated. Strange

Thanks
Hogger69

[Lowlander]

AutoPlaylists are database only, thus when you remove the database they're lost as AutoPlaylists. You may have exported them at some point which is why scanning picked them up, but as static Playlists.

If a failing hard drive is the cause it wouldn't have been an issue before. Do you have a different hard drive in your system, that at least for now, you could setup the database file?

If you have a backup of the database you could use that, as long as there is backup from before the database become malformed. It would also have your AutoPlaylists as AutoPlaylists.

[Hogger]

I have recently built a new computer (8 mos) and the database lives on the C:/ drive which is a fairly new ( maybe 1 year old ) Samsung 980 Pro 1TB SSD, so I don't think that is it besides it syncs with other devices with no database error. I will include a PC summary if you wish, but this whole MM5 arrangement has been living on this system quite nicely since its build. I thought it might be the newest version of MM5 as I did an upgrade a while back but now I am wondering if this is not a network issue as I have updated my network recently to a mesh system Deco XE75 6E system ( It has been working on the network for a couple of weeks now). I have attempted restoring a back up which did not work, I am now doing a USB Sync to see if this might correct the database error and allow my wifi sync to work again. Other times I have had syncing problems in the past it always seems to be on the android end ( my phone or tablet ) not on the PC. WiFi Syncing is all that seems to be affected and only between my PC and a Blackview Tab 16 Pro ( which previously worked and synced normally over WiFi ) all other iterations of MediaMonkey on all the other devices I have are functioning properly, Samsung S23Ultra syncs fine.

Code: Select all

   Computer:
      Computer Type                                     ACPI x64-based PC
      Operating System                                  Microsoft Windows 10 Pro
      OS Service Pack                                   -
      DirectX                                           DirectX 12.0
      Computer Name                                     DESKTOP-XXXXXX (XXX Desktop)
      User Name                                         XXX XXXXXXXXXX
      Logon Domain                                      DESKTOP-XXXXXXX
      Date / Time                                       2025-02-07 / 11:11

    Motherboard:
      CPU Type                                          8C+16c Intel Core i9-13900K, 5500 MHz (55 x 100)
      Motherboard Name                                  Asus ROG Maximus Z790 Hero  (3 PCI-E x16, 5 M.2, 4 DDR5 DIMM, Audio, Video, 2.5GbE LAN, 2 Thunderbolt 4, WiFi)
      Motherboard Chipset                               Intel Raptor Point-S Z790, Intel Raptor Lake-S
      System Memory                                     130779 MB  (DDR5 SDRAM)
      BIOS Type                                         AMI (02/15/2024)
      Communication Port                                Standard Serial over Bluetooth link (COM6)
      Communication Port                                Standard Serial over Bluetooth link (COM7)

    Display:
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      Video Adapter                                     AMD Radeon RX 6950 XT  (16368 MB)
      3D Accelerator                                    AMD Radeon RX 6950 XT (Navi 21)
      Monitor                                           Dell UltraSharp U2412M (DP)  [24" e-IPS LCD]  

    Multimedia:
      Audio Adapter                                     ATI Radeon HDMI @ AMD Navi 21/22/23/24 - High Definition Audio Controller
      Audio Adapter                                     Intel Raptor Point-S PCH - HD Audio (Audio, Voice, Speech)

    Storage:
      IDE Controller                                    Standard SATA AHCI Controller
      IDE Controller                                    Standard SATA AHCI Controller
      Storage Controller                                Microsoft Storage Spaces Controller
      Storage Controller                                Standard NVM Express Controller
      Storage Controller                                Standard NVM Express Controller
      Storage Controller                                Standard NVM Express Controller
      Storage Controller                                Xvdd SCSI Miniport
      Disk Drive                                        PM981 NVMe Samsung 256GB  (256 GB, PCI-E 3.0 x4)
      Disk Drive                                        Samsung SSD 960 EVO 500GB  (500 GB, PCI-E 3.0 x4)
      Disk Drive                                        Samsung SSD 980 1TB  (1000 GB, PCI-E 3.0 x4)
      Disk Drive                                        ST8000DM004-XXXXXXX  (8 TB, 5000 RPM, SATA-III)
      Disk Drive                                        ST8000DM004-XXXXXX  (8 TB, 5000 RPM, SATA-III)
      Disk Drive                                        WDC WD40EZRZ-XXXXXXX  (4 TB, SATA-III)
      Disk Drive                                        WDC WD40EZRZ-XXXXXXX  (4 TB, SATA-III)
      SMART Hard Disks Status                           OK

    Partitions:
      C: (NTFS)                                         931.5 GB (490.6 GB free)
      D: (NTFS)                                         3726.0 GB (451.4 GB free)
      E: (NTFS)                                         3725.9 GB (1736.7 GB free)
      F: (NTFS)                                         7452.0 GB (1261.3 GB free)
      G: (NTFS)                                         7452.0 GB (1265.6 GB free)
      H: (NTFS)                                         451.9 GB (248.0 GB free)
      I: (NTFS)                                         238.5 GB (221.4 GB free)
      Total Size                                        23977.9 GB (5675.2 GB free)

    Input:
      Keyboard                                          HID Keyboard Device
      Mouse                                             HID-Compliant Mouse
      Mouse                                             HID-compliant mouse

    Network:
      Primary IP Address                                XXX.XXX.XXX.XXX
      Primary MAC Address                               XX-XX-XX-XX-XX-XX
      Network Adapter                                   Bluetooth Device (Personal Area Network)
      Network Adapter                                   Intel(R) Ethernet Controller I226-V  (XXX.XXX.XX.XXX)
      Network Adapter                                   Intel(R) Wi-Fi 6E AX211 160MHz
      Network Adapter                                   Microsoft Wi-Fi Direct Virtual Adapter #2
      Network Adapter                                   Microsoft Wi-Fi Direct Virtual Adapter
      Network Adapter                                   NordLynx Tunnel #2  (XXX.XXX.XXX.XXX)
      Network Adapter                                   OpenVPN Data Channel Offload
      Network Adapter                                   TAP-NordVPN Windows Adapter V9
      Modem                                             SAMSUNG Mobile USB Modem
 DMI:
      DMI BIOS Vendor                                   American Megatrends Inc.
      DMI BIOS Version                                  2001
      DMI System Manufacturer                           ASUS
      DMI System Product                                System Product Name
      DMI System Version                                System Version
      DMI System Serial Number                          System Serial Number
      DMI System UUID                                   XXXXXXXXXXX-XXXXXXXXX-XXXXXXXXX
      DMI Motherboard Manufacturer                      ASUSTeK COMPUTER INC.
      DMI Motherboard Product                           ROG MAXIMUS Z790 HERO
      DMI Motherboard Version                           Rev 1.xx
      DMI Motherboard Serial Number                     XXXXXXXXXXXXXXX
      DMI Chassis Manufacturer                          Default string
      DMI Chassis Version                               Default string
      DMI Chassis Serial Number                         Default string
      DMI Chassis Asset Tag                             Default string
      DMI Chassis Type                                  Desktop Case

[Lowlander]

You can capture the Sync causing the malformed error to happen in a debug log (step 4b) and attach the log and database file to a Support Ticket: viewtopic.php?t=86643

[hogger69]

Here is the dbgview log for the crash [personal info removed]

[Lowlander]

Please provide link to a Support Ticket.