[MDEV-31154] Fatal InnoDB error or assertion `!is_v' failure upon multi-update with indexed virtual column - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
Fix Version/s: 10.4.34, 10.5.25, 10.11.8, 10.6.18, 11.0.6, 11.1.5, 11.2.4
Component/s: Data Manipulation - Update, Storage Engine - InnoDB, Virtual Columns
Labels:
- regression

Description

Notes:

The test case is non-deterministic despite the absence of obvious race conditions. The difference is likely in statistics. When the failure occurs, the UPDATE plan is different from the usual one (see the plans below). It only happens once in a while, run with --repeat=N. It usually fails for me withing ~20-30 attempts.

PASSING plan
EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d);
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index NULL d 6 NULL 455 Using index
1 SIMPLE t2 ref t,d t 4 func 1 Using where

FAILING plan
EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d);
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index NULL d 6 NULL 547 Using index
1 SIMPLE t2 ref\|filter t,d t\|d 4\|6 func 2 (83%) Using where; Using rowid filter

The test case turns off InnoDB persistent statistics to achieve the result. It is not a mandatory requirement for the failure to happen, initially (outside MTR) it occurred with InnoDB persistent statistics ON. I suppose for someone knowing the conditions when the optimization is triggered, it should be possible to modify the dataset so that the target execution plan is chosen deterministically, even with EITS.

The failure apparently started happening on 11.1 after this commit:

commit 554278e24dbc2c0af9fcfd66c54ca6a99a3cf17f

Author: Igor Babaev

    MDEV-7487 Semi-join optimization for single-table update/delete statements

However, it's possible that it just revealed a pre-existing problem.

--source include/have_innodb.inc

SET GLOBAL innodb_stats_persistent= 0;

CREATE TABLE t (

  pk INTEGER AUTO_INCREMENT,

  d DATETIME DEFAULT '2000-01-01 00:00:00',

  t TIME AS (TIME(d)) VIRTUAL,

  f1 TIME,

  f2 DATETIME DEFAULT '2000-01-01 00:00:00',

  f3 VARCHAR(1) DEFAULT 'x',

  f4 VARCHAR(1) DEFAULT 'x',

  PRIMARY KEY (pk),

  KEY (t),

  KEY (d)

) ENGINE=InnoDB;

INSERT INTO t (d) VALUES

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),

  ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-03-26 00:00:00'),

  ('1900-05-19 19:48:19'),('1901-05-02 00:00:00'),('1901-12-12 23:05:43'),

  ('1902-05-31 00:00:00'),('1902-06-17 00:00:00'),('1902-11-06 08:31:01'),

  ('1903-06-11 00:00:00'),('1904-01-16 09:00:30'),('1904-02-24 08:17:28'),

  ('1904-04-03 00:00:00'),('1905-01-17 00:00:00'),('1905-05-23 04:59:29'),

  ('1905-09-22 21:52:15'),('1905-12-06 13:11:49'),('1906-02-27 10:51:18'),

  ('1906-06-08 20:01:15'),('1907-02-09 23:08:14'),('1907-04-03 08:33:28'),

  ('1907-11-23 19:00:13'),('1908-09-03 03:19:29'),('1908-10-03 20:54:11'),

  ('1908-12-22 09:47:25'),('1909-04-10 10:29:16'),('1911-03-11 00:00:00'),

  ('1911-06-30 00:00:00'),('1911-08-07 01:32:56'),('1912-03-08 00:00:00'),

  ('1912-03-10 00:00:00'),('1912-03-13 11:40:19'),('1912-11-12 20:10:13'),

  ('1913-01-10 00:00:00'),('1913-09-15 18:43:53'),('1913-10-10 00:00:00'),

  ('1913-10-11 00:00:00'),('1914-01-18 17:52:52'),('1915-07-10 23:29:43'),

  ('1915-09-05 00:00:00'),('1915-09-25 14:42:14'),('1916-04-17 00:00:00'),

  ('1916-11-02 23:33:35'),('1917-04-22 13:14:41'),('1917-05-12 00:00:00'),

  ('1917-05-23 16:50:52'),('1917-06-24 12:14:19'),('1917-09-17 07:37:32'),

  ('1918-01-04 18:27:31'),('1918-05-02 12:55:51'),('1918-05-18 00:00:00'),

  ('1918-08-05 21:51:15'),('1918-09-12 19:27:33'),('1919-02-18 22:26:53'),

  ('1919-07-24 00:54:48'),('1919-09-07 22:41:09'),('1919-10-04 16:12:01'),

  ('1919-12-06 04:40:47'),('1920-01-28 00:00:00'),('1920-05-07 14:45:18'),

  ('1920-06-07 16:44:53'),('1921-02-15 11:55:05'),('1921-04-16 00:00:00'),

  ('1921-07-06 00:00:00'),('1922-04-13 00:00:00'),('1922-11-25 13:15:40'),

  ('1922-12-10 00:00:00'),('1923-02-01 00:00:00'),('1923-04-07 00:00:00'),

  ('1923-08-12 08:57:05'),('1923-10-22 00:00:00'),('1924-03-09 00:00:00'),

  ('1924-07-01 14:53:14'),('1924-07-04 23:45:21'),('1924-07-28 07:16:47'),

  ('1924-12-02 11:49:57'),('1925-09-09 00:00:00'),('1925-11-06 00:00:00'),

  ('1926-05-04 00:00:00'),('1926-06-21 06:38:24'),('1926-09-26 07:03:33'),

  ('1926-10-24 00:00:00'),('1926-11-17 03:12:56'),('1926-12-01 10:37:11'),

  ('1926-12-26 01:06:29'),('1927-08-25 00:00:00'),('1927-08-25 01:00:09'),

  ('1928-02-29 01:21:11'),('1928-03-08 00:00:00'),('1928-05-07 08:14:46'),

  ('1928-06-11 02:30:03'),('1928-09-04 03:56:02'),('1928-09-14 00:10:49'),

  ('1929-11-23 23:11:52'),('1929-12-10 00:00:00'),('1930-05-01 00:00:00'),

  ('1930-05-07 00:25:07'),('1931-04-26 00:00:00'),('1931-06-05 23:04:47'),

  ('1931-07-08 23:24:45'),('1932-10-08 00:00:00'),('1932-10-22 00:00:00'),

  ('1933-08-27 23:05:40'),('1933-10-21 05:28:44'),('1934-07-09 00:00:00'),

  ('1934-09-27 10:53:33'),('1935-04-01 00:00:00'),('1935-05-08 09:40:03'),

  ('1935-10-24 20:43:43'),('1935-11-18 11:22:59'),('1936-05-10 00:00:00'),

  ('1936-09-03 00:00:00'),('1937-02-16 06:36:19'),('1937-03-16 00:00:00'),

  ('1937-05-16 20:05:38'),('1937-09-12 00:00:00'),('1939-01-03 00:00:00'),

  ('1940-09-18 00:00:00'),('1940-10-26 00:00:00'),('1941-02-08 05:23:51'),

  ('1941-04-18 00:00:00'),('1941-07-01 00:00:00'),('1941-08-21 00:00:00'),

  ('1941-12-17 13:48:07'),('1942-09-17 15:03:18'),('1942-11-28 20:49:30'),

  ('1943-01-18 00:18:15'),('1943-05-20 00:00:00'),('1943-06-01 00:00:00'),

  ('1943-12-16 11:48:11'),('1943-12-31 12:45:58'),('1944-01-15 06:43:50'),

  ('1944-03-19 00:00:00'),('1944-03-23 00:00:00'),('1944-05-19 00:00:00'),

  ('1944-06-13 09:26:18'),('1944-07-19 11:52:08'),('1944-08-11 00:00:00'),

  ('1944-10-27 00:00:00'),('1945-01-17 17:55:51'),('1945-02-23 20:54:46'),

  ('1945-03-04 07:58:13'),('1945-05-07 00:00:00'),('1945-06-12 00:00:00'),

  ('1945-07-14 09:47:28'),('1945-10-24 19:31:58'),('1945-11-03 00:00:00'),

  ('1945-11-26 20:13:02'),('1945-12-24 00:00:00'),('1946-10-06 00:00:00'),

  ('1946-10-23 00:00:00'),('1946-11-19 03:11:21'),('1947-01-02 05:04:16'),

  ('1947-09-23 23:57:34'),('1947-11-30 00:50:13'),('1948-03-05 18:11:03'),

  ('1948-03-09 02:33:13'),('1948-04-10 00:24:59'),('1948-06-01 08:51:57'),

  ('1948-07-27 16:11:03'),('1948-10-29 05:29:57'),('1949-06-13 00:38:11'),

  ('1949-10-14 01:50:48'),('1950-02-12 00:00:00'),('1950-02-21 22:38:06'),

  ('1950-03-26 07:56:02'),('1951-01-31 13:12:27'),('1951-04-17 13:35:33'),

  ('1951-08-17 11:51:53'),('1951-12-31 00:00:00'),('1952-05-25 06:22:51'),

  ('1953-05-02 14:26:04'),('1953-06-19 19:35:42'),('1953-07-02 18:01:07'),

  ('1953-11-01 14:27:14'),('1954-01-05 02:40:21'),('1954-05-01 05:52:08'),

  ('1954-06-05 15:11:12'),('1955-01-12 00:00:00'),('1955-02-03 19:51:41'),

  ('1955-02-27 15:38:21'),('1955-05-25 00:00:00'),('1955-08-22 19:47:38'),

  ('1955-08-30 08:38:26'),('1955-12-15 22:02:31'),('1956-08-17 00:00:00'),

  ('1956-09-17 06:58:08'),('1956-10-02 00:00:00'),('1957-05-15 05:05:17'),

  ('1958-11-01 10:11:48'),('1959-03-31 00:00:00'),('1959-11-02 23:28:29'),

  ('1960-01-26 21:57:36'),('1960-10-31 00:00:00'),('1960-11-18 11:19:40'),

  ('1961-03-22 01:28:24'),('1961-07-11 03:48:39'),('1962-11-08 00:00:00'),

  ('1963-02-27 12:25:30'),('1963-04-11 00:44:21'),('1963-06-26 03:25:23'),

  ('1963-07-26 16:14:47'),('1963-08-14 08:09:23'),('1963-10-28 15:24:24'),

  ('1964-01-11 21:08:21'),('1964-05-26 05:12:28'),('1965-03-18 22:49:37'),

  ('1966-03-26 18:42:55'),('1966-09-11 22:46:33'),('1967-01-21 00:00:21'),

  ('1967-02-28 02:47:14'),('1967-06-09 13:27:40'),('1967-06-29 00:49:17'),

  ('1967-09-29 00:00:00'),('1967-12-14 06:37:06'),('1968-02-04 11:27:22'),

  ('1968-03-15 21:33:37'),('1968-08-31 18:53:30'),('1968-09-04 00:00:00'),

  ('1968-09-11 00:00:00'),('1968-11-07 02:40:13'),('1968-11-28 01:29:10'),

  ('1969-01-31 00:00:00'),('1969-05-04 09:11:55'),('1969-10-28 19:10:25'),

  ('1970-01-02 00:00:00'),('1970-06-09 05:45:57'),('1970-07-17 10:13:47'),

  ('1970-12-21 16:08:41'),('1971-02-03 00:00:00'),('1971-10-03 00:00:00'),

  ('1971-12-30 17:44:34'),('1972-03-12 04:03:57'),('1972-08-27 00:00:00'),

  ('1972-09-13 13:44:08'),('1972-11-26 00:00:00'),('1973-05-28 00:00:00'),

  ('1974-03-30 00:00:00'),('1974-05-23 19:28:42'),('1974-08-03 07:58:03'),

  ('1975-09-20 04:00:22'),('1975-11-03 16:41:33'),('1975-12-20 00:00:00'),

  ('1976-01-07 00:55:02'),('1976-05-14 11:04:05'),('1976-08-04 15:11:46'),

  ('1976-08-18 17:11:29'),('1977-03-03 19:45:25'),('1977-09-11 22:10:22'),

  ('1977-12-13 06:18:33'),('1979-05-05 16:04:17'),('1979-06-02 22:22:32'),

  ('1979-12-08 00:00:00'),('1980-02-03 09:54:52'),('1980-05-30 02:23:29'),

  ('1980-07-14 17:19:17'),('1980-12-15 00:00:00'),('1981-04-13 19:17:48'),

  ('1981-11-21 16:22:17'),('1982-04-06 04:42:04'),('1982-11-24 12:17:25'),

  ('1983-12-04 16:23:48'),('1984-04-26 00:00:00'),('1984-07-30 00:00:00'),

  ('1985-01-02 00:00:00'),('1985-07-23 05:12:22'),('1985-10-04 14:56:23'),

  ('1985-12-02 17:47:43'),('1986-03-01 00:00:00'),('1986-08-30 03:27:04'),

  ('1987-01-16 14:09:52'),('1987-02-03 03:55:02'),('1987-03-03 12:04:10'),

  ('1987-09-21 11:28:54'),('1988-04-24 20:59:14'),('1988-06-13 18:25:07'),

  ('1988-07-04 00:00:00'),('1988-07-23 10:09:14'),('1988-08-26 09:41:22'),

  ('1989-07-25 05:19:18'),('1990-07-13 00:00:00'),('1990-07-22 16:52:29'),

  ('1990-08-22 22:40:34'),('1991-01-09 00:00:00'),('1991-02-25 02:06:00'),

  ('1991-04-26 00:00:00'),('1991-10-20 12:57:55'),('1991-11-15 12:18:40'),

  ('1992-06-15 03:23:28'),('1992-08-22 11:08:44'),('1992-12-06 23:07:49'),

  ('1992-12-23 10:48:27'),('1993-07-18 18:05:03'),('1993-08-28 12:46:25'),

  ('1994-06-01 18:17:38'),('1994-08-25 14:39:37'),('1994-12-02 00:00:00'),

  ('1995-04-21 04:09:34'),('1995-06-28 21:26:52'),('1995-07-11 03:04:35'),

  ('1995-09-24 00:00:00'),('1996-06-27 02:43:39'),('1997-10-05 09:25:29'),

  ('1997-10-16 01:24:59'),('1999-01-16 00:00:00'),('1999-05-28 06:52:34'),

  ('1999-08-11 12:35:50'),('2000-04-30 00:00:00'),('2000-11-04 12:40:42'),

  ('2001-01-29 07:51:53'),('2001-09-05 11:22:16'),('2002-02-01 19:34:03'),

  ('2003-02-18 00:00:00'),('2003-03-06 00:00:00'),('2003-05-22 00:00:00'),

  ('2004-02-19 00:00:00'),('2004-05-12 00:00:00'),('2004-09-10 00:00:00'),

  ('2005-02-04 21:34:25'),('2005-03-08 14:48:55'),('2005-03-28 09:35:18'),

  ('2005-06-17 10:29:21'),('2005-08-06 07:43:46'),('2006-01-03 11:02:29'),

  ('2006-03-11 00:42:35'),('2006-03-25 13:55:48'),('2006-10-25 23:18:04'),

  ('2007-07-10 21:14:32'),('2007-09-26 15:45:08'),('2007-11-28 19:07:20'),

  ('2008-06-04 08:48:59'),('2008-07-18 00:00:00'),('2008-08-14 03:00:01'),

  ('2008-11-28 05:02:23'),('2008-11-29 16:07:13'),('2010-09-09 11:08:48'),

  ('2011-01-17 12:47:26'),('2011-03-25 06:25:51'),('2011-05-06 03:38:56'),

  ('2012-02-06 14:45:33'),('2012-05-01 00:46:29'),('2012-05-23 13:56:45'),

  ('2012-09-17 15:14:54'),('2012-12-12 21:21:34'),('2013-04-16 00:00:00'),

  ('2014-03-10 05:07:51'),('2014-05-09 23:13:07'),('2014-07-24 06:41:03'),

  ('2014-07-27 05:13:13'),('2015-05-05 05:31:40'),('2016-05-18 14:44:12'),

  ('2016-09-29 00:00:00'),('2017-01-27 00:00:00'),('2017-05-03 01:50:33'),

  ('2017-06-09 00:53:25'),('2017-09-12 04:34:06'),('2018-02-01 07:14:12'),

  ('2018-03-22 22:16:24'),('2018-04-20 08:19:24'),('2018-07-25 19:32:34'),

  ('2018-08-09 00:00:00'),('2019-03-23 00:00:00'),('2019-12-18 15:04:21'),

  ('2020-04-09 15:54:29'),('2020-09-13 15:05:56'),('2021-04-21 08:07:20'),

  ('2021-05-04 10:09:48'),('2021-06-18 00:00:00'),('2021-09-06 00:00:00'),

  ('2022-10-24 00:00:00'),('2022-11-24 02:54:09'),('2023-04-07 16:59:25'),

  ('2023-11-26 00:00:00'),('2024-04-01 11:20:53'),('2024-04-19 00:00:00'),

  ('2024-09-16 05:45:31'),('2024-10-15 02:07:05'),('2024-11-05 00:00:00'),

  ('2024-12-27 02:53:35'),('2025-02-04 00:00:00'),('2025-05-05 12:19:13'),

  ('2025-08-20 00:00:00'),('2025-09-25 01:09:50'),('2027-03-02 10:18:54'),

  ('2028-08-20 00:00:00'),('2028-11-18 16:08:10'),('2029-01-20 11:11:25'),

  ('2029-11-06 00:00:00'),('2030-06-11 10:48:40'),('2030-08-24 01:16:16'),

  ('2031-03-08 20:50:33'),('2031-04-25 21:26:00'),('2032-05-31 14:26:32'),

  ('2032-07-28 04:02:35'),('2033-04-30 03:04:26'),('2033-06-16 15:07:21'),

  ('2033-08-11 10:08:08'),('2033-09-21 07:18:35'),('2034-01-25 13:32:44'),

  ('2034-01-30 15:30:45'),('2034-08-26 19:59:15'),('2034-12-01 23:39:50'),

  ('2034-12-25 00:00:00'),('2035-04-12 07:50:46'),('2035-04-25 15:36:36'),

  ('2035-05-25 20:29:49'),('2035-06-06 20:59:57'),('2035-07-15 20:11:20'),

  ('2035-08-02 09:53:16'),('2035-08-03 00:00:00'),('2035-12-08 00:00:00'),

  ('2036-03-13 10:35:23'),('2036-03-25 16:31:32'),('2036-09-06 12:50:17'),

  ('2036-10-07 02:50:31'),('2037-05-26 00:00:00'),('2037-11-21 05:17:58'),

  ('2038-02-11 07:16:04'),('2038-04-08 00:16:00'),('2038-05-26 01:10:18'),

  ('2038-11-17 09:13:06'),('2039-03-10 11:41:13'),('2039-11-08 10:08:53');

UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d);

# Cleanup

DROP TABLE t;

SET GLOBAL innodb_stats_persistent= DEFAULT;

11.1 3ef11161 non-debug
2023-04-30 2:52:32 36 [ERROR] [FATAL] InnoDB: Clustered record field for column 6 not found table n_user_defined 1 index n_user_defined 6 InnoDB table `test`.`t` field name NULL MySQL table t field name DB_ROW_ID n_fields 6 query UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)
230430 2:52:32 [ERROR] mysqld got signal 6 ;

#2 <signal handler called>
#3 __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at ./nptl/pthread_kill.c:44
#4 0x00007f4a3f2a9d2f in __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
#5 0x00007f4a3f25aef2 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#6 0x00007f4a3f245472 in __GI_abort () at ./stdlib/abort.c:79
#7 0x000055cf561ced91 in ib::fatal::~fatal (this=this@entry=0x7f4a305a6400, __in_chrg=<optimized out>) at /data/src/11.1/storage/innobase/ut/ut0ut.cc:527
#8 0x000055cf561aff10 in build_template_field (prebuilt=<optimized out>, clust_index=clust_index@entry=0x7f49ac033fd0, index=index@entry=0x7f49ac033fd0, table=<optimized out>, field=field@entry=0x7f49acb22ce0, i=i@entry=6, v_no=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7137
#9 0x000055cf567f974d in ha_innobase::build_template (this=this@entry=0x7f49acb224d0, whole_row=<optimized out>, whole_row@entry=false) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7521
#10 0x000055cf567fa280 in ha_innobase::change_active_index (this=0x7f49acb224d0, keynr=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171
#11 0x000055cf56391168 in handler::ha_index_init (sorted=<optimized out>, idx=1, this=0x7f49acb224d0) at /data/src/11.1/sql/handler.h:3409
#12 join_read_always_key (tab=0x7f49acb0e0f0) at /data/src/11.1/sql/sql_select.cc:23811
#13 0x000055cf5637b1e1 in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0e0f0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036
#14 0x000055cf56369e41 in evaluate_join_record (join=join@entry=0x7f49ac012ec0, join_tab=join_tab@entry=0x7f49acb0dcf0, error=<optimized out>) at /data/src/11.1/sql/sql_select.cc:23272
#15 0x000055cf5637b1fd in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0dcf0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039
#16 0x000055cf563a8d5d in do_select (procedure=<optimized out>, join=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:22571
#17 JOIN::exec_inner (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4899
#18 0x000055cf563a91ee in JOIN::exec (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4676
#19 0x000055cf563a9316 in Sql_cmd_dml::execute_inner (this=this@entry=0x7f49ac0124e8, thd=thd@entry=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32615
#20 0x000055cf56406b01 in Sql_cmd_update::execute_inner (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_update.cc:3062
#21 0x000055cf563686cd in Sql_cmd_dml::execute (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32552
#22 0x000055cf563323d6 in mysql_execute_command (thd=thd@entry=0x7f49ac000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/src/11.1/sql/sql_parse.cc:4393
#23 0x000055cf56335ff5 in mysql_parse (thd=0x7f49ac000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/11.1/sql/sql_parse.cc:7760
#24 0x000055cf563382d5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f49ac000c68, packet=packet@entry=0x7f49ac1031d9 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=packet_length@entry=88, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1989
#25 0x000055cf563395d7 in do_command (thd=0x7f49ac000c68, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1405
#26 0x000055cf564498e7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cf5a22cf88, put_in_cache=put_in_cache@entry=true) at /data/src/11.1/sql/sql_connect.cc:1416
#27 0x000055cf56449c7d in handle_one_connection (arg=arg@entry=0x55cf5a22cf88) at /data/src/11.1/sql/sql_connect.cc:1318
#28 0x000055cf56759ad7 in pfs_spawn_thread (arg=0x55cf5a1e0608) at /data/src/11.1/storage/perfschema/pfs.cc:2201
#29 0x00007f4a3f2a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#30 0x00007f4a3f3285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

11.1 3ef11161 debug
mariadbd: /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400: void ha_innobase::build_template(bool): Assertion `!is_v' failed.
230430 2:57:32 [ERROR] mysqld got signal 6 ;

