Jira (PDB-5549) PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes
Title: Message Title Sebastian Döring commented on PDB-5549 Re: PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes Problem is still observed in 7.13.0-1bullseye Add Comment This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8) -- 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.470699.1665479002000.416.1684487400023%40Atlassian.JIRA.
Jira (PDB-5549) PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes
Title: Message Title Sebastian Döring commented on PDB-5549 Re: PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes Problem still occurs with 7.12.1-1bullseye Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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.470699.1665479002000.9765.1676286840028%40Atlassian.JIRA.
Jira (PDB-5549) PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes
Title: Message Title Andreas Paul commented on PDB-5549 Re: PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes I can confirm this also happens with 7.10.1 Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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.470699.1665479002000.46546.1665749100031%40Atlassian.JIRA.
Jira (PDB-5549) PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes
Title: Message Title
Sebastian Döring commented on PDB-5549
Re: PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes
I enabled in /etc/puppetlabs/puppetdb/logback.xml, but my untrained eyes don't notice anything suspicious or obviously wrong:
2022-10-11T15:57:20.799+02:00 INFO [p.p.export] Export triggered for PuppetDB
2022-10-11T15:57:20.801+02:00 DEBUG [o.e.j.s.HttpOutput] write(array HeapByteBuffer@238840f2[p=0,l=10,c=1024,r=10]={<<<\x1f\x8b\x08\x00\x00\x00\x00\x00\x00\xFf>>>\x00\x00\x00\x00\x00\x00\x00\x00\x00...\x00\x00\x00\x00\x00\x00\x00})
2022-10-11T15:57:20.801+02:00 DEBUG [o.e.j.s.HttpOutput] write(array) s=OPEN,api=BLOCKING,sc=false,e=null aggregated !flush HeapByteBuffer@397d38c0[p=0,l=10,c=32768, r=10]={<<<\x1f\x8b\x08\x00\x00\x00\x00\x00\x00\xFf>>>\x00\x00\x00\x00\x00\x00\x00\x00\x00...\x00\x00\x00\x00\x00\x00\x00}
2022-10-11T15:57:20.819+02:00 INFO [p.p.query-eng] PDBQuery:935142ef-95d8-44d2-abf3-92266305ccec:{"ast":["from","nodes-with-fact-expiration"],"origin":null}
2022-10-11T15:57:20.856+02:00 DEBUG [p.p.q.engine] Attempting to drop unused joins from query
2022-10-11T15:57:20.864+02:00 INFO [p.p.query-eng] PDBQuery:935142ef-95d8-44d2-abf3-92266305ccec:{"origin":null,"params":[],"sql":"WITH inactive_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL AND deactivated >'2022-04-14T13:57:20.859Z') OR (expired IS NOT NULL and expired > '2022-04-14T13:57:20.859Z')), not_active_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL OR expired IS NOT NULL)) SELECT reports.corrective_change AS \"latest_report_corrective_change\", certnames.deactivated AS \"deactivated\", certnames.expired AS \"expired\", reports_environment.environment AS \"report_environment\", certnames.certname AS
Jira (PDB-5549) PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes
Title: Message Title Sebastian Döring created an issue PuppetDB / PDB-5549 PuppetDB 7.11.1: /pdb/admin/v1/archive returns 257 bytes Issue Type: Bug Affects Versions: PDB 7.11.0 Assignee: Unassigned Components: PuppetDB \ API Created: 2022/10/11 2:03 AM Priority: Normal Reporter: Sebastian Döring On our puppetdb instance with around ~3000 nodes the puppetdb export stopped working. The behaviour occurs with both the puppetdb cli gem (puppet db export ) and when accessing the api directly: root@issopuppet7dbmwbsproda01:~# curl -X GET http://localhost:8080/pdb/admin/v1/archive -o puppetdb-export.tgz % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 258 100 258 0 0 2015 0 --:--:--
