Can not start app server into kubernetes env

Setup and configuration
1

Logs from app server pod log:

time=“2021-04-05T17:40:54Z” level=fatal msg=“setup storage error: storage: applying PostgreSQL data migrations error: pq: invalid byte sequence for encoding “UTF8”: 0x00 handling 0046_devaddr_appskey_to_device.sql”

I tried few versions of pgsql and app server from latest to 3.10 and got same error every time.

I follow yamls from here:

and here:

with same result please can you advise what should i change.

Thank you.

2

We moved the repository to: https://gitlab.com/wobcom/iot/chirpstack-helm
But that should not be your issue, did you try a fresh DB every time you tested a new version?

3

You still need to provide a database properly configured:

AS:

-- create the chirpstack_as user
create role chirpstack_as with login password 'dbpassword';

-- create the chirpstack_as database
create database chirpstack_as with owner chirpstack_as;

-- enable the trigram and hstore extensions
\c chirpstack_as
create extension pg_trgm;
create extension hstore;

-- exit the prompt
\q

If using Zalando’s Postgresql Operator:

apiVersion: "acid.zalan.do/v1"
kind: postgresql
metadata:
  name: chirpstack-as-postgres
  namespace: chirpstack
spec:
  teamId: "chirpstack"
  volume:
    size: 5Gi
  numberOfInstances: 1
  preparedDatabases:
    chirpas:
      defaultUsers: true
      extensions:
        pg_trgm: public
        hstore: public
  postgresql:
    version: "12"

NS:

-- create the chirpstack_ns user with password 'dbpassword'
create role chirpstack_ns with login password 'dbpassword';

-- create the chirpstack_ns database
create database chirpstack_ns with owner chirpstack_ns;

-- exit the prompt
\q

If using Zalando’s Postgresql Operator:

---
apiVersion: "acid.zalan.do/v1"
kind: postgresql
metadata:
  name: chirpstack-ns-postgres
  namespace: chirpstack
spec:
  teamId: "chirpstack"
  volume:
    size: 5Gi
  numberOfInstances: 1
  preparedDatabases:
    chirpns:
      defaultUsers: true
  postgresql:
    version: "12"