#9 0x00007fdbdc453df2 in __GI___assert_fail (assertion=0x55a20fb36440 "!is_v", file=0x55a20fb2a8c0 "/data/src/11.1/storage/innobase/handler/ha_innodb.cc", line=7400, function=0x55a20fb363e0 "void ha_innobase::build_template(bool)") at ./assert/assert.c:101
#10 0x000055a20e3611f9 in ha_innobase::build_template (this=0x61d0004844b8, whole_row=true) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400
#11 0x000055a20e36d352 in ha_innobase::change_active_index (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171
#12 0x000055a20e36a2dc in ha_innobase::index_init (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:8744
#13 0x000055a20cdac9f5 in handler::ha_index_init (this=0x61d0004844b8, idx=1, sorted=false) at /data/src/11.1/sql/handler.h:3409
#14 0x000055a20d25fd3a in join_read_always_key (tab=0x62900086d680) at /data/src/11.1/sql/sql_select.cc:23811
#15 0x000055a20d25a637 in sub_select (join=0x62900010b810, join_tab=0x62900086d680, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036
#16 0x000055a20d25bf77 in evaluate_join_record (join=0x62900010b810, join_tab=0x62900086d280, error=0) at /data/src/11.1/sql/sql_select.cc:23272
#17 0x000055a20d25a7f3 in sub_select (join=0x62900010b810, join_tab=0x62900086d280, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039
#18 0x000055a20d2585b9 in do_select (join=0x62900010b810, procedure=0x0) at /data/src/11.1/sql/sql_select.cc:22571
#19 0x000055a20d1da6df in JOIN::exec_inner (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4899
#20 0x000055a20d1d7a62 in JOIN::exec (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4676
#21 0x000055a20d29f962 in Sql_cmd_dml::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32615
#22 0x000055a20d44edf7 in Sql_cmd_update::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_update.cc:3062
#23 0x000055a20d29f44e in Sql_cmd_dml::execute (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32552
#24 0x000055a20d0c7ead in mysql_execute_command (thd=0x62b00017a218, is_called_from_prepared_stmt=false) at /data/src/11.1/sql/sql_parse.cc:4393
#25 0x000055a20d0df33a in mysql_parse (thd=0x62b00017a218, rawbuf=0x629000109238 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", length=88, parser_state=0x7fdbc47daa20) at /data/src/11.1/sql/sql_parse.cc:7760
#26 0x000055a20d0b7ab1 in dispatch_command (command=COM_QUERY, thd=0x62b00017a218, packet=0x6290008c0219 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=88, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1892
#27 0x000055a20d0b47ef in do_command (thd=0x62b00017a218, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1405
#28 0x000055a20d56c6e2 in do_handle_one_connection (connect=0x60800005c8b8, put_in_cache=true) at /data/src/11.1/sql/sql_connect.cc:1416
#29 0x000055a20d56c0a3 in handle_one_connection (arg=0x608000003a38) at /data/src/11.1/sql/sql_connect.cc:1318
#30 0x000055a20e165870 in pfs_spawn_thread (arg=0x617000008218) at /data/src/11.1/storage/perfschema/pfs.cc:2201
#31 0x00007fdbdc4a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#32 0x00007fdbdc5285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Attachments

