[#MDEV-24779] main.subselect fails in buildbot with --ps-protocol

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

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

mysqld: /data/src/10.2/sql/sql_prepare.cc:3097: void reinit_stmt_before_use(THD*, LEX*): Assertion `sl->join == 0' failed.

210203 18:25:12 [ERROR] mysqld got signal 6 ;

#7  0x00007fde14c74f36 in __GI___assert_fail (assertion=0x556f2f8d1826 "sl->join == 0", file=0x556f2f8d1058 "/data/src/10.2/sql/sql_prepare.cc", line=3097, function=0x556f2f8d17f0 "void reinit_stmt_before_use(THD*, LEX*)") at assert.c:101

#8  0x0000556f2ee829b3 in reinit_stmt_before_use (thd=0x7fddf4000d90, lex=0x7fddf407d580) at /data/src/10.2/sql/sql_prepare.cc:3097

#9  0x0000556f2ee875a6 in Prepared_statement::execute (this=0x7fddf40a3a80, expanded_query=0x7fde0ada49a0, open_cursor=false) at /data/src/10.2/sql/sql_prepare.cc:5012

#10 0x0000556f2ee85ba4 in Prepared_statement::execute_loop (this=0x7fddf40a3a80, expanded_query=0x7fde0ada49a0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.2/sql/sql_prepare.cc:4466

#11 0x0000556f2ee83904 in mysql_sql_stmt_execute (thd=0x7fddf4000d90) at /data/src/10.2/sql/sql_prepare.cc:3574

#12 0x0000556f2ee5bcb0 in mysql_execute_command (thd=0x7fddf4000d90) at /data/src/10.2/sql/sql_parse.cc:3575

#13 0x0000556f2ee69065 in mysql_parse (thd=0x7fddf4000d90, rawbuf=0x7fddf40126f8 "EXECUTE stmt", length=12, parser_state=0x7fde0ada55f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7763

#14 0x0000556f2ee5733e in dispatch_command (command=COM_QUERY, thd=0x7fddf4000d90, packet=0x7fddf4008b51 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827

#15 0x0000556f2ee55e39 in do_command (thd=0x7fddf4000d90) at /data/src/10.2/sql/sql_parse.cc:1381

#16 0x0000556f2efb088e in do_handle_one_connection (connect=0x556f32546980) at /data/src/10.2/sql/sql_connect.cc:1336

#17 0x0000556f2efb05f3 in handle_one_connection (arg=0x556f32546980) at /data/src/10.2/sql/sql_connect.cc:1241

#18 0x0000556f2f7d8b82 in pfs_spawn_thread (arg=0x556f32529d90) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#19 0x00007fde15184609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#20 0x00007fde14d60293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

[MDEV-24779] main.subselect fails in buildbot with --ps-protocol Created: 2021-02-03 Updated: 2021-06-30 Resolved: 2021-02-16
Status:	Closed
Project:	MariaDB Server
Component/s:	Prepared Statements
Affects Version/s:	10.2, 10.3, 10.4, 10.5
Fix Version/s:	10.2.38, 10.3.29, 10.4.19, 10.5.10

[MDEV-24779] main.subselect fails in buildbot with --ps-protocol Created: 2021-02-03 Updated: 2021-06-30 Resolved: 2021-02-16