Bug 13616

Summary: sql error on recipes using multiple git repos
Product: [Build System, Metadata & Runtime] BitBake Reporter: Jonathan Richardson <jon.richardson>
Component: bitbakeAssignee: Armin Kuster <akuster>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: Medium+ CC: akuster808, poky.bs.watcher, poky.watcher, randy.macleod, richard.purdie, rick.liu, scott.branden
Version: 3.0   
Target Milestone: 3.0.3   
Hardware: x86   
OS: Multiple   
Whiteboard:
OS type for building Yocto: --- Type of Regression: ---
Verified: Documentation change: No (bug/feature does not impact docs)
Attachments:
Description Flags
parse error none

Description Jonathan Richardson 2019-11-06 23:45:43 UTC
Created attachment 4584 [details]
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'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't tell what's wrong. It looks like a bug. If you need the full recipe I can add them.


nitro.inc:

BRCM_NXT-NVM_BRANCH ?= "bcm/master"
BRCM_NXT-NVM_SRCREV ?= "${AUTOREV}"
SRC_URI = "
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"
SRCREV_nxt-nvm = "${BRCM_NXT-NVM_SRCREV}"

BRCM_NXT-UTILS_BRANCH ?= "bcm/master"
BRCM_NXT-UTILS_SRCREV ?= "${AUTOREV}"
SRC_URI +=
"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"
SRCREV_nxt-utils = "${BRCM_NXT-UTILS_SRCREV}"

SRCREV_FORMAT = "nxt-nvm_nxt-utils"


brcm-nitro.bb:

require nitro.inc
PV = "git${SRCPV}"
BRCM_NXT-RELEASE_BRANCH ?= "int_nxt"
BRCM_NXT-RELEASE_SRCREV ?= "${AUTOREV}"
SRC_URI
+="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"
SRCREV_FORMAT_append = "_nxt-release"
SRCREV_nxt-release = "${BRCM_NXT-RELEASE_SRCREV}"


brcm-nitro_nxtrelease214.bb:

require nitro.inc
PV = "nxtrelease214+git${SRCPV}"
BRCM_NXT-RELEASE-214_BRANCH ?= "rel_nxt_214"
BRCM_NXT-RELEASE-214_SRCREV ?= "${AUTOREV}"
SRC_URI
+="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"
SRCREV_FORMAT_append = "_nxt-release-214"
SRCREV_nxt-release-214 = "${BRCM_NXT-RELEASE-214_SRCREV}"


brcm-nitro_nxtrelease216.bb:

require brcm-nitro.inc
PV = "nxtrelease216+git${SRCPV}"
BRCM_NXT-RELEASE-216_BRANCH ?= "int_nxt"
BRCM_NXT-RELEASE-216_SRCREV ?= "${AUTOREV}"
SRC_URI
+="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"
SRCREV_FORMAT_append = "_nxt-release-216"
SRCREV_nxt-release-216 = "${BRCM_NXT-RELEASE-216_SRCREV}"


local.conf:
BRCM_NXT-RELEASE-216_BRANCH = "bcm/stable"
PREFERRED_VERSION_brcm-nitro = "nxtrelease216%"
Comment 1 Richard Purdie 2020-04-23 08:17:37 UTC
Fixed in master, needs backport? http://git.yoctoproject.org/cgit.cgi/poky/commit/?id=1b1a533133e68b1850cd4194d51b53e819fa9183
Comment 2 akuster 2020-05-21 07:33:48 UTC
zeus has fix. warrior needs it.
Comment 4 akuster 2020-05-21 07:35:04 UTC
closing