Error when trying to view OTAA keys for a device

ChirpStack (v4)
1

In the UI, if I try to view the OTAA keys for a device, an error window pops up with:
“multi-dimensional arrays are not supported”

And I’m unable to view or modify the APPKEY.

I have several v4 instances running, and this is the only one with this behavoir.

Has anyone seen this before? Any ideas on what is going on?

2

Never seen this before, I’d be curious what happens if you try to pull the keys using gRPC API:
https://www.chirpstack.io/docs/chirpstack/api/api.html#api-GetDeviceKeysRequest

Might be able to fix it using updateDeviceKeys request:

https://www.chirpstack.io/docs/chirpstack/api/api.html#api-UpdateDeviceKeysRequest

Although chances are these just fail in error too.

Is it with every device or just one?

3

Failing with every device.

4

Both of these API calls fail.

5

Something wrong with your pSQL database then. Did you do Docker or ubuntu install?

6

It seems like something was corrupted in the device_keys table, but nothing obvious was wrong. Records could be queried directly from the DB and a full table dump did not reveal any obvious issues.
When an export of the DB to a new installation was performed, the problem persisted.

And update was made to v4.11 of Chirpstack and the problem has gone away.

I’m still unsure why this update fixed the problem - still looking into it.