MSAN error in basic spider spider/bg.direct_update test

spider/bg.direct_update                  [ fail ]

        Test ended at 2024-09-25 06:01:32

CURRENT_TEST: spider/bg.direct_update

mysqltest: In included file "/source/storage/spider/mysql-test/spider/bg/t/../include/../../include/init_spider.inc": 

included from /source/storage/spider/mysql-test/spider/bg/t/../include/init_master_1.inc at line 2:

included from /source/storage/spider/mysql-test/spider/bg/t/test_init.inc at line 12:

included from /source/storage/spider/mysql-test/spider/bg/t/direct_update.test at line 5:

At line 79: query 'INSTALL SONAME 'ha_spider'' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:

for master_1

Server [mysqld.1.1 - pid: 175391, winpid: 175391, exit: 256] failed during test run

Server log from this test:

----------SERVER LOG START-----------

$ /build/sql/mariadbd --defaults-group-suffix=.1.1 --defaults-file=/build/mysql-test/var/my.cnf --log-output=file --loose-innodb --loose-skip-performance-schema --core-file --loose-debug-sync-timeout=300

2024-09-25  6:01:29 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32198)

2024-09-25  6:01:29 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2024-09-25  6:01:29 0 [Note] Starting MariaDB 10.5.27-MariaDB-log source revision  server_uid rXZzxG4wJdhNnfqapJAChQVA4hg= as process 175392

2024-09-25  6:01:29 0 [Note] Plugin 'SEQUENCE' is disabled.

....

2024-09-25  6:01:30 0 [Note] /build/sql/mariadbd: ready for connections.

Version: '10.5.27-MariaDB-log'  socket: '/build/mysql-test/var/tmp/mysqld.1.1.sock'  port: 19000  Source distribution

