[MDEV-7057] Track most important upstream bugs which also affect MariaDB - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Won't Do
Fix Version/s: N/A
Component/s: OTHER
Labels:
None

Description

The goal of this task is to track bug reports filed at bugs.mysql.com for major bugs which also affect MariaDB, to make sure that upstream bug fixes come with test cases, and that the fixes fix the problem for MariaDB as well.
It also covers upstream bugs filed by us – they should be tracked regardless their importance.

The workflow is supposed to be this:

pick up a bug report which has been verified on MySQL;
check that MariaDB is also affected;
subscribe to updates add a link to the bug report to this task;
after the bug is fixed upstream, add fixed versions to this task;
before a MariaDB release, check if there are any bugs which are supposed to be fixed by merges in the upcoming release, and if there are, check that they fix MariaDB as well, and the fixes have test cases, and add test cases if there aren't any.

Tracker

Bug	Jira if any	Description	Fixed upstream	Fixed in MariaDB	Oracle no
68694	~~MDEV-4285~~	Server crashes in ptr_compare on NOW and CAST in ORDER BY	5.6.12	10.0.14+ (revno 4471)
73463		Out of memory error when concurrently write locking tables with triggers	5.6.21	5.5.40+ 10.0,14+ (revno 4471)
73819	MDEV-5518	Valgrind warnings " Syscall param write(buf) points to uninitialised byte(s)"
74220		ctype-ucs2.c:2522: my_well_formed_len_utf32: Assertion `(length % 4) == 0' fail	5.6.21	5.5.40 10.0.14+ (revno 4471)	13712655
74221		ctype-ucs2.c:1545: my_strnncollsp_utf16_bin: Assertion `(slen % 2) == 0' failed.	5.6.22?	10.0.14+ (revno 4471)	18487049
74288		Assertion `part_share->partitions_share_refs->num_parts >= m_tot_parts' failed.	5.6.25	10.0.14+ (revno 4471)
74448		Assertion `table_share->tmp_table != NO_TMP_TABLE \|\| m_lock_type != 2' failed	5.6.21	5.5.40+ 10.0.14+ (revno 4471)
74480	~~MDEV-7046~~	Failing assertion: os_file_status(newpath, &exists, &type) after Operating system error number 36 in a file operation	5.6.21	10.0.14+ (revno 4471)
74481	~~MDEV-7047~~	Failing assertion: zip_size == fil_space_get_zip_size(space) on setting innodb_fil_make_page_dirty_debug	5.6.21	10.0.14+ (revno 4471)
74504	MDEV-7048	Assertion `map->bitmap && map2->bitmap && map->n_bits==map2->n_bits' failed in bitmap_union	5.6.21	10.0.14+ (revno 4471)
74585	~~MDEV-7049~~	InnoDB: Failing assertion: *mbmaxlen < 5 in file ha_innodb.cc line 1904	5.6.21	5.5.40+ 10.0.14+ (revno 4471)
74603	~~MDEV-7050~~	Assertion `comma_length > 0' failed in mysql_prepare_create_table	5.6.21	5.5.40+ 10.0.14+ (revno 4471)
74605	~~MDEV-7051~~	InnoDB: Failing assertion: node_addr.page != FIL_NULL in file btr0btr.cc line 1101	5.6.21	10.0.14+ (revno 4471)
74646	~~MDEV-7052~~	Assertion `((Item_result_field*)item)->result_field' failed in create_tmp_field	5.6.21	5.5.40+ 10.0.14+ (revno 4471)
74663		DROP TABLE corrupts table	5.6.21	5.5.40+ 10.0.14+ (revno 4471)
74664	~~MDEV-7055~~	Assertion: len <= col->len \|\| col->mtype==5 \|\| (col->len == 0 && col->mtype ==1)	5.6.21	10.0.14+ (revno 4471)
74682		Assertion: index->id == btr_page_get_index_id(page) in btr0cur.cc line 899	5.6.21	10.0.14+ (revno 4471)
74695	~~MDEV-7814~~	Asser tion `args[0]->fixed' failed \| sig 6 abort in sql/item_strfunc.h:882	5.6.21	10.0.14+ (revno 4471)
74729		assertion:mode == BUF_GET_POSSIBLY_FREED \|\| !fix_block->page.file_page_was_freed	5.6.21	10.0.14 (revno 4471)
74730		Assertion failure in fil0fil.cc line 5594 \| abort sig 6 in fil/fil0fil.cc:5594	5.6.21	10.0.14 (revno 4471)
74740	MDEV-16686	Assertion `(*tables)->reginfo.lock_type >= TL_READ' failed in lock_external	5.6.21	10.0.14 (revno 4471)
74762		Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS.	5.6.21	10.0.14 (revno 4471)
74777		Assertion :bitmap_is_subset(&m_part_info->lock_partitions, &m_locked_partitions)	5.6.22	10.0.14+ (revno 4471)
74779		Assertion :bitmap_is_s et(&m_part_info->read_partitions, m_part_spec.start_part)	5.6.22	10.0.14+ (revno 4471)
74841		handle_fatal_signal (sig=11) in cmp_rec_and_tuple \| sql/sql_partition.cc:7610	5.6.24	10.0.14+ (revno 4479)
74856		handle_fatal_signal (sig=6) in get_parts_for_update \| sql/sql_partition.cc:328	5.6.22	10.0.14+ (revno 4492)
74859		Assertion `scale >= 0 && precision > 0 && scale <= precision' failed	5.6 5.7.6	10.0.14+ (revno 4492)
74860		handle_fatal_signal (sig=11) in generate_partition_syntax	5.6.24	10.0.14+ (revno 4492)
74869		handle_fatal_signal (sig=11) in ha_partition::handle_opt_partitions	5.6.22	10.0.14+ (revno 4492)
74889	~~MDEV-7122~~	Sig-6 abort in Item_in_subselect::exec \| sql/item_subselect.cc:730 or in subselect_hash_sj_engine::init	5.6.22	10.0.14+ (revno 4492)
74946		Assertion `nr >= 0.0' failed in virtual double Item_sum_std::val_real()	5.6.22	10.0.14+ (revno 4504)
74953		handle_fatal_signal (sig=11) in Field_blob::get_key_image \| sql/field.cc:8016	5.6.22	5.5.40+ 10.0.14+ (revno 4504)
75057		Assertion `auto_increment_value' failed in ha_partition::info	5.6.22	5.5.40+ 10.0.15+ (revno 4521)
75083		handle_fatal_signal (sig=6) in retrieve_auto_increment \| myisam/mi_key.c:588	5.6.22	10.0.15+ (revno 4535)
75227		Assertion `thd->killed != THD::KILL_BAD_DATA \|\| error > 0' failed	5.6.22	10.0.15+ (revno 4543)
75232		Sig 6 abort in get_partition_id_range_for_endpoint \| sql/sql_partition.cc:3600	5.6.22	10.0.15+ (revno 4543)
75284		handle_fatal_signal (sig=11) in mark_trx_read_write \| sql/handler.cc:4108	5.6.22	10.0.15+ (revno 4543)
75640		Failing assertion: array->n_elems < array->max_elems in sync_thread_add_level	5.6.23	10.0.16+ (revno 4588)
75833		InnoDB: Failing assertion: found in buf0buf.cc line 3856	5.7.7	10.0.16+ (revno 4613)
1368552		InnoDB: Failing assertion: purge_sys->state == PURGE_STATE_RUN	XtraDB 5.6.21	10.0.14+(revno4492)

Private bugs which might also affect MariaDB (or not)

Bug	Jira	Description	Fixed upstream	Fixed in MariaDB	Submitter
73120		crash (signal 11)			marko kos
73337		Replication without index may cause crash			qinglin zhang
73412		Failing assertion with TEMP table for a procedure called from a function			Markus Frosch
73556		fatal_signal in add_key_equal_fields() with UPDATE VIEW using outer subquery			Ramesh Sivaraman
73620		Segfaults when altering tables / dropping database			Brett Gardner
73650		Server crashes when executing ALTER TABLE ADD FOREIGN KEY			Tianzhou Chen
74035		InnoDB crash (signal 11) when updating foreign keys			thomas borghs
74130		fatal_signal in i_s_fts_config_fill with I_S.INNODB_FT_CONFIG table			Ramesh Sivaraman
74436		Assertion `m_lock_type == 2' failed in sql/handler.cc:2753 \| abort (sig=6)			Ramesh Sivaraman
74451		handle_fatal_signal 11 in partition_info::check_partition_info			Ramesh Sivaraman
74478		handle_fatal_signal 11 in base_list_iterator::next			Ramesh Sivaraman
74491		handle_fatal_signal 11 in make_used_partitions_str			Ramesh Sivaraman
74499		handle_fatal_signal 11 in strmake			Ramesh Sivaraman
74502		handle_fatal_signal 11 in ha_myisammrg::append_create_info			Ramesh Sivaraman
74503					Ramesh Sivaraman ?
74628		handle_fatal_signal (sig=11) in st_join_table::cleanup \| sql/sql_select.cc:3010			Ramesh Sivaraman
74677		Assertion `data_offset == ((null_count + 7) / 8)' failed in make_empty_rec			Ramesh Sivaraman
74778					Ramesh Sivaraman?

Attachments

Issue Links

relates to

MDEV-7046 MySQL#74480 - Failing assertion: os_file_status(newpath, &exists, &type) after Operating system error number 36 in a file operation

Closed

MDEV-7047 MySQL#74481 - Failing assertion: zip_size == fil_space_get_zip_size(space) on setting innodb_fil_make_page_dirty_debug

Closed

MDEV-7048 MySQL#74504 - Assertion `map->bitmap && map2->bitmap && map->n_bits==map2->n_bits' failed in bitmap_union

Open

MDEV-7049 MySQL#74585 - InnoDB: Failing assertion: *mbmaxlen < 5 in file ha_innodb.cc line 1904

Closed

MDEV-7050 MySQL#74603 - Assertion `comma_length > 0' failed in mysql_prepare_create_table

Closed

MDEV-7051 MySQL#74605 - InnoDB: Failing assertion: node_addr.page != FIL_NULL in file btr0btr.cc line 1101

Closed

MDEV-7052 MySQL#74646 - Assertion `((Item_result_field*)item)->result_field' failed in create_tmp_field

Closed

MDEV-7055 MySQL#74664 - InnoDB: Failing assertion: len <= col->len || col->mtype == 5 || (col->len == 0 && col->mtype == 1) in file rem0rec.cc line 845

Closed

MDEV-16686 Assertion `(*tables)->reginfo.lock_type >= TL_READ' failed in lock_external upon using a mix of trigger, view, SP

Stalled

MDEV-4285 Server crashes in ptr_compare on NOW and CAST in ORDER BY

Closed

MDEV-7814 Assertion `args[0]->fixed' fails in Item_func_conv_charset::Item_func_conv_charset

Closed

(6 relates to)

Sub-Tasks

There are no Sub-Tasks for this issue.

Activity

Ascending order - Click to sort in descending order

View 38 older comments

Elena Stepanova added a comment - 2015-02-06 17:34 - edited

http://bugs.mysql.com/bug.php?id=75688
http://bugs.mysql.com/bug.php?id=75701
http://bugs.mysql.com/bug.php?id=75718
http://bugs.mysql.com/bug.php?id=75721
http://bugs.mysql.com/bug.php?id=75741

couldn't reproduce on the current 10.0 tree (revno 4595)

Elena Stepanova added a comment - 2015-02-06 17:34 - edited http://bugs.mysql.com/bug.php?id=75688 http://bugs.mysql.com/bug.php?id=75701 http://bugs.mysql.com/bug.php?id=75718 http://bugs.mysql.com/bug.php?id=75721 http://bugs.mysql.com/bug.php?id=75741 couldn't reproduce on the current 10.0 tree (revno 4595)

Elena Stepanova added a comment - 2015-02-19 19:13

http://bugs.mysql.com/bug.php?id=75833

2015-02-19 20:08:55 7f8072f53700  InnoDB: Assertion failure in thread 140189661214464 in file buf0buf.cc line 2674

InnoDB: Failing assertion: zip_size == fil_space_get_zip_size(space)

#5  0x00007f8070d9a3e0 in *__GI_abort () at abort.c:92

#6  0x0000000000bd5dc8 in buf_page_get_gen (space=4, zip_size=0, offset=0, rw_latch=2, guess=0x0, mode=10, file=0x102b598 "/home/elenst/bzr/10.0/storage/xtradb/handler/ha_innodb.cc", line=15655, mtr=0x7f8072f51550) at /home/elenst/bzr/10.0/storage/xtradb/buf/buf0buf.cc:2674

#7  0x0000000000a19e1d in innodb_make_page_dirty (thd=0x7f8058721070, var=0x16b61c0, var_ptr=0x1894640, save=0x7f80468222a8) at /home/elenst/bzr/10.0/storage/xtradb/handler/ha_innodb.cc:15654

#8  0x0000000000694da5 in sys_var_pluginvar::global_update (this=0x7f80705566f8, thd=0x7f8058721070, var=0x7f8046822288) at /home/elenst/bzr/10.0/sql/sql_plugin.cc:3410

#9  0x00000000005db7fd in sys_var::update (this=0x7f80705566f8, thd=0x7f8058721070, var=0x7f8046822288) at /home/elenst/bzr/10.0/sql/set_var.cc:195

#10 0x00000000005ddc2c in set_var::update (this=0x7f8046822288, thd=0x7f8058721070) at /home/elenst/bzr/10.0/sql/set_var.cc:772

#11 0x00000000005dd7f2 in sql_set_variables (thd=0x7f8058721070, var_list=0x7f8058725a70) at /home/elenst/bzr/10.0/sql/set_var.cc:675

#12 0x000000000067eb7a in mysql_execute_command (thd=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:3744

#13 0x00000000006860d7 in mysql_parse (thd=0x7f8058721070, rawbuf=0x7f8046822088 "set global innodb_fil_make_page_dirty_debug=@space_id", length=53, parser_state=0x7f8072f52650) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513

#14 0x0000000000678b21 in dispatch_command (command=COM_QUERY, thd=0x7f8058721070, packet=0x7f8058600071 "set global innodb_fil_make_page_dirty_debug=@space_id", packet_length=53) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300

#15 0x0000000000677eb7 in do_command (thd=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996

#16 0x000000000079530f in do_handle_one_connection (thd_arg=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375

#17 0x0000000000795062 in handle_one_connection (arg=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289

