[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 104881] New: Memory leak after database query error
From:       Greg Meyer <greg () gkmweb ! com>
Date:       2005-05-01 1:54:08
Message-ID: 20050501035407.104881.greg () gkmweb ! com
[Download RAW message or body]

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
         
http://bugs.kde.org/show_bug.cgi?id=104881         
           Summary: Memory leak after database query error
           Product: amarok
           Version: unspecified
          Platform: unspecified
        OS/Version: Linux
            Status: NEW
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: amarok-bugs-dist lists sourceforge net
        ReportedBy: greg gkmweb com


Version:           CVS (using KDE KDE 3.4.0)
Installed from:    Unlisted Binary Package
Compiler:          GCC 3.4.3 
OS:                Linux

I have run into a rather nasty memory leak that I first thought was related to mysql, \
but now appears to affect sqlite too.  Running amarokapp in gdb, I see a query error, \
and then the program immediately starts gobbling memory and crashes the machine in \
short order.

Here is the error when using mysql:

amarok: [CollectionDB] MYSQL QUERY FAILED: You have an error in your SQL syntax; \
check the manual that corresponds to your MySQL server version for the right syntax \
to use near 'FROM tags,artist,album,genre  WHERE 1 AND album.id=tags.album AND \
                artist.id=tags' at line 1
amarok: FAILED QUERY: SELECT DISTINCT  FROM tags,artist,album,genre  WHERE 1 AND \
album.id=tags.album AND artist.id=tags.artist AND genre.id=tags.genre

Here is the error when using sqlite:

amarok: [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const \
                QString&)]  sqlite3_compile error:
amarok: [CollectionDB] [ERROR!] near "FROM": syntax error
amarok: [CollectionDB] [ERROR!] on query: SELECT DISTINCT  FROM \
tags,artist,album,genre  WHERE 1 AND album.id=tags.album AND artist.id=tags.artist \
AND genre.id=tags.genre


[prev in list] [next in list] [prev in thread] [next in thread]