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

Gilles Caulier caulier.gilles at gmail.com
Mon May 17 10:09:13 BST 2010


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





--- Comment #54 from Gilles Caulier <caulier gilles gmail com>  2010-05-17 11:09:07 ---
Marcel, 

This is my condition to switch from SQlite to MysSQL :

- Clean up all, no DB file, no config file.
- Start digiKam from scratch from First Run Assistant.
- Go imediatly to DB config pannel, and swith from SQLite to Internal MySQL.

Results and remarks :

1/ I press on "Check DB connection" button. Why i can see these message on the
console :

digikam(1396)/digikam (core) Digikam::SetupDatabase::readSettings: Comparing
comboboxentry on index [ 0 ] [ "QSQLITE" ] with [ "QSQLITE" ]                   
digikam(1396)/digikam (core) Digikam::SetupDatabase::readSettings: Comparing
comboboxentry on index [ 1 ] [ "QMYSQL" ] with [ "QSQLITE" ]                    
digikam(1396)/digikam (core) Digikam::DatabaseParameters::defaultParameters:
ConnectOptions 
"UNIX_SOCKET=/home/gilles/.kde4/share/apps/digikam/db_misc/mysql.socket"        
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
(3959) Digikam::DatabaseConfigElementLoader::readConfig:
"/usr/share/apps/digikam/database/dbconfig.xml"                      
(3959) Digikam::DatabaseParameters::defaultParameters: ConnectOptions 
"UNIX_SOCKET=/home/gilles/.kde4/share/apps/digikam/db_misc/mysql.socket"        
(3959) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Failed to use
database "digikam"                                   
(3959) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Query error:
"Unknown database 'digikam' QMYSQL: Unable to execute query"                    
(3959) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Database error:
"Can't connect to local MySQL server through socket
'/home/gilles/.kde4/share/apps/digikam/db_misc/mysql.socket' (2) QMYSQL: Unable
to connect"                                  
(3959) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Trying to create
database now...                                   
(3959) Digikam::DatabaseServer::startMYSQLDatabaseProcess: Database was
successfully created                                  
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.             
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server          
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server          
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server          
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
timeChanged                                                                     
void SunLocator::update()                                                       
timeChanged                                                                     
void SunLocator::update()                                                       
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server          
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server          
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server          
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]         
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
timeChanged
void SunLocator::update()
timeChanged
void SunLocator::update()
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
timeChanged
void SunLocator::update()
timeChanged
void SunLocator::update()
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]

Soemthing is wrong with this message : "Digikam::PollThread::run: Waiting  10 
seconds...stop: [ false ]"

Note : this message continu to be printed on the console after than digiKam
instance is closed. It's relevant of digikamdatabaseserver.

[gilles at pc-caulier digikam]$ ps -ax |grep digikamdata
 3959 ?        Sl     0:00 /usr/lib/kde4/libexec/digikamdatabaseserver
[gilles at pc-caulier digikam]$

If i kill it, this message disappear.

2/ I press Ok button from DB config pannel. digiKam show Collection File paths
settings panel. Why ? digiKam is not able to take SQlite collection paths and
import it as well ?

3/ I set by hand the unique collection path (/mnt/data/photos) where DB files
are hosted. I press ok. Collection File paths settings panel still displayed
with the progress dialog starting to scan collection path. I think that
collection settings panel can be closed there. Progress dialog look fine.

4/ When Scanning is complete, all dialog are closed properly and focus go back
to icon view. On the console i can always seen :

(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]

Help/DB stats dialog show right information.
I can navigate through folder view, search tools, and other. It sound to work.

5/ I close digiKam. I can see these messages on the console :

(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
Model deleted: Marble::MarbleModel(0xa294350)
Deleting FileStorageWatcher
Model deleted: Marble::MarbleModel(0xbe56dd8)
Deleting FileStorageWatcher
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-156351760' is
still in use, all queries will cease to work.
QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-214966704' is
still in use, all queries will cease to work.
QSqlDatabasePrivate::removeDatabase: connection 'thumbnailDatabase-214966704'
is still in use, all queries will cease to work.
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
Error in my_thread_global_end(): 2 threads didn't exit
[gilles at pc-caulier digikam]$ (3959)
Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]
(3959) Digikam::PollThread::checkDigikamInstancesRunning: At least service [
"org.kde.digikam.KIO-digikamtags-30762" ] is using the database server
(3959) Digikam::PollThread::run: Waiting  10  seconds...stop: [ false ]

Something is wrong there ?

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.



More information about the Digikam-devel mailing list