[Digikam-devel] [Bug 267802] New: Database connections not closed on exit

[Marco Tedaldi]

https://bugs.kde.org/show_bug.cgi?id=267802

           Summary: Database connections not closed on exit
           Product: digikam
           Version: 1.4.0
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database
        AssignedTo: digikam-devel at kde.org
        ReportedBy: marco.tedaldi at gmx.ch


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

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.