Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Sebastian Reitenbach commented on PDB-3857 Re: Error during garbage collection: java.sql.BatchUpdateException Russell Mull thanks for the info, I don't do funny things with custom facts I think then I feel safe and will actually update the official OpenBSD pupptedb package for OpenBSD -current Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Russell Mull commented on PDB-3857 Re: Error during garbage collection: java.sql.BatchUpdateException Ah, I missed that the first time I looked. PDB 5.2 has a new way of storing facts, which incorporates this new GC query. I think you're probably ok for this query to just fail for the time being; it cleans up records for fact names which are no longer in use; so this is only really an issue if you're doing some really crazy stuff with custom facts. Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Sebastian Reitenbach commented on PDB-3857 Re: Error during garbage collection: java.sql.BatchUpdateException Russell Mull yes, as I gave it in the Environment info, I'm running PostgreSQL 10.1. another note: I updated from 5.1.3, which did not bring these errors/warnings. But reading the CHANGELOG, I guess the garbage collection was redone/update in that version, and now that's new. thanks Sebastian Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Russell Mull commented on PDB-3857 Re: Error during garbage collection: java.sql.BatchUpdateException Are you running postgresql 10? It looks like the behaviour around this kind of query may have changed between 9.6 (which we developed against) and 10. Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Sebastian Reitenbach commented on PDB-3857 Re: Error during garbage collection: java.sql.BatchUpdateException indeed I get errors logged there as well, should have provided them with the initial report: 2018-03-01 05:53:50.658 CET [89665] ERROR: set-returning functions are not allowed in CASE at character 559 2018-03-01 05:53:50.658 CET [89665] HINT: You might be able to move the set-returning function into a LATERAL FROM item. 2018-03-01 05:53:50.658 CET [89665] STATEMENT: with recursive live_paths(key, path, value) as (select key, key as path, value from (select (jsonb_each(stable||volatile)).* from factsets) as base_case union all select sub_path as key, sub_paths.path||'#~'||sub_path as path, sub_value as value from (select * from (select path, case jsonb_typeof(value) when 'object' then (jsonb_each(value)).key when 'array' then generate_series(0, jsonb_array_length(value - 1))::text end as sub_path, case jsonb_typeof(value) when 'object' then (jsonb_each(value)).value when 'array' then jsonb_array_elements(value) end as sub_value from live_paths) as candidates where candidates.sub_path is not null) as sub_paths) delete from fact_paths fp where not exists (select 1 from live_paths where live_paths.path = fp.path) Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Russell Mull commented on PDB-3857 Re: Error during garbage collection: java.sql.BatchUpdateException Hi Sebastian, thanks for the bug report! Can you provide any correlated logs from postgresql? I'd expect to see something related to this at the same frequency. Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3857 Error during garbage collection: java.sql.BatchUpdateException Change By: Jeff Yarnell Sprint: Hopper/Triage Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3857 Error during garbage collection: java.sql.BatchUpdateException Change By: Jeff Yarnell Team: Data Platform Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3857) Error during garbage collection: java.sql.BatchUpdateException
Title: Message Title Sebastian Reitenbach created an issue PuppetDB / PDB-3857 Error during garbage collection: java.sql.BatchUpdateException Issue Type: Bug Affects Versions: PDB 5.2.0 Assignee: Unassigned Components: PuppetDB Created: 2018/02/26 2:02 PM Environment: Puppet 5.4.0 postgresql-server and client: 10.1 puppetdb: 5.2.0 ruby: 2.4.3 java: jdk-1.8.0.144 OS/Version: OpenBSD 6.2-current amd64 {{cat bootstrap.cfg }} # This file is used by the application framework (trapperkeeper) to # determine what services should be loaded at boot time. # For more info, see: # https://github.com/puppetlabs/trapperkeeper/wiki/Bootstrapping # Web Server puppetlabs.trapperkeeper.services.webserver.jetty9-service/jetty9-service # Webrouting puppetlabs.trapperkeeper.services.webrouting.webrouting-service/webrouting-service # TK status puppetlabs.trapperkeeper.services.metrics.metrics-service/metrics-webservice puppetlabs.trapperkeeper.services.status.status-service/status-service puppetlabs.trapperkeeper.services.scheduler.scheduler-service/scheduler-service # PuppetDB Services puppetlabs.puppetdb.cli.services/puppetdb-service puppetlabs.puppetdb.command/command-service puppetlabs.puppetdb.pdb-routing/maint-mode-service puppetlabs.puppetdb.pdb-routing/pdb-routing-service puppetlabs.puppetdb.config/config-service# NREPL puppetlabs.trapperkeeper.services.nrepl.nrepl-service/nrepl-service# Dashboard redirect: remove to disable puppetlabs.puppetdb.dashboard/dashboard-redirect-service {{}}{{cat database.ini }} [database] classname = org.postgresql.Driver subprotocol = postgresq subname = //localhost:5432/puppetdb username = puppetdb password = password gc-interval = 60 log-slow-statements = 10 syntax_pgs = true node-ttl = 0s node-purge-ttl = 0s report-ttl = 14d conn-max-age = 60 conn-keep-alive = 45 conn-lifetime = 0 Priority: Normal Reporter: Sebastian Reitenbach