Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5271

5.6 ASan: intermittent thread stack overrun on rpl.rpl_row_sp011

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 5.6, Not 5.7, Not 8.0
    • Fix Version/s: 5.6.43-84.3
    • Component/s: None
    • Labels:

      Description

      rpl.rpl_row_sp011 'row'                  w3 [ fail ]
              Test ended at 2019-01-02 14:16:18
      
      CURRENT_TEST: rpl.rpl_row_sp011
      mysqltest: At line 76: query 'CALL test.p1()' failed: 1436: Thread stack overrun:  76976 bytes used of a 196608 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.
      

      which should be fixed by cherry-picking from 5.7:

      commit 71d72830c2c6b487058eab9b2823d6313a133745
      Author: parveez <parveez.baig@oracle.com>
      Date:   Wed Sep 16 14:58:00 2015 +0200
      
          Bug #21161874 -TEST:RPL.RPL_ROW_SP011 FAILS WITH THREAD STACK OVERRRUN. rpl_row_sp011 test was failing due to thread stack overrun problem.Fix: increased the thread stack size for the test in the opt file.
      
      diff --git a/mysql-test/suite/rpl/t/rpl_row_sp011-master.opt b/mysql-test/suite/rpl/t/rpl_row_sp011-master.opt
      index d03d176150d..2a213c3b06f 100644
      --- a/mysql-test/suite/rpl/t/rpl_row_sp011-master.opt
      +++ b/mysql-test/suite/rpl/t/rpl_row_sp011-master.opt
      @@ -1 +1,2 @@
       ${?PB_HOST_SPECIFIC_MYSQLD_ARGS}
      +--thread_stack=409600
      diff --git a/mysql-test/suite/rpl/t/rpl_row_sp011.test b/mysql-test/suite/rpl/t/rpl_row_sp011.test
      index c5027c79f7b..a7a5209efbf 100644
      --- a/mysql-test/suite/rpl/t/rpl_row_sp011.test
      +++ b/mysql-test/suite/rpl/t/rpl_row_sp011.test
      @@ -2,8 +2,11 @@
       # Original Author: JBM                                                      #
       # Original Date: Aug/18/2005                                                #
       # Updated: 08/29/2005  turned on diff and commented out debug SQL statements#
      +# Updated: sep/16/2015                                                      #
      +#          This testcase requires minimum stack size of 300KB to run on WIN.#
      +#          Modified *-master.opt file to increase the thread_stack to 400KB.#
       #############################################################################
      -#TEST: SP to test alter table and nested SP calls                           #
      +# TEST: SP to test alter table and nested SP calls                          #
       #############################################################################
       
       # Includes
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                laurynas.biveinis Laurynas Biveinis
                Reporter:
                laurynas.biveinis Laurynas Biveinis
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 8 minutes
                  8m