Hello, we just upgraded to the latest version and started getting an error on start up (these errors are not affecting any functionality). The error seems to come from the fact that it reads

pg_class.reltuples

into an int, but in postgres, it is stored as a `real`/`float4`, which leads to parsing errors.

unable to query DB stats: unable to read relationship count: can't scan into dest[0]: strconv.ParseInt: parsing "1.018981e+06": invalid syntax

Running the SQL command my self, I get:

authz=> SELECT reltuples FROM pg_class WHERE relname = 'relation_tuple';
  reltuples
--------------
 1.018981e+06
(1 row)

Location of the suspected bug: https://github.com/authzed/spicedb/blob/fd2978a1771fa9b09fdfb3ba05ba32bbd4006d69/internal/datastore/postgres/stats.go#L60 SpiceDB: v.1.35.3 Postgres: 16.1

is this the latest SpiceDB version or the latest postgres version or both?

This happened when upgrading to the latest SpiceDB version (1.35.3). Postgres is not on the latest, latest is 16.4

what version of SpiceDB were you previously on? 1.35.2?

1.28.0

lemme write up a bug report

Thanks!

issue here: https://github.com/authzed/spicedb/issues/2045 thanks for reporting!

Awesome, thanks.

fix merged

Great, thanks for the quick fix.