[digiKam-users] Failure when open DigiKam with internal MySQL database

[Acki Schnacki]

I am new to DigiKam using 7.2 with internal Mysql database. 1.8GB big so far.

For unkown reason, yesterday I cannot correctly open digikam anymore.

 

When I open the app, it takes ages to open an than quits with a short message,

"cannot connect to localhost", something similar, the message is not long present on the screen.

 

When using DebgView I see following messages:

[10684] QSqlQuery::prepare: database not open
[10684] QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120' is still in use, all queries will cease to work.
[10684] QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-275987120', old connection removed.
[10684] QSqlQuery::prepare: database not open
[10684] QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-166507360' is still in use, all queries will cease to work.
[10684] QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-166507360', old connection removed.
[10684] QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120' is still in use, all queries will cease to work.
[10684] QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-275987120', old connection removed.
[10684] QSqlQuery::prepare: database not open
[10684] QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120' is still in use, all queries will cease to work.
[10684] QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-275987120', old connection removed.
[10684] QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120' is still in use, all queries will cease to work.
[10684] QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-275987120', old connection removed.
[10684] QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-166507360' is still in use, all queries will cease to work.
[10684] QSqlDatabasePrivate::addDatabase: duplicate connection name 'digikamDatabase-166507360', old connection removed.

 

What can I do? Is my database gone?

[Maik Qualmann]

Set the debug environment variable in the Windows Environment Variable Editor
as described here:

https://www.digikam.org/contribute/

And then the DebugView log from the beginning.

Maik

Am Mittwoch, 28. April 2021, 18:27:54 CEST schrieb Acki Schnacki:

> I am new to DigiKam using 7.2 with internal Mysql database. 1.8GB big so
> far. For unkown reason, yesterday I cannot correctly open digikam anymore.
> When I open the app, it takes ages to open an than quits with a short
> message, "cannot connect to localhost", something similar, the message is
> not long present on the screen.
> When using DebgView I see following messages:
> [10684] QSqlQuery::prepare: database not open
> [10684] QSqlDatabasePrivate::removeDatabase: connection
> 'digikamDatabase-275987120' is still in use, all queries will cease to
> work. [10684] QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlQuery::prepare: database not open
> [10684] QSqlDatabasePrivate::removeDatabase: connection
> 'digikamDatabase-166507360' is still in use, all queries will cease to
> work. [10684] QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-166507360', old connection removed. [10684]
> QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120'
> is still in use, all queries will cease to work. [10684]
> QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlQuery::prepare: database not open
> [10684] QSqlDatabasePrivate::removeDatabase: connection
> 'digikamDatabase-275987120' is still in use, all queries will cease to
> work. [10684] QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120'
> is still in use, all queries will cease to work. [10684]
> QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-166507360'
> is still in use, all queries will cease to work. [10684]
> QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-166507360', old connection removed.
> What can I do? Is my database gone?

[Acki Schnacki]

I uploaded the complete log here: https://paste.ee/p/37de9

This seems to be the interesting part:

00000362	21.42408752	[10536] digikam.dbengine: Failure executing query:
00000363	21.42408752	[10536]  "SELECT creationDate FROM ImageInformation INNER JOIN Images ON Images.id=ImageInformation.imageid  WHERE Images.status=1;"
00000364	21.42408752	[10536] Error messages: "QMYSQL3: Unable to store statement results" "Lost connection to MySQL server during query" "2013" 2
00000365	21.42408752	[10536] Bound values:  ()
00000366	21.42440414	[10536] digikam.dbengine: Prepare failed!
00000367	21.42446327	[10536] digikam.dbengine: Failure executing query:	

 

 

Gesendet: Mittwoch, 28. April 2021 um 18:59 Uhr
Von: "Maik Qualmann" <[hidden email]>
An: "digiKam - Home Manage your photographs as a professional with the power of open source" <[hidden email]>
Betreff: Re: [digiKam-users] Failure when open DigiKam with internal MySQL database

Set the debug environment variable in the Windows Environment Variable Editor
as described here:

https://www.digikam.org/contribute/

And then the DebugView log from the beginning.

Maik

Am Mittwoch, 28. April 2021, 18:27:54 CEST schrieb Acki Schnacki:
> I am new to DigiKam using 7.2 with internal Mysql database. 1.8GB big so
> far. For unkown reason, yesterday I cannot correctly open digikam anymore.
> When I open the app, it takes ages to open an than quits with a short
> message, "cannot connect to localhost", something similar, the message is
> not long present on the screen.
> When using DebgView I see following messages:
> [10684] QSqlQuery::prepare: database not open
> [10684] QSqlDatabasePrivate::removeDatabase: connection
> 'digikamDatabase-275987120' is still in use, all queries will cease to
> work. [10684] QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlQuery::prepare: database not open
> [10684] QSqlDatabasePrivate::removeDatabase: connection
> 'digikamDatabase-166507360' is still in use, all queries will cease to
> work. [10684] QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-166507360', old connection removed. [10684]
> QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120'
> is still in use, all queries will cease to work. [10684]
> QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlQuery::prepare: database not open
> [10684] QSqlDatabasePrivate::removeDatabase: connection
> 'digikamDatabase-275987120' is still in use, all queries will cease to
> work. [10684] QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-275987120'
> is still in use, all queries will cease to work. [10684]
> QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-275987120', old connection removed. [10684]
> QSqlDatabasePrivate::removeDatabase: connection 'digikamDatabase-166507360'
> is still in use, all queries will cease to work. [10684]
> QSqlDatabasePrivate::addDatabase: duplicate connection name
> 'digikamDatabase-166507360', old connection removed.
> What can I do? Is my database gone?