Dear Brocaar,
I successfully upgraded. Why didnt I get this error message?
Dear Brocaar,
I successfully upgraded. Why didnt I get this error message?
You mean the RxInfo must have...
error message? This only occurred in LoRa App Server 0.14.0 and when Add gateway meta-data was disabled.
yes Brocaar. I see! thanks! No problems from update thus far and system still is very stable.
Thanks for all the feedback guys! I’ve just pushed the .deb
packages to the Debian and Ubuntu repositories so you can now upgrade to the latest version as usual by apt update && apt upgrade
I just updated trough .deb packages.
I expected new menu’s because of the update but found nothing of that.
Also a complet reinstall did not ake that happen.
Did I miss something?
Ok, it seems solved now: I had to refresh the cache of my browser.
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
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"
I already upgraded loraserver, and backup the database.
how to migrations database for posgtresql?
Also with the --db-automigrate=true
flag.
Make sure you see something like this in the loraserver logs:
INFO[0000] applying database migrations
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"
Please note that these are the logs of LoRa App Server, not LoRa Server.
, you are right, I don’t set the --db-automigrate flag on LoRa Serve.
Please let us know if that solved the issue
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.
It seems to be works fine after upgrading.
Note: Upgraded from 0.13 and 0.21 versions.
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.
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
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
The apt repo only has the latest version. You need to do a apt update
.