mysqldump backup do not report failure

Bug #1753498 reported by Yang Youseok
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
New
Undecided
Yang Youseok

Bug Description

When mysqldump strategy failed by any reasons, trove-guestagent do not report the failure. Different from other backup strategies which has failure check logic (check_process), mysqldump itself depends only on base.py raise_if_process_error().

But the problem is that stderr never catched as expected since there is redirect part in command (mysqldump ... >/tmp/mysqldump.log). If error occurred when sqldump command executed, all stderr messages are redirected to the log file and it makes success state for the backup.

version: newton-eol, seems to be same as version above.
How to reproduce: add invalid extra-opts for sqldump. In my case, I added --single-transaction with no binlog.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/549773

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/549773
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=49fea478ee6d2fe67f6c248b8da9b0ce910184f8
Submitter: Zuul
Branch: master

commit 49fea478ee6d2fe67f6c248b8da9b0ce910184f8
Author: Yang Youseok <email address hidden>
Date: Mon Mar 5 23:16:33 2018 +0900

    Fix false-negative failure report for mysqldump backup

    If mysqldump command has redirect part for stderr, catching error logic
    by stderr doest not work as expected. Remove redirect part to report
    BackupError normally for sqldump failure.

    Change-Id: I2c10ae7b6b6094af7819594e889385b0ed77fe4b
    Close-Bug: 1753498

Yang Youseok (ileixe)
Changed in trove:
assignee: nobody → Yang Youseok (ileixe)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.