10.7.0-dbg>INSTALL PLUGIN spider SONAME 'ha_spider.so';

ERROR 1126 (HY000): Can't open shared library '/test/UBASAN_MD100921-mariadb-10.7.0-linux-x86_64-dbg/lib/plugin/ha_spider.so' (errno: 2, undefined symbol: _ZTI12ha_partition)

ERROR 1126 (HY000) at line 2 in file: 't11': Can't open shared library '/test/UBSAN_SPIDER_MD101222-mariadb-10.5.19-linux-x86_64-dbg/lib/plugin/ha_spider.so' (errno: 2, undefined symbol: _ZTI12ha_partition)

diff --git a/storage/spider/CMakeLists.txt b/storage/spider/CMakeLists.txt

index 706b11ac141..0eb2140fe4b 100644

--- a/storage/spider/CMakeLists.txt

+++ b/storage/spider/CMakeLists.txt

@@ -78,3 +78,7 @@ IF(MSVC)

                        COMMAND copy Debug\\ha_spider.dll ..\\..\\sql\\lib\\plugin\\ha_spider.dll)

   ENDIF()

 ENDIF()

+

+if(WITH_UBSAN)

+  set(CMAKE_CXX_FLAGS "${CMAKE_CXX_FLAGS} -fno-rtti")

+endif()

--echo #

--echo # MDEV-26541 Undefined symbol: _ZTI12ha_partition when attempting to use ha_spider.so in UBSAN builds

--echo #

if (`select not(count(*)) from information_schema.system_variables where variable_name='have_sanitizer' and global_value="UBSAN"`)

{

--skip test needs to be run with UBSAN

}

# init spider

INSTALL PLUGIN spider SONAME 'ha_spider.so';

let $PLUGIN_NAME= spider_flush_table_mon_cache;

let $PLUGIN_EXIST=

  `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`;

while (!$PLUGIN_EXIST)

{

  let $PLUGIN_EXIST=

    `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`;

}

# deinit spider

DROP FUNCTION spider_flush_table_mon_cache;

DROP FUNCTION spider_copy_tables;

DROP FUNCTION spider_ping_table;

DROP FUNCTION spider_bg_direct_sql;

DROP FUNCTION spider_direct_sql;

UNINSTALL PLUGIN spider_alloc_mem;

UNINSTALL PLUGIN spider;

DROP TABLE IF EXISTS mysql.spider_xa;

DROP TABLE IF EXISTS mysql.spider_xa_member;

DROP TABLE IF EXISTS mysql.spider_xa_failed_log;

DROP TABLE IF EXISTS mysql.spider_tables;

DROP TABLE IF EXISTS mysql.spider_link_mon_servers;

DROP TABLE IF EXISTS mysql.spider_link_failed_log;

DROP TABLE IF EXISTS mysql.spider_table_position_for_recovery;

DROP TABLE IF EXISTS mysql.spider_table_sts;

DROP TABLE IF EXISTS mysql.spider_table_crd;

$ nm /home/ycp/source/mariadb-server/mdev-26541/build/mysql-test/var/plugins/ha_spider.so

...

0000000000b4a488 V _ZTI10Item_const

                 U _ZTI10Item_field

                 U _ZTI10Item_ident

                 U _ZTI11Item_string

                 U _ZTI11Query_arena

                 U _ZTI12ha_partition

...

$ nm -C /home/ycp/source/mariadb-server/mdev-26541/build/mysql-test/var/plugins/ha_spider.so

...

0000000000b4a488 V typeinfo for Item_const

                 U typeinfo for Item_field

                 U typeinfo for Item_ident

                 U typeinfo for Item_string

                 U typeinfo for Query_arena

                 U typeinfo for ha_partition

...

$ nm -C /home/ycp/source/mariadb-server/mdev-26541/build/sql/mysqld

...

0000000007beb3d8 d typeinfo for ha_partition

...

$ nm sql/mysqld | grep 0000000007beb3d8

0000000007beb3d8 d _ZTI12ha_partition

$ nm /home/ycp/source/mariadb-server/mdev-26541/build/mysql-test/var/plugins/ha_spider.so | grep ha_partition

0000000000782488 W _ZN12ha_partition18get_child_handlersEv

$ nm -C /home/ycp/source/mariadb-server/mdev-26541/build/mysql-test/var/plugins/ha_spider.so | grep ha_partition

0000000000782488 W ha_partition::get_child_handlers()

$ ./mysql-test/mtr spider.basic_sql

...

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

spider.basic_sql                         [ fail ]  Found warnings/errors in server log file!

        Test ended at 2022-12-21 18:56:23

line

/home/ycp/source/mariadb-server/mdev-26541/src/sql/handler.cc:320:17: runtime error: member call on address 0x7f54e8016ce8 which does not point to an object of type 'handler'

/home/ycp/source/mariadb-server/mdev-26541/src/sql/handler.h:3168:36: runtime error: member call on address 0x7f54e8016ce8 which does not point to an object of type 'handler'

/home/ycp/source/mariadb-server/mdev-26541/src/sql/handler.h:3168:5: runtime error: member access within address 0x7f54e8016ce8 which does not point to an object of type 'handler'

/home/ycp/source/mariadb-server/mdev-26541/src/sql/sql_table.cc:3463:39: runtime error: member call on address 0x7f54e8016ce8 which does not point to an object of type 'handler'

/home/ycp/source/mariadb-server/mdev-26541/src/sql/handler.h:3922:12: runtime error: member call on address 0x7f54e8016ce8 which does not point to an object of type 'handler'

/home/ycp/source/mariadb-server/mdev-26541/src/sql/sql_table.cc:3497:61: runtime error: member call on address 0x7f54e8016ce8 which does not point to an object of type 'handler'

...

diff --git a/cmake/libutils.cmake b/cmake/libutils.cmake

index 74853c36a74..a6d2628fffc 100644

--- a/cmake/libutils.cmake

+++ b/cmake/libutils.cmake

@@ -344,11 +344,6 @@ SET(VISIBILITY_HIDDEN_FLAG)

 IF(CMAKE_C_COMPILER_ID MATCHES "SunPro")

   SET(VISIBILITY_HIDDEN_FLAG "-xldscope=hidden")

-ELSEIF(UNIX)

-  CHECK_C_COMPILER_FLAG("-fvisibility=hidden" HAVE_VISIBILITY_HIDDEN)

-  IF(HAVE_VISIBILITY_HIDDEN)

-    SET(VISIBILITY_HIDDEN_FLAG "-fvisibility=hidden")

-  ENDIF()

 ENDIF()

 # We try to hide the symbols in bundled libraries to avoid name clashes with

  IF(VISIBILITY_HIDDEN_FLAG AND TARGET wsrep)

diff --git a/storage/spider/spd_conn.cc b/storage/spider/spd_conn.cc

index 80d2489185b..a0b36dbe0b6 100644

--- a/storage/spider/spd_conn.cc

+++ b/storage/spider/spd_conn.cc

@@ -648,8 +648,8 @@ SPIDER_CONN *spider_create_conn(

       share->tgt_usernames_lengths[link_idx]);

     conn->tgt_password_length = share->tgt_passwords_lengths[link_idx];

     conn->tgt_password = tmp_password;

-    memcpy(conn->tgt_password, share->tgt_passwords[link_idx],

-      share->tgt_passwords_lengths[link_idx]);

+    if (size_t s= share->tgt_passwords_lengths[link_idx])

+      memcpy(conn->tgt_password, share->tgt_passwords[link_idx], s);

     conn->tgt_socket_length = share->tgt_sockets_lengths[link_idx];

     conn->tgt_socket = tmp_socket;

     memcpy(conn->tgt_socket, share->tgt_sockets[link_idx],

Completed: Failed 3/40 tests, 92.50% were successful.

Failing test(s): spider.ha_part spider.auto_increment spider.ha