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

MariaDB can't find tables mysql.user and mysql.servers

    XMLWordPrintable

Details

    Description

      I've been running MariaDB for some time now without problem. I did a minor version upgrade from 10.2.14 to 10.2.15 and now it refuses to start. If I'm reading the error logs correctly, it can't find the tables mysql.user and mysql.servers. I have confirmed that the data files exist, are not corrupted, and they appear to have the proper permissions.

      This is the dump from the error log. The references to the privilege tables are near the end.

      2018-06-19 17:12:41 140244707127552 [Note] RocksDB: 2 column families found
      2018-06-19 17:12:41 140244707127552 [Note] RocksDB: Column Families at start:
      2018-06-19 17:12:41 140244707127552 [Note]   cf=default
      2018-06-19 17:12:41 140244707127552 [Note]     write_buffer_size=67108864
      2018-06-19 17:12:41 140244707127552 [Note]     target_file_size_base=67108864
      2018-06-19 17:12:41 140244707127552 [Note]   cf=__system__
      2018-06-19 17:12:41 140244707127552 [Note]     write_buffer_size=67108864
      2018-06-19 17:12:41 140244707127552 [Note]     target_file_size_base=67108864
      2018-06-19 17:12:41 140244707127552 [Note] RocksDB: Table_store: loaded DDL data for 0 tables
      2018-06-19 17:12:41 140244707127552 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
      2018-06-19 17:12:41 140244707127552 [Note] MyRocks storage engine plugin has been successfully initialized.
      Tue Jun 19 17:12:41 2018 PerconaFT recovery starting in env /var/lib/mysql/
      Tue Jun 19 17:12:41 2018 PerconaFT recovery scanning backward from 1319
      Tue Jun 19 17:12:41 2018 PerconaFT recovery bw_end_checkpoint at 1319 timestamp 1529453469731997 xid 1315 (bw_newer)
      Tue Jun 19 17:12:41 2018 PerconaFT recovery bw_begin_checkpoint at 1315 timestamp 1529453469731991 (bw_between)
      Tue Jun 19 17:12:41 2018 PerconaFT recovery turning around at begin checkpoint 1315 time 6
      Tue Jun 19 17:12:41 2018 PerconaFT recovery starts scanning forward to 1319 from 1315 left 4 (fw_between)
      Tue Jun 19 17:12:41 2018 PerconaFT recovery closing 2 dictionaries
      Tue Jun 19 17:12:41 2018 PerconaFT recovery making a checkpoint
      Tue Jun 19 17:12:41 2018 PerconaFT recovery done
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Uses event mutexes
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Using Linux native AIO
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Number of pools: 1
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Using SSE2 crc32 instructions
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Completed initialization of buffer pool
      2018-06-19 17:12:41 140243754858240 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Highest supported file format is Barracuda.
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Creating shared tablespace for temporary tables
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: Waiting for purge to start
      2018-06-19 17:12:41 140244707127552 [Note] InnoDB: 5.7.22 started; log sequence number 26491335405
      2018-06-19 17:12:41 140243746465536 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2018-06-19 17:12:41 140244707127552 [Note] Plugin 'FEEDBACK' is disabled.
      2018-06-19 17:12:41 140244707127552 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
      2018-06-19 17:12:41 140244707127552 [Note] Recovering after a crash using tc.log
      2018-06-19 17:12:41 140244707127552 [Note] Starting crash recovery...
      2018-06-19 17:12:41 140244707127552 [Note] Crash recovery finished.
      2018-06-19 17:12:41 140244707127552 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      2018-06-19 17:12:41 140244707127552 [Note] Server socket created on IP: '::'.
      2018-06-19 17:12:41 140244707127552 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
      

      This the systemd output:

      Starting MariaDB 10.2 database server...
      mysql-prepare-db-dir[10435]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
      mysql-prepare-db-dir[10435]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.
      [Note] /usr/libexec/mysqld (mysqld 10.2.15-MariaDB) starting as process 10472 ...
      systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
      systemd[1]: mariadb.service: Failed with result 'exit-code'.
      systemd[1]: Failed to start MariaDB 10.2 database server.
      

      I've run myisamchk on all the tables in the data directory, and I've uninstalled and reinstalled the mariadb-server package. As far as I can tell it hasn't made a difference.

      Attachments

        1. plugin.frm
          1 kB
        2. plugin.MYI
          1.0 kB
        3. servers.frm
          3 kB
        4. servers.MYI
          1.0 kB

        Activity

          People

            Unassigned Unassigned
            xaglen Glen Davis
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.