Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3811

main.ps_ddl flaky (12 failures over 100 runs)

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 5.5.27
        • Fix Version/s: 5.5.28
        • Component/s: None
        • Labels:
          None
        • Environment:
          x86_64 GNU/Linux (kernel based on 2.6.38)

          Description

          main.ps_ddl does not pass consistently. Prepared statement view->temporary table transition in particular. It is more flaky with -DCMAKE_BUILD_TYPE=Debug (fails roughly twice as often).

          MariaDB Version 5.5.27-MariaDB-debug
          Installing system database...

          • skipping ndbcluster
          • skipping SSL, mysqld not compiled with SSL
          • binaries are debug compiled
            Collecting tests...
            Using server port 37374

          ==============================================================================

          TEST RESULT TIME (ms) or COMMENT
          --------------------------------------------------------------------------

          worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
          main.ps_ddl [ fail ]
          Test ended at 2012-10-17 09:05:19

          CURRENT_TEST: main.ps_ddl
          — /usr/local/google/home/andrewford/mariadb/mariadb55/mysql-test/r/ps_ddl.result 2012-10-10 10:32:19.475265252 -0700
          +++ /usr/local/google/home/andrewford/mariadb/mariadb55/mysql-test/r/ps_ddl.reject 2012-10-17 09:05:19.721286104 -0700
          @@ -781,7 +781,7 @@
          create temporary table t1 (a int);
          execute stmt;
          table_name
          -t1
          +NULL
          call p_verify_reprepare_count(0);
          SUCCESS

          mysqltest: Result length mismatch

          Warnings from just before the error:
          Note 1051 Unknown table 'test.v1'

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Hi Andrew,

                Could you please specify

                • whether you build from release or LP source, and in the latter case – which revision;
                • the exact flavor of Linux you are running the tests on;
                • if there are any non-default build options apart from CMAKE_BUILD_TYPE;
                • the full MTR command line you use to run the tests.

                So far I couldn't reproduce the problem.

                Show
                elenst Elena Stepanova added a comment - Hi Andrew, Could you please specify whether you build from release or LP source, and in the latter case – which revision; the exact flavor of Linux you are running the tests on; if there are any non-default build options apart from CMAKE_BUILD_TYPE; the full MTR command line you use to run the tests. So far I couldn't reproduce the problem.
                Hide
                Permalink
                andrewford Andrew Ford added a comment -

                I download the source tarball from https://downloads.mariadb.org/mariadb/5.5.27/

                It is based on Ubuntu, but has a custom kernel and some custom packages.

                <in root of clean tarball>:
                cmake -DCMAKE_BUILD_TYPE=Debug .
                make
                cd mysql-test
                SUCCESS=0
                for i in

                {1..100}

                ; do ./mysql-test-run.pl main.ps_ddl && SUCCESS=$(($SUCCESS+1)); done
                echo $SUCCESS

                <prints something around 84 (varies)>

                Show
                andrewford Andrew Ford added a comment - I download the source tarball from https://downloads.mariadb.org/mariadb/5.5.27/ It is based on Ubuntu, but has a custom kernel and some custom packages. <in root of clean tarball>: cmake -DCMAKE_BUILD_TYPE=Debug . make cd mysql-test SUCCESS=0 for i in {1..100} ; do ./mysql-test-run.pl main.ps_ddl && SUCCESS=$(($SUCCESS+1)); done echo $SUCCESS <prints something around 84 (varies)>
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Thanks.
                The reason I couldn't reproduce it on the current maria/5.5 tree is that it was actually fixed right after 5.5.27 release, in this revision: http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3528

                Could you please try 5.5.28 release to see if you observe the problem there?

                Show
                elenst Elena Stepanova added a comment - Thanks. The reason I couldn't reproduce it on the current maria/5.5 tree is that it was actually fixed right after 5.5.27 release, in this revision: http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3528 Could you please try 5.5.28 release to see if you observe the problem there?
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Please feel free to re-open if you find out it's still reproducible in your environment.

                Show
                elenst Elena Stepanova added a comment - Please feel free to re-open if you find out it's still reproducible in your environment.

                  People

                  • Assignee:
                    elenst Elena Stepanova
                    Reporter:
                    andrewford Andrew Ford
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: