Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2345

Crash triggered with mysqldump single-transaction

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: 5.7.24-31.33
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:

      OS: Ubuntu 16.04.5 LTS
      Package: percona-xtradb-cluster-server-5.7 - 5.7.24-31.33-1.xenial

      Description

      We are able to trigger a crash when we use --single-transaction with mysqldump. We tracked the issue down to the setting 'log_bin'. When removing 'log_bin' from the my.cnf we crash mysql by using this command:

      mysqldump -u user --single-transaction mysql > mysql.sql
      mysqldump: Couldn't execute 'START TRANSACTION /*!40100 WITH CONSISTENT SNAPSHOT */': Lost connection to MySQL server during query (2013)

      When 'log_bin' is enabled in the my.cnf, it does not trigger the crash. Enclosed document contains the stack trace from the mysqld log.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  kenn.takara Kenn Takara
                  Reporter:
                  DaveShock Dave
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 6 hours
                    1d 6h