Re: upgrading soler.d.o

[Florian Weimer <fw@deneb.enyo.de>]

* Salvatore Bonaccorso:

> If one tries to access the JSON format url this triggers the issue.

Thanks for isolating the issue and providing a test case.  I can
reproduce locally.  It may not be a memory leak, but a change in the
SQLite query planner.

The problematic query appears to be:

SELECT sp.name, st.bug_name,
                (SELECT cve_desc FROM nvd_data
                WHERE cve_name = st.bug_name),
                (SELECT debian_cve.bug FROM debian_cve
                WHERE debian_cve.bug_name = st.bug_name
                ORDER BY debian_cve.bug),
                sp.release, sp.subrelease,
                sp.version,
                (SELECT pn.fixed_version FROM package_notes AS pn
                WHERE pn.bug_name = st.bug_name
                AND pn.package = sp.name AND
                (pn.release = sp.release OR (pn.release = '' AND fixed_version != ''))),
                st.vulnerable, st.urgency,
                (SELECT range_remote FROM nvd_data
                WHERE cve_name = st.bug_name),
                (SELECT comment FROM package_notes_nodsa AS nd
                WHERE nd.package = sp.name AND nd.release = sp.release
                AND nd.bug_name = st.bug_name) AS nodsa
                FROM source_package_status AS st, source_packages AS sp, bugs
                WHERE sp.rowid = st.package AND st.bug_name = bugs.name
                AND ( st.bug_name LIKE 'CVE-%' OR st.bug_name LIKE 'TEMP-%' )
                AND ( sp.release = ? OR sp.release = ? OR sp.release = ?
                OR sp.release = ? OR sp.release = ? )
                ORDER BY sp.name, st.bug_name, sp.release, sp.subrelease


I hope to debug this later today.