<?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>13616</bug_id>
          
          <creation_ts>2019-11-06 23:45:43 +0000</creation_ts>
          <short_desc>sql error on recipes using multiple git repos</short_desc>
          <delta_ts>2020-05-21 07:35:04 +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>BitBake</product>
          <component>bitbake</component>
          <version>3.0</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Multiple</op_sys>
          <bug_status>CLOSED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium+</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>3.0.3</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Jonathan Richardson">jon.richardson</reporter>
          <assigned_to name="Armin Kuster">akuster</assigned_to>
          <cc>akuster808</cc>
    
    <cc>poky.bs.watcher</cc>
    
    <cc>poky.watcher</cc>
    
    <cc>randy.macleod</cc>
    
    <cc>richard.purdie</cc>
    
    <cc>rick.liu</cc>
    
    <cc>scott.branden</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>85484</commentid>
    <comment_count>0</comment_count>
      <attachid>4584</attachid>
    <who name="Jonathan Richardson">jon.richardson</who>
    <bug_when>2019-11-06 23:45:43 +0000</bug_when>
    <thetext>Created attachment 4584
parse error

Hi,

I posted this on the mailing list but it probably needs a bug report also.

As of warrior release (and zeus) I&apos;m encountering an SQL error (attached)
on a bunch of recipes that use SRCREV_FORMAT and multiple git repos. The
simplified recipes are below. On the build server it happens most of the
time, on my local 32 core machine I rarely see it. The error can occur on
any version of the recipe. I can&apos;t tell what&apos;s wrong. It looks like a bug. If you need the full recipe I can add them.


nitro.inc:

BRCM_NXT-NVM_BRANCH ?= &quot;bcm/master&quot;
BRCM_NXT-NVM_SRCREV ?= &quot;${AUTOREV}&quot;
SRC_URI = &quot;
git://svcccxswgit@git-ccxsw.rtp.broadcom.com/brcm/ctrl/nxt-utils.git;proto
col=ssh;branch=${BRCM_NXT-NVM_BRANCH};nobranch=0;name=nxt-nvm&quot;
SRCREV_nxt-nvm = &quot;${BRCM_NXT-NVM_SRCREV}&quot;

BRCM_NXT-UTILS_BRANCH ?= &quot;bcm/master&quot;
BRCM_NXT-UTILS_SRCREV ?= &quot;${AUTOREV}&quot;
SRC_URI +=
&quot;git://svcccxswgit@git-ccxsw.rtp.broadcom.com/brcm/ctrl/nxt-utils.git;prot
ocol=ssh;branch=${BRCM_NXT-UTILS_BRANCH};nobranch=0;destsuffix=git/nxt-uti
ls;name=nxt-utils&quot;
SRCREV_nxt-utils = &quot;${BRCM_NXT-UTILS_SRCREV}&quot;

SRCREV_FORMAT = &quot;nxt-nvm_nxt-utils&quot;


brcm-nitro.bb:

require nitro.inc
PV = &quot;git${SRCPV}&quot;
BRCM_NXT-RELEASE_BRANCH ?= &quot;int_nxt&quot;
BRCM_NXT-RELEASE_SRCREV ?= &quot;${AUTOREV}&quot;
SRC_URI
+=&quot;git://svcccxswgit@git-ccxsw.rtp.broadcom.com/brcm/ctrl/nxt-release.git;
protocol=ssh;branch=${BRCM_NXT-RELEASE_BRANCH};nobranch=0;destsuffix=git/p
rebuilts/nxt-release;name=nxt-release&quot;
SRCREV_FORMAT_append = &quot;_nxt-release&quot;
SRCREV_nxt-release = &quot;${BRCM_NXT-RELEASE_SRCREV}&quot;


brcm-nitro_nxtrelease214.bb:

require nitro.inc
PV = &quot;nxtrelease214+git${SRCPV}&quot;
BRCM_NXT-RELEASE-214_BRANCH ?= &quot;rel_nxt_214&quot;
BRCM_NXT-RELEASE-214_SRCREV ?= &quot;${AUTOREV}&quot;
SRC_URI
+=&quot;git://svcccxswgit@git-ccxsw.rtp.broadcom.com/brcm/ctrl/nxt-release-214.
git;protocol=ssh;branch=${BRCM_NXT-RELEASE-214_BRANCH};nobranch=0;destsuff
ix=git/prebuilts/nxt-release;name=nxt-release-214&quot;
SRCREV_FORMAT_append = &quot;_nxt-release-214&quot;
SRCREV_nxt-release-214 = &quot;${BRCM_NXT-RELEASE-214_SRCREV}&quot;


brcm-nitro_nxtrelease216.bb:

require brcm-nitro.inc
PV = &quot;nxtrelease216+git${SRCPV}&quot;
BRCM_NXT-RELEASE-216_BRANCH ?= &quot;int_nxt&quot;
BRCM_NXT-RELEASE-216_SRCREV ?= &quot;${AUTOREV}&quot;
SRC_URI
+=&quot;git://svcccxswgit@git-ccxsw.rtp.broadcom.com/brcm/ctrl/nxt-release-216.
git;protocol=ssh;branch=${BRCM_NXT-RELEASE-216_BRANCH};nobranch=0;destsuff
ix=git/prebuilts/nxt-release;name=nxt-release-216&quot;
SRCREV_FORMAT_append = &quot;_nxt-release-216&quot;
SRCREV_nxt-release-216 = &quot;${BRCM_NXT-RELEASE-216_SRCREV}&quot;


local.conf:
BRCM_NXT-RELEASE-216_BRANCH = &quot;bcm/stable&quot;
PREFERRED_VERSION_brcm-nitro = &quot;nxtrelease216%&quot;</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>87077</commentid>
    <comment_count>1</comment_count>
    <who name="Richard Purdie">richard.purdie</who>
    <bug_when>2020-04-23 08:17:37 +0000</bug_when>
    <thetext>Fixed in master, needs backport? http://git.yoctoproject.org/cgit.cgi/poky/commit/?id=1b1a533133e68b1850cd4194d51b53e819fa9183</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>87280</commentid>
    <comment_count>2</comment_count>
    <who name="akuster">akuster808</who>
    <bug_when>2020-05-21 07:33:48 +0000</bug_when>
    <thetext>zeus has fix. warrior needs it.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>87281</commentid>
    <comment_count>3</comment_count>
    <who name="akuster">akuster808</who>
    <bug_when>2020-05-21 07:34:45 +0000</bug_when>
    <thetext>http://git.yoctoproject.org/cgit/cgit.cgi/poky/commit/bitbake/lib/bb/persist_data.py?h=zeus&amp;id=64d62e5d48014af963967e4b5b24553853cb6df3</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>87282</commentid>
    <comment_count>4</comment_count>
    <who name="akuster">akuster808</who>
    <bug_when>2020-05-21 07:35:04 +0000</bug_when>
    <thetext>closing</thetext>
  </long_desc>
      
          <attachment
              isobsolete="0"
              ispatch="0"
              isprivate="0"
          >
            <attachid>4584</attachid>
            <date>2019-11-06 23:45:43 +0000</date>
            <delta_ts>2019-11-06 23:45:43 +0000</delta_ts>
            <desc>parse error</desc>
            <filename>parse-error.txt</filename>
            <type>text/plain</type>
            <size>2620</size>
            <attacher name="Jonathan Richardson">jon.richardson</attacher>
            
              <data encoding="base64">UGFyc2luZyByZWNpcGVzLi4uRVJST1I6IEV4cGFuc2lvbkVycm9yIGR1cmluZyBwYXJzaW5nIC90
