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

Binlogging of MEMORY table recreation from server restart is silently deferred

    XMLWordPrintable

Details

    • Notable changes
    • Hide
      When accessing a MEMORY table whose data is lost to restarting a *read-only* server *with replication connection(s) configured* for the first time, the automatically-generated TRUNCATE query in the Binary Log is now annotated with a comment and accompanied by a warning in the Error Log.
      Show
      When accessing a MEMORY table whose data is lost to restarting a *read-only* server *with replication connection(s) configured* for the first time, the automatically-generated TRUNCATE query in the Binary Log is now annotated with a comment and accompanied by a warning in the Error Log.
    • Q2/2026 Server Maintenance

    Description

      The data in MEMORY tables is temporary and is lost when the server restarts.
      To represent this recreation with no data, the server logs a TRUNCATE statement to the binary log.
      However, there is no warning about MEMORY tables losing data after a reboot, let alone this TRUNCATE log entry.

      Worse, this TRUNCATE entry is not immediately written during startup, but rather when the MEMORY table is accessed.
      This means that any desynchronization error (due to data loss) does not occur during the restart phase in maintenance, but instead unexpectedly during operation.
      Namely, MDEV-29796 reported that --gtid-strict-mode checks would fail (if the server does not have a different Domain ID from its replication upstreams).

      Attachments

        Issue Links

          Activity

            People

              ParadoxV5 Jimmy Hú
              ParadoxV5 Jimmy Hú
              Jimmy Hú Jimmy Hú
              Brandon Nesterenko Brandon Nesterenko
              Jimmy Hú Jimmy Hú
              Votes:
              0 Vote for this issue
              Watchers:
              9 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.