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

MariaDB Restore Causes System Schema Corruption (mariadb.sys) and Database Inconsistency in

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Description
      During restore validation in SIT2, the restored MariaDB database entered an inconsistent state. Investigation identified issues involving the MariaDB system schema, specifically the mariadb.sys account and related system metadata.
      Following the restore operation:
      Database health checks reported inconsistencies.
      mariadb.sys was missing/corrupted.
      Authentication and user metadata operations were impacted.
      Recovery activities were required with MariaDB Support assistance.
      The issue required recreation of the mariadb.sys user and additional system object validation before the database became operational again.

      Attachments

        Issue Links

          Activity

            People

              seppo Seppo Jaakola
              debashisapatra Debashisa Patra
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.