Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures

[Jarret Lavallee (Jira)]

Title: Message Title

Jarret Lavallee created an issue   PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Issue Type: Bug Affects Versions: PDB 7.7.1 Assignee: Unassigned Components: PuppetDB Created: 2021/11/11 8:59 AM Priority: Normal Reporter: Jarret Lavallee In PDB 7.7.1, if log-queries = true some PDB queries will fail with Cannot JSON encode object of class: class org.postgresql.jdbc.PgArray. This was working in 7.5.2. Disabling log-queries alleviates the issue.   Reproduction Install 7.7.1 or PE 2021.4.0 Set log-queries = true in the jetty.ini Run the following query and observe the error # curl -G http://localhost:8080/pdb/query/v4/facts --data-urlencode 'query=["extract", ["certname", "name", "value"], ["and", ["or", ["in", "certname", ["array", ["somenode"]]]], ["in", "name", ["array", ["aio_agent_version"]]]]]' Cannot JSON encode object of class: class org.postgresql.jdbc.PgArray: {"somenode"}   Impact This query is generated from bolt, so running bolt against a PE instance in 2021.4.0 with log-queries = true will fail.   # bolt task run facts --targets $(puppet config print certname) --transport pcp Started on pe-server-16712b-0.us-west1-c.c.customer-support-scratchpad.internal... Failed on pe-server-16712b-0.us-west1-c.c.customer-support-scratchpad.internal:   Query to PuppetDB v4/facts failed with query ["extract" ["certname" "name" "value"] ["and" ("or" ["in" "certname" ["array" ("pe-server-16712b-0.us-west1-c.c.customer-support-scratchpad.internal")]]) ["in" "name" ["array" ["aio_agent_version"]]]]]: Cannot JSON encode object of class: class org.postgresql.jdbc.PgArray: {"pe-server-16712b-0.us-west1-c.c.customer-support-scratchpad.internal"} Failed on 1 target: pe-server-16712b-0.us-west1-c.c.customer-support-scratchpad.internal Ran on 1 target in 0.55 sec   Workaround Set log-queries = false or remove the line from the jetty.ini Add Comment   This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.423245.1636649950000.5105.1636650000195%40Atlassian.JIRA.