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

Server startup failure when setting max_session_mem_used too low

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.8.2
    • Fix Version/s: N/A
    • Component/s: Admin statements
    • Labels:
      None

      Description

      According to the documentation the minimum value for max_session_mem_used is 8192 bytes. With that setting the server fails on startup. I could start it with a value of 34000, but not with 33000 or below. I did not disect the threshold value any further than that.

      On 10.8.2 the server complained about the option setting before aborting:

      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] /usr/sbin/mariadbd (server 10.8.2-MariaDB-1:10.8.2+maria~focal) starting as process 4616 ...
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Number of transaction pools: 1
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Using Linux native AIO
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Completed initialization of buffer pool
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: 128 rollback segments are active.
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: log sequence number 46939; transaction id 14
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] Plugin 'FEEDBACK' is disabled.
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [ERROR] Could not open mysql.plugin table: "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement". Some plugins may be not load>
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [ERROR] Can't open and lock privilege tables: The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [Note] Server socket created on IP: '127.0.0.1'.
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [ERROR] Fatal error: Can't open and lock privilege tables: The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement
      Mar 02 00:11:41 ubuntu-focal mariadbd[4616]: 2022-03-02  0:11:41 0 [ERROR] Aborting
      

      But on 10.4.14 I just got a segfault instead. (did not check later 10.4.x releases yet)

      I'd suggest to raise the min. value for this setting to at least 64KB instead of 8KB

        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.