7 Nov
2019
7 Nov
'19
2:05 p.m.
Somehow osmo-hlr is no longer building in OBS for a variety of targets
--
- Harald Welte <laforge(a)osmocom.org> http://laforge.gnumonks.org/
============================================================================
"Privacy in residential applications is a desirable marketing option."
(ETSI EN 300 175-7 Ch. A6)
7 Nov
7 Nov
2:56 p.m.
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.
12 Nov
12 Nov
7:53 a.m.
On Thu, Nov 07, 2019 at 08:56:28PM +0700, Vadim Yanitskiy wrote:
Hi Harald, Neels,
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
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') ..." 
1:43 p.m.
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:
--
- Oliver Smith <osmith(a)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
Hi Harald, Neels,
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
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') ..."
1639
days inactive
1644
days old
3 comments
4 participants
participants (4)
-
Harald Welte -
Neels Hofmeyr -
Oliver Smith -
Vadim Yanitskiy