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

main.subselect fails in buildbot with --ps-protocol

    XMLWordPrintable

    Details

      Description

      main.subselect                           w2 [ fail ]
              Test ended at 2021-02-01 04:23:35
       
      CURRENT_TEST: main.subselect
      /mnt/buildbot/build/mariadb-10.2.37/client/mysqltest: Error on delete of '/mnt/buildbot/build/mariadb-10.2.37/mysql-test/var/2/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory")
      mysqltest: At line 5898: query 'select exists(select 1 from t1 group by `c` in (select `c` from t1))' failed: 2013: Lost connection to MySQL server during query
      
      

      Core was generated by `/mnt/buildbot/build/mariadb-10.2.37/sql/mysqld --defaults-group-suffix=.1 --def'.
      Program terminated with signal SIGABRT, Aborted.
      #0  0xb7754c31 in __kernel_vsyscall ()
      [Current thread is 1 (Thread 0xb0dfeb40 (LWP 1365))]
      #0  0xb7754c31 in __kernel_vsyscall ()
      #1  0xb73b3ce1 in pthread_kill () from /lib/i386-linux-gnu/libpthread.so.0
      #2  0x80d5392d in my_write_core (sig=6) at /home/buildbot/buildbot/build/mariadb-10.2.37/mysys/stacktrace.c:382
      #3  0x8064888a in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/signal_handler.cc:343
      #4  <signal handler called>
      #5  0xb7754c31 in __kernel_vsyscall ()
      #6  0xb7032e89 in raise () from /lib/i386-linux-gnu/libc.so.6
      #7  0xb70343e7 in abort () from /lib/i386-linux-gnu/libc.so.6
      #8  0xb702bd07 in ?? () from /lib/i386-linux-gnu/libc.so.6
      #9  0xb702bd8b in __assert_fail () from /lib/i386-linux-gnu/libc.so.6
      #10 0x8040ac27 in reinit_stmt_before_use (thd=0xb06005d0, lex=0xb0655970) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:3097
      #11 0x8040f039 in Prepared_statement::execute (this=0xb041ffc0, expanded_query=0xb0dfd9bc, open_cursor=false) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:5012
      #12 0x8040d90c in Prepared_statement::execute_loop (this=0xb041ffc0, expanded_query=0xb0dfd9bc, open_cursor=false, packet=0xb0605a52 "", packet_end=0xb0605a52 "") at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:4466
      #13 0x8040b642 in mysql_stmt_execute_common (thd=0xb06005d0, stmt_id=2250, packet=0xb0605a52 "", packet_end=0xb0605a52 "", cursor_flags=0, bulk_op=false, read_types=false) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:3468
      #14 0x8040b09d in mysqld_stmt_execute (thd=0xb06005d0, packet_arg=0xb0605a49 "\312\b", packet_length=9) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:3259
      #15 0x803e0e7b in dispatch_command (command=COM_STMT_EXECUTE, thd=0xb06005d0, packet=0xb0605a49 "\312\b", packet_length=9, is_com_multi=false, is_next_command=false) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_parse.cc:1770
      #16 0x803dfbc6 in do_command (thd=0xb06005d0) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_parse.cc:1382
      #17 0x805243ec in do_handle_one_connection (connect=0x832ba6e8) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_connect.cc:1336
      #18 0x8052414c in handle_one_connection (arg=0x832ba6e8) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_connect.cc:1241
      #19 0x8084a8f8 in pfs_spawn_thread (arg=0x832f4748) at /home/buildbot/buildbot/build/mariadb-10.2.37/storage/perfschema/pfs.cc:1869
      #20 0xb73ad2b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
      #21 0xb70ee16e in clone () from /lib/i386-linux-gnu/libc.so.6
      

      The failure happens with the commit

      commit 26f5033555a9bb33d3d8b68e2d766e274bec28ba (origin/bb-10.2-varun)
      Author: Varun Gupta <varun.gupta@mariadb.com>
      Date:   Sun Jan 31 19:55:07 2021 +0530
       
          MDEV-23449: alias do not exist and a query do not report an error
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              varun Varun Gupta (Inactive)
              Reporter:
              varun Varun Gupta (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: