Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28255

"Error" instead of NULL in P_S.THREADS_CONNECTION_TYPE for background threads

    XMLWordPrintable

    Details

      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           |
      +-----------------------------------+-----------------+
      

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            hholzgra Hartmut Holzgraefe
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

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