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

wsrep_debug only logs DDL information on originating node

    XMLWordPrintable

Details

    Description

      When wsrep_debug is enabled, Galera Cluster logs more verbose information to the error log.

      For example, when DDL is executed on a particular node, the node logs some information like this:

      160222 15:30:44 [Note] WSREP: TO BEGIN: -1, 0 : ALTER ONLINE TABLE test_table DROP KEY str
      160222 15:30:44 [Note] WSREP: TO BEGIN: 1100033, 2
      160222 15:30:44 [Note] WSREP: TO END: 1100033, 2 : ALTER ONLINE TABLE test_table DROP KEY str
      160222 15:30:44 [Note] WSREP: Set WSREPXid for InnoDB:  fbeb045d-b94f-11e5-8504-4ae80b892690:1100033
      160222 15:30:44 [Note] WSREP: TO END: 1100033, update seqno
      160222 15:30:44 [Note] WSREP: TO END: 1100033

      However, when wsrep_OSU_method is set to TOI and the DDL command is replicated to the other nodes in the cluster, those other nodes do not log anything about the DDL to their error logs, even if wsrep_debug is enabled on those other nodes.

      It would be useful to see some kind of information in the error logs about replicated DDL when wsrep_debug is ON. The main use case is when trying to track exactly what DDL is being replicated to other nodes.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.