Build failures of network:osmocom:nightly/osmo-hlr
Somehow osmo-hlr is no longer building in OBS for a variety of targets -- - Harald Welte <laforge@osmocom.org> http://laforge.gnumonks.org/ ============================================================================ "Privacy in residential applications is a desirable marketing option." (ETSI EN 300 175-7 Ch. A6)
Hi Harald, Neels,
Somehow osmo-hlr is no longer building in OBS for a variety of targets
I also faced this problem on my machine. This particular line in db_upgrade_test.sh: echo sqlite3 -header "$db_file" "SELECT ... FROM PRAGMA_TABLE_INFO('$table') ..." seems to be the culprit. Old SQLite3 versions like 3.8.2 raise a "Syntax error". With best regards, Vadim Yanitskiy.
On Thu, Nov 07, 2019 at 08:56:28PM +0700, Vadim Yanitskiy wrote:
Hi Harald, Neels,
Somehow osmo-hlr is no longer building in OBS for a variety of targets
I also faced this problem on my machine. This particular line in db_upgrade_test.sh:
echo sqlite3 -header "$db_file" "SELECT ... FROM PRAGMA_TABLE_INFO('$table') ..."
Just want to note that I see this, but am not sure how to resolve. One way could be to use sqldiff instead of extracting an alphabetically sorted DB schema? not sure if that would work. The other could be to find backwards compatible way of doing that PRAGMA_TABLE_INFO stuff, which I basically duckducked from the internet and have no idea about otherwise. The other other solution is to require a newer sqlite version on the build slaves?? But I think it is worth the effort to have and keep such a DB equivalence test. ~N
Let's skip the check for old sqlite versions: https://gerrit.osmocom.org/c/osmo-hlr/+/16048 On 11/12/19 7:53 AM, Neels Hofmeyr wrote:
On Thu, Nov 07, 2019 at 08:56:28PM +0700, Vadim Yanitskiy wrote:
Hi Harald, Neels,
Somehow osmo-hlr is no longer building in OBS for a variety of targets
I also faced this problem on my machine. This particular line in db_upgrade_test.sh:
echo sqlite3 -header "$db_file" "SELECT ... FROM PRAGMA_TABLE_INFO('$table') ..."
Just want to note that I see this, but am not sure how to resolve. One way could be to use sqldiff instead of extracting an alphabetically sorted DB schema? not sure if that would work.
The other could be to find backwards compatible way of doing that PRAGMA_TABLE_INFO stuff, which I basically duckducked from the internet and have no idea about otherwise.
The other other solution is to require a newer sqlite version on the build slaves??
But I think it is worth the effort to have and keep such a DB equivalence test.
~N
-- - Oliver Smith <osmith@sysmocom.de> https://www.sysmocom.de/ ======================================================================= * sysmocom - systems for mobile communications GmbH * Alt-Moabit 93 * 10559 Berlin, Germany * Sitz / Registered office: Berlin, HRB 134158 B * Geschaeftsfuehrer / Managing Director: Harald Welte
participants (4)
-
Harald Welte -
Neels Hofmeyr -
Oliver Smith -
Vadim Yanitskiy