MySQL QA Episode 6: Analyzing and Filtering

Welcome to MySQL QA Episode #6!

Today we will look into analyzing and filtering our QA run. We’ll use tools like, &

1. Quick re-cap and QA run setup
5. Bonus: pquery reach –

We’ll also introduce the 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

Share this post

Comments (7)

  • Shahriyar Rzayev

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

    [root@centos-base percona-qa]# ./
    [07:40:46] [] Assert! jemalloc not found at /usr/lib64/, please install it!
    ./ 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

    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:

    solution is:
    yum install perl-Data-Dumper

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

    @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

    @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

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

    You must edit and give a correct path to find Default is:
    # User variables

    Just change it and it will work correctly.

    To get a just do:

    bzr branch lp:randgen

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

    All, please note we have moved percona-qa to GitHub:

    To clone it, use:
    $ sudo yum install git
    $ cd ~
    $ git clone 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

Comments are closed.

Use Percona's Technical Forum to ask any follow-up questions on this blog topic.