Issue Links

includes

MDEV-18911 Assertion `(templ->is_virtual && !field) || (field && field->prefix_len ? field->prefix_len == len : templ->mysql_col_len == len)' failed row_sel_field_store_in_mysql_format_func

Closed

is duplicated by

MDEV-27840 Wrong result or Assertion `!is_v' failure upon query using rowid filter

Closed

relates to

MDEV-33558 Fatal error InnoDB: Clustered record field for column x not found

Closed

MDEV-33795 MariaDB segfault on rowid filter query involving generated column

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2023-04-30 00:00

Elena Stepanova made changes - 2023-04-30 00:02

Field	Original Value	New Value
Description	Notes: - The test case is non-deterministic despite the absence of obvious race conditions. The problem is apparently in statistics. When the failure occurs, the UPDATE plan is different from the usual one (see the plans below). It only happens once in a while, run with {{--repeat=N}}. It usually fails for me withing ~20-30 attempts. {code:sql\|title=PASSING plan} EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL d 6 NULL 455 Using index 1 SIMPLE t2 ref t,d t 4 func 1 Using where {code} {code:sql\|title=FAILING plan} EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL d 6 NULL 547 Using index 1 SIMPLE t2 ref\|filter t,d t\|d 4\|6 func 2 (83%) Using where; Using rowid filter {code} - The test case turns off InnoDB persistent statistics to achieve the result. It is not a mandatory requirement for the failure to happen, initially (outside MTR) it occurred with InnoDB persistent statistics ON. I suppose for someone knowing the conditions when the optimization is triggered, it should be possible to modify the dataset so that the target execution plan is chosen deterministically, even with EITS. - The failure started happening on 11.1 after this commit: {noformat} commit 554278e24dbc2c0af9fcfd66c54ca6a99a3cf17f Author: Igor Babaev ~~MDEV-7487~~ Semi-join optimization for single-table update/delete statements {noformat} However, it's possible that it just revealed a pre-existing problem. {code:sql} --source include/have_innodb.inc SET GLOBAL innodb_stats_persistent= 0; CREATE TABLE t ( pk INTEGER AUTO_INCREMENT, d DATETIME DEFAULT '2000-01-01 00:00:00', t TIME AS (TIME(d)) VIRTUAL, f1 TIME, f2 DATETIME DEFAULT '2000-01-01 00:00:00', f3 VARCHAR(1) DEFAULT 'x', f4 VARCHAR(1) DEFAULT 'x', PRIMARY KEY (pk), KEY (t), KEY (d) ) ENGINE=InnoDB; INSERT INTO t (d) VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-03-26 00:00:00'), ('1900-05-19 19:48:19'),('1901-05-02 00:00:00'),('1901-12-12 23:05:43'), ('1902-05-31 00:00:00'),('1902-06-17 00:00:00'),('1902-11-06 08:31:01'), ('1903-06-11 00:00:00'),('1904-01-16 09:00:30'),('1904-02-24 08:17:28'), ('1904-04-03 00:00:00'),('1905-01-17 00:00:00'),('1905-05-23 04:59:29'), ('1905-09-22 21:52:15'),('1905-12-06 13:11:49'),('1906-02-27 10:51:18'), ('1906-06-08 20:01:15'),('1907-02-09 23:08:14'),('1907-04-03 08:33:28'), ('1907-11-23 19:00:13'),('1908-09-03 03:19:29'),('1908-10-03 20:54:11'), ('1908-12-22 09:47:25'),('1909-04-10 10:29:16'),('1911-03-11 00:00:00'), ('1911-06-30 00:00:00'),('1911-08-07 01:32:56'),('1912-03-08 00:00:00'), ('1912-03-10 00:00:00'),('1912-03-13 11:40:19'),('1912-11-12 20:10:13'), ('1913-01-10 00:00:00'),('1913-09-15 18:43:53'),('1913-10-10 00:00:00'), ('1913-10-11 00:00:00'),('1914-01-18 17:52:52'),('1915-07-10 23:29:43'), ('1915-09-05 00:00:00'),('1915-09-25 14:42:14'),('1916-04-17 00:00:00'), ('1916-11-02 23:33:35'),('1917-04-22 13:14:41'),('1917-05-12 00:00:00'), ('1917-05-23 16:50:52'),('1917-06-24 12:14:19'),('1917-09-17 07:37:32'), ('1918-01-04 18:27:31'),('1918-05-02 12:55:51'),('1918-05-18 00:00:00'), ('1918-08-05 21:51:15'),('1918-09-12 19:27:33'),('1919-02-18 22:26:53'), ('1919-07-24 00:54:48'),('1919-09-07 22:41:09'),('1919-10-04 16:12:01'), ('1919-12-06 04:40:47'),('1920-01-28 00:00:00'),('1920-05-07 14:45:18'), ('1920-06-07 16:44:53'),('1921-02-15 11:55:05'),('1921-04-16 00:00:00'), ('1921-07-06 00:00:00'),('1922-04-13 00:00:00'),('1922-11-25 13:15:40'), ('1922-12-10 00:00:00'),('1923-02-01 00:00:00'),('1923-04-07 00:00:00'), ('1923-08-12 08:57:05'),('1923-10-22 00:00:00'),('1924-03-09 00:00:00'), ('1924-07-01 14:53:14'),('1924-07-04 23:45:21'),('1924-07-28 07:16:47'), ('1924-12-02 11:49:57'),('1925-09-09 00:00:00'),('1925-11-06 00:00:00'), ('1926-05-04 00:00:00'),('1926-06-21 06:38:24'),('1926-09-26 07:03:33'), ('1926-10-24 00:00:00'),('1926-11-17 03:12:56'),('1926-12-01 10:37:11'), ('1926-12-26 01:06:29'),('1927-08-25 00:00:00'),('1927-08-25 01:00:09'), ('1928-02-29 01:21:11'),('1928-03-08 00:00:00'),('1928-05-07 08:14:46'), ('1928-06-11 02:30:03'),('1928-09-04 03:56:02'),('1928-09-14 00:10:49'), ('1929-11-23 23:11:52'),('1929-12-10 00:00:00'),('1930-05-01 00:00:00'), ('1930-05-07 00:25:07'),('1931-04-26 00:00:00'),('1931-06-05 23:04:47'), ('1931-07-08 23:24:45'),('1932-10-08 00:00:00'),('1932-10-22 00:00:00'), ('1933-08-27 23:05:40'),('1933-10-21 05:28:44'),('1934-07-09 00:00:00'), ('1934-09-27 10:53:33'),('1935-04-01 00:00:00'),('1935-05-08 09:40:03'), ('1935-10-24 20:43:43'),('1935-11-18 11:22:59'),('1936-05-10 00:00:00'), ('1936-09-03 00:00:00'),('1937-02-16 06:36:19'),('1937-03-16 00:00:00'), ('1937-05-16 20:05:38'),('1937-09-12 00:00:00'),('1939-01-03 00:00:00'), ('1940-09-18 00:00:00'),('1940-10-26 00:00:00'),('1941-02-08 05:23:51'), ('1941-04-18 00:00:00'),('1941-07-01 00:00:00'),('1941-08-21 00:00:00'), ('1941-12-17 13:48:07'),('1942-09-17 15:03:18'),('1942-11-28 20:49:30'), ('1943-01-18 00:18:15'),('1943-05-20 00:00:00'),('1943-06-01 00:00:00'), ('1943-12-16 11:48:11'),('1943-12-31 12:45:58'),('1944-01-15 06:43:50'), ('1944-03-19 00:00:00'),('1944-03-23 00:00:00'),('1944-05-19 00:00:00'), ('1944-06-13 09:26:18'),('1944-07-19 11:52:08'),('1944-08-11 00:00:00'), ('1944-10-27 00:00:00'),('1945-01-17 17:55:51'),('1945-02-23 20:54:46'), ('1945-03-04 07:58:13'),('1945-05-07 00:00:00'),('1945-06-12 00:00:00'), ('1945-07-14 09:47:28'),('1945-10-24 19:31:58'),('1945-11-03 00:00:00'), ('1945-11-26 20:13:02'),('1945-12-24 00:00:00'),('1946-10-06 00:00:00'), ('1946-10-23 00:00:00'),('1946-11-19 03:11:21'),('1947-01-02 05:04:16'), ('1947-09-23 23:57:34'),('1947-11-30 00:50:13'),('1948-03-05 18:11:03'), ('1948-03-09 02:33:13'),('1948-04-10 00:24:59'),('1948-06-01 08:51:57'), ('1948-07-27 16:11:03'),('1948-10-29 05:29:57'),('1949-06-13 00:38:11'), ('1949-10-14 01:50:48'),('1950-02-12 00:00:00'),('1950-02-21 22:38:06'), ('1950-03-26 07:56:02'),('1951-01-31 13:12:27'),('1951-04-17 13:35:33'), ('1951-08-17 11:51:53'),('1951-12-31 00:00:00'),('1952-05-25 06:22:51'), ('1953-05-02 14:26:04'),('1953-06-19 19:35:42'),('1953-07-02 18:01:07'), ('1953-11-01 14:27:14'),('1954-01-05 02:40:21'),('1954-05-01 05:52:08'), ('1954-06-05 15:11:12'),('1955-01-12 00:00:00'),('1955-02-03 19:51:41'), ('1955-02-27 15:38:21'),('1955-05-25 00:00:00'),('1955-08-22 19:47:38'), ('1955-08-30 08:38:26'),('1955-12-15 22:02:31'),('1956-08-17 00:00:00'), ('1956-09-17 06:58:08'),('1956-10-02 00:00:00'),('1957-05-15 05:05:17'), ('1958-11-01 10:11:48'),('1959-03-31 00:00:00'),('1959-11-02 23:28:29'), ('1960-01-26 21:57:36'),('1960-10-31 00:00:00'),('1960-11-18 11:19:40'), ('1961-03-22 01:28:24'),('1961-07-11 03:48:39'),('1962-11-08 00:00:00'), ('1963-02-27 12:25:30'),('1963-04-11 00:44:21'),('1963-06-26 03:25:23'), ('1963-07-26 16:14:47'),('1963-08-14 08:09:23'),('1963-10-28 15:24:24'), ('1964-01-11 21:08:21'),('1964-05-26 05:12:28'),('1965-03-18 22:49:37'), ('1966-03-26 18:42:55'),('1966-09-11 22:46:33'),('1967-01-21 00:00:21'), ('1967-02-28 02:47:14'),('1967-06-09 13:27:40'),('1967-06-29 00:49:17'), ('1967-09-29 00:00:00'),('1967-12-14 06:37:06'),('1968-02-04 11:27:22'), ('1968-03-15 21:33:37'),('1968-08-31 18:53:30'),('1968-09-04 00:00:00'), ('1968-09-11 00:00:00'),('1968-11-07 02:40:13'),('1968-11-28 01:29:10'), ('1969-01-31 00:00:00'),('1969-05-04 09:11:55'),('1969-10-28 19:10:25'), ('1970-01-02 00:00:00'),('1970-06-09 05:45:57'),('1970-07-17 10:13:47'), ('1970-12-21 16:08:41'),('1971-02-03 00:00:00'),('1971-10-03 00:00:00'), ('1971-12-30 17:44:34'),('1972-03-12 04:03:57'),('1972-08-27 00:00:00'), ('1972-09-13 13:44:08'),('1972-11-26 00:00:00'),('1973-05-28 00:00:00'), ('1974-03-30 00:00:00'),('1974-05-23 19:28:42'),('1974-08-03 07:58:03'), ('1975-09-20 04:00:22'),('1975-11-03 16:41:33'),('1975-12-20 00:00:00'), ('1976-01-07 00:55:02'),('1976-05-14 11:04:05'),('1976-08-04 15:11:46'), ('1976-08-18 17:11:29'),('1977-03-03 19:45:25'),('1977-09-11 22:10:22'), ('1977-12-13 06:18:33'),('1979-05-05 16:04:17'),('1979-06-02 22:22:32'), ('1979-12-08 00:00:00'),('1980-02-03 09:54:52'),('1980-05-30 02:23:29'), ('1980-07-14 17:19:17'),('1980-12-15 00:00:00'),('1981-04-13 19:17:48'), ('1981-11-21 16:22:17'),('1982-04-06 04:42:04'),('1982-11-24 12:17:25'), ('1983-12-04 16:23:48'),('1984-04-26 00:00:00'),('1984-07-30 00:00:00'), ('1985-01-02 00:00:00'),('1985-07-23 05:12:22'),('1985-10-04 14:56:23'), ('1985-12-02 17:47:43'),('1986-03-01 00:00:00'),('1986-08-30 03:27:04'), ('1987-01-16 14:09:52'),('1987-02-03 03:55:02'),('1987-03-03 12:04:10'), ('1987-09-21 11:28:54'),('1988-04-24 20:59:14'),('1988-06-13 18:25:07'), ('1988-07-04 00:00:00'),('1988-07-23 10:09:14'),('1988-08-26 09:41:22'), ('1989-07-25 05:19:18'),('1990-07-13 00:00:00'),('1990-07-22 16:52:29'), ('1990-08-22 22:40:34'),('1991-01-09 00:00:00'),('1991-02-25 02:06:00'), ('1991-04-26 00:00:00'),('1991-10-20 12:57:55'),('1991-11-15 12:18:40'), ('1992-06-15 03:23:28'),('1992-08-22 11:08:44'),('1992-12-06 23:07:49'), ('1992-12-23 10:48:27'),('1993-07-18 18:05:03'),('1993-08-28 12:46:25'), ('1994-06-01 18:17:38'),('1994-08-25 14:39:37'),('1994-12-02 00:00:00'), ('1995-04-21 04:09:34'),('1995-06-28 21:26:52'),('1995-07-11 03:04:35'), ('1995-09-24 00:00:00'),('1996-06-27 02:43:39'),('1997-10-05 09:25:29'), ('1997-10-16 01:24:59'),('1999-01-16 00:00:00'),('1999-05-28 06:52:34'), ('1999-08-11 12:35:50'),('2000-04-30 00:00:00'),('2000-11-04 12:40:42'), ('2001-01-29 07:51:53'),('2001-09-05 11:22:16'),('2002-02-01 19:34:03'), ('2003-02-18 00:00:00'),('2003-03-06 00:00:00'),('2003-05-22 00:00:00'), ('2004-02-19 00:00:00'),('2004-05-12 00:00:00'),('2004-09-10 00:00:00'), ('2005-02-04 21:34:25'),('2005-03-08 14:48:55'),('2005-03-28 09:35:18'), ('2005-06-17 10:29:21'),('2005-08-06 07:43:46'),('2006-01-03 11:02:29'), ('2006-03-11 00:42:35'),('2006-03-25 13:55:48'),('2006-10-25 23:18:04'), ('2007-07-10 21:14:32'),('2007-09-26 15:45:08'),('2007-11-28 19:07:20'), ('2008-06-04 08:48:59'),('2008-07-18 00:00:00'),('2008-08-14 03:00:01'), ('2008-11-28 05:02:23'),('2008-11-29 16:07:13'),('2010-09-09 11:08:48'), ('2011-01-17 12:47:26'),('2011-03-25 06:25:51'),('2011-05-06 03:38:56'), ('2012-02-06 14:45:33'),('2012-05-01 00:46:29'),('2012-05-23 13:56:45'), ('2012-09-17 15:14:54'),('2012-12-12 21:21:34'),('2013-04-16 00:00:00'), ('2014-03-10 05:07:51'),('2014-05-09 23:13:07'),('2014-07-24 06:41:03'), ('2014-07-27 05:13:13'),('2015-05-05 05:31:40'),('2016-05-18 14:44:12'), ('2016-09-29 00:00:00'),('2017-01-27 00:00:00'),('2017-05-03 01:50:33'), ('2017-06-09 00:53:25'),('2017-09-12 04:34:06'),('2018-02-01 07:14:12'), ('2018-03-22 22:16:24'),('2018-04-20 08:19:24'),('2018-07-25 19:32:34'), ('2018-08-09 00:00:00'),('2019-03-23 00:00:00'),('2019-12-18 15:04:21'), ('2020-04-09 15:54:29'),('2020-09-13 15:05:56'),('2021-04-21 08:07:20'), ('2021-05-04 10:09:48'),('2021-06-18 00:00:00'),('2021-09-06 00:00:00'), ('2022-10-24 00:00:00'),('2022-11-24 02:54:09'),('2023-04-07 16:59:25'), ('2023-11-26 00:00:00'),('2024-04-01 11:20:53'),('2024-04-19 00:00:00'), ('2024-09-16 05:45:31'),('2024-10-15 02:07:05'),('2024-11-05 00:00:00'), ('2024-12-27 02:53:35'),('2025-02-04 00:00:00'),('2025-05-05 12:19:13'), ('2025-08-20 00:00:00'),('2025-09-25 01:09:50'),('2027-03-02 10:18:54'), ('2028-08-20 00:00:00'),('2028-11-18 16:08:10'),('2029-01-20 11:11:25'), ('2029-11-06 00:00:00'),('2030-06-11 10:48:40'),('2030-08-24 01:16:16'), ('2031-03-08 20:50:33'),('2031-04-25 21:26:00'),('2032-05-31 14:26:32'), ('2032-07-28 04:02:35'),('2033-04-30 03:04:26'),('2033-06-16 15:07:21'), ('2033-08-11 10:08:08'),('2033-09-21 07:18:35'),('2034-01-25 13:32:44'), ('2034-01-30 15:30:45'),('2034-08-26 19:59:15'),('2034-12-01 23:39:50'), ('2034-12-25 00:00:00'),('2035-04-12 07:50:46'),('2035-04-25 15:36:36'), ('2035-05-25 20:29:49'),('2035-06-06 20:59:57'),('2035-07-15 20:11:20'), ('2035-08-02 09:53:16'),('2035-08-03 00:00:00'),('2035-12-08 00:00:00'), ('2036-03-13 10:35:23'),('2036-03-25 16:31:32'),('2036-09-06 12:50:17'), ('2036-10-07 02:50:31'),('2037-05-26 00:00:00'),('2037-11-21 05:17:58'), ('2038-02-11 07:16:04'),('2038-04-08 00:16:00'),('2038-05-26 01:10:18'), ('2038-11-17 09:13:06'),('2039-03-10 11:41:13'),('2039-11-08 10:08:53'); UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d); # Cleanup DROP TABLE t; SET GLOBAL innodb_stats_persistent= DEFAULT; {code} {noformat:title=11.1 3ef11161 non-debug} 2023-04-30 2:52:32 36 [ERROR] [FATAL] InnoDB: Clustered record field for column 6 not found table n_user_defined 1 index n_user_defined 6 InnoDB table `test`.`t` field name NULL MySQL table t field name DB_ROW_ID n_fields 6 query UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d) 230430 2:52:32 [ERROR] mysqld got signal 6 ; #2 <signal handler called> #3 __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at ./nptl/pthread_kill.c:44 #4 0x00007f4a3f2a9d2f in __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78 #5 0x00007f4a3f25aef2 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26 #6 0x00007f4a3f245472 in __GI_abort () at ./stdlib/abort.c:79 #7 0x000055cf561ced91 in ib::fatal::~fatal (this=this@entry=0x7f4a305a6400, __in_chrg=<optimized out>) at /data/src/11.1/storage/innobase/ut/ut0ut.cc:527 #8 0x000055cf561aff10 in build_template_field (prebuilt=<optimized out>, clust_index=clust_index@entry=0x7f49ac033fd0, index=index@entry=0x7f49ac033fd0, table=<optimized out>, field=field@entry=0x7f49acb22ce0, i=i@entry=6, v_no=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7137 #9 0x000055cf567f974d in ha_innobase::build_template (this=this@entry=0x7f49acb224d0, whole_row=<optimized out>, whole_row@entry=false) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7521 #10 0x000055cf567fa280 in ha_innobase::change_active_index (this=0x7f49acb224d0, keynr=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171 #11 0x000055cf56391168 in handler::ha_index_init (sorted=<optimized out>, idx=1, this=0x7f49acb224d0) at /data/src/11.1/sql/handler.h:3409 #12 join_read_always_key (tab=0x7f49acb0e0f0) at /data/src/11.1/sql/sql_select.cc:23811 #13 0x000055cf5637b1e1 in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0e0f0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036 #14 0x000055cf56369e41 in evaluate_join_record (join=join@entry=0x7f49ac012ec0, join_tab=join_tab@entry=0x7f49acb0dcf0, error=<optimized out>) at /data/src/11.1/sql/sql_select.cc:23272 #15 0x000055cf5637b1fd in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0dcf0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039 #16 0x000055cf563a8d5d in do_select (procedure=<optimized out>, join=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:22571 #17 JOIN::exec_inner (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4899 #18 0x000055cf563a91ee in JOIN::exec (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4676 #19 0x000055cf563a9316 in Sql_cmd_dml::execute_inner (this=this@entry=0x7f49ac0124e8, thd=thd@entry=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32615 #20 0x000055cf56406b01 in Sql_cmd_update::execute_inner (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_update.cc:3062 #21 0x000055cf563686cd in Sql_cmd_dml::execute (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32552 #22 0x000055cf563323d6 in mysql_execute_command (thd=thd@entry=0x7f49ac000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/src/11.1/sql/sql_parse.cc:4393 #23 0x000055cf56335ff5 in mysql_parse (thd=0x7f49ac000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/11.1/sql/sql_parse.cc:7760 #24 0x000055cf563382d5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f49ac000c68, packet=packet@entry=0x7f49ac1031d9 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=packet_length@entry=88, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1989 #25 0x000055cf563395d7 in do_command (thd=0x7f49ac000c68, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1405 #26 0x000055cf564498e7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cf5a22cf88, put_in_cache=put_in_cache@entry=true) at /data/src/11.1/sql/sql_connect.cc:1416 #27 0x000055cf56449c7d in handle_one_connection (arg=arg@entry=0x55cf5a22cf88) at /data/src/11.1/sql/sql_connect.cc:1318 #28 0x000055cf56759ad7 in pfs_spawn_thread (arg=0x55cf5a1e0608) at /data/src/11.1/storage/perfschema/pfs.cc:2201 #29 0x00007f4a3f2a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #30 0x00007f4a3f3285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat} {noformat:title=11.1 3ef11161 debug} mariadbd: /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400: void ha_innobase::build_template(bool): Assertion `!is_v' failed. 230430 2:57:32 [ERROR] mysqld got signal 6 ; #9 0x00007fdbdc453df2 in __GI___assert_fail (assertion=0x55a20fb36440 "!is_v", file=0x55a20fb2a8c0 "/data/src/11.1/storage/innobase/handler/ha_innodb.cc", line=7400, function=0x55a20fb363e0 "void ha_innobase::build_template(bool)") at ./assert/assert.c:101 #10 0x000055a20e3611f9 in ha_innobase::build_template (this=0x61d0004844b8, whole_row=true) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400 #11 0x000055a20e36d352 in ha_innobase::change_active_index (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171 #12 0x000055a20e36a2dc in ha_innobase::index_init (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:8744 #13 0x000055a20cdac9f5 in handler::ha_index_init (this=0x61d0004844b8, idx=1, sorted=false) at /data/src/11.1/sql/handler.h:3409 #14 0x000055a20d25fd3a in join_read_always_key (tab=0x62900086d680) at /data/src/11.1/sql/sql_select.cc:23811 #15 0x000055a20d25a637 in sub_select (join=0x62900010b810, join_tab=0x62900086d680, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036 #16 0x000055a20d25bf77 in evaluate_join_record (join=0x62900010b810, join_tab=0x62900086d280, error=0) at /data/src/11.1/sql/sql_select.cc:23272 #17 0x000055a20d25a7f3 in sub_select (join=0x62900010b810, join_tab=0x62900086d280, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039 #18 0x000055a20d2585b9 in do_select (join=0x62900010b810, procedure=0x0) at /data/src/11.1/sql/sql_select.cc:22571 #19 0x000055a20d1da6df in JOIN::exec_inner (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4899 #20 0x000055a20d1d7a62 in JOIN::exec (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4676 #21 0x000055a20d29f962 in Sql_cmd_dml::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32615 #22 0x000055a20d44edf7 in Sql_cmd_update::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_update.cc:3062 #23 0x000055a20d29f44e in Sql_cmd_dml::execute (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32552 #24 0x000055a20d0c7ead in mysql_execute_command (thd=0x62b00017a218, is_called_from_prepared_stmt=false) at /data/src/11.1/sql/sql_parse.cc:4393 #25 0x000055a20d0df33a in mysql_parse (thd=0x62b00017a218, rawbuf=0x629000109238 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", length=88, parser_state=0x7fdbc47daa20) at /data/src/11.1/sql/sql_parse.cc:7760 #26 0x000055a20d0b7ab1 in dispatch_command (command=COM_QUERY, thd=0x62b00017a218, packet=0x6290008c0219 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=88, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1892 #27 0x000055a20d0b47ef in do_command (thd=0x62b00017a218, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1405 #28 0x000055a20d56c6e2 in do_handle_one_connection (connect=0x60800005c8b8, put_in_cache=true) at /data/src/11.1/sql/sql_connect.cc:1416 #29 0x000055a20d56c0a3 in handle_one_connection (arg=0x608000003a38) at /data/src/11.1/sql/sql_connect.cc:1318 #30 0x000055a20e165870 in pfs_spawn_thread (arg=0x617000008218) at /data/src/11.1/storage/perfschema/pfs.cc:2201 #31 0x00007fdbdc4a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #32 0x00007fdbdc5285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat}	Notes: - The test case is non-deterministic despite the absence of obvious race conditions. The difference is likely in statistics. When the failure occurs, the UPDATE plan is different from the usual one (see the plans below). It only happens once in a while, run with {{--repeat=N}}. It usually fails for me withing ~20-30 attempts. {code:sql\|title=PASSING plan} EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL d 6 NULL 455 Using index 1 SIMPLE t2 ref t,d t 4 func 1 Using where {code} {code:sql\|title=FAILING plan} EXPLAIN UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL d 6 NULL 547 Using index 1 SIMPLE t2 ref\|filter t,d t\|d 4\|6 func 2 (83%) Using where; Using rowid filter {code} - The test case turns off InnoDB persistent statistics to achieve the result. It is not a mandatory requirement for the failure to happen, initially (outside MTR) it occurred with InnoDB persistent statistics ON. I suppose for someone knowing the conditions when the optimization is triggered, it should be possible to modify the dataset so that the target execution plan is chosen deterministically, even with EITS. - The failure apparently started happening on 11.1 after this commit: {noformat} commit 554278e24dbc2c0af9fcfd66c54ca6a99a3cf17f Author: Igor Babaev ~~MDEV-7487~~ Semi-join optimization for single-table update/delete statements {noformat} However, it's possible that it just revealed a pre-existing problem. {code:sql} --source include/have_innodb.inc SET GLOBAL innodb_stats_persistent= 0; CREATE TABLE t ( pk INTEGER AUTO_INCREMENT, d DATETIME DEFAULT '2000-01-01 00:00:00', t TIME AS (TIME(d)) VIRTUAL, f1 TIME, f2 DATETIME DEFAULT '2000-01-01 00:00:00', f3 VARCHAR(1) DEFAULT 'x', f4 VARCHAR(1) DEFAULT 'x', PRIMARY KEY (pk), KEY (t), KEY (d) ) ENGINE=InnoDB; INSERT INTO t (d) VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-01-01 00:00:00'), ('1900-01-01 00:00:00'),('1900-01-01 00:00:00'),('1900-03-26 00:00:00'), ('1900-05-19 19:48:19'),('1901-05-02 00:00:00'),('1901-12-12 23:05:43'), ('1902-05-31 00:00:00'),('1902-06-17 00:00:00'),('1902-11-06 08:31:01'), ('1903-06-11 00:00:00'),('1904-01-16 09:00:30'),('1904-02-24 08:17:28'), ('1904-04-03 00:00:00'),('1905-01-17 00:00:00'),('1905-05-23 04:59:29'), ('1905-09-22 21:52:15'),('1905-12-06 13:11:49'),('1906-02-27 10:51:18'), ('1906-06-08 20:01:15'),('1907-02-09 23:08:14'),('1907-04-03 08:33:28'), ('1907-11-23 19:00:13'),('1908-09-03 03:19:29'),('1908-10-03 20:54:11'), ('1908-12-22 09:47:25'),('1909-04-10 10:29:16'),('1911-03-11 00:00:00'), ('1911-06-30 00:00:00'),('1911-08-07 01:32:56'),('1912-03-08 00:00:00'), ('1912-03-10 00:00:00'),('1912-03-13 11:40:19'),('1912-11-12 20:10:13'), ('1913-01-10 00:00:00'),('1913-09-15 18:43:53'),('1913-10-10 00:00:00'), ('1913-10-11 00:00:00'),('1914-01-18 17:52:52'),('1915-07-10 23:29:43'), ('1915-09-05 00:00:00'),('1915-09-25 14:42:14'),('1916-04-17 00:00:00'), ('1916-11-02 23:33:35'),('1917-04-22 13:14:41'),('1917-05-12 00:00:00'), ('1917-05-23 16:50:52'),('1917-06-24 12:14:19'),('1917-09-17 07:37:32'), ('1918-01-04 18:27:31'),('1918-05-02 12:55:51'),('1918-05-18 00:00:00'), ('1918-08-05 21:51:15'),('1918-09-12 19:27:33'),('1919-02-18 22:26:53'), ('1919-07-24 00:54:48'),('1919-09-07 22:41:09'),('1919-10-04 16:12:01'), ('1919-12-06 04:40:47'),('1920-01-28 00:00:00'),('1920-05-07 14:45:18'), ('1920-06-07 16:44:53'),('1921-02-15 11:55:05'),('1921-04-16 00:00:00'), ('1921-07-06 00:00:00'),('1922-04-13 00:00:00'),('1922-11-25 13:15:40'), ('1922-12-10 00:00:00'),('1923-02-01 00:00:00'),('1923-04-07 00:00:00'), ('1923-08-12 08:57:05'),('1923-10-22 00:00:00'),('1924-03-09 00:00:00'), ('1924-07-01 14:53:14'),('1924-07-04 23:45:21'),('1924-07-28 07:16:47'), ('1924-12-02 11:49:57'),('1925-09-09 00:00:00'),('1925-11-06 00:00:00'), ('1926-05-04 00:00:00'),('1926-06-21 06:38:24'),('1926-09-26 07:03:33'), ('1926-10-24 00:00:00'),('1926-11-17 03:12:56'),('1926-12-01 10:37:11'), ('1926-12-26 01:06:29'),('1927-08-25 00:00:00'),('1927-08-25 01:00:09'), ('1928-02-29 01:21:11'),('1928-03-08 00:00:00'),('1928-05-07 08:14:46'), ('1928-06-11 02:30:03'),('1928-09-04 03:56:02'),('1928-09-14 00:10:49'), ('1929-11-23 23:11:52'),('1929-12-10 00:00:00'),('1930-05-01 00:00:00'), ('1930-05-07 00:25:07'),('1931-04-26 00:00:00'),('1931-06-05 23:04:47'), ('1931-07-08 23:24:45'),('1932-10-08 00:00:00'),('1932-10-22 00:00:00'), ('1933-08-27 23:05:40'),('1933-10-21 05:28:44'),('1934-07-09 00:00:00'), ('1934-09-27 10:53:33'),('1935-04-01 00:00:00'),('1935-05-08 09:40:03'), ('1935-10-24 20:43:43'),('1935-11-18 11:22:59'),('1936-05-10 00:00:00'), ('1936-09-03 00:00:00'),('1937-02-16 06:36:19'),('1937-03-16 00:00:00'), ('1937-05-16 20:05:38'),('1937-09-12 00:00:00'),('1939-01-03 00:00:00'), ('1940-09-18 00:00:00'),('1940-10-26 00:00:00'),('1941-02-08 05:23:51'), ('1941-04-18 00:00:00'),('1941-07-01 00:00:00'),('1941-08-21 00:00:00'), ('1941-12-17 13:48:07'),('1942-09-17 15:03:18'),('1942-11-28 20:49:30'), ('1943-01-18 00:18:15'),('1943-05-20 00:00:00'),('1943-06-01 00:00:00'), ('1943-12-16 11:48:11'),('1943-12-31 12:45:58'),('1944-01-15 06:43:50'), ('1944-03-19 00:00:00'),('1944-03-23 00:00:00'),('1944-05-19 00:00:00'), ('1944-06-13 09:26:18'),('1944-07-19 11:52:08'),('1944-08-11 00:00:00'), ('1944-10-27 00:00:00'),('1945-01-17 17:55:51'),('1945-02-23 20:54:46'), ('1945-03-04 07:58:13'),('1945-05-07 00:00:00'),('1945-06-12 00:00:00'), ('1945-07-14 09:47:28'),('1945-10-24 19:31:58'),('1945-11-03 00:00:00'), ('1945-11-26 20:13:02'),('1945-12-24 00:00:00'),('1946-10-06 00:00:00'), ('1946-10-23 00:00:00'),('1946-11-19 03:11:21'),('1947-01-02 05:04:16'), ('1947-09-23 23:57:34'),('1947-11-30 00:50:13'),('1948-03-05 18:11:03'), ('1948-03-09 02:33:13'),('1948-04-10 00:24:59'),('1948-06-01 08:51:57'), ('1948-07-27 16:11:03'),('1948-10-29 05:29:57'),('1949-06-13 00:38:11'), ('1949-10-14 01:50:48'),('1950-02-12 00:00:00'),('1950-02-21 22:38:06'), ('1950-03-26 07:56:02'),('1951-01-31 13:12:27'),('1951-04-17 13:35:33'), ('1951-08-17 11:51:53'),('1951-12-31 00:00:00'),('1952-05-25 06:22:51'), ('1953-05-02 14:26:04'),('1953-06-19 19:35:42'),('1953-07-02 18:01:07'), ('1953-11-01 14:27:14'),('1954-01-05 02:40:21'),('1954-05-01 05:52:08'), ('1954-06-05 15:11:12'),('1955-01-12 00:00:00'),('1955-02-03 19:51:41'), ('1955-02-27 15:38:21'),('1955-05-25 00:00:00'),('1955-08-22 19:47:38'), ('1955-08-30 08:38:26'),('1955-12-15 22:02:31'),('1956-08-17 00:00:00'), ('1956-09-17 06:58:08'),('1956-10-02 00:00:00'),('1957-05-15 05:05:17'), ('1958-11-01 10:11:48'),('1959-03-31 00:00:00'),('1959-11-02 23:28:29'), ('1960-01-26 21:57:36'),('1960-10-31 00:00:00'),('1960-11-18 11:19:40'), ('1961-03-22 01:28:24'),('1961-07-11 03:48:39'),('1962-11-08 00:00:00'), ('1963-02-27 12:25:30'),('1963-04-11 00:44:21'),('1963-06-26 03:25:23'), ('1963-07-26 16:14:47'),('1963-08-14 08:09:23'),('1963-10-28 15:24:24'), ('1964-01-11 21:08:21'),('1964-05-26 05:12:28'),('1965-03-18 22:49:37'), ('1966-03-26 18:42:55'),('1966-09-11 22:46:33'),('1967-01-21 00:00:21'), ('1967-02-28 02:47:14'),('1967-06-09 13:27:40'),('1967-06-29 00:49:17'), ('1967-09-29 00:00:00'),('1967-12-14 06:37:06'),('1968-02-04 11:27:22'), ('1968-03-15 21:33:37'),('1968-08-31 18:53:30'),('1968-09-04 00:00:00'), ('1968-09-11 00:00:00'),('1968-11-07 02:40:13'),('1968-11-28 01:29:10'), ('1969-01-31 00:00:00'),('1969-05-04 09:11:55'),('1969-10-28 19:10:25'), ('1970-01-02 00:00:00'),('1970-06-09 05:45:57'),('1970-07-17 10:13:47'), ('1970-12-21 16:08:41'),('1971-02-03 00:00:00'),('1971-10-03 00:00:00'), ('1971-12-30 17:44:34'),('1972-03-12 04:03:57'),('1972-08-27 00:00:00'), ('1972-09-13 13:44:08'),('1972-11-26 00:00:00'),('1973-05-28 00:00:00'), ('1974-03-30 00:00:00'),('1974-05-23 19:28:42'),('1974-08-03 07:58:03'), ('1975-09-20 04:00:22'),('1975-11-03 16:41:33'),('1975-12-20 00:00:00'), ('1976-01-07 00:55:02'),('1976-05-14 11:04:05'),('1976-08-04 15:11:46'), ('1976-08-18 17:11:29'),('1977-03-03 19:45:25'),('1977-09-11 22:10:22'), ('1977-12-13 06:18:33'),('1979-05-05 16:04:17'),('1979-06-02 22:22:32'), ('1979-12-08 00:00:00'),('1980-02-03 09:54:52'),('1980-05-30 02:23:29'), ('1980-07-14 17:19:17'),('1980-12-15 00:00:00'),('1981-04-13 19:17:48'), ('1981-11-21 16:22:17'),('1982-04-06 04:42:04'),('1982-11-24 12:17:25'), ('1983-12-04 16:23:48'),('1984-04-26 00:00:00'),('1984-07-30 00:00:00'), ('1985-01-02 00:00:00'),('1985-07-23 05:12:22'),('1985-10-04 14:56:23'), ('1985-12-02 17:47:43'),('1986-03-01 00:00:00'),('1986-08-30 03:27:04'), ('1987-01-16 14:09:52'),('1987-02-03 03:55:02'),('1987-03-03 12:04:10'), ('1987-09-21 11:28:54'),('1988-04-24 20:59:14'),('1988-06-13 18:25:07'), ('1988-07-04 00:00:00'),('1988-07-23 10:09:14'),('1988-08-26 09:41:22'), ('1989-07-25 05:19:18'),('1990-07-13 00:00:00'),('1990-07-22 16:52:29'), ('1990-08-22 22:40:34'),('1991-01-09 00:00:00'),('1991-02-25 02:06:00'), ('1991-04-26 00:00:00'),('1991-10-20 12:57:55'),('1991-11-15 12:18:40'), ('1992-06-15 03:23:28'),('1992-08-22 11:08:44'),('1992-12-06 23:07:49'), ('1992-12-23 10:48:27'),('1993-07-18 18:05:03'),('1993-08-28 12:46:25'), ('1994-06-01 18:17:38'),('1994-08-25 14:39:37'),('1994-12-02 00:00:00'), ('1995-04-21 04:09:34'),('1995-06-28 21:26:52'),('1995-07-11 03:04:35'), ('1995-09-24 00:00:00'),('1996-06-27 02:43:39'),('1997-10-05 09:25:29'), ('1997-10-16 01:24:59'),('1999-01-16 00:00:00'),('1999-05-28 06:52:34'), ('1999-08-11 12:35:50'),('2000-04-30 00:00:00'),('2000-11-04 12:40:42'), ('2001-01-29 07:51:53'),('2001-09-05 11:22:16'),('2002-02-01 19:34:03'), ('2003-02-18 00:00:00'),('2003-03-06 00:00:00'),('2003-05-22 00:00:00'), ('2004-02-19 00:00:00'),('2004-05-12 00:00:00'),('2004-09-10 00:00:00'), ('2005-02-04 21:34:25'),('2005-03-08 14:48:55'),('2005-03-28 09:35:18'), ('2005-06-17 10:29:21'),('2005-08-06 07:43:46'),('2006-01-03 11:02:29'), ('2006-03-11 00:42:35'),('2006-03-25 13:55:48'),('2006-10-25 23:18:04'), ('2007-07-10 21:14:32'),('2007-09-26 15:45:08'),('2007-11-28 19:07:20'), ('2008-06-04 08:48:59'),('2008-07-18 00:00:00'),('2008-08-14 03:00:01'), ('2008-11-28 05:02:23'),('2008-11-29 16:07:13'),('2010-09-09 11:08:48'), ('2011-01-17 12:47:26'),('2011-03-25 06:25:51'),('2011-05-06 03:38:56'), ('2012-02-06 14:45:33'),('2012-05-01 00:46:29'),('2012-05-23 13:56:45'), ('2012-09-17 15:14:54'),('2012-12-12 21:21:34'),('2013-04-16 00:00:00'), ('2014-03-10 05:07:51'),('2014-05-09 23:13:07'),('2014-07-24 06:41:03'), ('2014-07-27 05:13:13'),('2015-05-05 05:31:40'),('2016-05-18 14:44:12'), ('2016-09-29 00:00:00'),('2017-01-27 00:00:00'),('2017-05-03 01:50:33'), ('2017-06-09 00:53:25'),('2017-09-12 04:34:06'),('2018-02-01 07:14:12'), ('2018-03-22 22:16:24'),('2018-04-20 08:19:24'),('2018-07-25 19:32:34'), ('2018-08-09 00:00:00'),('2019-03-23 00:00:00'),('2019-12-18 15:04:21'), ('2020-04-09 15:54:29'),('2020-09-13 15:05:56'),('2021-04-21 08:07:20'), ('2021-05-04 10:09:48'),('2021-06-18 00:00:00'),('2021-09-06 00:00:00'), ('2022-10-24 00:00:00'),('2022-11-24 02:54:09'),('2023-04-07 16:59:25'), ('2023-11-26 00:00:00'),('2024-04-01 11:20:53'),('2024-04-19 00:00:00'), ('2024-09-16 05:45:31'),('2024-10-15 02:07:05'),('2024-11-05 00:00:00'), ('2024-12-27 02:53:35'),('2025-02-04 00:00:00'),('2025-05-05 12:19:13'), ('2025-08-20 00:00:00'),('2025-09-25 01:09:50'),('2027-03-02 10:18:54'), ('2028-08-20 00:00:00'),('2028-11-18 16:08:10'),('2029-01-20 11:11:25'), ('2029-11-06 00:00:00'),('2030-06-11 10:48:40'),('2030-08-24 01:16:16'), ('2031-03-08 20:50:33'),('2031-04-25 21:26:00'),('2032-05-31 14:26:32'), ('2032-07-28 04:02:35'),('2033-04-30 03:04:26'),('2033-06-16 15:07:21'), ('2033-08-11 10:08:08'),('2033-09-21 07:18:35'),('2034-01-25 13:32:44'), ('2034-01-30 15:30:45'),('2034-08-26 19:59:15'),('2034-12-01 23:39:50'), ('2034-12-25 00:00:00'),('2035-04-12 07:50:46'),('2035-04-25 15:36:36'), ('2035-05-25 20:29:49'),('2035-06-06 20:59:57'),('2035-07-15 20:11:20'), ('2035-08-02 09:53:16'),('2035-08-03 00:00:00'),('2035-12-08 00:00:00'), ('2036-03-13 10:35:23'),('2036-03-25 16:31:32'),('2036-09-06 12:50:17'), ('2036-10-07 02:50:31'),('2037-05-26 00:00:00'),('2037-11-21 05:17:58'), ('2038-02-11 07:16:04'),('2038-04-08 00:16:00'),('2038-05-26 01:10:18'), ('2038-11-17 09:13:06'),('2039-03-10 11:41:13'),('2039-11-08 10:08:53'); UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d); # Cleanup DROP TABLE t; SET GLOBAL innodb_stats_persistent= DEFAULT; {code} {noformat:title=11.1 3ef11161 non-debug} 2023-04-30 2:52:32 36 [ERROR] [FATAL] InnoDB: Clustered record field for column 6 not found table n_user_defined 1 index n_user_defined 6 InnoDB table `test`.`t` field name NULL MySQL table t field name DB_ROW_ID n_fields 6 query UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d) 230430 2:52:32 [ERROR] mysqld got signal 6 ; #2 <signal handler called> #3 __pthread_kill_implementation (threadid=<optimized out>, signo=signo@entry=6, no_tid=no_tid@entry=0) at ./nptl/pthread_kill.c:44 #4 0x00007f4a3f2a9d2f in __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78 #5 0x00007f4a3f25aef2 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26 #6 0x00007f4a3f245472 in __GI_abort () at ./stdlib/abort.c:79 #7 0x000055cf561ced91 in ib::fatal::~fatal (this=this@entry=0x7f4a305a6400, __in_chrg=<optimized out>) at /data/src/11.1/storage/innobase/ut/ut0ut.cc:527 #8 0x000055cf561aff10 in build_template_field (prebuilt=<optimized out>, clust_index=clust_index@entry=0x7f49ac033fd0, index=index@entry=0x7f49ac033fd0, table=<optimized out>, field=field@entry=0x7f49acb22ce0, i=i@entry=6, v_no=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7137 #9 0x000055cf567f974d in ha_innobase::build_template (this=this@entry=0x7f49acb224d0, whole_row=<optimized out>, whole_row@entry=false) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7521 #10 0x000055cf567fa280 in ha_innobase::change_active_index (this=0x7f49acb224d0, keynr=<optimized out>) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171 #11 0x000055cf56391168 in handler::ha_index_init (sorted=<optimized out>, idx=1, this=0x7f49acb224d0) at /data/src/11.1/sql/handler.h:3409 #12 join_read_always_key (tab=0x7f49acb0e0f0) at /data/src/11.1/sql/sql_select.cc:23811 #13 0x000055cf5637b1e1 in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0e0f0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036 #14 0x000055cf56369e41 in evaluate_join_record (join=join@entry=0x7f49ac012ec0, join_tab=join_tab@entry=0x7f49acb0dcf0, error=<optimized out>) at /data/src/11.1/sql/sql_select.cc:23272 #15 0x000055cf5637b1fd in sub_select (join=0x7f49ac012ec0, join_tab=0x7f49acb0dcf0, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039 #16 0x000055cf563a8d5d in do_select (procedure=<optimized out>, join=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:22571 #17 JOIN::exec_inner (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4899 #18 0x000055cf563a91ee in JOIN::exec (this=this@entry=0x7f49ac012ec0) at /data/src/11.1/sql/sql_select.cc:4676 #19 0x000055cf563a9316 in Sql_cmd_dml::execute_inner (this=this@entry=0x7f49ac0124e8, thd=thd@entry=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32615 #20 0x000055cf56406b01 in Sql_cmd_update::execute_inner (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_update.cc:3062 #21 0x000055cf563686cd in Sql_cmd_dml::execute (this=0x7f49ac0124e8, thd=0x7f49ac000c68) at /data/src/11.1/sql/sql_select.cc:32552 #22 0x000055cf563323d6 in mysql_execute_command (thd=thd@entry=0x7f49ac000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/src/11.1/sql/sql_parse.cc:4393 #23 0x000055cf56335ff5 in mysql_parse (thd=0x7f49ac000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/11.1/sql/sql_parse.cc:7760 #24 0x000055cf563382d5 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f49ac000c68, packet=packet@entry=0x7f49ac1031d9 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=packet_length@entry=88, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1989 #25 0x000055cf563395d7 in do_command (thd=0x7f49ac000c68, blocking=blocking@entry=true) at /data/src/11.1/sql/sql_parse.cc:1405 #26 0x000055cf564498e7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cf5a22cf88, put_in_cache=put_in_cache@entry=true) at /data/src/11.1/sql/sql_connect.cc:1416 #27 0x000055cf56449c7d in handle_one_connection (arg=arg@entry=0x55cf5a22cf88) at /data/src/11.1/sql/sql_connect.cc:1318 #28 0x000055cf56759ad7 in pfs_spawn_thread (arg=0x55cf5a1e0608) at /data/src/11.1/storage/perfschema/pfs.cc:2201 #29 0x00007f4a3f2a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #30 0x00007f4a3f3285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat} {noformat:title=11.1 3ef11161 debug} mariadbd: /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400: void ha_innobase::build_template(bool): Assertion `!is_v' failed. 230430 2:57:32 [ERROR] mysqld got signal 6 ; #9 0x00007fdbdc453df2 in __GI___assert_fail (assertion=0x55a20fb36440 "!is_v", file=0x55a20fb2a8c0 "/data/src/11.1/storage/innobase/handler/ha_innodb.cc", line=7400, function=0x55a20fb363e0 "void ha_innobase::build_template(bool)") at ./assert/assert.c:101 #10 0x000055a20e3611f9 in ha_innobase::build_template (this=0x61d0004844b8, whole_row=true) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:7400 #11 0x000055a20e36d352 in ha_innobase::change_active_index (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:9171 #12 0x000055a20e36a2dc in ha_innobase::index_init (this=0x61d0004844b8, keynr=1) at /data/src/11.1/storage/innobase/handler/ha_innodb.cc:8744 #13 0x000055a20cdac9f5 in handler::ha_index_init (this=0x61d0004844b8, idx=1, sorted=false) at /data/src/11.1/sql/handler.h:3409 #14 0x000055a20d25fd3a in join_read_always_key (tab=0x62900086d680) at /data/src/11.1/sql/sql_select.cc:23811 #15 0x000055a20d25a637 in sub_select (join=0x62900010b810, join_tab=0x62900086d680, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23036 #16 0x000055a20d25bf77 in evaluate_join_record (join=0x62900010b810, join_tab=0x62900086d280, error=0) at /data/src/11.1/sql/sql_select.cc:23272 #17 0x000055a20d25a7f3 in sub_select (join=0x62900010b810, join_tab=0x62900086d280, end_of_records=false) at /data/src/11.1/sql/sql_select.cc:23039 #18 0x000055a20d2585b9 in do_select (join=0x62900010b810, procedure=0x0) at /data/src/11.1/sql/sql_select.cc:22571 #19 0x000055a20d1da6df in JOIN::exec_inner (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4899 #20 0x000055a20d1d7a62 in JOIN::exec (this=0x62900010b810) at /data/src/11.1/sql/sql_select.cc:4676 #21 0x000055a20d29f962 in Sql_cmd_dml::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32615 #22 0x000055a20d44edf7 in Sql_cmd_update::execute_inner (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_update.cc:3062 #23 0x000055a20d29f44e in Sql_cmd_dml::execute (this=0x62900010ad88, thd=0x62b00017a218) at /data/src/11.1/sql/sql_select.cc:32552 #24 0x000055a20d0c7ead in mysql_execute_command (thd=0x62b00017a218, is_called_from_prepared_stmt=false) at /data/src/11.1/sql/sql_parse.cc:4393 #25 0x000055a20d0df33a in mysql_parse (thd=0x62b00017a218, rawbuf=0x629000109238 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", length=88, parser_state=0x7fdbc47daa20) at /data/src/11.1/sql/sql_parse.cc:7760 #26 0x000055a20d0b7ab1 in dispatch_command (command=COM_QUERY, thd=0x62b00017a218, packet=0x6290008c0219 "UPDATE t AS t1 JOIN t AS t2 SET t2.d = t1.d WHERE t2.d IS NOT NULL AND t2.t = TIME(t1.d)", packet_length=88, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1892 #27 0x000055a20d0b47ef in do_command (thd=0x62b00017a218, blocking=true) at /data/src/11.1/sql/sql_parse.cc:1405 #28 0x000055a20d56c6e2 in do_handle_one_connection (connect=0x60800005c8b8, put_in_cache=true) at /data/src/11.1/sql/sql_connect.cc:1416 #29 0x000055a20d56c0a3 in handle_one_connection (arg=0x608000003a38) at /data/src/11.1/sql/sql_connect.cc:1318 #30 0x000055a20e165870 in pfs_spawn_thread (arg=0x617000008218) at /data/src/11.1/storage/perfschema/pfs.cc:2201 #31 0x00007fdbdc4a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #32 0x00007fdbdc5285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat}

