| Bug #111376 | Assertion `!thd->lex->is_exec_started() || thd->lex->is_query_tables_locked()' f | ||
|---|---|---|---|
| Submitted: | 13 Jun 2023 2:37 | Modified: | 13 Jun 2023 7:48 |
| Reporter: | Yu Liang | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S6 (Debug Builds) |
| Version: | 8.0.33 | OS: | Ubuntu (20.04 LTS) |
| Assigned to: | CPU Architecture: | x86 (Intel(R) Core(TM) i7-10700 CPU) | |
[13 Jun 2023 2:37]
Yu Liang
[13 Jun 2023 7:48]
MySQL Verification Team
Hello Yu Liang, Thank you for the report and test case. Observed that 8.0.33 only debug build is affected. regards, Umesh
[13 Jun 2023 7:49]
MySQL Verification Team
-- release build ./mtr bug111376 --nocheck-testcases Logging: ./mtr bug111376 --nocheck-testcases MySQL Version 8.0.33 Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/binaries/mysql-8.0.33/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ drop database if exists test123; Warnings: Note 1008 Can't drop database 'test123'; database doesn't exist create database test123; use test123; create table v0(c1 INT); CREATE TABLE v3 ( c4 NATIONAL CHAR ) PARTITION BY HASH ( c1 ) AS TABLE v0 ; Warnings: Warning 3720 NATIONAL/NCHAR/NVARCHAR implies the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using CHAR(x) CHARACTER SET UTF8MB4 in order to be unambiguous. CREATE TABLE v5 ( INDEX ( ( c4 SOUNDS LIKE TRUE ) ) ) AS TABLE v3 ; [ 50%] main.bug111376 [ pass ] 128 [100%] shutdown_report [ pass ] -- debug build - affected ./mtr bug111376 --nocheck-testcases --debug-server Logging: ./mtr bug111376 --nocheck-testcases --debug-server MySQL Version 8.0.33 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/binaries/mysql-8.0.33/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ drop database if exists test123; Warnings: Note 1008 Can't drop database 'test123'; database doesn't exist create database test123; use test123; create table v0(c1 INT); CREATE TABLE v3 ( c4 NATIONAL CHAR ) PARTITION BY HASH ( c1 ) AS TABLE v0 ; Warnings: Warning 3720 NATIONAL/NCHAR/NVARCHAR implies the character set UTF8MB3, which will be replaced by UTF8MB4 in a future release. Please consider using CHAR(x) CHARACTER SET UTF8MB4 in order to be unambiguous. CREATE TABLE v5 ( INDEX ( ( c4 SOUNDS LIKE TRUE ) ) ) AS TABLE v3 ; [ 50%] main.bug111376 [ fail ] Test ended at 2023-06-13 09:48:01 CURRENT_TEST: main.bug111376 mysqltest: At line 6: Query 'CREATE TABLE v5 ( INDEX ( ( c4 SOUNDS LIKE TRUE ) ) ) AS TABLE v3 ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query -bt #0 0x00007fa735e43aa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000004005426 in my_write_core(int) () #2 0x00000000032b0166 in handle_fatal_signal () #3 <signal handler called> #4 0x00007fa734304387 in raise () from /lib64/libc.so.6 #5 0x00007fa734305a78 in abort () from /lib64/libc.so.6 #6 0x00007fa7342fd1a6 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fa7342fd252 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000033f5684 in Item::may_evaluate_const(THD const*) const () #9 0x000000000340b445 in Item_charset_conversion::Item_charset_conversion(THD*, Item*, CHARSET_INFO const*, bool) () #10 0x000000000340b54d in Item_func_conv_charset::Item_func_conv_charset(THD*, Item*, CHARSET_INFO const*, bool) () #11 0x00000000033fb15d in Item::safe_charset_converter(THD*, CHARSET_INFO const*) () #12 0x00000000033fb366 in agg_item_set_converter(DTCollation&, char const*, Item**, unsigned int, unsigned int, int, bool) () #13 0x00000000033fb436 in agg_item_charsets(DTCollation&, char const*, Item**, unsigned int, unsigned int, int, bool) () #14 0x00000000034221b5 in agg_item_charsets_for_comparison(DTCollation&, char const*, Item**, unsigned int, int) () #15 0x00000000034224c2 in Item_func::agg_arg_charsets_for_comparison(DTCollation&, Item**, unsigned int, int) () #16 0x0000000003419829 in Item_bool_func2::resolve_type(THD*) () #17 0x00000000034585ca in Item_func::fix_fields(THD*, Item**) () #18 0x000000000354a683 in Key_part_spec::resolve_expression(THD*) () #19 0x00000000031d8649 in add_functional_index_to_create_list(THD*, Key_spec*, Alter_info*, Key_part_spec*, unsigned int, HA_CREATE_INFO*) () #20 0x00000000031da8ba in mysql_prepare_create_table(THD*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, handler*, bool, KEY**, unsigned int*, FOREIGN_KEY**, unsigned int*, FOREIGN_KEY*, unsigned int, dd::Table const*, unsigned int, int, bool) () #21 0x00000000031dc05c in create_table_impl(THD*, dd::Schema const&, char const*, char const*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, bool, unsigned int, bool, bool, bool, bool*, KEY**, unsigned int*, Alter_info::enum_enable_or_disable, FOREIGN_KEY**, unsigned int*, FOREIGN_KEY*, unsigned int, dd::Table const*, unsigned int, std::unique_ptr<dd::Table, std::default_delete<dd::Table> >*, handlerton**) () #22 0x00000000031dcaa5 in mysql_create_table_no_lock(THD*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, unsigned int, bool, bool*, handlerton**) () #23 0x0000000003602485 in create_table_from_items(THD*, HA_CREATE_INFO*, Table_ref*, Alter_info*, mem_root_deque<Item*> const&, handlerton**) () #24 0x0000000003602668 in Query_result_create::create_table_for_query_block(THD*) () #25 0x00000000035ede58 in populate_table(THD*, LEX*) () #26 0x00000000035eeb2c in Sql_cmd_create_table::execute(THD*) () #27 0x000000000313d2da in mysql_execute_command(THD*, bool) () #28 0x0000000003140bc8 in dispatch_sql_command(THD*, Parser_state*) () #29 0x00000000031421fb in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #30 0x0000000003143e97 in do_command(THD*) () #31 0x00000000032a219e in handle_connection () #32 0x00000000047b1601 in pfs_spawn_thread () #33 0x00007fa735e3eea5 in start_thread () from /lib64/libpthread.so.0 #34 0x00007fa7343ccb2d in clone () from /lib64/libc.so.6
