Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Charlie Sharpsteen commented on PDB-5364 Re: Enabling log-queries in 7.7.1 causes JSON serialization failures Looks like PDB-5259 fixed this in passing by adding an encoder for PgArray objects along with performance optimizations. Should be present in 6.20.0 and 7.9.0. Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.13082.169760031%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Austin Blatt Fix Version/s: PDB 7.9.0 Fix Version/s: PDB 6.20.0 Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.13060.168620031%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Austin Blatt commented on PDB-5364 Re: Enabling log-queries in 7.7.1 causes JSON serialization failures This issue was resolved while working on PDB-5259. Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.13059.168440066%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Charlie Sharpsteen commented on PDB-5364 Re: Enabling log-queries in 7.7.1 causes JSON serialization failures This issue also affects PuppetDB 6.19.1 in PE 2019.8.9. Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.13055.168020057%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Charlie Sharpsteen updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Charlie Sharpsteen Affects Version/s: PDB 6.19.1 Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.13054.167960103%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title David McTavish updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: David McTavish Sprint: HAHA/Grooming Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.12804.1644436380280%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title
Andreas Papst commented on PDB-5364
Re: Enabling log-queries in 7.7.1 causes JSON serialization failures
Hello, same issue here with puppetdb 7.8.0-1buster : $ curl -X GET http://localhost:8080/pdb/query/v4 --data-urlencode 'query= facts[certname, name]{ name in ["fact1", "fact2"] }' Cannot JSON encode object of class: class org.postgresql.jdbc.PgArray: {"fact1","fact2"} I've got a hint: https://stackoverflow.com/questions/29819540/org-postgresql-util-pgobject-cannot-be-cast-to-org-postgresql-util-pgobject This can only really happen when you have multiple versions of the Postgresql JDBC driver on your classpath. Maybe one in your webapp and another one in the servlet container itself. Make sure to only have one such jar file. Maybe a fix should be easy now. Regards Andreas
Add Comment
This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d)
--
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.163664995.1620.1642509240043%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Austin Blatt Sprint: HAHA/Grooming Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.978.1638923100240%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Austin Blatt Sprint: HAHA/Grooming Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.977.1638923100195%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Rob Browning updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Rob Browning Fix Version/s: PDB 7.8.0 Add Comment This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- 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.163664995.882.1638919440093%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Austin Blatt Sprint: HAHA/Grooming 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.163664995.17869.1638380820100%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-5364 Enabling log-queries in 7.7.1 causes JSON serialization failures Change By: Austin Blatt Fix Version/s: PDB 7.8.0 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.163664995.6060.1636738920066%40Atlassian.JIRA.
Jira (PDB-5364) Enabling log-queries in 7.7.1 causes JSON serialization failures
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"}