Elena Stepanova made changes - 2023-04-30 00:03

Labels

regression

Marko Mäkelä made changes - 2024-01-05 07:49

Assignee

Marko Mäkelä [ marko ]

Debarun Banerjee [ JIRAUSER54513 ]

Debarun Banerjee made changes - 2024-02-19 06:43

Status

Open [ 1 ]

Confirmed [ 10101 ]

Debarun Banerjee made changes - 2024-02-19 10:51

Assignee	Debarun Banerjee [ JIRAUSER54513 ]	Marko Mäkelä [ marko ]
Status	Confirmed [ 10101 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2024-02-19 13:40

Assignee

Marko Mäkelä [ marko ]

Nikita Malyavin [ nikitamalyavin ]

Nikita Malyavin made changes - 2024-02-26 20:32

Assignee	Nikita Malyavin [ nikitamalyavin ]	Debarun Banerjee [ JIRAUSER54513 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Christoph Ziebuhr made changes - 2024-02-28 10:17

Link

This issue relates to ~~MDEV-33558~~ [ ~~MDEV-33558~~ ]

Debarun Banerjee made changes - 2024-03-08 10:11

Assignee	Debarun Banerjee [ JIRAUSER54513 ]	Marko Mäkelä [ marko ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2024-03-15 10:16

Assignee	Marko Mäkelä [ marko ]	Debarun Banerjee [ JIRAUSER54513 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2024-03-15 10:17

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.2 [ 28603 ]
Fix Version/s		11.4 [ 29301 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]
Affects Version/s		11.2 [ 28603 ]
Affects Version/s		11.3 [ 28565 ]
Affects Version/s		11.4 [ 29301 ]

Debarun Banerjee made changes - 2024-03-16 04:53

Fix Version/s		10.4.34 [ 29625 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.0 [ 28320 ]
Fix Version/s	11.1 [ 28549 ]
Fix Version/s	11.2 [ 28603 ]
Fix Version/s	11.4 [ 29301 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

JiraAutomate made changes - 2024-03-16 04:53

Fix Version/s		10.5.25 [ 29626 ]
Fix Version/s		10.6.18 [ 29627 ]
Fix Version/s		10.11.8 [ 29630 ]
Fix Version/s		11.0.6 [ 29628 ]
Fix Version/s		11.1.5 [ 29629 ]
Fix Version/s		11.2.4 [ 29631 ]

Marko Mäkelä made changes - 2024-03-31 09:56

Link

This issue relates to ~~MDEV-33795~~ [ ~~MDEV-33795~~ ]

Alice Sherepa made changes - 2024-07-03 14:37

Link

This issue includes ~~MDEV-18911~~ [ ~~MDEV-18911~~ ]

Alice Sherepa made changes - 2025-03-07 17:19

Link

This issue is duplicated by ~~MDEV-27840~~ [ ~~MDEV-27840~~ ]

People

Assignee:: Debarun Banerjee

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2023-04-30 00:00

Updated:: 2025-03-07 17:19

Resolved:: 2024-03-16 04:53

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration