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

Server crashes when executing a query related to uninstalled RocksDB storage engine using prepared statement

    XMLWordPrintable

Details

    Description

      INSTALL SONAME 'ha_rocksdb';
      PREPARE ps FROM "SHOW ENGINE ROCKSDB STATUS";
      UNINSTALL PLUGIN RocksDB;
      SHOW ENGINE ROCKSDB STATUS;
      EXECUTE ps;
      

      Leads to:

      10.5.25 1e5b0ff9778b16801d5afa08b6433070948f0910 (Debug)

      Core was generated by `/test/MD130524-mariadb-10.5.25-linux-x86_64-dbg/bin/mariadbd --no-defaults --ma'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  0x000055b5d1546300 in ha_show_status (thd=thd@entry=0x14bdb4000d48, db_type=0x14bdb407f268, stat=<optimized out>, stat@entry=HA_ENGINE_STATUS)at /test/10.5_dbg/sql/handler.cc:6682
      [Current thread is 1 (Thread 0x14bdfc1ae700 (LWP 3823957))]
      (gdb) bt
      #0  0x000055b5d1546300 in ha_show_status (thd=thd@entry=0x14bdb4000d48, db_type=0x14bdb407f268, stat=<optimized out>, stat@entry=HA_ENGINE_STATUS) at /test/10.5_dbg/sql/handler.cc:6682
      #1  0x000055b5d127267e in mysql_execute_command (thd=0x14bdb4000d48) at /test/10.5_dbg/sql/sql_parse.cc:4251
      #2  0x000055b5d128a30c in Prepared_statement::execute (this=this@entry=0x14bdb4261cb8, expanded_query=expanded_query@entry=0x14bdfc1acc90, open_cursor=open_cursor@entry=false) at /test/10.5_dbg/sql/sql_prepare.cc:5131
      #3  0x000055b5d128a671 in Prepared_statement::execute_loop (this=this@entry=0x14bdb4261cb8, expanded_query=expanded_query@entry=0x14bdfc1acc90, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/10.5_dbg/sql/sql_prepare.cc:4553
      #4  0x000055b5d128ab26 in mysql_sql_stmt_execute (thd=thd@entry=0x14bdb4000d48) at /test/10.5_dbg/sql/sql_prepare.cc:3594
      #5  0x000055b5d1271d36 in mysql_execute_command (thd=thd@entry=0x14bdb4000d48) at /test/10.5_dbg/sql/sql_parse.cc:4045
      #6  0x000055b5d125e52a in mysql_parse (thd=thd@entry=0x14bdb4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14bdfc1ad2c0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8203
      #7  0x000055b5d126cce7 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14bdb4000d48, packet=packet@entry=0x14bdb400aa19 "", packet_length=packet_length@entry=10, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1328
      #8  0x000055b5d126fa20 in do_command (thd=0x14bdb4000d48) at /test/10.5_dbg/sql/sql_parse.cc:1375
      #9  0x000055b5d13bbb9e in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55b5d54144b8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1415
      #10 0x000055b5d13bc23c in handle_one_connection (arg=arg@entry=0x55b5d54144b8) at /test/10.5_dbg/sql/sql_connect.cc:1317
      #11 0x000055b5d1838f0d in pfs_spawn_thread (arg=0x55b5d53f7628) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
      #12 0x000014be115cd609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #13 0x000014be111b9133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.4.34 (dbg), 10.4.34 (opt), 10.5.25 (dbg), 10.5.25 (opt), 10.6.18 (dbg), 10.6.18 (opt), 10.11.8 (dbg), 10.11.8 (opt), 11.0.6 (dbg), 11.0.6 (opt), 11.1.5 (dbg), 11.1.5 (opt), 11.2.4 (dbg), 11.2.4 (opt), 11.3.3 (dbg), 11.3.3 (opt), 11.4.2 (dbg), 11.4.2 (opt), 11.5.0 (dbg), 11.5.0 (opt)

      Attachments

        Activity

          People

            shulga Dmitry Shulga
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.