Attachment 133204 Details for Bug 30511 – Bug 30511: Don't lock up entire database while running koha-dump

[patch] Bug 30511: Don't lock up entire database while running koha-dump

Bug-30511-Dont-lock-up-entire-database-while-runni.patch (text/plain), 1.51 KB, created by David Cook on 2022-04-12 07:05:49 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Cook

Created: 2022-04-12 07:05:49 UTC

Size: 1.51 KB

patch

obsolete

>From fa0dab2c0c63b6526ad018798e1d60e554843ae7 Mon Sep 17 00:00:00 2001
>From: Alex Buckley <alexbuckley@catalyst.net.nz>
>Date: Fri, 8 Apr 2022 08:10:04 +0000
>Subject: [PATCH] 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>
>---
> debian/scripts/koha-dump | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/debian/scripts/koha-dump b/debian/scripts/koha-dump
>index f3a6b5aed7..f8d2ad1fa1 100755
>--- a/debian/scripts/koha-dump
>+++ b/debian/scripts/koha-dump
>@@ -79,13 +79,13 @@ dump_instance()
>     then
>         schemadump="$backupdir/$name-schema-$date.sql"
>         [ "$quiet" = "no" ] && echo "* schema to $schemadump"
>-        mysqldump $dbflag -d --host="$mysqlhost" \
>+        mysqldump $dbflag -d --host="$mysqlhost" --single-transaction \
>             --user="$mysqluser" --password="$mysqlpass" "$mysqldb" | sed --expression='s/ AUTO_INCREMENT=[0-9]\+//' > "$schemadump"
>         chown "root:$name-koha" "$schemadump"
>         chmod g+r "$schemadump"
>     else
>         [ "$quiet" = "no" ] && echo "* DB to $dbdump"
>-        mysqldump $dbflag --host="$mysqlhost" \
>+        mysqldump $dbflag --host="$mysqlhost" --single-transaction \
>             --user="$mysqluser" --password="$mysqlpass" "$mysqldb" |
>             gzip > "$dbdump"
>         chown "root:$name-koha" "$dbdump"
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 30511: 133203 | 133204 | 134347