bXAveW9jdG9fYnVpbGRzLzEyMzMzNzA3X254cy1uZXh0X3N0aW5ncmF5LWJjbTk1ODc0MmsvcG9r
eS9idWlsZC8uLi9tZXRhLWJyY20vbWV0YS1kYXRhY2VudGVyL3JlY2lwZXMtYnNwL25pdHJvL2Jy
Y20tbml0cm8uYmINClRyYWNlYmFjayAobW9zdCByZWNlbnQgY2FsbCBsYXN0KToNCiAgRmlsZSAi
L3RtcC95b2N0b19idWlsZHMvMTIzMzM3MDdfbnhzLW5leHRfc3RpbmdyYXktYmNtOTU4NzQyay9w
b2t5L2JpdGJha2UvbGliL2JiL2ZldGNoMi9fX2luaXRfXy5weSIsIGxpbmUgMTE2NywgaW4gc3Jj
cmV2X2ludGVybmFsX2hlbHBlcih1ZD08YmIuZmV0Y2gyLkZldGNoRGF0YSBvYmplY3QgYXQgMHg3
ZmQ2M2Y1Yzg0Mzg+LCBkPTxiYi5kYXRhX3NtYXJ0LkRhdGFTbWFydCBvYmplY3QgYXQgMHg3ZmQ2
NDQwMzA5ZTg+LCBuYW1lPSdueHQtbnZtJyk6DQogICAgICAgICBpZiBzcmNyZXYgPT0gIkFVVE9J
TkMiOg0KICAgID4gICAgICAgIHNyY3JldiA9IHVkLm1ldGhvZC5sYXRlc3RfcmV2aXNpb24odWQs
IGQsIG5hbWUpDQoNCiAgRmlsZSAiL3RtcC95b2N0b19idWlsZHMvMTIzMzM3MDdfbnhzLW5leHRf
c3RpbmdyYXktYmNtOTU4NzQyay9wb2t5L2JpdGJha2UvbGliL2JiL2ZldGNoMi9fX2luaXRfXy5w
eSIsIGxpbmUgMTU2MiwgaW4gR2l0LmxhdGVzdF9yZXZpc2lvbih1ZD08YmIuZmV0Y2gyLkZldGNo
RGF0YSBvYmplY3QgYXQgMHg3ZmQ2M2Y1Yzg0Mzg+LCBkPTxiYi5kYXRhX3NtYXJ0LkRhdGFTbWFy
dCBvYmplY3QgYXQgMHg3ZmQ2NDQwMzA5ZTg+LCBuYW1lPSdueHQtbnZtJyk6DQogICAgICAgICAg
ICAgZXhjZXB0IEtleUVycm9yOg0KICAgID4gICAgICAgICAgICByZXZzW2tleV0gPSByZXYgPSBz
ZWxmLl9sYXRlc3RfcmV2aXNpb24odWQsIGQsIG5hbWUpDQogICAgICAgICAgICAgICAgIHJldHVy
biByZXYNCiAgRmlsZSAiL3RtcC95b2N0b19idWlsZHMvMTIzMzM3MDdfbnhzLW5leHRfc3Rpbmdy
YXktYmNtOTU4NzQyay9wb2t5L2JpdGJha2UvbGliL2JiL3BlcnNpc3RfZGF0YS5weSIsIGxpbmUg
NTAsIGluIFNRTFRhYmxlLndyYXBfZnVuYygqYXJncz0oJ2dpdDpnaXQtY2N4c3cucnRwLmJyb2Fk
Y29tLmNvbS5icmNtLmN0cmwubnh0LW52bS5naXRiY20vbWFzdGVyLWJyY20tbml0cm8nLCAnZWE0
MDY3OWE2YmUwM2NkZjdjYzNkZWY3YzdmZjBhOTI3ODI3NThmYicpLCAqKmt3YXJncz17fSk6DQog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRyeToNCiAgICA+ICAgICAgICAgICAgICAgICAg
ICAgICAgICAgIHJldHVybiBmKHNlbGYsICphcmdzLCAqKmt3YXJncykNCiAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgZXhjZXB0IHNxbGl0ZTMuT3BlcmF0aW9uYWxFcnJvciBhcyBleGM6DQog
IEZpbGUgIi90bXAveW9jdG9fYnVpbGRzLzEyMzMzNzA3X254cy1uZXh0X3N0aW5ncmF5LWJjbTk1
ODc0MmsvcG9reS9iaXRiYWtlL2xpYi9iYi9wZXJzaXN0X2RhdGEucHkiLCBsaW5lIDc5LCBpbiBT
UUxUYWJsZS53cmFwX2Z1bmMoKmFyZ3M9KCdnaXQ6Z2l0LWNjeHN3LnJ0cC5icm9hZGNvbS5jb20u
YnJjbS5jdHJsLm54dC1udm0uZ2l0YmNtL21hc3Rlci1icmNtLW5pdHJvJywgJ2VhNDA2NzlhNmJl
MDNjZGY3Y2MzZGVmN2M3ZmYwYTkyNzgyNzU4ZmInKSwgKiprd2FyZ3M9e30pOg0KICAgICAgICAg
ICAgICAgICAgICAgICAgIHdpdGggY29udGV4dGxpYi5jbG9zaW5nKHNlbGYuY29ubmVjdGlvbi5j
dXJzb3IoKSkgYXMgY3Vyc29yOg0KICAgID4gICAgICAgICAgICAgICAgICAgICAgICByZXR1cm4g
ZihzZWxmLCBjdXJzb3IsICphcmdzLCAqKmt3YXJncykNCiAgICAgICAgICAgICAgICAgcmV0dXJu
IHdyYXBfZnVuYw0KICBGaWxlICIvdG1wL3lvY3RvX2J1aWxkcy8xMjMzMzcwN19ueHMtbmV4dF9z
dGluZ3JheS1iY205NTg3NDJrL3Bva3kvYml0YmFrZS9saWIvYmIvcGVyc2lzdF9kYXRhLnB5Iiwg
bGluZSAxODcsIGluIFNRTFRhYmxlLl9fc2V0aXRlbV9fKGN1cnNvcj08c3FsaXRlMy5DdXJzb3Ig
b2JqZWN0IGF0IDB4N2ZkNjQ1MTA2ZWEwPiwga2V5PSdnaXQ6Z2l0LWNjeHN3LnJ0cC5icm9hZGNv
bS5jb20uYnJjbS5jdHJsLm54dC1udm0uZ2l0YmNtL21hc3Rlci1icmNtLW5pdHJvJywgdmFsdWU9
J2VhNDA2NzlhNmJlMDNjZGY3Y2MzZGVmN2M3ZmYwYTkyNzgyNzU4ZmInKToNCiAgICAgICAgICAg
ICBlbHNlOg0KICAgID4gICAgICAgICAgICBjdXJzb3IuZXhlY3V0ZSgiSU5TRVJUIGludG8gJXMo
a2V5LCB2YWx1ZSkgdmFsdWVzICg/LCA/KTsiICUgc2VsZi50YWJsZSwgW2tleSwgdmFsdWVdKQ0K
DQpiYi5kYXRhX3NtYXJ0LkV4cGFuc2lvbkVycm9yOiBGYWlsdXJlIGV4cGFuZGluZyB2YXJpYWJs
ZSBTUkNQViwgZXhwcmVzc2lvbiB3YXMgJHtAYmIuZmV0Y2gyLmdldF9zcmNyZXYoZCl9IHdoaWNo
IHRyaWdnZXJlZCBleGNlcHRpb24gSW50ZWdyaXR5RXJyb3I6IFVOSVFVRSBjb25zdHJhaW50IGZh
aWxlZDogQkJfVVJJX0hFQURSRVZTLmtleQ0KDQoNClN1bW1hcnk6IFRoZXJlIHdhcyAxIEVSUk9S
IG1lc3NhZ2Ugc2hvd24sIHJldHVybmluZyBhIG5vbi16ZXJvIGV4aXQgY29kZS4NCnJjPTI1Ng==
</data>

          </attachment>
      

    </bug>

</bugzilla>