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

performance_schema_session_connect_attrs_size set to 512 by default

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5.9
    • N/A
    • Performance Schema
    • 5 node mariadb cluster running 10.5.9, rhel 8, 24G memory, 4 cpus vmware vhosts

    Description

      As of the upgrade to 10.5.9 (autoupdate) I was seeing a large number of warnings in my mariadb logs saying attribute lengths of 569/570 were truncated. When I looked at global variables performance_schema_session_connect_attrs_size was at 512. This is a variable I did not define specifically and the default is supposed to be -1. When I set this setting specifically and restarted mariadb on the nodes the errors went away.

      2021-03-22 10:31:54 142120 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:31:58 335410 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:31:58 335420 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:31:58 240646 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:31:59 335410 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:03 408238 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:06 335407 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:07 335412 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:07 142120 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:08 335418 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:10 335407 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:10 429847 [Warning] Connection attributes of length 569 were truncated
      2021-03-22 10:32:11 335412 [Warning] Connection attributes of length 569 were truncated

      Attachments

        Activity

          People

            serg Sergei Golubchik
            thaylin Christopher E Bowen
            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.