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

MariaDB Crashes after transactions locked due to semasphore and subsequent attempted blocking transaction rollback (kill)

    XMLWordPrintable

Details

    Description

      I have quite a few transations, inserts, update's etc. on one of our tables from multiple clusters. I was monitoring the server and noticed that it became unresponsive to transactions, so I checked the processlist and saw that transactions were backing up.

      I captured an 'show engine innodb status' and then attempted to kill (rollback) the blocking 'update' transaction. Within a minute the server crashed and rebooted.

      Server is currently participating in async replication with three additional servers. Been quite pleased with the performance.

      I will attach the mariadb.log and the show_engine_innodb_status output as separate files.

      I'm working at fixing those unsafe binary log transactions. Not sure if that has anything to do with the crash.

      Attachments

        Activity

          People

            marko Marko Mäkelä
            TheWitness Larry Adams
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.