[bug]: lncli deletepayments -all crashes node (hard boot) #10322
Description
Pre-Submission Checklist
- I have searched the existing issues and believe this is a new bug.
- I am not asking a question about how to use lnd, but reporting a bug (otherwise open a discussion).
LND Version
0.20.0-beta.rc1
LND Configuration
[db]
db.no-rev-log-amt-data=true
db.backend=postgres
db.postgres.dsn=postgres://db.postgres.timeout=360s
db.use-native-sql=true
db.postgres.maxconnections=50
Backend Version
Bitcoin Core version v28.0
Backend Configuration
N/A
OS/Distribution
Ubuntu 24.04.3 LTS
Bug Details & Steps to Reproduce
When running lncli deletepayments --all (in a screen), after a few hours, my entire node halts and requires a hard reboot. Initially, there is no performance impact, but later in the day the crash occurs. At this time, I am unable to SSH to the LND server or ping it. The postgres DB is still operational. I have included some graphs showing what occurs to the lead up to the crash.
Expected Behavior
deletepayments to fail gracefully, or split the transaction into segments to prevent a crash (or have an option for max payments deleted).
Debug Information
No response
Environment
No response