Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

invalid input syntax for type json" source="postgres_exporter.go:1356" #4

Open
kumarvijendar opened this issue Apr 19, 2021 · 0 comments

Comments

@kumarvijendar
Copy link

I am trying to use postgres-operator version 4.6.1/4.6.2 with posgtres version 12.6 i'e crunchy-postgres-ha:centos8-12.6-4.6.1 and centos8-12.6-4.6.2.
In both of the versions, when I deploy the cluster and try to check the exporters logs, I get following error.


time="2021-04-19T09:04:59Z" level=error msg="queryNamespaceMappings returned 4 errors" source="postgres_exporter.go:1474"
time="2021-04-19T09:05:59Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_diff_backup pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:07:00Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_incr_backup pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:08:00Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_diff_backup pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:09:00Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_incr_backup pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:10:01Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_info pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:11:01Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_full_backup pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:12:02Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_info pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
time="2021-04-19T09:13:02Z" level=info msg="Error running query on database \"127.0.0.1:5432\": ccp_backrest_last_diff_backup pq: invalid input syntax for type json" source="postgres_exporter.go:1356"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant