[MDEV-11703] InnoDB background threads show up in the processlist - Jira

XML

Word

Printable

10.2 f2fe65106f, debug build, default configuration
MariaDB [test]> show processlist;
+----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
\| Id \| User \| Host \| db \| Command \| Time \| State \| Info \| Progress \|
+----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
\| 1 \| system user \| \| NULL \| Daemon \| NULL \| InnoDB background thread \| NULL \| 0.000 \|
\| 2 \| system user \| \| NULL \| Daemon \| NULL \| InnoDB background thread \| NULL \| 0.000 \|
\| 4 \| system user \| \| NULL \| Daemon \| NULL \| InnoDB background thread \| NULL \| 0.000 \|
\| 3 \| system user \| \| NULL \| Daemon \| NULL \| InnoDB background thread \| NULL \| 0.000 \|
\| 5 \| system user \| \| NULL \| Daemon \| NULL \| InnoDB background thread \| NULL \| 0.000 \|
\| 10 \| root \| localhost:39009 \| test \| Query \| 0 \| init \| show processlist \| 0.000 \|
+----+-------------+-----------------+------+---------+------+--------------------------+------------------+----------+
6 rows in set (0.00 sec)

I don't think they should be there

duplicates

MDEV-20558 innodb processes appears in processlist, ver10.3.13

is caused by

MDEV-5800 indexes on virtual (not materialized) columns

relates to

MDEV-12531 TIme column in SHOW PROCESSLIST shows NULL for InnoDB service threads

MDEV-16264 Implement a common work queue for InnoDB background tasks

MDEV-18698 Show InnoDB's internal background threads in SHOW ENGINE INNODB STATUS

MDEV-17238 Document special thread IDs used in SHOW ENGINE INNODB STATUS output

(1 relates to)

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