==175392==WARNING: MemorySanitizer: use-of-uninitialized-value

    #0 0x56408b1b1d82 in my_ok(THD*, unsigned long long, unsigned long long, char const*) /source/sql/sql_class.h:5484:23

    #1 0x56408b1b1d82 in do_execute_sp(THD*, sp_head*) /source/sql/sql_parse.cc:3124:3

    #2 0x56408b1b677a in mysql_execute_command(THD*) /source/sql/sql_parse.cc:5905:9

    #3 0x56408b20a6dc in execute_server_code(THD*, char const*, unsigned long) /source/sql/sql_prepare.cc:3989:10

    #4 0x56408b21e152 in loc_advanced_command(st_mysql*, enum_server_command, unsigned char const*, unsigned long, unsigned char const*, unsigned long, char, st_mysql_stmt*) /source/sql/sql_prepare.cc:6138:13

    #5 0x56408b8829d9 in server_mysql_send_query /source/sql-common/client.c:3615:3

    #6 0x56408b8829d9 in server_mysql_real_query /source/sql-common/client.c:3625:7

    #7 0x7f6747ce0285 in spider_init_system_tables() /source/storage/spider/spd_table.cc:6172:9

    #8 0x7f6747ce2134 in spider_db_init(void*) /source/storage/spider/spd_table.cc:6461:7

    #9 0x56408b92034e in ha_initialize_handlerton(st_plugin_int*) /source/sql/handler.cc:653:37

    #10 0x56408b1e561f in plugin_do_initialize(st_plugin_int*, unsigned int&) /source/sql/sql_plugin.cc:1451:18

    #11 0x56408b1e27c0 in plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool) /source/sql/sql_plugin.cc:1504:10

    #12 0x56408b1ecb57 in finalize_install(THD*, TABLE*, st_mysql_const_lex_string const*, int*, char**) /source/sql/sql_plugin.cc:2221:9

    #13 0x56408b1eb080 in mysql_install_plugin(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /source/sql/sql_plugin.cc:2329:11

    #14 0x56408b1b67fe in mysql_execute_command(THD*) /source/sql/sql_parse.cc:6082:17

    #15 0x56408b1a6dae in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /source/sql/sql_parse.cc:8236:18

    #16 0x56408b19f451 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /source/sql/sql_parse.cc:1892:7

    #17 0x56408b1a7d4f in do_command(THD*) /source/sql/sql_parse.cc:1376:17

    #18 0x56408b557f0e in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1417:11

    #19 0x56408b557a55 in handle_one_connection /source/sql/sql_connect.cc:1319:5

    #20 0x56408c1484b9 in pfs_spawn_thread /source/storage/perfschema/pfs.cc:2201:3

    #21 0x7f674d2a8143  (/lib/x86_64-linux-gnu/libc.so.6+0x89143) (BuildId: 30f067a5eccdb3bdce0b9ec7638ebd86992b9c8b)

    #22 0x7f674d3287db  (/lib/x86_64-linux-gnu/libc.so.6+0x1097db) (BuildId: 30f067a5eccdb3bdce0b9ec7638ebd86992b9c8b)

  Uninitialized value was stored to memory at

    #0 0x56408b1b1d7b in do_execute_sp(THD*, sp_head*) /source/sql/sql_parse.cc:3122:23

    #1 0x56408b1b677a in mysql_execute_command(THD*) /source/sql/sql_parse.cc:5905:9

    #2 0x56408b20a6dc in execute_server_code(THD*, char const*, unsigned long) /source/sql/sql_prepare.cc:3989:10

    #3 0x56408b21e152 in loc_advanced_command(st_mysql*, enum_server_command, unsigned char const*, unsigned long, unsigned char const*, unsigned long, char, st_mysql_stmt*) /source/sql/sql_prepare.cc:6138:13

    #4 0x56408b8829d9 in server_mysql_send_query /source/sql-common/client.c:3615:3

    #5 0x56408b8829d9 in server_mysql_real_query /source/sql-common/client.c:3625:7

    #6 0x7f6747ce0285 in spider_init_system_tables() /source/storage/spider/spd_table.cc:6172:9

    #7 0x7f6747ce2134 in spider_db_init(void*) /source/storage/spider/spd_table.cc:6461:7

    #8 0x56408b92034e in ha_initialize_handlerton(st_plugin_int*) /source/sql/handler.cc:653:37

    #9 0x56408b1e561f in plugin_do_initialize(st_plugin_int*, unsigned int&) /source/sql/sql_plugin.cc:1451:18

    #10 0x56408b1e27c0 in plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool) /source/sql/sql_plugin.cc:1504:10

    #11 0x56408b1ecb57 in finalize_install(THD*, TABLE*, st_mysql_const_lex_string const*, int*, char**) /source/sql/sql_plugin.cc:2221:9

    #12 0x56408b1eb080 in mysql_install_plugin(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /source/sql/sql_plugin.cc:2329:11

    #13 0x56408b1b67fe in mysql_execute_command(THD*) /source/sql/sql_parse.cc:6082:17

    #14 0x56408b1a6dae in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /source/sql/sql_parse.cc:8236:18

    #15 0x56408b19f451 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /source/sql/sql_parse.cc:1892:7

    #16 0x56408b1a7d4f in do_command(THD*) /source/sql/sql_parse.cc:1376:17

    #17 0x56408b557f0e in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1417:11

    #18 0x56408b557a55 in handle_one_connection /source/sql/sql_connect.cc:1319:5

    #19 0x56408c1484b9 in pfs_spawn_thread /source/storage/perfschema/pfs.cc:2201:3

    #20 0x7f674d2a8143  (/lib/x86_64-linux-gnu/libc.so.6+0x89143) (BuildId: 30f067a5eccdb3bdce0b9ec7638ebd86992b9c8b)

  Uninitialized value was stored to memory at

    #0 0x56408b0a0ce2 in THD::set_affected_rows(long long) /source/sql/sql_class.h:3161:18

    #1 0x56408b0a0ce2 in my_ok(THD*, unsigned long long, unsigned long long, char const*) /source/sql/sql_class.h:5483:8

    #2 0x56408b0a0ce2 in select_dumpvar::send_eof() /source/sql/sql_class.cc:4330:5

    #3 0x56408b2a7faa in do_select(JOIN*, Procedure*) /source/sql/sql_select.cc:20850:9

    #4 0x56408b2a5322 in JOIN::exec_inner() /source/sql/sql_select.cc:4659:50

    #5 0x56408b23e740 in JOIN::exec() /source/sql/sql_select.cc:4439:3

    #6 0x56408b23e740 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /source/sql/sql_select.cc:4916:9

    #7 0x56408b23d957 in handle_select(THD*, LEX*, select_result*, unsigned long) /source/sql/sql_select.cc:449:10

    #8 0x56408b1c775e in execute_sqlcom_select(THD*, TABLE_LIST*) /source/sql/sql_parse.cc:6438:12

    #9 0x56408b1b56f7 in mysql_execute_command(THD*) /source/sql/sql_parse.cc:4030:12

    #10 0x56408b20a6dc in execute_server_code(THD*, char const*, unsigned long) /source/sql/sql_prepare.cc:3989:10

    #11 0x56408b21e152 in loc_advanced_command(st_mysql*, enum_server_command, unsigned char const*, unsigned long, unsigned char const*, unsigned long, char, st_mysql_stmt*) /source/sql/sql_prepare.cc:6138:13

    #12 0x56408b8829d9 in server_mysql_send_query /source/sql-common/client.c:3615:3

    #13 0x56408b8829d9 in server_mysql_real_query /source/sql-common/client.c:3625:7

    #14 0x7f6747ce0285 in spider_init_system_tables() /source/storage/spider/spd_table.cc:6172:9

    #15 0x7f6747ce2134 in spider_db_init(void*) /source/storage/spider/spd_table.cc:6461:7

    #16 0x56408b92034e in ha_initialize_handlerton(st_plugin_int*) /source/sql/handler.cc:653:37

    #17 0x56408b1e561f in plugin_do_initialize(st_plugin_int*, unsigned int&) /source/sql/sql_plugin.cc:1451:18

    #18 0x56408b1e27c0 in plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool) /source/sql/sql_plugin.cc:1504:10

    #19 0x56408b1ecb57 in finalize_install(THD*, TABLE*, st_mysql_const_lex_string const*, int*, char**) /source/sql/sql_plugin.cc:2221:9

    #20 0x56408b1eb080 in mysql_install_plugin(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /source/sql/sql_plugin.cc:2329:11

    #21 0x56408b1b67fe in mysql_execute_command(THD*) /source/sql/sql_parse.cc:6082:17

    #22 0x56408b1a6dae in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /source/sql/sql_parse.cc:8236:18

    #23 0x56408b19f451 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /source/sql/sql_parse.cc:1892:7

  Memory was marked as uninitialized

    #0 0x56408ae8a6ed in __msan_allocated_memory (/build/sql/mariadbd+0x7536ed) (BuildId: 02b38507251428ebcfcf3f6869b8dd113ffee626)

    #1 0x56408cbb1066 in my_malloc /source/mysys/my_malloc.c:114:7

    #2 0x56408b217e81 in ilink::operator new(unsigned long) /source/sql/sql_list.h:679:19

    #3 0x56408b217e81 in mysql_real_connect_local /source/sql/sql_prepare.cc:6314:14

    #4 0x7f6747ce01d6 in spider_init_system_tables() /source/storage/spider/spd_table.cc:6162:8

    #5 0x7f6747ce2134 in spider_db_init(void*) /source/storage/spider/spd_table.cc:6461:7

    #6 0x56408b92034e in ha_initialize_handlerton(st_plugin_int*) /source/sql/handler.cc:653:37

    #7 0x56408b1e561f in plugin_do_initialize(st_plugin_int*, unsigned int&) /source/sql/sql_plugin.cc:1451:18

    #8 0x56408b1e27c0 in plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool) /source/sql/sql_plugin.cc:1504:10

    #9 0x56408b1ecb57 in finalize_install(THD*, TABLE*, st_mysql_const_lex_string const*, int*, char**) /source/sql/sql_plugin.cc:2221:9

    #10 0x56408b1eb080 in mysql_install_plugin(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /source/sql/sql_plugin.cc:2329:11

    #11 0x56408b1b67fe in mysql_execute_command(THD*) /source/sql/sql_parse.cc:6082:17

    #12 0x56408b1a6dae in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /source/sql/sql_parse.cc:8236:18

    #13 0x56408b19f451 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /source/sql/sql_parse.cc:1892:7

    #14 0x56408b1a7d4f in do_command(THD*) /source/sql/sql_parse.cc:1376:17

    #15 0x56408b557f0e in do_handle_one_connection(CONNECT*, bool) /source/sql/sql_connect.cc:1417:11

    #16 0x56408b557a55 in handle_one_connection /source/sql/sql_connect.cc:1319:5

    #17 0x56408c1484b9 in pfs_spawn_thread /source/storage/perfschema/pfs.cc:2201:3

    #18 0x7f674d2a8143  (/lib/x86_64-linux-gnu/libc.so.6+0x89143) (BuildId: 30f067a5eccdb3bdce0b9ec7638ebd86992b9c8b)

SUMMARY: MemorySanitizer: use-of-uninitialized-value /source/sql/sql_class.h:5484:23 in my_ok(THD*, unsigned long long, unsigned long long, char const*)

Exiting

240925  6:01:31 [ERROR] mysqld got signal 6 ;

Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed, 

something is definitely wrong and this may fail.

Server version: 10.5.27-MariaDB-log source revision: 

key_buffer_size=1048576

read_buffer_size=131072

max_used_connections=2

max_threads=153

thread_count=3

It is possible that mysqld could use up to 

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63726 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

WSREP: Suppressing further logging

WSREP: Shutting down network communications

libc++abi: terminating due to uncaught exception of type wsrep::runtime_error: provider not loaded

----------SERVER LOG END-------------