Error querying database version while migrating up to 3.1.1

Local Setup
1

Hi,

I am trying to upgrade to the new version but I get an error while trying to migrate the database:

Im am running 2.15.0+668ac667 and trying to upgrade to the latest 3.1.1. Below the output of the “nakama migrate up” command.

sudo nakama migrate up -database.address 'xxxxxx:xxxxx@yyyyyy.xxxxxx.cc:26257/nakama?sslmode=require'

{"level":"info","ts":"2021-02-16T10:49:15.600+0100","caller":"migrate/migrate.go:140","msg":"Database connection","dsn":"postgresql://xxxxxx:xxxxx@yyyyyy.xxxxxx.cc:26257/nakama?sslmode=require"}

{"level":"fatal","ts":"2021-02-16T10:49:16.054+0100","caller":"migrate/migrate.go:153","msg":"Error querying database version","error":"unknown oid: 25, name: version","errorVerbose":"unknown oid: 25, name: version\ngithub.com/jackc/pgx.(*Conn).prepareEx\n\tgithub.com/jackc/pgx@v3.5.0+incompatible/conn.go:1137\ngithub.com/jackc/pgx.(*Conn).PrepareEx\n\tgithub.com/jackc/pgx@v3.5.0+incompatible/conn.go:1065\ngithub.com/jackc/pgx/stdlib.(*Conn).QueryContext\n\tgithub.com/jackc/pgx@v3.5.0+incompatible/stdlib/sql.go:365\ndatabase/sql.ctxDriverQuery\n\tdatabase/sql/ctxutil.go:48\ndatabase/sql.(*DB).queryDC.func1\n\tdatabase/sql/sql.go:1643\ndatabase/sql.withLock\n\tdatabase/sql/sql.go:3284\ndatabase/sql.(*DB).queryDC\n\tdatabase/sql/sql.go:1638\ndatabase/sql.(*DB).query\n\tdatabase/sql/sql.go:1621\ndatabase/sql.(*DB).QueryContext\n\tdatabase/sql/sql.go:1598\ndatabase/sql.(*DB).QueryRowContext\n\tdatabase/sql/sql.go:1699\ndatabase/sql.(*DB).QueryRow\n\tdatabase/sql/sql.go:1710\ngithub.com/heroiclabs/nakama/v3/migrate.Parse\n\tgithub.com/heroiclabs/nakama/v3/migrate/migrate.go:152\nmain.main\n\tgithub.com/heroiclabs/nakama/v3/main.go:79\nruntime.main\n\truntime/proc.go:204\nruntime.goexit\n\truntime/asm_amd64.s:1374"}

Any hints on how to solve this would be welcome

Thanks!

2

Solved it. The user I used did not have admin rights in Cockroach.