[Digikam-devel] [Bug 262231] New: Missing records after migration from SQLite to Digikam

[Vincent Tassy]

https://bugs.kde.org/show_bug.cgi?id=262231

           Summary: Missing records after migration from SQLite to Digikam
           Product: digikam
           Version: 1.6.0
          Platform: Fedora RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: timetre at free.fr


Version:           1.6.0 (using KDE 4.5.4) 
OS:                Linux

I've run the migration tool and then looked at the content of the
supposedly synced SQLite and MySQL databases ...

                          Records
Table               SQLite      MySQL
-------------------------------------
AlbumRoots               2          2
Albums                 808        808
DownloadHistory     13,403     13,403
ImageComments        5,969      5,969
ImageCopyright      50,303     50,303
ImageHaarMatrix     27,756     27,756
ImageInformation    81,216     81,216
ImageMetadata       72,383          0
ImagePositions       6,481      6,481
ImageProperties         50         50
Images              81,216     81,210
ImageTags           52,463     52,463
Searches                15         15
Settings                20         11
Tags                   461        461
TagsTree             1,886      2,240

As you can see, most tables seem to have been migrated correctly but
ImageMetadata is empty, Images is missing 6 records, Settings is missing
9 and TagsTree is abnormally bigger !


Reproducible: Always

Steps to Reproduce:
Perform Database migration

Actual Results:  
ImageMetadata table is empty
Images table is missing 6 records
Settings table is missing 9 records
TagsTree Table has more records than source table !!

Expected Results:  
Source and Destination Database should be perfectly in sync

I found that while the migration was going, the more it advanced, the slower it
was ...
When the progressbar indicated the migration of the TagsTree table it took more
than 10 minutes ! while the migration of the Images table took a few seconds
...

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.