Actions
Bug #8316
closedRemoving a long-standing host creates huge transaction
Description
Removing a host with some reports (say 200), and each of them with several log lines (10000) generates 2.000.000 DELETE sql statements in the same transaction.
More often than not, ActiveRecord won't be able to make such a big transaction, in fact it will likely eat all memory available and Foreman will stop working in that host. In the best scenario the DB will end up with a non-committed giant transaction.
I suggest deleting hosts and reports manually on host destroy to avoid this.
Updated by The Foreman Bot almost 10 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/1907 added
- Pull request deleted (
)
Updated by Dominic Cleal almost 10 years ago
- Category set to Database
- Assignee set to Daniel Lobato Garcia
Updated by Dominic Cleal almost 10 years ago
- Related to Bug #8565: report::expire is running very slowly added
Updated by Daniel Lobato Garcia almost 10 years ago
- Related to Refactor #1955: improve host deletion speed added
Updated by Daniel Lobato Garcia over 9 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset 3e7507198f25b41b90a55115671fe0edd495f531.
Updated by Dominic Cleal over 9 years ago
- Translation missing: en.field_release set to 28
Actions