[release] LoRa Server 0.22.0 & LoRa App Server 0.14.x (read carefully!)

lazyxwq · November 21, 2017, 2:57am

hi brocaar, I successfully upgraded, but it have a Error when i running lora-app-server.
what’t mean in this Error?

➜  lora-app-server git:(master) ✗ ./start.sh 
INFO[0000] starting LoRa App Server                      docs="https://docs.loraserver.io/" version=0.14.2
INFO[0000] connecting to postgresql                     
INFO[0000] setup redis connection pool                  
INFO[0000] handler/mqtt: connecting to mqtt broker       server="tcp://localhost:1883"
INFO[0000] applying database migrations                 
INFO[0000] handler/mqtt: connected to mqtt broker       
INFO[0000] handler/mqtt: subscribling to tx topic        topic="application/+/node/+/tx"
INFO[0000] migrations applied                            count=0
ERRO[0000] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0000] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0002] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0002] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0004] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0004] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0006] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0006] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0008] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0008] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0010] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0010] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0012] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0012] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0014] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0014] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"

this is my start scripts

#!/bin/bash

sudo systemctl stop lora-app-server.service
./build/lora-app-server \
    --postgres-dsn="postgres://loraserver_as:dbpassword@localhost/loraserver_as?sslmode=disable" \
    --db-automigrate=true \
    --redis-url="redis://localhost:6379/1" \
    --mqtt-server="tcp://localhost:1883" \
    --mqtt-username="loraappserver" \
    --mqtt-password="mqtt" \
    --bind="0.0.0.0:8001" \
    --http-bind="0.0.0.0:8080" \
    --http-tls-cert="/etc/lora-app-server/certs/http.pem" \
    --http-tls-key="/etc/lora-app-server/certs/http-key.pem" \
    --jwt-secret="c6xTHkE4lsqtjoX8B2LWjsfaEqmtJffIN8qp3tC9H5c=" \
    --ns-server="127.0.0.1:8000" \
    --log-level=5

brocaar · November 21, 2017, 8:34am

It seems that you didn’t upgrade loraserver yet, or at least that the database migrations were not applied.

pq: relation “routing_profile” does not exist"

lazyxwq · November 21, 2017, 8:40am

I already upgraded loraserver, and backup the database.

how to migrations database for posgtresql?

brocaar · November 21, 2017, 8:49am

Also with the --db-automigrate=true flag.

Make sure you see something like this in the loraserver logs:

INFO[0000] applying database migrations

lazyxwq · November 21, 2017, 8:55am

yes, I always set the --db-automigrate flag to be true, and I can see the logs:

INFO[0000] applying database migrations                 
INFO[0000] handler/mqtt: connected to mqtt broker       
INFO[0000] handler/mqtt: subscribling to tx topic        topic="application/+/node/+/tx"
INFO[0000] migrations applied                            count=0
INFO[0000] ns-server=127.0.0.1:8000                     
ERRO[0000] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0000] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
INFO[0002] ns-server=127.0.0.1:8000                     
ERRO[0002] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0002] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"

brocaar · November 21, 2017, 9:09am

Please note that these are the logs of LoRa App Server, not LoRa Server.

lazyxwq · November 21, 2017, 9:46am

, you are right, I don’t set the --db-automigrate flag on LoRa Serve.

brocaar · November 21, 2017, 9:47am

Please let us know if that solved the issue

lazyxwq · November 21, 2017, 10:02am

sure, make sure we already upgraded LoRa Server and LoRa App Server.

If re-restart the LoRa Server and LoRa App Server, and see these Error logs of LoRa App Server

INFO[0000] starting LoRa App Server                      docs="https://docs.loraserver.io/" version=0.14.2
INFO[0000] connecting to postgresql                     
INFO[0000] setup redis connection pool                  
INFO[0000] handler/mqtt: connecting to mqtt broker       server="tcp://localhost:1883"
INFO[0000] applying database migrations                 
INFO[0000] handler/mqtt: connected to mqtt broker       
INFO[0000] handler/mqtt: subscribling to tx topic        topic="application/+/node/+/tx"
INFO[0000] migrations applied                            count=0
ERRO[0000] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0000] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0002] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0002] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0004] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0004] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0006] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0006] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0008] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0008] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0010] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0010] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0012] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0012] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0014] network-server create routing-profile api error  error="rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"
ERRO[0014] profiles migration failed                     error="create network-server error: create routing-profile error: rpc error: code = Unknown desc = pq: relation "routing_profile" does not exist"

So how to fix it, we need to migrations database for posgtresql, we need to set the --db-automigrate=true flag on LoRa Server and LoRa App Server. Okay we successfully migrations database.

If have this Error logs on LoRa Server, we need to restart the Redis service.

ERRO[0123] backend/gateway: acquire uplink payload lock error: MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk. Commands that may modify the data set are disabled. Please check Redis logs for details about the error.

alexanderplanar · November 21, 2017, 10:47am

It seems to be works fine after upgrading.

Note: Upgraded from 0.13 and 0.21 versions.

David · January 19, 2018, 8:40am

Hey Brocaar, after instaling the .deb files manually, it broke my apt-get update and upgrade. I had to run sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 1CE2AFD36DBCCA00 to remedy the error. Now no problems. Just keeping you informed.

brocaar · January 19, 2018, 9:54am

That is probably since your OS had to update my key (for which I extended the expiration date as its original expiration date was due). See also: https://keyserver.ubuntu.com/pks/lookup?op=vindex&search=0x1CE2AFD36DBCCA00&fingerprint=on

Q_Lion · January 19, 2018, 8:26pm

Hi

is the Upgrade still available on Ubuntu repo’s?

Fetched 40.6 MB in 1s (28.6 MB/s)
E: Failed to fetch https://repos.loraserver.io/ubuntu/pool/testing/l/lora-app-server/lora-app-server_0.16.0_amd64.deb 404 Not Found

E: Failed to fetch https://repos.loraserver.io/ubuntu/pool/testing/l/loraserver/loraserver_0.23.1_amd64.deb 404 Not Found

brocaar · January 20, 2018, 4:06pm

The apt repo only has the latest version. You need to do a apt update.