Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27895

Performance Schema: Assertion `host_length <= HOSTNAME_LENGTH' failed, and Assertions host_length <= 255 and host_length <= 60 in set_setup_actor_key on INSERT

    XMLWordPrintable

Details

    Description

      # mysqld options required for replay:  --performance-schema
      INSERT INTO performance_schema.setup_actors VALUES ('%','USR','%');
      SET SESSION sql_mode='pad_char_to_full_length';
      SET CHARACTER SET 'BINARY';
      SET collation_connection=ucs2_general_ci;
      INSERT INTO performance_schema.setup_actors SET USER='a',HOST='LOCALHOST';
      

      Leads to:

      10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug)

      mysqld: /test/10.9_dbg/storage/perfschema/pfs_setup_actor.cc:125: void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, const char*, uint, const char*, uint): Assertion `host_length <= HOSTNAME_LENGTH' failed.
      

      10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug)

      Core was generated by `/test/MD140222-mariadb-10.9.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x14c33012b700 (LWP 3965514))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x000014c359ea6859 in __GI_abort () at abort.c:79
      #2  0x000014c359ea6729 in __assert_fail_base (fmt=0x14c35a03c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x555b4b9e34c0 "host_length <= HOSTNAME_LENGTH", file=0x555b4b9e64a8 "/test/10.9_dbg/storage/perfschema/pfs_setup_actor.cc", line=125, function=<optimized out>) at assert.c:92
      #3  0x000014c359eb7f36 in __GI___assert_fail (assertion=assertion@entry=0x555b4b9e34c0 "host_length <= HOSTNAME_LENGTH", file=file@entry=0x555b4b9e64a8 "/test/10.9_dbg/storage/perfschema/pfs_setup_actor.cc", line=line@entry=125, function=function@entry=0x555b4b9e64e0 "void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, const char*, uint, const char*, uint)") at assert.c:101
      #4  0x0000555b4b118c28 in set_setup_actor_key (key=0x555b4e1e7184, user=<optimized out>, user_length=<optimized out>, host=0x14c280021381 "L佃䅌䡏協", ' ' <repeats 187 times>..., host_length=263, role=0x555b4b9c88e3 "%", role_length=1) at /test/10.9_dbg/storage/perfschema/pfs_setup_actor.cc:140
      #5  0x0000555b4b119488 in insert_setup_actor (user=user@entry=0x14c330129980, host=host@entry=0x14c3301299a0, role=role@entry=0x14c3301299c0, enabled=enabled@entry=true, history=history@entry=true) at /test/10.9_dbg/sql/sql_string.h:278
      #6  0x0000555b4b14116a in table_setup_actors::write_row (table=0x14c2800204a8, buf=<optimized out>, fields=0x14c280020928) at /test/10.9_dbg/storage/perfschema/table_setup_actors.cc:123
      #7  0x0000555b4b104696 in PFS_engine_table_share::write_row (this=<optimized out>, table=0x14c2800204a8, buf=buf@entry=0x14c280021380 "\377L佃䅌䡏協", ' ' <repeats 186 times>..., fields=<optimized out>) at /test/10.9_dbg/storage/perfschema/pfs_engine_table.cc:372
      #8  0x0000555b4b0f2f56 in ha_perfschema::write_row (this=0x14c280020d80, buf=0x14c280021380 "\377L佃䅌䡏協", ' ' <repeats 186 times>...) at /test/10.9_dbg/storage/perfschema/ha_perfschema.cc:278
      #9  0x0000555b4ae0f369 in handler::ha_write_row (this=0x14c280020d80, buf=0x14c280021380 "\377L佃䅌䡏協", ' ' <repeats 186 times>...) at /test/10.9_dbg/sql/handler.cc:7522
      #10 0x0000555b4aaa5372 in write_record (thd=thd@entry=0x14c280000db8, table=table@entry=0x14c2800204a8, info=info@entry=0x14c330129cd0, sink=sink@entry=0x0) at /test/10.9_dbg/sql/sql_insert.cc:2156
      #11 0x0000555b4aab10c8 in mysql_insert (thd=thd@entry=0x14c280000db8, table_list=0x14c280014180, fields=@0x14c280006080: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14c280014a28, last = 0x14c280014c08, elements = 2}, <No data fields>}, values_list=@0x14c2800060c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14c280014878, last = 0x14c280014878, elements = 1}, <No data fields>}, update_fields=@0x14c2800060b0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x555b4c1409e0 <end_of_list>, last = 0x14c2800060b0, elements = 0}, <No data fields>}, update_values=@0x14c280006098: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x555b4c1409e0 <end_of_list>, last = 0x14c280006098, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0) at /test/10.9_dbg/sql/sql_insert.cc:1127
      #12 0x0000555b4aaf792a in mysql_execute_command (thd=thd@entry=0x14c280000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.9_dbg/sql/sql_parse.cc:4562
      #13 0x0000555b4aae2315 in mysql_parse (thd=thd@entry=0x14c280000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14c33012a400) at /test/10.9_dbg/sql/sql_parse.cc:8027
      #14 0x0000555b4aaf0fb1 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14c280000db8, packet=packet@entry=0x14c28001a129 "INSERT INTO performance_schema.setup_actors SET USER='a',HOST='LOCALHOST'", packet_length=packet_length@entry=73, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_class.h:1362
      #15 0x0000555b4aaf43f8 in do_command (thd=0x14c280000db8, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_parse.cc:1402
      #16 0x0000555b4ac6efc4 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x555b4e959388, put_in_cache=put_in_cache@entry=true) at /test/10.9_dbg/sql/sql_connect.cc:1418
      #17 0x0000555b4ac6f5c9 in handle_one_connection (arg=arg@entry=0x555b4e959388) at /test/10.9_dbg/sql/sql_connect.cc:1312
      #18 0x0000555b4b0f5d67 in pfs_spawn_thread (arg=0x555b4e8506d8) at /test/10.9_dbg/storage/perfschema/pfs.cc:2201
      #19 0x000014c35a3b5609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #20 0x000014c359fa3293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.7.2 3351dfaab0599268eaf25f9d6995ef128910a8b9 (Debug)

      mysqld: /test/10.7_dbg/storage/perfschema/pfs_setup_actor.cc:125: void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, const char*, uint, const char*, uint): Assertion `host_length <= 255' failed.
      

      10.7.2 3351dfaab0599268eaf25f9d6995ef128910a8b9 (Debug)

      Core was generated by `/test/MD290122-mariadb-10.7.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x151dc415f700 (LWP 3966705))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x0000151ddea1c859 in __GI_abort () at abort.c:79
      #2  0x0000151ddea1c729 in __assert_fail_base (fmt=0x151ddebb2588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55734a3582d7 "host_length <= 255", file=0x55734a35b5e0 "/test/10.7_dbg/storage/perfschema/pfs_setup_actor.cc", line=125, function=<optimized out>) at assert.c:92
      #3  0x0000151ddea2df36 in __GI___assert_fail (assertion=assertion@entry=0x55734a3582d7 "host_length <= 255", file=file@entry=0x55734a35b5e0 "/test/10.7_dbg/storage/perfschema/pfs_setup_actor.cc", line=line@entry=125, function=function@entry=0x55734a35b678 "void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, const char*, uint, const char*, uint)") at assert.c:101
      #4  0x0000557349a94010 in set_setup_actor_key (key=0x55734ca69184, user=0x151d7802164e "a", ' ' <repeats 199 times>..., user_length=128, host=0x151d78021351 "L佃䅌䡏協", ' ' <repeats 187 times>..., host_length=263, role=0x55734a33d043 "%", role_length=1) at /test/10.7_dbg/storage/perfschema/pfs_setup_actor.cc:125
      #5  0x0000557349a9493c in insert_setup_actor (user=user@entry=0x151dc415d980, host=host@entry=0x151dc415d9a0, role=role@entry=0x151dc415d9c0, enabled=enabled@entry=true, history=history@entry=true) at /test/10.7_dbg/sql/sql_string.h:278
      #6  0x0000557349abfb3a in table_setup_actors::write_row (table=0x151d78020488, buf=<optimized out>, fields=0x151d78020908) at /test/10.7_dbg/storage/perfschema/table_setup_actors.cc:123
      #7  0x0000557349a7da4a in PFS_engine_table_share::write_row (this=<optimized out>, table=0x151d78020488, buf=buf@entry=0x151d78021350 "\377L佃䅌䡏協", ' ' <repeats 186 times>..., fields=<optimized out>) at /test/10.7_dbg/storage/perfschema/pfs_engine_table.cc:372
      #8  0x0000557349a6859c in ha_perfschema::write_row (this=0x151d78020d60, buf=0x151d78021350 "\377L佃䅌䡏協", ' ' <repeats 186 times>...) at /test/10.7_dbg/storage/perfschema/ha_perfschema.cc:278
      #9  0x0000557349786933 in handler::ha_write_row (this=0x151d78020d60, buf=0x151d78021350 "\377L佃䅌䡏協", ' ' <repeats 186 times>...) at /test/10.7_dbg/sql/handler.cc:7516
      #10 0x0000557349426160 in write_record (thd=thd@entry=0x151d78000db8, table=table@entry=0x151d78020488, info=info@entry=0x151dc415dcd0, sink=sink@entry=0x0) at /test/10.7_dbg/sql/sql_insert.cc:2156
      #11 0x0000557349431dcf in mysql_insert (thd=thd@entry=0x151d78000db8, table_list=0x151d78014170, fields=@0x151d78006078: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x151d78014a18, last = 0x151d78014bf8, elements = 2}, <No data fields>}, values_list=@0x151d780060c0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x151d78014868, last = 0x151d78014868, elements = 1}, <No data fields>}, update_fields=@0x151d780060a8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55734aaafb00 <end_of_list>, last = 0x151d780060a8, elements = 0}, <No data fields>}, update_values=@0x151d78006090: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55734aaafb00 <end_of_list>, last = 0x151d78006090, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0) at /test/10.7_dbg/sql/sql_insert.cc:1127
      #12 0x000055734947852c in mysql_execute_command (thd=thd@entry=0x151d78000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_parse.cc:4562
      #13 0x0000557349462f17 in mysql_parse (thd=thd@entry=0x151d78000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x151dc415e400) at /test/10.7_dbg/sql/sql_parse.cc:8027
      #14 0x0000557349471bb3 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x151d78000db8, packet=packet@entry=0x151d7801a119 "INSERT INTO performance_schema.setup_actors SET USER='a',HOST='LOCALHOST'", packet_length=packet_length@entry=73, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1360
      #15 0x0000557349474ffa in do_command (thd=0x151d78000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1402
      #16 0x00005573495eea44 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55734d1daba8, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1418
      #17 0x00005573495ef049 in handle_one_connection (arg=arg@entry=0x55734d1daba8) at /test/10.7_dbg/sql/sql_connect.cc:1312
      #18 0x0000557349a6f8b0 in pfs_spawn_thread (arg=0x55734d0d2298) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201
      #19 0x0000151ddef2b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #20 0x0000151ddeb19293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.2.42 (Debug)

      mysqld: /test/10.2_dbg/storage/perfschema/pfs_setup_actor.cc:147: void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, const char*, uint, const char*, uint): Assertion `host_length <= 60' failed.
      

      10.2.42 (Debug)

      Core was generated by `/test/MD290122-mariadb-10.2.42-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x14647c0c8700 (LWP 3967951))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000056079691e403 in my_write_core (sig=sig@entry=6) at /test/10.2_dbg/mysys/stacktrace.c:382
      #2  0x0000560796213999 in handle_fatal_signal (sig=6) at /test/10.2_dbg/sql/signal_handler.cc:355
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014649cf0a859 in __GI_abort () at abort.c:79
      #6  0x000014649cf0a729 in __assert_fail_base (fmt=0x14649d0a0588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x560796b77482 "host_length <= 60", file=0x560796b7a360 "/test/10.2_dbg/storage/perfschema/pfs_setup_actor.cc", line=147, function=<optimized out>) at assert.c:92
      #7  0x000014649cf1bf36 in __GI___assert_fail (assertion=assertion@entry=0x560796b77482 "host_length <= 60", file=file@entry=0x560796b7a360 "/test/10.2_dbg/storage/perfschema/pfs_setup_actor.cc", line=line@entry=147, function=function@entry=0x560796b7a398 "void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, const char*, uint, const char*, uint)") at assert.c:101
      #8  0x0000560796887e79 in set_setup_actor_key (key=0x560797d3b044, user=<optimized out>, user_length=<optimized out>, host=0x1464240210d9 "L佃䅌䡏協", ' ' <repeats 167 times>, "a", ' ' <repeats 19 times>..., host_length=68, role=0x560796b65769 "%", role_length=1) at /usr/include/x86_64-linux-gnu/bits/string_fortified.h:34
      #9  0x00005607968880d0 in insert_setup_actor (user=user@entry=0x14647c0c5940, host=host@entry=0x14647c0c5960, role=role@entry=0x14647c0c5980) at /test/10.2_dbg/sql/sql_string.h:206
      #10 0x000056079689970c in table_setup_actors::write_row (table=0x14642401ffa0, buf=<optimized out>, fields=0x14642400c0f0) at /test/10.2_dbg/storage/perfschema/table_setup_actors.cc:97
      #11 0x000056079687c264 in PFS_engine_table_share::write_row (this=<optimized out>, table=0x14642401ffa0, buf=buf@entry=0x1464240210d8 "\377L佃䅌䡏協", ' ' <repeats 167 times>, "a", ' ' <repeats 18 times>..., fields=<optimized out>) at /test/10.2_dbg/storage/perfschema/pfs_engine_table.cc:198
      #12 0x0000560796879c76 in ha_perfschema::write_row (this=0x146424020ba8, buf=0x1464240210d8 "\377L佃䅌䡏協", ' ' <repeats 167 times>, "a", ' ' <repeats 18 times>...) at /test/10.2_dbg/storage/perfschema/ha_perfschema.cc:281
      #13 0x0000560796221cda in handler::ha_write_row (this=0x146424020ba8, buf=0x1464240210d8 "\377L佃䅌䡏協", ' ' <repeats 167 times>, "a", ' ' <repeats 18 times>...) at /test/10.2_dbg/sql/handler.cc:6118
      #14 0x0000560795fe82b7 in write_record (thd=thd@entry=0x146424000d90, table=table@entry=0x14642401ffa0, info=info@entry=0x14647c0c5ca0) at /test/10.2_dbg/sql/sql_insert.cc:1951
      #15 0x0000560795ff3915 in mysql_insert (thd=thd@entry=0x146424000d90, table_list=0x146424011518, fields=@0x1464240056c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x146424011d00, last = 0x146424011ee0, elements = 2}, <No data fields>}, values_list=@0x146424005710: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x146424011b50, last = 0x146424011b50, elements = 1}, <No data fields>}, update_fields=@0x1464240056f8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x56079712e660 <end_of_list>, last = 0x1464240056f8, elements = 0}, <No data fields>}, update_values=@0x1464240056e0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x56079712e660 <end_of_list>, last = 0x1464240056e0, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false) at /test/10.2_dbg/sql/sql_insert.cc:1066
      #16 0x000056079600c79c in mysql_execute_command (thd=thd@entry=0x146424000d90) at /test/10.2_dbg/sql/sql_parse.cc:4217
      #17 0x00005607960132a4 in mysql_parse (thd=thd@entry=0x146424000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14647c0c7510, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.2_dbg/sql/sql_parse.cc:7793
      #18 0x0000560796015da7 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x146424000d90, packet=packet@entry=0x1464240197f1 "INSERT INTO performance_schema.setup_actors SET USER='a',HOST='LOCALHOST'", packet_length=packet_length@entry=73, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.2_dbg/sql/sql_class.h:1109
      #19 0x0000560796018baa in do_command (thd=0x146424000d90) at /test/10.2_dbg/sql/sql_parse.cc:1381
      #20 0x000056079611ddd2 in do_handle_one_connection (connect=connect@entry=0x5607987ee710) at /test/10.2_dbg/sql/sql_connect.cc:1336
      #21 0x000056079611dffd in handle_one_connection (arg=arg@entry=0x5607987ee710) at /test/10.2_dbg/sql/sql_connect.cc:1241
      #22 0x000056079689f3a7 in pfs_spawn_thread (arg=0x560798756660) at /test/10.2_dbg/storage/perfschema/pfs.cc:1869
      #23 0x000014649d413609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #24 0x000014649d007293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.2.42 (dbg), 10.3.33 (dbg), 10.4.23 (dbg), 10.5.14 (dbg), 10.5.14 (opt), 10.6.6 (dbg), 10.7.2 (dbg), 10.8.1 (dbg), 10.9.0 (dbg), 10.9.0 (opt)
      MySQL: 5.6.51 (dbg), 5.7.36 (dbg)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.42 (opt), 10.3.33 (opt), 10.4.23 (opt), 10.6.6 (opt), 10.7.2 (opt), 10.8.1 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (opt), 5.7.36 (opt), 8.0.27 (dbg), 8.0.27 (opt)

      Attachments

        Activity

          People

            bar Alexander Barkov
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.