MySQL QA Episode 6: Analyzing and Filtering

MySQL QA Episode 6: Analyzing and Filtering

PREVIOUS POST
NEXT POST

Welcome to MySQL QA Episode #6!

Today we will look into analyzing and filtering our QA run. We’ll use tools like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh

1. Quick re-cap and QA run setup
2. pquery-prep-red.sh
3. pquery-clean-known.sh
4. pquery-results.sh
5. Bonus: pquery reach – pquery-reach++.sh

We’ll also introduce the text_string.sh tool which extracts a most-specific text string from the error log in order to classify a bug/issue.

Full-screen viewing @ 720p resolution recommended

PREVIOUS POST
NEXT POST

Share this post

Comments (7)

  • Shahriyar Rzayev Reply

    If you run pquery-run.sh first time you will likely get an error indicating missing “jemalloc” package:

    [root@centos-base percona-qa]# ./pquery-run.sh
    [07:40:46] [] Assert! jemalloc not found at /usr/lib64/libjemalloc.so.1, please install it!
    ./pquery-run.sh: line 31: //home/221554/pquery-run.log: No such file or directory

    The solution for CentOS 7 is just activating EPEL and installing:

    yum -y install epel-release
    yum -y install jemalloc

    August 19, 2015 at 7:46 am
  • Shahriyar Rzayev Reply

    Another issue i have encountered is:
    [08:07:25] [0] Copying datadir from template…
    ls: cannot access /home/470678/data.template/*: No such file or directory
    [08:07:25] [0] Assert: /home/470678/data.template/ is empty? Check /home/470678/log/mysql_install_db.txt to see if the original template creation worked ok. Terminating.

    [root@centos-base ~]# cat /home/470678/log/mysql_install_db.txt
    FATAL ERROR: please install the following Perl modules before executing /opt/mysql-5.6.19/scripts/mysql_install_db:
    Data::Dumper

    solution is:
    yum install perl-Data-Dumper

    August 19, 2015 at 8:18 am
  • Roel Van de Paar Reply

    @Shahriyar Rzayev Thanks! I’ve added the info above directly in the script to help others in the future. Rev 1514 (use ‘bzr pull’ to get it). Thanks again!

    August 20, 2015 at 4:48 am
  • Shahriyar Rzayev Reply

    @Roel Van de Paar thank you for such wonderful tutorials 🙂 it is pleasure to test and learn.

    August 20, 2015 at 5:26 am
  • Shahriyar Rzayev Reply

    Dear all,
    Also you may be hit an error below, first pquery-prep-red.sh
    [root@centos-base 362406]# ~/percona-qa/pquery-prep-red.sh
    Something is wrong: this script could not read reducer.sh at /sda/randgen/util/reducer/reducer.sh – please set REDUCER variable inside the script correctly.

    You must edit pquery-prep-red.sh and give a correct path to find reducer.sh. Default is:
    # User variables
    REDUCER=”/sda/randgen/util/reducer/reducer.sh

    Just change it and it will work correctly.

    To get a reducer.sh just do:

    bzr branch lp:randgen

    August 20, 2015 at 11:02 am
  • Roel Van de Paar Reply

    All, please note we have moved percona-qa to GitHub:
    https://github.com/Percona-QA/percona-qa

    To clone it, use:
    $ sudo yum install git
    $ cd ~
    $ git clone https://github.com/Percona-QA/percona-qa.git

    reducer.sh was also put directly into this repository (and it is maintained there), so *no* need anymore to separately fetch lp:randgen.

    November 26, 2015 at 12:57 am

Leave a Reply