[Bug 288599] New: Schema update to V6 failed

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

           Summary: Schema update to V6 failed
           Product: digikam
           Version: unspecified
          Platform: Gentoo Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: Database
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           unspecified (using KDE 4.7.3)
OS:                Linux

Today I have upgraded digikam from 1.9 up to 2.4.1  

I use MySQL database. When starting digikam prints

QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(14004)/digikam (core): Schema update to V6 failed!

and finally I obtain empty albums.

Please, help

Reproducible: Didn't try

Steps to Reproduce:
Start digikam after upgrade


Expected Results:  
I want to see my albums

--
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

[Francesco Riosa-2]

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


Francesco Riosa <[hidden email]> changed:

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




--- Comment #1 from Francesco Riosa <francesco+kde pnpitalia it>  2011-12-09 22:15:57 ---
need more info to try to understand the problem:
1) is the database populated? (if yes please backup)
2) do a mysqldump --no-data of the database, will be needed to know the
structure of the database.
3) if you leave digikam run for a pair of minutes and then restart it does it
work?
4) using the `kdebugdialog` activate the output for the following areas:
  [50003] [50004] [50005] [50006] [50007] [51000] [51001] [digikam] [showfoto]
[unnamed app]
  then run digikam from the command line, should give a lot of output

please attach at least the structure of the db and the digikam log to this bug

--
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

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





--- Comment #2 from  <serge pdmi ras ru>  2011-12-09 22:27:33 ---
This is digikam output after 4).

$ digikam
digikam(25800)/kdeui (KIconLoader) KIconThemeDir::KIconThemeDir: Invalid
Context= "Apps" line for icon theme:  "/usr/share/icons/Mist/22x22/apps"
digikam(25800)/kdeui (KIconLoader) KIconThemeDir::KIconThemeDir: Invalid
Context= "Apps" line for icon theme:  "/usr/share/icons/Mist/16x16/apps"
digikam(25800)/kdeui (KIconLoader) KIconThemeDir::KIconThemeDir: Invalid
Context= "Apps" line for icon theme:  "/usr/share/icons/Mist/32x32/apps"
digikam(25800)/kdeui (KIconLoader) KIconThemeDir::KIconThemeDir: Invalid
Context= "Apps" line for icon theme:  "/usr/share/icons/Mist/48x48/apps"
digikam(25800)/kdeui (KIconLoader) KIconThemeDir::KIconThemeDir: Invalid
Context= "Apps" line for icon theme:  "/usr/share/icons/Mist/24x24/apps"
digikam(25800)/kdeui (KIconLoader) KIconThemeDir::KIconThemeDir: Invalid
Context= "Apps" line for icon theme:  "/usr/share/icons/Mist/256x256/apps"
digikam(25800)/digikam (core) Digikam::KInotify::Private::open: Successfully
opened connection to inotify: 17
digikam(25800)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QMYSQL", Name "digikam" (Thumbnails Name
"digikam"); ConnectOptions:
"UNIX_SOCKET=/home/serge/.kde4/share/apps/digikam/db_misc/mysql.socket",
Username and Password: "root", ""]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(25800)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
Loading SQL code from config file
"/usr/share/apps/digikam/database/dbconfig.xml"
digikam(25800)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
false "1" 1 1
digikam(25800)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(25800)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  5
digikam(25800)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates
5  to  6
digikam(25800)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 ""
Error messages: "QMYSQL: Unable to execute query" "PROCEDURE
digikam.create_index_if_not_exists does not exist" 1305 2
Bound values:  ()
digikam(25800)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error
while executing DBAction [ "UpdateSchemaFromV5ToV6" ] Statement [ "CALL
create_index_if_not_exists('ImageTags','tag_id_index','imageid');" ]
digikam(25800)/digikam (core): Schema update to V6 failed!

--
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

[Francesco Riosa-2]

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





--- Comment #3 from Francesco Riosa <francesco+kde pnpitalia it>  2011-12-09 22:36:49 ---
the (mysql digikam code) problem is that you're using two different databases
for images and thumbnails.

try to execute the following SQL in both databases, and then restart digikam:

DROP PROCEDURE IF EXISTS create_index_if_not_exists;

delimiter ;;

CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50),
index_name_vc varchar(50), field_list_vc varchar(1024), is_unique int)
SQL SECURITY INVOKER
BEGIN

set @Index_cnt = (
    SELECT COUNT(1) cnt
    FROM INFORMATION_SCHEMA.STATISTICS
    WHERE CONVERT(DATABASE() USING latin1) = CONVERT(TABLE_SCHEMA USING latin1)
    AND CONVERT(table_name USING latin1) = CONVERT(table_name_vc USING latin1)
    AND CONVERT(index_name USING latin1) = CONVERT(index_name_vc USING latin1)
);

IF IFNULL(@Index_cnt, 0) = 0 THEN
    set @index_sql = CONCAT(
        CONVERT( 'ALTER TABLE ' USING latin1),
        CONVERT( table_name_vc USING latin1),
        CONVERT( IF(is_unique = 0, ' ADD INDEX ', ' ADD UNIQUE INDEX ') USING
latin1),
        CONVERT( index_name_vc USING latin1),
        CONVERT( '(' USING latin1),
        CONVERT( field_list_vc USING latin1),
        CONVERT( ');' USING latin1)
    );
    PREPARE stmt FROM @index_sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END IF;
END ;;

--
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

[Francesco Riosa-2]

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





--- Comment #4 from Francesco Riosa <francesco+kde pnpitalia it>  2011-12-09 22:39:52 ---
please confirm the problem has been "fixed" (a real fix is waiting for me to
understand much better qt+threads+database).

--
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

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





--- Comment #5 from  <serge pdmi ras ru>  2011-12-09 22:40:16 ---
Ok, many thanks for quick answer, I will try tomorrow and send a feedback.

--
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

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





--- Comment #6 from  <serge pdmi ras ru>  2011-12-10 07:25:21 ---
Dear Francesco, it is not absolutely clear for me what do you mean by different
databases. I have the following settings in digikamrc:

[Database Settings]
Database
Connectoptions=UNIX_SOCKET=/home/serge/.kde4/share/apps/digikam/db_misc/mysql.socket
Database Hostname=
Database Name=digikam
Database Name Thumbnails=digikam
Database Password=
Database Port=0
Database Type=QMYSQL
Database Username=root
Internal Database Server=false

So, it seems that I have only one database "digikam"

--
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

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





--- Comment #7 from  <serge pdmi ras ru>  2011-12-10 07:47:36 ---
Created an attachment (id=66581)
 --> (http://bugs.kde.org/attachment.cgi?id=66581)
Database structure

--
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

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





--- Comment #8 from  <serge pdmi ras ru>  2011-12-11 10:09:25 ---
This is the digikam output after applying sql code from comment #3:

digikam(20752)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QMYSQL", Name "digikam" (Thumbnails Name
"digikam"); ConnectOptions:
"UNIX_SOCKET=/home/serge/.kde4/share/apps/digikam/db_misc/mysql.socket",
Username and Password: "root", ""]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(20752)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
Loading SQL code from config file
"/usr/share/apps/digikam/database/dbconfig.xml"
digikam(20752)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
false "1" 1 1
digikam(20752)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(20752)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  5
digikam(20752)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates
5  to  6
digikam(20752)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 ""
Error messages: "QMYSQL: Unable to execute query" "Incorrect number of
arguments for PROCEDURE digikam.create_index_if_not_exists; expected 4, got 3"
1318 2
Bound values:  ()
digikam(20752)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error
while executing DBAction [ "UpdateSchemaFromV5ToV6" ] Statement [ "CALL
create_index_if_not_exists('ImageTags','tag_id_index','imageid');" ]
digikam(20752)/digikam (core): Schema update to V6 failed!

Please, help!

--
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

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





--- Comment #9 from  <serge pdmi ras ru>  2011-12-11 12:01:06 ---
Created an attachment (id=66621)
 --> (http://bugs.kde.org/attachment.cgi?id=66621)
MYSQL server log (running digikam after executing SQL code from comment #3)

--
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

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





--- Comment #10 from  <serge pdmi ras ru>  2011-12-11 14:19:16 ---
I have fixed somehow my problems by means of executing of SQL code from bug
283502. Seems to be a duplicate of 283502

--
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=288599


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
            Version|unspecified                 |2.4.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=288599


Gilles Caulier <[hidden email]> changed:

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




--- Comment #11 from Gilles Caulier <caulier gilles gmail com>  2011-12-11 14:54:16 ---


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

--
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

[bugzilla_noreply]

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

[hidden email] changed:

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

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