<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugzilla.yoctoproject.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.6"
          urlbase="https://bugzilla.yoctoproject.org/"
          
          maintainer="it-coreprojects-helpdesk@linuxfoundation.org"
>

    <bug>
          <bug_id>15560</bug_id>
          
          <creation_ts>2024-07-24 12:54:23 +0000</creation_ts>
          <short_desc>Corrupt sqlite database in CVE updates</short_desc>
          <delta_ts>2026-08-27 15:35:45 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>7</classification_id>
          <classification>Build System, Metadata &amp; Runtime</classification>
          <product>OE-Core</product>
          <component>core</component>
          <version>5.0.18</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Multiple</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          <see_also>https://bugzilla.yoctoproject.org/show_bug.cgi?id=15660</see_also>
          <bug_file_loc></bug_file_loc>
          <status_whiteboard>AB-INT</status_whiteboard>
          <keywords></keywords>
          <priority>Medium+</priority>
          <bug_severity>major</bug_severity>
          <target_milestone>5.0.22</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Ross Burton">ross.burton</reporter>
          <assigned_to name="Yoann Congal">yoann.congal</assigned_to>
          <cc>meta.mr.watcher</cc>
    
    <cc>meta.watcher</cc>
    
    <cc>randy.macleod</cc>
    
    <cc>richard.purdie</cc>
    
    <cc>rybczynska</cc>
    
    <cc>steve</cc>
    
    <cc>tim.orling</cc>
    
    <cc>yoann.congal</cc>
          
          
          <cf_os>---</cf_os>
          <cf_regression_type>---</cf_regression_type>
          
          <cf_docchange>No (bug/feature does not impact docs)</cf_docchange>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>99425</commentid>
    <comment_count>0</comment_count>
    <who name="Ross Burton">ross.burton</who>
    <bug_when>2024-07-24 12:54:23 +0000</bug_when>
    <thetext>We&apos;re seeing occasional failures when updating the CVE database due to sqlite corruption:

File: &apos;/home/pokybuild/yocto-worker/oe-selftest-ubuntu/build/meta/classes/cve-check.bbclass&apos;, lineno: 344, function: check_cves
     0340:            vendor = &quot;%&quot;
     0341:
     0342:        # Find all relevant CVE IDs.
     0343:        cve_cursor = conn.execute(&quot;SELECT DISTINCT ID FROM PRODUCTS WHERE PRODUCT IS ? AND VENDOR LIKE ?&quot;, (product, vendor))
 *** 0344:        for cverow in cve_cursor:
     0345:            cve = cverow[0]
     0346:
     0347:            if cve in cve_ignore:
     0348:                bb.note(&quot;%s-%s ignores %s&quot; % (product, pv, cve))
Exception: sqlite3.DatabaseError: database disk image is malformed

https://autobuilder.yoctoproject.org/typhoon/#/builders/87/builds/6974</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>99484</commentid>
    <comment_count>1</comment_count>
    <who name="Steve Sakoman">steve</who>
    <bug_when>2024-08-01 14:54:13 +0000</bug_when>
    <thetext>kirkstone:

https://autobuilder.yoctoproject.org/typhoon/#/builders/87/builds/7019/steps/14/logs/stdio
oe-selftest-ubuntu ubuntu2204-ty-1</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>99519</commentid>
    <comment_count>2</comment_count>
    <who name="Randy MacLeod">randy.macleod</who>
    <bug_when>2024-08-08 14:39:00 +0000</bug_when>
    <thetext>There&apos;s a patch to copy the sqlite file from NFS to a local FS.
Waiting to see if that fixes the problem...</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>99567</commentid>
    <comment_count>3</comment_count>
    <who name="Richard Purdie">richard.purdie</who>
    <bug_when>2024-08-22 14:56:42 +0000</bug_when>
    <thetext>We&apos;re going to assume this fixes it: https://git.yoctoproject.org/poky/commit/?id=0731d49014cae5615c434534554f670090a519f9</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>105989</commentid>
    <comment_count>4</comment_count>
    <who name="Yoann Congal">yoann.congal</who>
    <bug_when>2026-06-23 09:40:15 +0000</bug_when>
    <thetext>oe-selftest-armhost ubuntu2404-vk-arm1 scarthgap completed at 2026-06-23 09:31:22+00:00
https://autobuilder.yoctoproject.org/valkyrie/#/builders/23/builds/4183

Reopening and attributing to me to track the backporting of the alleged fix:
cve_check: Use a local copy of the database during builds
https://git.yoctoproject.org/poky/commit/?id=0731d49014cae5615c434534554f670090a519f9</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>106388</commentid>
    <comment_count>5</comment_count>
    <who name="Randy MacLeod">randy.macleod</who>
    <bug_when>2026-07-30 15:08:52 +0000</bug_when>
    <thetext>Need to backport commit in to EOL releases that are still being used to generate metrics

https://bugzilla.yoctoproject.org/show_bug.cgi?id=15560#c3

and one other commit...</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>106395</commentid>
    <comment_count>6</comment_count>
    <who name="Yoann Congal">yoann.congal</who>
    <bug_when>2026-07-30 23:26:05 +0000</bug_when>
    <thetext>I&apos;ve sent patches:
* [OE-core][dunfell 0/2] Pull request
  https://lore.kernel.org/openembedded-core/cover.1785450470.git.yoann.congal@smile.fr/T/#t
* [OE-core][kirkstone 0/1] Pull request
  https://lore.kernel.org/openembedded-core/cover.1785453214.git.yoann.congal@smile.fr/T/#t
* scarthgap, whinlatter &amp; wrynose already have the patches.

Per https://git.yoctoproject.org/yocto-autobuilder2/tree/schedulers.py#n677 those are the only stable that run metrics.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>106661</commentid>
    <comment_count>7</comment_count>
    <who name="Yoann Congal">yoann.congal</who>
    <bug_when>2026-08-27 15:35:45 +0000</bug_when>
    <thetext>Merged:
* https://git.openembedded.org/openembedded-core/commit/?h=kirkstone&amp;id=9687b9409d3a1e121f0f04de856055764d0a392e
* https://git.openembedded.org/openembedded-core/commit/?h=dunfell&amp;id=1e668895f80725cb4102d000c879d57464757cc1

Closing</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>