[Digikam-devel] [Bug 235928] digikam fails to open database at startup

[Bruno Friedmann]

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


Bruno Friedmann <brunofr at ioda.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |brunofr at ioda.net




--- Comment #63 from Bruno Friedmann <brunofr ioda net>  2010-08-01 11:13:48 ---
Info about digikam rpm : 
Repository: @System
Name: digikam
Version: 1.3.0-41.1
Arch: i586
Vendor: obs://build.opensuse.org/KDE
Installed: Yes
Status: up-to-date
Installed Size: 15.5 MiB
Summary: A KDE Photo Manager

Context : in a project to store and work with ~1500000 photos we have to use
mysql (several computers need access to the same db)
Those mysql server is up and running a user exist and have all rights to it's
digikam db. 
(All works with akonadi and amarok)

What steps will reproduce the problem?

1. Open digikam 1.3.1, and try to setup the use of mysql

2. Mysql is setup to use innodb engine by default ( necessary for akonadi ) and
also the digikam database ( triggers )

3. digikam stop  with the error of unable to write table : this is due to the
use of string in index without limiting them to a max of 255

4. I've not found how can I pre setup the digikam to directly use the mysql
before indexing my folders.

5. We try to correct manually the qsql instruction as you wrongly use string
index that are more than 255 and this is not supported by innodb.

What is the actual output?
lot's of error

What is the expected output?
a smooth working database.

Even trying to use the mysql embedded server ... 

(23291) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(23291) Digikam::DatabaseConfigElementLoader::readConfig:
"/usr/share/kde4/apps/digikam/database/dbconfig.xml"
(23291) Digikam::DatabaseParameters::defaultParameters: ConnectOptions 
"UNIX_SOCKET=/home/bruno/.kde4/share/apps/digikam/db_misc/mysql.socket"
(23291) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Failed to use
database "digikam"
(23291) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Query error:
"Unknown database 'digikam' QMYSQL: Unable to execute query"
(23291) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Database error:
"Can't connect to local MySQL server through socket
'/home/bruno/.kde4/share/apps/digikam/db_misc/mysql.socket' (2) QMYSQL: Unable
to connect"
(23291) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Trying to create
database now...
(23291) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Database was
successfully created
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
(23291) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-20202" ] is using the database server
(23291) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-139614608' is
still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name
'digikamDatabase-139614608', old connection removed.
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 
(23291) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-20202" ] is using the database server
(23291) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
digikam(20046)/digikam (core): Error while opening the database. Error details
[ QSqlError(-1, "Erreur lors de l'ouverture de la base de données", "unable to
open database file") ] 


What version of the product are you using? On what target Application (e.g.
Firefox 3.5.1, etc.)? On what operating system?
Extension Version =
Application =
OS =

Please provide any additional information below. In some cases
errors/warnings may be logged in the Error Console (in Firefox) which is
available under the Tools menu or using Ctrl+Shift+J. If you find any
related to this extension, please report that too.

Also our global mysql configuration is utf-8 as we have picture name coming
from several countries which are not latin1 

our modified xml.

None of the triggers actually works with a mysql 5.1.46

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