-
Type:
Incident report
-
Resolution: Cannot Reproduce
-
Priority:
Trivial
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Environment:PostGreSQL 10 SLES12
Puppet
When we add a host with puppet agent, we can see an error in the postgresql lo :
ERROR: syntax error at or near "AND" at character 75
STATEMENT: SELECT DISTINCT h.* FROM hosts h,hosts_templates ht WHERE h.status=3 AND AND h.hostid=ht.templateid
When are unale to find where this "
SELECT * FROM hosts where status = '3';" is done