Bug 267802 - Database connections not closed on exit
Summary: Database connections not closed on exit
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Engine (show other bugs)
Version: 1.4.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-06 16:53 UTC by Marco Tedaldi
Modified: 2012-06-27 10:26 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 2.0.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Marco Tedaldi 2011-03-06 16:53:23 UTC
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
Comment 1 caulier.gilles 2011-03-06 18:08:00 UTC
Please update to last 1.9.0 release and try to see if it's reproducible.

Gilles Caulier
Comment 2 Francesco Riosa 2011-06-29 12:53:38 UTC
2.0.0-rc is out, please re-open if needed