Hi there. I’m trying to use latest API and I found DB issues when calling balena apps. Parsing GET /resin/my_application?$orderby=app_name%20asc&$select=id,app_name,slug,device_type&$expand=owns__device($select=is_online) Failed to translate url: { “resource”: “my_application”, “options”: { “$…

Hi there, I think the error happens because you are referencing device_type, but the actual field’s name is is_for__device_type. Try that and let us know if it works.

[image] sradevski: and Actually - I just bump api container version and run ./scripts/compose up -d

No, I used default container from open-balena v2.0.2 OPENBALENA_API_VERSION_TAG=v0.19.5 Later I updated version to the v0.76.3 and found migrations problem

Can anyone tell me exact versions of API, DB, S3, Registry, supervisor and CLI Which are tested and compatible?

The versions described here are tested and compatible: https://github.com/balena-io/open-balena/blob/master/compose/versions and the supervisor version v10.8.0 should work with these. The CLI version shouldn’t really make a difference, just anything recent. The more recent supervisor v11 makes some …

yep, but they don’t work with latest supervisor since v11.3.8 - please take a look into another topic I opened - Device can't register with API Initially, everything I’ve done according to official instructions and issues I faced/found was posted here(in forum threads).

Could you specify the migrations problems that you’re referencing please? We have two options (with the other thread in mind). Downgrade the supervisor to v10.8.0 and use the specified versions from open-balena, or we upgrade your API. Upgrading the API is more future proof so let’s try that. Basic…

After I changed API version in compose file and applied compose up -d, new API started and failed: ay 29 01:13:13 b58d2dc157d6 api[999]: Running node-supervisor with May 29 01:13:13 b58d2dc157d6 api[999]: program ‘index.js’ May 29 01:13:13 b58d2dc157d6 api[999]: --watch ‘src’ May 29 01:13:13…

DB container log: b_1 | 2020-05-29 01:13:16.729 UTC [31] ERROR: relation “uniq_model_model_type_vocab” already exists db_1 | 2020-05-29 01:13:16.729 UTC [31] STATEMENT: CREATE UNIQUE INDEX “uniq_model_model_type_vocab” ON “model” (“is of-vocabulary”, “mode…

open-balena-api v0.76.3 sql migrations

openBalena

sradevski May 27, 2020, 9:37am 5

Hey there, I didn’t understand, did bumping the container resolve your issue?

Topic		Replies	Views
Fixed - OpenBalena API Migration Issues (v0.209.2 --> v14.3.6) openBalena support	7	530	August 26, 2024
Device doesn't appear into the devices list openBalena	16	1312	July 21, 2020
Updating OpenBalena certificates failed openBalena	12	287	May 28, 2024
openBalena 2024 openBalena	9	763	February 28, 2025
version `CXXABI_1.3.9' not found when running 'balena os configure' openBalena	38	3866	August 14, 2020

open-balena-api v0.76.3 sql migrations

Related topics