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

handle_fatal_signal (sig=8, SIGFPE) in dict_index_add_to_cache

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t (c MULTIPOLYGON UNIQUE);
      ALTER TABLE t ADD INDEX(c);
      # ---- OR ----
      CREATE TABLE t (c GEOMETRYCOLLECTION UNIQUE);
      ALTER TABLE t ADD INDEX(c);
      # ---- OR ----
      CREATE TABLE t(c LINESTRING UNIQUE);
      ALTER TABLE t ADD INDEX(c);
      

      Leads to:

      10.5.2 535c284aedddb6cc3bedba4a8877b501f456991e

      Core was generated by `/data/MD180320-mariadb-10.5.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGFPE, Arithmetic exception.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=8)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      [Current thread is 1 (Thread 0x7f298129f700 (LWP 2811))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=8) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055eecad6d7d4 in my_write_core (sig=sig@entry=8) at /data/git/10.5_dbg/mysys/stacktrace.c:518
      #2  0x000055eeca516b5f in handle_fatal_signal (sig=8) at /data/git/10.5_dbg/sql/signal_handler.cc:325
      #3  <signal handler called>
      #4  0x000055eecac0552c in dict_index_add_to_cache (index=@0x7f2952c829d0: 0x7f2952ca4498, page_no=page_no@entry=4294967295, add_v=<optimized out>) at /data/git/10.5_dbg/storage/innobase/dict/dict0dict.cc:2035
      #5  0x000055eecabf171b in dict_create_index_step (thr=thr@entry=0x7f2952c8bc38) at /data/git/10.5_dbg/storage/innobase/dict/dict0crea.cc:1247
      #6  0x000055eeca9ec2d9 in que_thr_step (thr=0x7f2952c8bc38) at /data/git/10.5_dbg/storage/innobase/que/que0que.cc:1048
      #7  que_run_threads_low (thr=0x7f2952c8bc38) at /data/git/10.5_dbg/storage/innobase/que/que0que.cc:1100
      #8  que_run_threads (thr=thr@entry=0x7f2952c8bc38) at /data/git/10.5_dbg/storage/innobase/que/que0que.cc:1140
      #9  0x000055eecaa4d4eb in row_create_index_for_mysql (index=<optimized out>, index@entry=0x7f2952ca4498, trx=trx@entry=0x7f296b4033b0, field_lengths=field_lengths@entry=0x7f2952c5a368) at /data/git/10.5_dbg/storage/innobase/row/row0mysql.cc:2544
      #10 0x000055eeca8ef112 in create_index (trx=<optimized out>, form=<optimized out>, table=<optimized out>, key_num=key_num@entry=1) at /data/git/10.5_dbg/storage/innobase/handler/ha_innodb.cc:11002
      #11 0x000055eeca8eba5c in create_table_info_t::create_table (this=this@entry=0x7f2981298ec0, create_fk=create_fk@entry=true) at /data/git/10.5_dbg/storage/innobase/handler/ha_innodb.cc:12712
      #12 0x000055eeca8f81ad in ha_innobase::create (this=<optimized out>, name=0x7f298129cf4d "./test/#sql-90d_5", form=<optimized out>, create_info=0x7f298129d2d0, file_per_table=<optimized out>, trx=<optimized out>, trx@entry=0x0) at /data/git/10.5_dbg/storage/innobase/handler/ha_innodb.cc:13175
      #13 0x000055eeca8ebdb9 in ha_innobase::create (this=<optimized out>, name=<optimized out>, form=<optimized out>, create_info=<optimized out>) at /data/git/10.5_dbg/storage/innobase/handler/ha_innodb.cc:13228
      #14 0x000055eeca5261d9 in handler::ha_create (this=0x7f2952c31ea0, name=0x7f298129cf4d "./test/#sql-90d_5", form=form@entry=0x7f2981299480, info_arg=info_arg@entry=0x7f298129d2d0) at /data/git/10.5_dbg/sql/handler.cc:4859
      #15 0x000055eeca526ec5 in ha_create_table (thd=thd@entry=0x7f2952c15088, path=path@entry=0x7f298129cf4d "./test/#sql-90d_5", db=0x7f2952c74858 "test", table_name=0x7f2952c74150 "t", create_info=create_info@entry=0x7f298129d2d0, frm=frm@entry=0x7f298129aab0) at /data/git/10.5_dbg/sql/handler.cc:5323
      #16 0x000055eeca346cab in mysql_alter_table (thd=thd@entry=0x7f2952c15088, new_db=new_db@entry=0x7f2952c19938, new_name=new_name@entry=0x7f2952c19d40, create_info=create_info@entry=0x7f298129d2d0, table_list=<optimized out>, table_list@entry=0x7f2952c74188, alter_info=alter_info@entry=0x7f298129d200, order_num=0, order=0x0, ignore=false) at /data/git/10.5_dbg/sql/sql_table.cc:10266
      #17 0x000055eeca3c8066 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7f2952c15088) at /data/git/10.5_dbg/sql/sql_alter.cc:519
      #18 0x000055eeca274cae in mysql_execute_command (thd=thd@entry=0x7f2952c15088) at /data/git/10.5_dbg/sql/sql_parse.cc:5887
      #19 0x000055eeca27c7a5 in mysql_parse (thd=thd@entry=0x7f2952c15088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f298129e450, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/git/10.5_dbg/sql/sql_parse.cc:7926
      #20 0x000055eeca268664 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f2952c15088, packet=packet@entry=0x7f2952c67089 "ALTER TABLE t ADD INDEX(c)", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/git/10.5_dbg/sql/sql_parse.cc:1839
      #21 0x000055eeca266eaf in do_command (thd=0x7f2952c15088) at /data/git/10.5_dbg/sql/sql_parse.cc:1358
      #22 0x000055eeca3c0a09 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7f295d62b3a8, put_in_cache=put_in_cache@entry=true) at /data/git/10.5_dbg/sql/sql_connect.cc:1422
      #23 0x000055eeca3c0d38 in handle_one_connection (arg=arg@entry=0x7f295d62b3a8) at /data/git/10.5_dbg/sql/sql_connect.cc:1319
      #24 0x000055eeca81dcfc in pfs_spawn_thread (arg=0x7f297ec45888) at /data/git/10.5_dbg/storage/perfschema/pfs.cc:2201
      #25 0x00007f29806c66db in start_thread (arg=0x7f298129f700) at pthread_create.c:463
      #26 0x00007f297fac488f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.5.2 (dbg)

      Bug confirmed not present in:
      MariaDB: 10.1.45 (dbg), 10.1.45 (opt), 10.2.32 (dbg), 10.2.32 (opt), 10.3.23 (dbg), 10.3.23 (opt), 10.4.13 (dbg), 10.4.13 (opt), 10.5.2 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: