cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Visitor
Visitor
477 Views
Registered: ‎05-17-2018

petalinux-config error: sqlite3.OperationalError: no such table: BB_URI_HEADREVS

Jump to solution

Hi all,

I am a newbie to petalinux. And I recently meet a error after exiting mainmenu for petalinux-config.

 

[INFO] generating Kconfig for project
INFO: [Hsi 55-1698] elapsed time for repository loading 1 seconds
hsi::open_hw_design: Time (s): cpu = 00:00:07 ; elapsed = 00:00:17 . Memory (MB): peak = 574.348 ; gain = 143.707 ; free physical = 4586 ; free virtual = 337921
[INFO] menuconfig project
[INFO] sourcing bitbake
SDK environment now set up; additionally you may now run devtool to perform development tasks.
Run devtool --help for further details.
You had no conf/local.conf file. This configuration file has therefore been
created for you with some default values. You may wish to edit it to, for
example, select a different MACHINE (target hardware). See conf/local.conf
for more information as common configuration options are commented.

You had no conf/bblayers.conf file. This configuration file has therefore been
created for you with some default values. To add additional metadata layers
into your configuration please add entries to conf/bblayers.conf.

The Yocto Project has extensive documentation about OE including a reference
manual which can be found at:
    http://yoctoproject.org/documentation

For more information about OpenEmbedded see their website:
    http://www.openembedded.org/


### Shell environment set up for builds. ###

You can now run 'bitbake <target>'

INFO: Adding user layer: /work/project/project.sdk/petalinux_test0/project-spec/meta-user
ERROR: Error parsing configuration files
Traceback (most recent call last):
  File "/work/Xilinx/petalinux/2017.4/components/yocto/source/aarch64/layers/core/bitbake/lib/bb/cookerdata.py", line 268, in parseBaseConfiguration
    bb.fetch.fetcher_init(self.data)
  File "/work/Xilinx/petalinux/2017.4/components/yocto/source/aarch64/layers/core/bitbake/lib/bb/fetch2/__init__.py", line 504, in fetcher_init
    revs.clear()
  File "/work/Xilinx/petalinux/2017.4/components/yocto/source/aarch64/layers/core/bitbake/lib/bb/persist_data.py", line 147, in clear
    self._execute("DELETE FROM %s;" % self.table)
  File "/work/Xilinx/petalinux/2017.4/components/yocto/source/aarch64/layers/core/bitbake/lib/bb/persist_data.py", line 66, in _execute
    return self.cursor.execute(*query)
sqlite3.OperationalError: no such table: BB_URI_HEADREVS
ERROR: Failed to add user layer: /work/project/project.sdk/petalinux_test0/project-spec/meta-user
ERROR: Failed to source bitbake

 

I installed petalinux tools (2017.4 / 2018.3 / 2019.1) on a server. They were always generating BOOT.BIN before the server was upgraded.

But when I recently try to petalinux-config a hdf with a corresponding petalinux version, the error message "sqlite3.OperationalError: no such table: BB_URI_HEADREVS" always pop up.

Any suggestion? More information needed?

Thank you.

0 Kudos
1 Solution

Accepted Solutions
Highlighted
Visitor
Visitor
362 Views
Registered: ‎05-17-2018

Thanks @eliezer 

I actually commented the clear() in the script and then petalinux-build then uncommented back.

No error shown anymore.

Thanks a lot for every help.

View solution in original post

0 Kudos
3 Replies
Highlighted
Explorer
Explorer
396 Views
Registered: ‎03-21-2019
ERROR: Failed to source bitbake

Might want to look into this error before anything else

0 Kudos
Highlighted
Visitor
Visitor
363 Views
Registered: ‎05-17-2018

Thanks @eliezer 

I actually commented the clear() in the script and then petalinux-build then uncommented back.

No error shown anymore.

Thanks a lot for every help.

View solution in original post

0 Kudos
Highlighted
Observer
Observer
171 Views
Registered: ‎07-01-2019

In which script did you comment out "clear()"? And was it petalinux-build or petalinux-config that you ran after doing this?

I'm up to about six scripts that need this fix now - a single script isn't going to do it.

I'm looking for where the sqlite3 table is set up to begin with - why is this table not included in the database?

Modified the petalinux-v2019.2-final/components/yocto/source/aarch64/layers/core/bitbake/lib/bb/fetch2/__init__.py script as follows: 

try:
    revs.clear()
except sqlite3.OperationalError as exc:
    print("revs.clear() %s" % str(exc))

And I seem to have gotten past it...

0 Kudos