Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.15, 10.6.7, 10.7.3, 10.8.2
-
None
Description
According to the KB the P_S.THREADS.CONNECTION_TYPE column should show NULL for background threads, and the source code has these possible states:
static const LEX_CSTRING vio_type_names[] =
|
{
|
{ STRING_WITH_LEN("Error") }, // cannot happen
|
{ STRING_WITH_LEN("TCP/IP") },
|
{ STRING_WITH_LEN("Socket") },
|
{ STRING_WITH_LEN("Named Pipe") },
|
{ STRING_WITH_LEN("SSL/TLS") },
|
{ STRING_WITH_LEN("Shared Memory") }
|
};
|
Yet it actually indeed shows "Error" instead of "NULL":
MariaDB [performance_schema]> select name, connection_type from threads where type="BACKGROUND";
|
+-----------------------------------+-----------------+
|
| name | connection_type |
|
+-----------------------------------+-----------------+
|
| thread/sql/main | Error |
|
| thread/mysys/statement_timer | Error |
|
| thread/aria/checkpoint_background | Error |
|
| thread/innodb/page_cleaner_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/sql/signal_handler | Error |
|
| thread/sql/manager | Error |
|
+-----------------------------------+-----------------+
|