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

485 GB of galera.page.xxxxx files never deleted!?

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6.7
    • Fix Version/s: 10.6
    • Component/s: Galera
    • Labels:
      None
    • Environment:
      Ubuntu 22.04.1

      Description

      This is a 2-node cluster (third node is down and is being entirely replaced). Both nodes are used for writing but one node has scripts running every 2, 3, 5 and 10 minutes updating data extensively.

      On that node (running scripts), I found 485GB of galera.page.xxx files (not gcache.page.xxx) and the server keeps creating them every minute or so!

      First, can I safely delete oldest one before disk space is completely consumed?

      Any way to flush those without restarting server?

      At that pace, the disk would be full in less than 2 days, so I tried to remove some oldest files and it seems ok however disk space is still consummed by those deleted files!?

      Any way to resolve that without restarting server or at least that it stops happening after a restart (that I can do at night) ?

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ccounotte COUNOTTE CEDRIC
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.