Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
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
- causes
-
-
- Closed
-
- is caused by
-
-
- Closed
-
To make it better searchable in JIRA:
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