| Summary: | Database connections not closed on exit | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | Marco Tedaldi <marco.tedaldi> |
| Component: | Database-Engine | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | caulier.gilles, vivo75+kde |
| Priority: | NOR | ||
| Version: | 1.4.0 | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | 2.0.0 | |
| Sentry Crash Report: | |||
Please update to last 1.9.0 release and try to see if it's reproducible. Gilles Caulier 2.0.0-rc is out, please re-open if needed |
Version: 1.4.0 (using KDE 4.5.1) OS: Linux After opening and closing digikam with mysql as database backend several times, "sleeping" connections accumulate on mysql server. Example Output of mytop: MySQL on localhost (5.0.51a-24+lenny5-log) up 18+00:01:53 [16:49:26] Queries: 2.2M qps: 1 Slow: 0.0 Se/In/Up/De(%): 00/00/00/00 qps now: 0 Slow qps: 0.0 Threads: 31 ( 1/ 5) 00/00/00/00 Key Efficiency: 99.9% Bps in/out: 0.1/ 19.4 Now in/out: 8.4/ 1.7k Id User Host/IP DB Time Cmd Query or State -- ---- ------- -- ---- --- ---------- 29554 root localhost 0 Query show full processlist 36526 digikam 1und1 digikam-db 3247 Sleep 36527 digikam 1und1 digikam-db 3247 Sleep 36521 digikam 1und1 digikam-db 3308 Sleep 36522 digikam 1und1 digikam-th 3308 Sleep 36519 digikam 1und1 digikam-db 3312 Sleep 36520 digikam 1und1 digikam-th 3312 Sleep 36470 digikam 1und1 digikam-db 3313 Sleep 36469 digikam 1und1 digikam-db 3313 Sleep 36518 digikam 1und1 digikam-db 3313 Sleep 36515 digikam 1und1 digikam-db 3336 Sleep 36495 digikam 1und1 digikam-db 3976 Sleep 36497 digikam 1und1 digikam-db 4363 Sleep 36498 digikam 1und1 digikam-db 4363 Sleep 36499 digikam 1und1 digikam-th 4363 Sleep 36483 digikam 1und1 digikam-db 4543 Sleep 36484 digikam 1und1 digikam-th 4543 Sleep 36447 digikam 1und1 digikam-db 16107 Sleep 36448 digikam 1und1 digikam-th 16107 Sleep 36449 digikam 1und1 digikam-db 16163 Sleep 36450 digikam 1und1 digikam-th 16163 Sleep 36444 digikam 1und1 digikam-db 16171 Sleep 36445 digikam 1und1 digikam-th 16171 Sleep 36443 digikam 1und1 digikam-db 16195 Sleep 36440 digikam 1und1 digikam-db 16212 Sleep 36428 digikam 1und1 digikam-db 16455 Sleep 36429 digikam 1und1 digikam-th 16455 Sleep 36427 digikam 1und1 digikam-th 16768 Sleep 36426 digikam 1und1 digikam-db 16769 Sleep 36425 digikam 1und1 digikam-db 16995 Sleep 36423 digikam 1und1 digikam-db 17354 Sleep Reproducible: Always Steps to Reproduce: Use MySQL as Backend and open and close digikam several times Actual Results: There are new connections to the db opened every time but they seem to stay opened even if digikam is closed. Expected Results: Database connections should be closed on exit