Postgre integration / gw.UplinkRXInfo

miimote · May 26, 2021, 9:49am

I’ve been working with Chirpstack for a couple of months. The postgresql integration has been working like a charm but since yesterday it doesnt work at all. InfluxDB is working fine. I get this error when I do a journalctl over chirpstack application server
…

may 26 11:30:16 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:16.198684724+02:00” level=info msg=“device last-seen and dr updated” ctx_id=9ef5421e-b399-4c40-9eb9-decf1a484125 dev_eui=XXXXXXXXXXXXXXX
may 26 11:30:16 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:16.206954421+02:00” level=info msg=“finished unary call with code OK” ctx_id=9ef5421e-b399-4c40-9eb9-decf1a484125 grpc.code=OK grpc.method=HandleUplinkData grpc.request.deadline=“2021-05-26T11:30:17+02:00” grpc.service=as.ApplicationServerService grpc.start_time=“2021-05-26T11:30:16+02:00” grpc.time_ms=29.476 peer.address="[::1]:34314" span.kind=server system=grpc
may 26 11:30:16 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:16.218292437+02:00” level=info msg=“integration/logger: logging event” ctx_id=9ef5421e-b399-4c40-9eb9-decf1a484125 dev_eui=XXXXXXXXXXXXXXX type=up

may 26 11:30:16 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:16.219994616+02:00” level=error msg=“integration/multi: integration error” ctx_id=9ef5421e-b399-4c40-9eb9-decf1a484125 error=“marshal rx_info error: unknown message type: *gw.UplinkRXInfo” integration="*postgresql.Integration"

may 26 11:30:16 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:16.223032204+02:00” level=info msg=“integration/mqtt: publishing event” ctx_id=9ef5421e-b399-4c40-9eb9-decf1a484125 dev_eui=XXXXXXXXXXXXXXX qos=0 retain=false topic=application/2/device/7c9ebdfc0ad80000/event/up
may 26 11:30:16 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:16.230317636+02:00” level=info msg=“integration/influxdb: uplink measurements written” ctx_id=9ef5421e-b399-4c40-9eb9-decf1a484125 dev_eui=XXXXXXXXXXXXXXX
may 26 11:30:44 rP17 chirpstack-application-server[1194]: time=“2021-05-26T11:30:44.860075352+02:00” level=info msg=“gateway updated” ctx_id=52cd9ab3-e174-450b-900c-ebdba12a05f2 id=YYYYYYYYYYYY name=Dragino_LSP8

…

Can anyone help me?

miimote · May 26, 2021, 10:44am

The join is saved correctly in its table (device_join) but not the uplink message

may 26 12:38:51 rP17 chirpstack-application-server[461]: time=“2021-05-26T12:38:51.512074133+02:00” level=error msg=“integration/multi: integration error” ctx_id=24552353-cc0d-4b1e-8f2b-37c120c15024 error=“marshal rx_info error: unknown message type: *gw.UplinkRXInfo” integration="*postgresql.Integration"

may 26 12:38:51 rP17 chirpstack-application-server[461]: time=“2021-05-26T12:38:51.534816825+02:00” level=info msg=“integration/postgresql: event stored” ctx_id=24552353-cc0d-4b1e-8f2b-37c120c15024 dev_eui=XXXXXXXXXXXXX event=join

miimote · May 26, 2021, 11:22am

The problem may be in the upgrade from chirpstack-application-server from 3.14 to 3.15 in these improvements

PostgreSQL integration improvements

Store confirmed_uplink and dev_addr for uplink. (#579)
Use marshaler configuration when encoding rx_info to JSON.
Add tx_info field for uplinks.
Store txack payloads into PostgreSQL database.

@brocaar May be that some field has been renamed? Could I do a downgrade?

miimote · May 26, 2021, 3:35pm

In chirpstack-application-server.toml, if you have

marshaler=“json_v3”

you will get the related error. You must change to

marshaler=“json”

as it was advised in the comments of configuration file.