Device doesn't appear into the devices list

[PastaGringo]

Thanks for the answer @pipex.

The apiEndpoint is well configured :

"apiEndpoint": "https://api.openbalena.mydomain.com"

Here is the supervisor log output get by the command journalctl --follow --unit=resin-supervisor:

root@3ae97dc:~# journalctl --follow --unit=resin-supervisor -- Logs begin at Mon 2020-05-11 13:18:42 UTC. -- Jul 15 22:52:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}} Jul 15 22:52:42 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap {} Jul 15 22:52:42 3ae97dc resin-supervisor[2047]: [info] New device detected. Provisioning... Jul 15 22:52:42 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}} Jul 15 22:53:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap {} Jul 15 22:53:12 3ae97dc resin-supervisor[2047]: [info] New device detected. Provisioning... Jul 15 22:53:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}} Jul 15 22:53:42 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap {} Jul 15 22:53:42 3ae97dc resin-supervisor[2047]: [info] New device detected. Provisioning... Jul 15 22:53:42 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}} Jul 15 22:54:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap {} Jul 15 22:54:12 3ae97dc resin-supervisor[2047]: [info] New device detected. Provisioning... Jul 15 22:54:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}} Jul 15 22:54:42 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap {} Jul 15 22:54:42 3ae97dc resin-supervisor[2047]: [info] New device detected. Provisioning... Jul 15 22:54:42 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}} Jul 15 22:55:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap {} Jul 15 22:55:12 3ae97dc resin-supervisor[2047]: [info] New device detected. Provisioning... Jul 15 22:55:12 3ae97dc resin-supervisor[2047]: [event] Event: Device bootstrap failed, retrying {"delay":30000,"error":{"message":"User ID must be a valid integer","stack":"Error: User ID must be a valid integer\n at /usr/src/app/dist/[app.js:2:2630094](http://app.js:2:2630094/)\n at [PassThroughHandlerContext.finallyHandler](http://passthroughhandlercontext.finallyhandler/) (/usr/src/app/dist/[app.js:2:1748917)](http://app.js:2:1748917)/)\n at [PassThroughHandlerContext.tryCatcher](http://passthroughhandlercontext.trycatcher/) (/usr/src/app/dist/[app.js:2:220284)](http://app.js:2:220284)/)\n at [Promise._settlePromiseFromHandler](http://promise._settlepromisefromhandler/) (/usr/src/app/dist/[app.js:2:1708447)](http://app.js:2:1708447)/)\n at [Promise._settlePromise](http://promise._settlepromise/) (/usr/src/app/dist/[app.js:2:1709730)](http://app.js:2:1709730)/)\n at [Promise._settlePromise0](http://promise._settlepromise0/) (/usr/src/app/dist/[app.js:2:1710770)](http://app.js:2:1710770)/)\n at [Promise._settlePromises](http://promise._settlepromises/) (/usr/src/app/dist/[app.js:2:1712478)](http://app.js:2:1712478)/)\n at _drainQueueStep (/usr/src/app/dist/[app.js:2:1715412)](http://app.js:2:1715412)/)\n at _drainQueue (/usr/src/app/dist/[app.js:2:1715308)](http://app.js:2:1715308)/)\n at [Async._drainQueues](http://async._drainqueues/) (/usr/src/app/dist/[app.js:2:1716625)](http://app.js:2:1716625)/)\n at [Immediate.Async.drainQueues](http://immediate.async.drainqueues/) [as _onImmediate] (/usr/src/app/dist/[app.js:2:1715217)](http://app.js:2:1715217)/)\n at processImmediate (internal/[timers.js:456:21)](http://timers.js:456:21)/)"}}

I’m currently checking these two topics because I found the “User ID must be a valid integer” sentence into :

Device can't register with API

I also created another topic about update - open-balena-api v0.76.3 sql migrations My current versions: cat compose/versions export OPENBALENA_API_VERSION_TAG=v0.19.5 #export OPENBALENA_API_VERSION_TAG=v0.48.1 #export OPENBALENA_API_VERSION_TAG=v0.66.0 export OPENBALENA_DB_VERSION_TAG=latest export OPENBALENA_MDNS_PUBLISHER_VERSION_TAG=v1.7.6 export OPENBALENA_REGISTRY_VERSION_TAG=v2.11.1 #export OPENBALENA_REGISTRY_VERSION_TAG=v2.13.7 export OPENBALENA_S3_VERSION_TAG=v2.9.6 export OP…

open-balena-api v0.76.3 sql migrations

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”: { “$select”: { “properties”: [ { “name”: “id”, “property”: null, “count”: null }, { “name”: “app_name”, “property”: null, “count”: null }, { “name”: “slug”, “property”: null, “count”: null …

I’m currenlty finding how to downgrade supervisor because it seems to resolve the issue : open-balena-api v0.76.3 sql migrations - #32 by mad666