ak0ska
2014-Oct-15 11:15 UTC
[Puppet Users] PDB 1.6: Queries filtering facts with large values might fail
Hello, We are running PuppetDB 1.6.0. We have fact 'a' in puppetdb that has large numbers occasionally, such as 2930266584. When we launch a query /v3/facts/a with filter '["<", "value", 1950341121]' it returns code 200 with an empty body, while puppetdb.log shows a new error: 2014-10-15 11:20:41,293 ERROR [clojure-agent-send-off-pool-15310]> [v3.facts] Error streaming response > org.postgresql.util.PSQLException: ERROR: value "2930266584" is out of > range for type integer >The table stores values in strings, and apparently the query cannot convert large values into integers. Could someone please check if this issue also exists with newer versions? Best regards, Akos Hencz -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/36aba949-c45f-4e44-aa1b-7107b36ff754%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.