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

main.signal_demo3 fails in buildbot on labrador

Details

    Description

      This kind of failure appeared only recently, first in bb-10.2-serg and then in 10.2:
      http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8786/steps/test/logs/stdio

      main.signal_demo3                        [ fail ]
              Test ended at 2017-01-03 21:37:10
       
      CURRENT_TEST: main.signal_demo3
      mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1051: 'Unknown table 'demo.oops_it_is_not_here'', 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();
      

      Another more frequent variation, which is, according to cross-reference, has happened on various trees:
      http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8739/steps/test/logs/stdio

      main.signal_demo3                        [ fail ]
              Test ended at 2017-01-04 18:21:11
       
      CURRENT_TEST: main.signal_demo3
      mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun:  186352 bytes used of a 297984 byte stack, and 112000 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();
       
      More results from queries before failure can be found in /Users/mariadb/elenst/bb-10.2-serg/mysql-test/var/log/signal_demo3.log
      

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Description This kind of failure appeared only recently, first in bb-10.2-serg and then in 10.2:
            http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8786/steps/test/logs/stdio

            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-03 21:37:10

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1051: 'Unknown table 'demo.oops_it_is_not_here'', 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();
            {noformat}
            This kind of failure appeared only recently, first in bb-10.2-serg and then in 10.2:
            http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8786/steps/test/logs/stdio

            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-03 21:37:10

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1051: 'Unknown table 'demo.oops_it_is_not_here'', 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();
            {noformat}

            Another more frequent variation, which is, according to cross-reference, has happened on various trees:
            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-04 18:21:11

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun: 186352 bytes used of a 297984 byte stack, and 112000 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();

            More results from queries before failure can be found in /Users/mariadb/elenst/bb-10.2-serg/mysql-test/var/log/signal_demo3.log
            {noformat}
            elenst Elena Stepanova made changes -
            Affects Version/s 5.5 [ 15800 ]
            Affects Version/s 10.0 [ 16000 ]
            Affects Version/s 10.1 [ 16100 ]
            elenst Elena Stepanova made changes -
            Description This kind of failure appeared only recently, first in bb-10.2-serg and then in 10.2:
            http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8786/steps/test/logs/stdio

            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-03 21:37:10

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1051: 'Unknown table 'demo.oops_it_is_not_here'', 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();
            {noformat}

            Another more frequent variation, which is, according to cross-reference, has happened on various trees:
            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-04 18:21:11

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun: 186352 bytes used of a 297984 byte stack, and 112000 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();

            More results from queries before failure can be found in /Users/mariadb/elenst/bb-10.2-serg/mysql-test/var/log/signal_demo3.log
            {noformat}
            This kind of failure appeared only recently, first in bb-10.2-serg and then in 10.2:
            http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8786/steps/test/logs/stdio

            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-03 21:37:10

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1051: 'Unknown table 'demo.oops_it_is_not_here'', 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();
            {noformat}

            Another more frequent variation, which is, according to cross-reference, has happened on various trees:
            http://buildbot.askmonty.org/buildbot/builders/labrador/builds/8739/steps/test/logs/stdio
            {noformat}
            main.signal_demo3 [ fail ]
                    Test ended at 2017-01-04 18:21:11

            CURRENT_TEST: main.signal_demo3
            mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun: 186352 bytes used of a 297984 byte stack, and 112000 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();

            More results from queries before failure can be found in /Users/mariadb/elenst/bb-10.2-serg/mysql-test/var/log/signal_demo3.log
            {noformat}
            elenst Elena Stepanova made changes -
            Fix Version/s 5.5 [ 15800 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            elenst Elena Stepanova made changes -
            Component/s Stored routines [ 13905 ]
            serg Sergei Golubchik made changes -
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 5.5 [ 15800 ]
            Affects Version/s 10.0 [ 16000 ]
            Affects Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 5.5-galera [ 21900 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 5.5 [ 15800 ]
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Affects Version/s 5.5-galera [ 21900 ]
            serg Sergei Golubchik made changes -
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 5.5-galera [ 21900 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 5.5-galera [ 21900 ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2.5 [ 22117 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 79071 ] MariaDB v4 [ 151485 ]

            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.