queryNamespaceMappings returned 1 errors

[bliubiu]

1. error info:
   postgres_exporter: time="2020-08-06T10:33:51+08:00" level=error msg="queryNamespaceMappings returned 1 errors" source="postgres_exporter.go:1474"

2. env info:
   postgres_exporter v0.8.0 (built with go1.11)
   psql (PostgreSQL) 12.0
   Red Hat Enterprise Linux Server release 7.6 (Maipo)
   Linux progs 3.10.0-957.el7.x86_64 binary replication montitoring metrics #1 SMP Thu Oct 4 20:48:51 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

[logkaa]

1. error info:
   postgres_exporter: time="2020-08-06T10:33:51+08:00" level=error msg="queryNamespaceMappings returned 1 errors" source="postgres_exporter.go:1474"
2. env info:
   postgres_exporter v0.8.0 (built with go1.11)
   psql (PostgreSQL) 12.0
   Red Hat Enterprise Linux Server release 7.6 (Maipo)
   Linux progs 3.10.0-957.el7.x86_64 binary replication montitoring metrics #1 SMP Thu Oct 4 20:48:51 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

I had the same problem. I solved it by this :
psql -d postgres -U postgres_exporter -c 'ALTER USER postgres_exporter SET SEARCH_PATH TO postgres_exporter, public, pg_catalog;'

[ahasna]

@logkaa Thanks for sharing this . I tried it out but the problem persisted. Any ideas why this is happening at all?