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

main.signal_demo3 and sys_vars.max_sp_recursion_depth_func fail in biuldbot on labrador with Thread stack overrun

    XMLWordPrintable

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/labrador/builds/4205/steps/test/logs/stdio

      sys_vars.max_sp_recursion_depth_func     [ fail ]
              Test ended at 2014-11-24 15:25:04
       
      CURRENT_TEST: sys_vars.max_sp_recursion_depth_func
      mysqltest: At line 64: query 'CALL sp_addRecords(0,8)' failed: 1436: Thread stack overrun:  172008 bytes used of a 294912 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.
       
      The result from queries just before the failure was:
      < snip >
      ** Connection test_con1 **
      SET @@session.max_sp_recursion_depth = 10;
      SELECT @@session.max_sp_recursion_depth;
      @@session.max_sp_recursion_depth
      10
      DROP PROCEDURE IF EXISTS sp_addRecords;
      CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT)
      BEGIN
      SELECT var1,var2;
      IF var1 < var2 THEN
      CALL sp_addRecords(var1+1,var2);
      SELECT var1,var2;
      END IF;
      END //
      CALL sp_addRecords(0,8);

      main.signal_demo3                        [ fail ]
              Test ended at 2014-11-24 15:19:00
       
      CURRENT_TEST: main.signal_demo3
      mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun:  172008 bytes used of a 294912 byte stack, and 128000 bytes needed.  Use 'mysqld --thread_stack=#' to specify a bigger stack.', instead of 1644...
       
      The result from queries just before the failure was:
      < snip >
      resignal sqlstate '45000' set message_text='Oops in proc_7';
      call proc_8();
      end
      $$
      create procedure proc_8()
      begin
      declare exit handler for sqlexception
      resignal sqlstate '45000' set message_text='Oops in proc_8';
      call proc_9();
      end
      $$
      create procedure proc_9()
      begin
      declare exit handler for sqlexception
      resignal sqlstate '45000' set message_text='Oops in proc_9';
      ## Do something that fails, to see how errors are reported
      drop table oops_it_is_not_here;
      end
      $$
      call proc_1();

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.