#18 0x00007f8072b8bb50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#19 0x00007f8070e4170d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Elena Stepanova added a comment - 2015-02-19 19:13 http://bugs.mysql.com/bug.php?id=75833 2015-02-19 20:08:55 7f8072f53700 InnoDB: Assertion failure in thread 140189661214464 in file buf0buf.cc line 2674 InnoDB: Failing assertion: zip_size == fil_space_get_zip_size(space) #5 0x00007f8070d9a3e0 in *__GI_abort () at abort.c:92 #6 0x0000000000bd5dc8 in buf_page_get_gen (space=4, zip_size=0, offset=0, rw_latch=2, guess=0x0, mode=10, file=0x102b598 "/home/elenst/bzr/10.0/storage/xtradb/handler/ha_innodb.cc", line=15655, mtr=0x7f8072f51550) at /home/elenst/bzr/10.0/storage/xtradb/buf/buf0buf.cc:2674 #7 0x0000000000a19e1d in innodb_make_page_dirty (thd=0x7f8058721070, var=0x16b61c0, var_ptr=0x1894640, save=0x7f80468222a8) at /home/elenst/bzr/10.0/storage/xtradb/handler/ha_innodb.cc:15654 #8 0x0000000000694da5 in sys_var_pluginvar::global_update (this=0x7f80705566f8, thd=0x7f8058721070, var=0x7f8046822288) at /home/elenst/bzr/10.0/sql/sql_plugin.cc:3410 #9 0x00000000005db7fd in sys_var::update (this=0x7f80705566f8, thd=0x7f8058721070, var=0x7f8046822288) at /home/elenst/bzr/10.0/sql/set_var.cc:195 #10 0x00000000005ddc2c in set_var::update (this=0x7f8046822288, thd=0x7f8058721070) at /home/elenst/bzr/10.0/sql/set_var.cc:772 #11 0x00000000005dd7f2 in sql_set_variables (thd=0x7f8058721070, var_list=0x7f8058725a70) at /home/elenst/bzr/10.0/sql/set_var.cc:675 #12 0x000000000067eb7a in mysql_execute_command (thd=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:3744 #13 0x00000000006860d7 in mysql_parse (thd=0x7f8058721070, rawbuf=0x7f8046822088 "set global innodb_fil_make_page_dirty_debug=@space_id", length=53, parser_state=0x7f8072f52650) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6513 #14 0x0000000000678b21 in dispatch_command (command=COM_QUERY, thd=0x7f8058721070, packet=0x7f8058600071 "set global innodb_fil_make_page_dirty_debug=@space_id", packet_length=53) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1300 #15 0x0000000000677eb7 in do_command (thd=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_parse.cc:996 #16 0x000000000079530f in do_handle_one_connection (thd_arg=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1375 #17 0x0000000000795062 in handle_one_connection (arg=0x7f8058721070) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1289 #18 0x00007f8072b8bb50 in start_thread (arg=<optimized out>) at pthread_create.c:304 #19 0x00007f8070e4170d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Elena Stepanova added a comment - 2015-02-19 19:40

http://bugs.mysql.com/bug.php?id=75854
http://bugs.mysql.com/bug.php?id=75862
http://bugs.mysql.com/bug.php?id=75943
http://bugs.mysql.com/bug.php?id=75946
http://bugs.mysql.com/bug.php?id=75947
http://bugs.mysql.com/bug.php?id=75958

couldn't reproduce on the current 10.0 tree (revno 4613)

Elena Stepanova added a comment - 2015-02-19 19:40 http://bugs.mysql.com/bug.php?id=75854 http://bugs.mysql.com/bug.php?id=75862 http://bugs.mysql.com/bug.php?id=75943 http://bugs.mysql.com/bug.php?id=75946 http://bugs.mysql.com/bug.php?id=75947 http://bugs.mysql.com/bug.php?id=75958 couldn't reproduce on the current 10.0 tree (revno 4613)

Elena Stepanova added a comment - 2015-03-04 16:11

https://bugs.mysql.com/bug.php?id=76039

couldn't reproduce on the current 10.0 tree (commit e33b48ae8b943b5d2aed4873f5ada7717860e162)

Elena Stepanova added a comment - 2015-03-04 16:11 https://bugs.mysql.com/bug.php?id=76039 couldn't reproduce on the current 10.0 tree (commit e33b48ae8b943b5d2aed4873f5ada7717860e162)

Elena Stepanova added a comment - 2022-09-19 12:46

Even if it's technically possible (I haven't checked for a while what the current policy for public bug reports is in MySQL), it doesn't make much sense anymore, code bases diverged too much.

Elena Stepanova added a comment - 2022-09-19 12:46 Even if it's technically possible (I haven't checked for a while what the current policy for public bug reports is in MySQL), it doesn't make much sense anymore, code bases diverged too much.

MariaDB Server

Track most important upstream bugs which also affect MariaDB