https://bugs.kde.org/show_bug.cgi?id=511011
Bug ID: 511011
Summary: Accidentally starting Digikam twice (doubleclick on
taskbar attached item) gives datbase error - "missing
rights to alter table"
Classification: Applications
Product: digikam
Version First 8.7.0
Reported In:
Platform: Compiled Sources
OS: Microsoft Windows
Status: REPORTED
Severity: minor
Priority: NOR
Component: Database-Mysql
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
SUMMARY
Ladies, Gentlemen,
I have been going nuts with this error before finally understanding what (I
think) is going on.
>From time to time, when starting up Digikam, I got a mysterious error "missing
rights for ALTER database".
(In a splash screen, which then shows up the digikam MySQL connection
parameters to be verified - which verify OK !).
After trying to reproduce and analyze this further, I now believe to have found
out that the following is happening:
- I double-click the Digikam Icon on the taskbar (...by accident, or rather
some old-style behaviour of mine)
- two instances of Digikam will be starting up (in Win11, *one* click on the
taskbar is enough to start the program associated with te taskbar item once)
- during initialisation, both instances of the program will try to run some
"alter table if exists" statement (or similar) against the MariaDB database,
but they "step on each others toes" - leading to the splash screen for one of
them.
I have tried to track this further down by using internal logging / DebugView,
but unfortunately, when this is enabled, the timing seems to be a bit delayed
due to the overhead associated with this. and I couldn't reproduce the error
then.
I don't consider this a major problem (I have not found anyone else reporting
this here in KDE bugs or KDE discuss), but it would be nice if .....
- the error reporting could be improved a bit here ("what SQL error is really
received")
- or a small '"retry logic" could be implemented
- or an option in the setup to restrict Digikam to one instance on one
computer added
STEPS TO REPRODUCE
1. Install digikam and make basic settings (use an external MariaDB - not sure
if this is a must)
2. Put a start icon for Digikam on the windows taskbar
3. Try to double-click this icon - this will in fact try to start two
"instances" of digikam running, and from time to time (depends on the timing)
you will get a splash screen with the infamous "Missing rights to alter
database" - may need some retries perhaps.
OBSERVED RESULT
Database error splash screen ("missing rights to alter table" , sometimes
also "drop table")
EXPECTED RESULT
Errorless start
SOFTWARE/OS VERSIONS
Windows: 1124H2
ADDITIONAL INFORMATION
Fotos and Metadatada (MariaDB) on a (powerful) NAS (Synology) attached via fast
LAN (not WiFi)
--
You are receiving this mail because:
You are watching all bug changes.
