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

Index corruption in passive db

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.6.20
    • N/A
    • Replication
    • None
    • RHEL 8

    Description

      Table in passive db is getting corrupted which leads to interruption of mysql replication process.

      This happens every time after few hours of replication.

      The error log is attached in the ticket.

      Process list has the following contents :

      Id User Host db Command Time State Info Progress
      --------------------------------------------------------------------------------------------------------------

      42 system user NULL Slave_IO 66259 Waiting for master to send event NULL 0.000
      5530 root 127.0.0.1:46804 naf Query 0 starting show full processlist 0.000

      Can you provide more insights on this ticket?

      Attachments

        Activity

          serg Sergei Golubchik added a comment -

          there are lots of errors about missing files. may be you bootstrap a new slave incorrectly or there is some process that cleans up space and incorrectly deletes table files or may be the filesystem is corrupted?

          serg Sergei Golubchik added a comment - there are lots of errors about missing files. may be you bootstrap a new slave incorrectly or there is some process that cleans up space and incorrectly deletes table files or may be the filesystem is corrupted?

          People

            Unassigned Unassigned
            RagulR Ragul
            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.