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

NPE w funkcji trx_undo_get_undo_rec_low

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.6.5
    • Fix Version/s: None
    • Labels:
    • Environment:

      Description

      Starting program:

      /usr/sbin/mysqld "--defaults-file=/home/dell/.local/share/akonadi/mysql.conf" "--datadir=/home/dell/.local/share/akonadi/db_data/" "--socket=/run/user/1000/akonadi/mysql.socket" "--pid-file=/run/user/1000/akonadi/mysql.pid"
      mysqldump >akonadi.sql --all-databases "--socket=/run/user/1000/akonadi/mysql.socket"
      

      2021-12-16 23:46:46 3 [Warning] InnoDB: A transaction id in a record of table
      `akonadi`.`parttable` is newer than the system-wide maximum.
      2021-12-16 23:46:46 3 [Warning] InnoDB: A transaction id in a record of table
      `akonadi`.`parttable` is newer than the system-wide maximum.
      211216 23:46:46   [ERROR] mysqld got signal 11 ;

      Thread 18 "mysqld" received signal SIGSEGV, Segmentation fault.

      2244            trx_rseg_t* rseg = &trx_sys.rseg_array[rseg_id];
      2245            ut_ad(rseg->is_persistent());
      2246
      2247            mtr.start();
      2248
      2249            buf_block_t* undo_page = trx_undo_page_get_s_latched(
      2250                    page_id_t(rseg->space->id, page_no), &mtr);
      2251
      2252            undo_rec = trx_undo_rec_copy(undo_page->frame + offset, heap);
      2253
      

      ! trx_sys.rseg_array[rseg_id].space && rseg_id == 40
      

      #0  trx_undo_get_undo_rec_low (roll_ptr=11258999090193127, heap=0x7fff90189308)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/trx/trx0rec.cc:2249
      #1  0x00005555563e8ba7 in trx_undo_get_undo_rec (undo_rec=<synthetic pointer>, 
          name=..., trx_id=<optimized out>, heap=0x7fff90189308, 
          roll_ptr=11258999090193127)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/trx/trx0rec.cc:2284
      #2  trx_undo_prev_version_build(unsigned char const*, mtr_t*, unsigned char const*, dict_index_t*, unsigned short*, mem_block_info_t*, unsigned char**, mem_block_info_t*, dtuple_t**, unsigned long) [clone .constprop.0] (
          rec=rec@entry=0x7fffdc53ad7c "\200", index=index@entry=0x7fff90065680, 
          offsets=0x7ffff52bd910, heap=heap@entry=0x7fff90189308, 
          old_vers=old_vers@entry=0x7ffff52bd758, v_heap=v_heap@entry=0x0, vrow=0x0, 
          v_status=0, index_mtr=<optimized out>, index_rec=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/trx/trx0rec.cc:2369
      #3  0x000055555623abb8 in row_vers_build_for_consistent_read (rec=<optimized out>, 
          mtr=<optimized out>, index=0x7fff90065680, offsets=0x7ffff52bd8d0, 
          view=0x7ffff5d79ea8, offset_heap=0x7ffff52bd8d8, in_heap=0x7fff900bc6c8, 
          old_vers=0x7ffff52bd908, vrow=0x0)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/row/row0vers.cc:1160
      #4  0x0000555556235963 in row_sel_build_prev_vers_for_mysql (mtr=0x7ffff52bddd0, 
          vrow=<optimized out>, old_vers=0x7ffff52bd908, offset_heap=0x7ffff52bd8d8, 
          offsets=0x7ffff52bd8d0, rec=<optimized out>, prebuilt=0x7fff90054470, 
          clust_index=<optimized out>, read_view=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/row/row0sel.cc:3244
      #5  row_search_mvcc (buf=0x7fff900511e0 "\370\202\036\a", mode=<optimized out>, 
          prebuilt=0x7fff90054470, match_mode=<optimized out>, direction=1)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/row/row0sel.cc:5312
      #6  0x0000555556174423 in ha_innobase::general_fetch (this=0x7fff90052c70, 
          buf=<optimized out>, direction=<optimized out>, match_mode=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/innobase/handler/ha_innodb.cc:9274
      #7  0x0000555555ef563f in handler::ha_rnd_next (this=0x7fff90052c70, 
          buf=0x7fff900511e0 "\370\202\036\a")
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/handler.cc:3396
      #8  0x000055555602b1fd in rr_sequential (info=0x7fff90013b50)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/records.cc:519
      #9  0x0000555555cfc771 in READ_RECORD::read_record (this=<optimized out>, 
          this=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/records.h:81
      #10 sub_select (join=0x7fff90012500, join_tab=0x7fff90013a88, end_of_records=false)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_select.cc:21086
      #11 0x0000555555cd89a5 in do_select (procedure=0x0, join=0x7fff90012500)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_select.cc:20614
      #12 JOIN::exec_inner (this=0x7fff90012500)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_select.cc:4737
      #13 0x0000555555cd8de3 in JOIN::exec (this=this@entry=0x7fff90012500)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_select.cc:4515
      #14 0x0000555555cd9763 in mysql_select (thd=0x7fff90000c58, tables=0x7fff90011538, 
          fields=..., conds=0x0, og_num=0, order=<optimized out>, group=0x0, having=0x0, 
          proc_param=0x0, select_options=<optimized out>, result=0x7fff900124d8, 
          unit=0x7fff90004e00, select_lex=0x7fff90010748)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_select.cc:4994
      #15 0x0000555555cc639d in handle_select (thd=0x7fff90000c58, lex=0x7fff90004d38, 
          result=0x7fff900124d8, setup_tables_done_option=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_select.cc:545
      #16 0x0000555555c94d4c in execute_sqlcom_select (thd=0x7fff90000c58, 
          all_tables=0x7fff90011538)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_parse.cc:6256
      #17 0x0000555555c9f817 in mysql_execute_command (thd=0x7fff90000c58, 
          is_called_from_prepared_stmt=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_parse.cc:3946
      #18 0x0000555555ca0e8a in mysql_parse (thd=0x7fff90000c58, rawbuf=<optimized out>, 
          length=<optimized out>, parser_state=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_parse.cc:8030
      #19 0x0000555555c8f17d in dispatch_command (command=COM_QUERY, thd=0x7fff90000c58, 
          packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_parse.cc:1896
      #20 0x0000555555c91140 in do_command (thd=0x7fff90000c58, blocking=<optimized out>)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_parse.cc:1404
      #21 0x0000555555dce30a in do_handle_one_connection (connect=<optimized out>, 
          put_in_cache=true)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_connect.cc:1418
      #22 0x0000555555dce830 in handle_one_connection (arg=arg@entry=0x5555578e74d8)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/sql/sql_connect.cc:1312
      #23 0x00005555560efb5d in pfs_spawn_thread (arg=0x5555579c8918)
          at /usr/src/debug/mariadb-10.6.5-3.1.x86_64/storage/perfschema/pfs.cc:2201
      #24 0x00007ffff74b4427 in start_thread (arg=<optimized out>) at pthread_create.c:435
      #25 0x00007ffff753d810 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Query (0x7f1bdc0105f0):

      SELECT /*!40001 SQL_NO_CACHE */ `id`, `pimItemId`, `partTypeId`,
      `data`, `datasize`, `version`, `storage` FROM `parttable`
      

        Attachments

        1. mysql.err
          298 kB
        2. mysql.conf
          3 kB

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            yecril71pl Christopher Yeleighton
            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.