Details

    Description

      mtr --repeat=10 rpl.rpl_parallel2 sometimes hangs in 10.5
      It works in 10.4.

      The problem in 10.5 started after a merge from 10.3 -> 10.5 on 2 of July that enabled the test in
      10.5. The issue is probably because of the slightly different implementation of FLUSH TABLES WITH READ LOCK in 10.5 compared to 10.4

      The hangs happens in reap of "FLUSH TABLES WITH READ LOCK" at line
      157 in suite/rpl/t/rpl_parallel2.test

      Other things:

      • The comments in ba02550166eb39c0375a6422ecaa4731421250b6 may be useful to find and fix the bug
      • The code for flush_tables_with_read_lock is in sql_reload.cc. I would suggest that one looks at the differences
        between the functions in 10.4 and 10.5 to try to find out what is going on.

      Attachments

        Issue Links

          Activity

            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Summary rpl_parallel2 fails in 10.3 rpl_parallel2 fails in 10.5
            monty Michael Widenius made changes -
            Description mtr --repeat=10 rpl.rpl_parallel2 sometimes hangs in 10.5
            It works in 10.4.

            The problem in 10.5 started after a merge from 10.3 -> 10.5 on 2 of July that enabled the test in
            10.5. The issue is probably because of the slightly different implementation of FLUSH TABLES WITH READ LOCK in 10.5 compared to 10.4

            The hangs happens in reap of "FLUSH TABLES WITH READ LOCK" at line
            157 in suite/rpl/t/rpl_parallel2.test

            Other things:
            The comments in ba02550166eb39c0375a6422ecaa4731421250b6 may be useful to find and fix the bug
            mtr --repeat=10 rpl.rpl_parallel2 sometimes hangs in 10.5
            It works in 10.4.

            The problem in 10.5 started after a merge from 10.3 -> 10.5 on 2 of July that enabled the test in
            10.5. The issue is probably because of the slightly different implementation of FLUSH TABLES WITH READ LOCK in 10.5 compared to 10.4

            The hangs happens in reap of "FLUSH TABLES WITH READ LOCK" at line
            157 in suite/rpl/t/rpl_parallel2.test

            Other things:
            - The comments in ba02550166eb39c0375a6422ecaa4731421250b6 may be useful to find and fix the bug
            - The code for flush_tables_with_read_lock is in sql_reload.cc. I would suggest that one looks at the differences
              between the functions in 10.4 and 10.5 to try to find out what is going on.
            elenst Elena Stepanova made changes -
            Issue Type Task [ 3 ] Bug [ 1 ]
            elenst Elena Stepanova made changes -
            Component/s Tests [ 10800 ]
            Affects Version/s 10.5 [ 23123 ]
            Assignee Andrei Elkin [ elkin ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Sachin Setiya [ sachin.setiya.007 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ] Sujatha Sivakumar [ sujatha.sivakumar ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Attachment gdb.txt [ 52977 ]
            sujatha.sivakumar Sujatha Sivakumar (Inactive) made changes -
            Assignee Sujatha Sivakumar [ sujatha.sivakumar ] Michael Widenius [ monty ]
            julien.fritsch Julien Fritsch made changes -
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            monty Michael Widenius made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            monty Michael Widenius made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            monty Michael Widenius made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            monty Michael Widenius made changes -
            Assignee Michael Widenius [ monty ] Sachin Setiya [ sachin.setiya.007 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Fix Version/s 10.4.15 [ 24507 ]
            Fix Version/s 10.5.5 [ 24423 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Fix Version/s 10.1.46 [ 24308 ]
            Fix Version/s 10.2.33 [ 24307 ]
            Fix Version/s 10.3.24 [ 24306 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4.16 [ 25020 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4.15 [ 24507 ]
            Elkin Andrei Elkin made changes -
            Labels ftwrl parallelslave
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 110860 ] MariaDB v4 [ 158056 ]

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.