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

RSU wait for active commit connection timeout should be configurable

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.6.40, 5.7.22
    • Component/s: None
    • Security Level: Public Bug
    • Labels:
      None

      Description

      When a DDL is issued in RSU it can timeout due to ongoing commits

      In the log we see

       

      Nov 23 13:58:24 ubupxc00003 mysqld: 2017-11-23 13:58:24 14240 [Warning] WSREP: RSU failed due to pending transactions, schema: (null), query CREATE DATABASE /*!32312 IF NOT EXISTS*/ `okn_man_main` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */

       

       

      Which comes from sql/wsrep_mysqld.cc (line 1925 for 5.7.18)

       

      if (wsrep_wait_committing_connections_close(5000))
       {
       /* no can do, bail out from DDL */
       WSREP_WARN("RSU failed due to pending transactions, schema: %s, query %s",
       (thd->db().str ? thd->db().str : "(null)"),
       WSREP_QUERY(thd));

       

       

      Is there any reason this can not be retried before giving up? 

      Introducing a variable wsrep_rsu_ddl_retry and wsrep_rsu_ddl_retry_sleep would allow users to tune for how long they want to wait before giving up.  Alternatively make the 5000ms configurable so the timeout would be longer and users can adjust according to their needs and workloads.

       

        Attachments

          Activity

            People

            • Assignee:
              krunal.bauskar Krunal Bauskar
              Reporter:
              marcos.albe Marcos Albe
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

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