| Summary: | Don't lock entire database when dumping Koha instance | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Alex Buckley <alexbuckley> |
| Component: | Command-line Utilities | Assignee: | Alex Buckley <alexbuckley> |
| Status: | CLOSED FIXED | QA Contact: | Marcel de Rooy <m.de.rooy> |
| Severity: | enhancement | ||
| Priority: | P5 - low | CC: | dcook, m.de.rooy, martin.renvoize, robin, victor |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| Change sponsored?: | Sponsored | Patch complexity: | Small patch |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: |
22.05.00
|
|
| Circulation function: | |||
| Attachments: |
Bug 30511: Don't lock up entire database while running koha-dump
Bug 30511: Don't lock up entire database while running koha-dump Bug 30511: Don't lock up entire database while running koha-dump |
||
|
Description
Alex Buckley
2022-04-12 02:20:51 UTC
Created attachment 133203 [details] [review] Bug 30511: Don't lock up entire database while running koha-dump Test plan: 1. Apply the patch 2. Restart services 3. Run koha-dump 4. Confirm the .sql.gz and .tar.gz files are generated successfully Sponsored-by: Catalyst IT Created attachment 133204 [details] [review] Bug 30511: Don't lock up entire database while running koha-dump Test plan: 1. Apply the patch 2. Restart services 3. Run koha-dump 4. Confirm the .sql.gz and .tar.gz files are generated successfully Sponsored-by: Catalyst IT Signed-off-by: David Cook <dcook@prosentient.com.au> I've been using this in production for a while and it's been great. Created attachment 134347 [details] [review] Bug 30511: Don't lock up entire database while running koha-dump Test plan: 1. Apply the patch 2. Restart services 3. Run koha-dump 4. Confirm the .sql.gz and .tar.gz files are generated successfully Sponsored-by: Catalyst IT Signed-off-by: David Cook <dcook@prosentient.com.au> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> We could do so since we do no longer have a mix of InnoDB and MyISAM tables. This produces a coherent dump for InnoDB tables. Pushed to master for 22.05, thanks to everybody involved [U+1F984] |