Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.6.5
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
Issue Links
- relates to
-
MDEV-31355 innodb_undo_log_truncate=ON fails to wait for purge of enough transaction history
- Closed