Jira (PDB-5496) Rework/augment critical timeouts, given jdbc not interruptable

[Rob Browning (Jira)]

Rob Browning created an issue

PuppetDB / PDB-5496 Rework/augment critical timeouts, given jdbc not interruptable Issue Type: Bug Assignee: Unassigned Created: 2022/05/10 9:42 AM Priority: Normal Reporter: Rob Browning It turns out some jdbc operations do not respect thread interrupts (double-check that, austin.blatt and I have some context), and recent important stability/performance improvements (e.g. sync timeouts), were written under the assumption that they do (I'll plan to link some relevant tickets). Assuming interrupts won't always work, rewrite the code to accommodate that. Possibilities include (also) cancelling the statement (evaluate what pgjdbc supports there), setting a query timeout (investigate Statement.setQueryTimeout, or in-line per-transaction set commands to establish a timeout), etc. Add Comment

This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d)