Bug 14887

Summary: do_cve_check failure: Exception: sqlite3.OperationalError: database is locked
Product: [Build System, Metadata & Runtime] OE-Core Reporter: Alexandre Belloni <alexandre.belloni>
Component: coreAssignee: Joshua Watt <JPEWhacker>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: Medium+ CC: alexandre.belloni, JPEWhacker, luca.ceresoli, meta.mr.watcher, meta.watcher, randy.macleod
Version: unspecified   
Target Milestone: 4.1 M4   
Hardware: x86   
OS: Multiple   
Whiteboard: AB-INT
OS type for building Yocto: --- Type of Regression: ---
Verified: Documentation change: No (bug/feature does not impact docs)

Description Alexandre Belloni 2022-08-12 10:10:41 UTC
https://autobuilder.yoctoproject.org/typhoon/#/builders/56/builds/1930/steps/14/logs/stdio

ERROR: libdnf-native-0.67.0-r0 do_cve_check: Error executing a python function in exec_func_python() autogenerated:
The stack trace of python calls that resulted in this exception/failure was:
File: 'exec_func_python() autogenerated', lineno: 2, function: <module>
     0001:
 *** 0002:do_cve_check(d)
     0003:
File: '/home/pokybuild/yocto-worker/oe-selftest/build/meta/classes/cve-check.bbclass', lineno: 147, function: do_cve_check
     0143:        try:
     0144:            patched_cves = get_patched_cves(d)
     0145:        except FileNotFoundError:
     0146:            bb.fatal("Failure in searching patches")
 *** 0147:        ignored, patched, unpatched, status = check_cves(d, patched_cves)
     0148:        if patched or unpatched or (d.getVar("CVE_CHECK_COVERAGE") == "1" and status):
     0149:            cve_data = get_cve_info(d, patched + unpatched + ignored)
     0150:            cve_write_data(d, patched, unpatched, ignored, cve_data, status)
     0151:    else:
File: '/home/pokybuild/yocto-worker/oe-selftest/build/meta/classes/cve-check.bbclass', lineno: 312, function: check_cves
     0308:
     0309:            vulnerable = False
     0310:            ignored = False
     0311:
 *** 0312:            for row in conn.execute("SELECT * FROM PRODUCTS WHERE ID IS ? AND PRODUCT IS ? AND VENDOR LIKE ?", (cve, product, vendor)):
     0313:                (_, _, _, version_start, operator_start, version_end, operator_end) = row
     0314:                #bb.debug(2, "Evaluating row " + str(row))
     0315:                if cve in cve_ignore:
     0316:                    ignored = True
Exception: sqlite3.OperationalError: database is locked
Comment 1 Richard Purdie 2022-08-18 14:38:00 UTC
*** Bug 14894 has been marked as a duplicate of this bug. ***
Comment 3 Alexandre Belloni 2022-08-25 12:55:52 UTC
https://autobuilder.yoctoproject.org/typhoon/#/builders/127/builds/7/steps/14/logs/stdio


oe-selftest-armhost ubuntu2004-arm-1
Comment 4 Alexandre Belloni 2022-08-25 12:58:46 UTC
https://autobuilder.yoctoproject.org/typhoon/#builders/127/builds/13/steps/14/logs/stdio

oe-selftest-armhost ubuntu2204-arm-1
Comment 7 Joshua Watt 2022-08-31 18:34:04 UTC
https://lists.openembedded.org/g/openembedded-core/message/170076 should fix this and we can re-open if necessary