Fuel for OpenStack

Diagnostic snapshot doesn't contain MySQL resources (logs and configs) from the controllers

Bug #1550984 reported by Maksim Malchuk
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Fix Released
High
Alex Schultz
Fuel for OpenStack 10.0
6.1.x
Won't Fix
High
Maksim Malchuk
Fuel for OpenStack 6.1-updates
7.0.x
Fix Released
High
Maksim Malchuk
Fuel for OpenStack 7.0-mu-6
8.0.x
Fix Released
High
Maksim Malchuk
Fuel for OpenStack 8.0-mu-4
Mitaka
Fix Released
High
Maksim Malchuk
Fuel for OpenStack 9.0

Bug Description

Diagnostic snapshot doesn't contain MySQL resources (logs and configs) from the controllers.

We need at least all configuration files from the /etc/mysql directory and log-files from the /var/log/mysql directory.

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

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

Changed in fuel:
assignee: nobody → Maksim Malchuk (mmalchuk)
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-web (master)

Reviewed: https://review.openstack.org/285831
Committed: https://git.openstack.org/cgit/openstack/fuel-web/commit/?id=9d810891ffc5d93820de6756b1089546ee78bf73
Submitter: Jenkins
Branch: master

commit 9d810891ffc5d93820de6756b1089546ee78bf73
Author: Maksim Malchuk <email address hidden>
Date: Sun Feb 28 22:26:49 2016 +0300

    Add MySQL configs and log-files to the diagnostic snapshot

    This will be added to the diagnostic snapshot:
     - /etc/mysql/*
     - /var/log/mysql/*
     - commands/mysql_resources.txt
    The file commands/mysql_resources.txt will contain the listing files
    from the /var/lib/mysql/ and /var/run/mysqld/ directories.

    Change-Id: Iddaa9e0d51a02e0d2962dc797c4c1d1cd35b949e
    Closes-Bug: #1550984

Changed in fuel:
status: In Progress → Fix Committed
Revision history for this message
Alex Schultz (alex-schultz) wrote :

Reopening because they are still missing.

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

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

Changed in fuel:
assignee: Maksim Malchuk (mmalchuk) → Alex Schultz (alex-schultz)
status: Confirmed → In Progress
Alex Schultz (alex-schultz)
tags: added: area-library
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-web (stable/8.0)

Fix proposed to branch: stable/8.0
Review: https://review.openstack.org/314680

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-web (stable/7.0)

Fix proposed to branch: stable/7.0
Review: https://review.openstack.org/314685

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-web (stable/6.1)

Fix proposed to branch: stable/6.1
Review: https://review.openstack.org/314686

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

Reviewed: https://review.openstack.org/313030
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=5446d2e0aaa441d808a328c3ffd37ad0e390a5a6
Submitter: Jenkins
Branch: master

commit 5446d2e0aaa441d808a328c3ffd37ad0e390a5a6
Author: Alex Schultz <email address hidden>
Date: Thu May 5 08:29:43 2016 -0600

    mysql logs should output to /var/log/mysql

    All mysql logs should be in /var/log/mysql so they are properly
    captured by shotgun for diagnostic reports.

    Change-Id: Id3812a25a235bc64db530d693112c51eaca0579f
    Closes-Bug: #1550984

Changed in fuel:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-library (stable/mitaka)

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/315449

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-library (stable/8.0)

Fix proposed to branch: stable/8.0
Review: https://review.openstack.org/315451

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-library (stable/7.0)

Fix proposed to branch: stable/7.0
Review: https://review.openstack.org/315452

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to fuel-library (stable/6.1)

Fix proposed to branch: stable/6.1
Review: https://review.openstack.org/315453

Dmitry Pyzhov (dpyzhov)
no longer affects: fuel/newton
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-library (stable/mitaka)

Reviewed: https://review.openstack.org/315449
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=b78ef174f0dd9aff86f59b4c44d5ef6f9e66eceb
Submitter: Jenkins
Branch: stable/mitaka

commit b78ef174f0dd9aff86f59b4c44d5ef6f9e66eceb
Author: Alex Schultz <email address hidden>
Date: Thu May 5 08:29:43 2016 -0600

    mysql logs should output to /var/log/mysql

    All mysql logs should be in /var/log/mysql so they are properly
    captured by shotgun for diagnostic reports.

    Change-Id: Id3812a25a235bc64db530d693112c51eaca0579f
    Closes-Bug: #1550984
    (cherry picked from commit 5446d2e0aaa441d808a328c3ffd37ad0e390a5a6)

Revision history for this message
Dmitry Tyzhnenko (dtyzhnenko) wrote :

Verified on CI
Version 10.0-235
Version 9.0-328
https://product-ci.infra.mirantis.net/view/10.0_swarm/job/10.0.system_test.ubuntu.ha_neutron/39/
https://product-ci.infra.mirantis.net/job/9.0.main.ubuntu.bvt_2/328/

Files:
     - /etc/mysql/*
     - /var/log/mysql/*
     - commands/mysql_resources.txt

are present in snapshot

Changed in fuel:
status: Fix Committed → Fix Released
Revision history for this message
Vitaly Sedelnik (vsedelnik) wrote :

Won't Fix for 6.1-updates as 6.1 is in Limited support now

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-web (stable/7.0)

Reviewed: https://review.openstack.org/314685
Committed: https://git.openstack.org/cgit/openstack/fuel-web/commit/?id=236b0c0952c6e1ca2bb3f72084b00ba49545233a
Submitter: Jenkins
Branch: stable/7.0

commit 236b0c0952c6e1ca2bb3f72084b00ba49545233a
Author: Maksim Malchuk <email address hidden>
Date: Sun Feb 28 22:26:49 2016 +0300

    Add MySQL configs and log-files to the diagnostic snapshot

    This will be added to the diagnostic snapshot:
     - /etc/mysql/*
     - /var/log/mysql/*
     - commands/mysql_resources.txt
    The file commands/mysql_resources.txt will contain the listing files
    from the /var/lib/mysql/ and /var/run/mysqld/ directories.

    Change-Id: Iddaa9e0d51a02e0d2962dc797c4c1d1cd35b949e
    Closes-Bug: #1550984
    (cherry picked from commit 9d810891ffc5d93820de6756b1089546ee78bf73)
    Signed-off-by: Maksim Malchuk <email address hidden>

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-library (stable/7.0)

Reviewed: https://review.openstack.org/315452
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=0aabc87f3e486f8e05c0694a4fd1fd73f0f60825
Submitter: Jenkins
Branch: stable/7.0

commit 0aabc87f3e486f8e05c0694a4fd1fd73f0f60825
Author: Alex Schultz <email address hidden>
Date: Thu May 5 08:29:43 2016 -0600

    mysql logs should output to /var/log/mysql

    All mysql logs should be in /var/log/mysql so they are properly
    captured by shotgun for diagnostic reports.

    Change-Id: Id3812a25a235bc64db530d693112c51eaca0579f
    Closes-Bug: #1550984
    (cherry picked from commit 5446d2e0aaa441d808a328c3ffd37ad0e390a5a6)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-library (stable/8.0)

Reviewed: https://review.openstack.org/315451
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=f14c3a218a0ca7d0404e2f1a85aa7bc87e1f9c21
Submitter: Jenkins
Branch: stable/8.0

commit f14c3a218a0ca7d0404e2f1a85aa7bc87e1f9c21
Author: Alex Schultz <email address hidden>
Date: Thu May 5 08:29:43 2016 -0600

    mysql logs should output to /var/log/mysql

    All mysql logs should be in /var/log/mysql so they are properly
    captured by shotgun for diagnostic reports.

    Change-Id: Id3812a25a235bc64db530d693112c51eaca0579f
    Closes-Bug: #1550984
    (cherry picked from commit 5446d2e0aaa441d808a328c3ffd37ad0e390a5a6)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to fuel-web (stable/8.0)

Reviewed: https://review.openstack.org/314680
Committed: https://git.openstack.org/cgit/openstack/fuel-web/commit/?id=a21ad207a14c2b8012486d94adc51346abe32ffb
Submitter: Jenkins
Branch: stable/8.0

commit a21ad207a14c2b8012486d94adc51346abe32ffb
Author: Maksim Malchuk <email address hidden>
Date: Sun Feb 28 22:26:49 2016 +0300

    Add MySQL configs and log-files to the diagnostic snapshot

    This will be added to the diagnostic snapshot:
     - /etc/mysql/*
     - /var/log/mysql/*
     - commands/mysql_resources.txt
    The file commands/mysql_resources.txt will contain the listing files
    from the /var/lib/mysql/ and /var/run/mysqld/ directories.

    Change-Id: Iddaa9e0d51a02e0d2962dc797c4c1d1cd35b949e
    Closes-Bug: #1550984
    (cherry picked from commit 9d810891ffc5d93820de6756b1089546ee78bf73)

TatyanaGladysheva (tgladysheva)
tags: added: on-verification
Revision history for this message
TatyanaGladysheva (tgladysheva) wrote :

Verified on MOS 7.0 + MU6 updates.

Diagnostic snapshot contains the following files on controllers:
     - /etc/mysql/*
     - /var/log/mysql/*
     - commands/mysql_resources.txt

tags: removed: on-verification
TatyanaGladysheva (tgladysheva)
tags: added: on-verification
Revision history for this message
TatyanaGladysheva (tgladysheva) wrote :

Verified on MOS 8.0 + MU4 updates.

Diagnostic snapshot contains the following files on controllers:
     - /etc/mysql/*
     - /var/log/mysql/*
     - commands/mysql_resources.txt

tags: removed: on-verification
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on fuel-library (stable/6.1)

Change abandoned by Tony Breeds (<email address hidden>) on branch: stable/6.1
Review: https://review.openstack.org/315453
Reason: This branch (stable/6.1) is at End Of Life

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on fuel-web (stable/6.1)

Change abandoned by Tony Breeds (<email address hidden>) on branch: stable/6.1
Review: https://review.openstack.org/314686
Reason: This branch (stable/6.1) is at End Of Life

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

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