[Bug 218571] New: schema update version 4 to 5 failed

[Per Jensen]

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

           Summary: schema update version 4 to 5 failed
           Product: digikam
           Version: unspecified
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           1beta5 (using KDE 4.3.2)
OS:                Linux
Installed from:    Ubuntu Packages

digikam suddenly pops up a message, presumably after an ubuntu update, that the
"the schema updating process from version 4 to 5 failed"

The program terminates after clicking the "OK" button and write this in the
terminal window:

"QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-17499296' is
still in use, all queries will cease to work."

This is the only output from digikam to the terminal window.

The dialog box suggests to remove the databasefiles digikam3.db and
digikam4.db. If I do so the program indeed starts, but of course with an empty
database.


I have tried to install the newer digikam version 1rc from Luka Renko's PPA at
https://launchpad.net/~lure/+archive/ppa - the result is the same.


Any help to fix the schema upgrade is much appreciated - I will be glad to
supply any further information/testing in order to solve this bug.

Regards
Per Jensen
[hidden email]

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|general                     |Database
            Version|unspecified                 |1.0.0-beta5




--- Comment #1 from Gilles Caulier <caulier gilles gmail com>  2009-12-13 22:36:51 ---
Do not use beta5 but rc. A lots of fix have be done since beta 5

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Per Jensen]

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





--- Comment #2 from Per Jensen <per net-es dk>  2009-12-15 14:15:43 ---
It is the same with Luka's PPA build.

I have now tried to start Luka's version on a backup copy of digikam4.db, and
it starts! - I guess this means the "real" digikam4.db is corrupted in some
way. It can be opened using sqlite3 though.

If you are interested in finding the cause, I will be glad to help out in any
way.

Me losing a months tags is no big deal, not much has changed. Thus I am a happy
man again - looking forward to 1.0

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|1.0.0-beta5                 |1.0.0




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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


Marcel Wiesweg <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #3 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-12-29 15:40:50 ---
I understand you don't have a backup copy from before your first attempt to
upgrade with beta5, but only a broken database from after the upgrade attempt,
and an older backup which can be upgraded without problems?
So maybe the original problem is fixed in 1.0?

You could send me the broken database for inspection in any case.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Guillaume Paumier]

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


Guillaume Paumier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #4 from Guillaume Paumier <guillom pom gmail com>  2010-08-28 19:08:25 ---
I'm encountering the same problem right now with digiKam Version 1.5.0 (rev.:
1169185). I also tried with the latest svn version (r1169202) but the problem
still happens.

I'd be happy to share my database if it can help fix the issue, since I'd
prefer not to lose the tagging & metadata work I've been doing (I hadn't sync'd
by writing the metadata to the RAW files yet). I don't have a backup of the
database before any upgrade was attempted.

My digikam4.db is ~73MB so it's not very convenient to send by email. I can put
it on my test server if you want to inspect it.

Also, here's some additional info from the console:

digikam(11788)/digikam (core) Digikam::SchemaUpdater::updateV4toV5: Dropped
triggers
digikam(11788)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
"/usr/local/share/apps/digikam/database/dbconfig.xml"
digikam(11788)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 ""
Error messages: "table AlbumRoots already exists Impossible d'exécuter
l'instruction" 1 2 "table AlbumRoots already exists" "Impossible d'exécuter
l'instruction" QSqlError(-1, "", "")
Bound values:  ()
digikam(11788)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error
while executing DBAction [ "CreateDB" ] Statement [ "CREATE TABLE AlbumRoots
                            (id INTEGER PRIMARY KEY,
                            label TEXT,
                            status INTEGER NOT NULL,
                            type INTEGER NOT NULL,
                            identifier TEXT,
                            specificPath TEXT,
                            UNIQUE(identifier, specificPath))" ]
digikam(11788)/digikam (core) Digikam::CollectionScanner::completeScan:
Complete scan took: 368 msecs.
digikam(11788)/digikam (core) Digikam::IccSettingsPriv::scanDirectories:
("/usr/share/color/icc")

If there's nothing you can do, that's ok, I'll get over it :) In any case, I'd
like to know what to expect.

Thanks!

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #5 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-08-29 10:09:53 ---
From which digikam version did you upgrade to which when this problem occurred?
Anything special happening?

Since there is a table AlbumRoots, it seems you already have used at least
0.10.0 and had a file digikam4.db. Normally, the v4tov5 update happens from 0.9
and digikam3.db.

Did you create fingerprints for your images? That would explain the size of the
db. Or do you have a million pictures?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Guillaume Paumier]

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





--- Comment #6 from Guillaume Paumier <guillom pom gmail com>  2010-08-29 18:32:38 ---
(In reply to comment #5)
> From which digikam version did you upgrade to which when this problem occurred?
> Anything special happening?

I don't remember anything special happening; I upgraded the digikam package for
ubuntu a few weeks ago and got this error.

> Since there is a table AlbumRoots, it seems you already have used at least
> 0.10.0 and had a file digikam4.db. Normally, the v4tov5 update happens from 0.9
> and digikam3.db.

When the v4toV5 schema change happens, is it supposed to keep digikam3.db until
the upgrade is completed? Because I don't have a digikam3.db file any more.

> Did you create fingerprints for your images? That would explain the size of the
> db. Or do you have a million pictures?

No, not a million, only ~20 000 :) But I did create fingerprints for them.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Guillaume Paumier]

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





--- Comment #7 from Guillaume Paumier <guillom pom gmail com>  2010-08-29 19:13:27 ---
FWIW I've decided to lose a few months worth of tags and start over with a new
database and the tags saved in the files, but I'm still willing to provide
additional information to help fix the issue if needed.

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

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





--- Comment #8 from Marcel Wiesweg <marcel wiesweg gmx de>  2010-08-30 12:15:21 ---
Yes, the digikam3.db file is never touched, only read. Also note that 0.10.0
was released 17 months ago.

You can open a copy of the digikam4.db file with the "sqlite3" tool and
execute:
DELETE FROM ImageHaarMatrix;
VACUUM;
to get a smaller db suitable for emailing

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #9 from Gilles Caulier <caulier gilles gmail com>  2011-12-15 09:16:36 ---
Guillaume, Per,

This file still valid using digiKam 2.4 ?

Do you see comment #8 from Marcel ?

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

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

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #10 from Gilles Caulier <[hidden email]> ---


*** This bug has been marked as a duplicate of bug 277928 ***

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Database                    |Database-Schema

--
You are receiving this mail because:
You are the assignee for the bug.