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

MariaDB server start emits error but continues anyway: Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

    XMLWordPrintable

Details

    • Q1/2026 Server Development

    Description

      While reading server logs in bug report I noticed that many of them have the message:

      [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      

      One would expect an error to prevent the server from starting. However, it seems the server disregards this:

      2026-02-09 11:28:45 0 [Note] Starting MariaDB 11.8.5-MariaDB-4 from Debian source revision a74edc42d080a73e20d5d94e1dd5beea400b507c server_uid gpwc7p3Q93PgRmZFcrpViA9eb3w= as process 13634
      2026-02-09 11:28:45 0 [Note] mysqld: File './ddl_recovery.log' not found (Errcode: 2 "No such file or directory")
      2026-02-09 11:28:45 0 [Note] Initializing built-in plugins
      2026-02-09 11:28:45 0 [Note] Initializing plugins specified on the command line
      2026-02-09 11:28:45 0 [Warning] --innodb-file-per-table is deprecated and will be removed in a future release
      2026-02-09 11:28:45 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
      2026-02-09 11:28:45 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
      2026-02-09 11:28:45 0 [Note] InnoDB: Number of transaction pools: 1
      2026-02-09 11:28:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2026-02-09 11:28:45 0 [Note] InnoDB: Using io_uring
      2026-02-09 11:28:45 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m
      2026-02-09 11:28:45 0 [Note] InnoDB: Initialized memory pressure event listener
      2026-02-09 11:28:45 0 [Note] InnoDB: Completed initialization of buffer pool
      2026-02-09 11:28:45 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      2026-02-09 11:28:45 0 [Note] InnoDB: End of log at LSN=473015284
      2026-02-09 11:28:45 0 [Note] InnoDB: Opened 3 undo tablespaces
      2026-02-09 11:28:45 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2026-02-09 11:28:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2026-02-09 11:28:45 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2026-02-09 11:28:45 0 [Note] InnoDB: log sequence number 473015284; transaction id 494119
      2026-02-09 11:28:45 0 [Note] Plugin 'FEEDBACK' is disabled.
      2026-02-09 11:28:45 0 [Note] Plugin 'wsrep-provider' is disabled.
      2026-02-09 11:28:45 0 [Note] InnoDB: Loading buffer pool(s) from /home/ben/.local/share/akonadi/db_data/ib_buffer_pool
      2026-02-09 11:28:45 0 [Note] mysqld: File './tc.log' not found (Errcode: 2 "No such file or directory")
      2026-02-09 11:28:45 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      2026-02-09 11:28:45 0 [Note] InnoDB: Buffer pool(s) load completed at 260209 11:28:45
      2026-02-09 11:28:45 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
      2026-02-09 11:28:45 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
      2026-02-09 11:28:45 0 [Note] Reading of all Master_info entries succeeded
      2026-02-09 11:28:45 0 [Note] Added new Master_info '' to hash table
      2026-02-09 11:28:45 0 [Note] /usr/sbin/mysqld: ready for connections.
      Version: '11.8.5-MariaDB-4 from Debian'  socket: '/run/user/1000/akonadi/mysql.socket'  port: 0  -- Please help get to 10k stars at https://github.com/MariaDB/Server
      

      This is very confusing. Why isn't the server stopping on an error? When the server later has real issues and errors, how can users distinguish between old errors and new errors?

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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