[MDEV-27290] NPE w funkcji trx_undo_get_undo_rec_low Created: 2021-12-16  Updated: 2021-12-16

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Subquery, Platform SUSE, Storage Engine - InnoDB, Upgrades
Affects Version/s: 10.6.5
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Christopher Yeleighton Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: crash
Environment:

System operacyjny: openSUSE Tumbleweed 20211213
Wersja Plazmy KDE: 5.23.4
Wersja Szkieletów KDE: 5.89.0
Wersja Qt: 5.15.2
Wersja jądra: 5.15.7-1-default (64-bity)
Platforma graficzna: X11
Procesory: 4 × Intel® Core™2 Quad CPU Q6600 @ 2.40GHz
Pamięć: 5,7 GiB RAM-u
Procesor graficzny: AMD TURKS

Attachments: File mysql.conf     File mysql.err    

 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`


Generated at Thu Feb 08 09:51:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.