[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