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

galera_new_cluster crashes mysqld when existing server contains databases

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.12
    • 10.2.13
    • Debian 9 fresh install
      mariadb from debian repos
      galera from debian repos
    • 10.2.13

    Description

      Try to setup galera cluster from standalone mariadb server that has a few databases.

      From existing mariadb server use /var/lib/mysql as is
      on stock /etc/mysql/my.cnf
      add

      [galera]

      1. Mandatory settings
        wsrep_on=ON
        wsrep_provider=/usr/lib/galera/libgalera_smm.so
        wsrep_cluster_name="tam_cluster"
        wsrep_cluster_address="gcomm://ip1, ip2, ip5"
        wsrep_node_address="ip5"
        wsrep_node_name="node_5"
        wsrep_sst_method=rsync
        binlog_format=row
        default_storage_engine=InnoDB
        innodb_autoinc_lock_mode=2

      run: galera_new_cluster

      result: mysqld crashes

      Attachments

        1. jgnoss_first_pages_001.bin
          128 kB
        2. mdb_dbg.tgz
          302 kB
        3. my.cnf
          6 kB
        4. mysqld_debug.txt
          17 kB
        5. mysqld.debug_outputs.txt
          14 kB
        6. mysqld.trace
          9.42 MB
        7. mysqld.trace
          1.76 MB
        8. mysqld.trace
          1.82 MB
        9. mysqld.trace
          88 kB

        Activity

          jgnoss Juergen Gnoss created issue -
          marko Marko Mäkelä made changes -
          Field Original Value New Value
          Component/s wsrep [ 11500 ]
          marko Marko Mäkelä made changes -
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          marko Marko Mäkelä made changes -
          Assignee Jan Lindström [ jplindst ]
          jgnoss Juergen Gnoss made changes -
          Attachment mysqld.trace [ 44869 ]
          jgnoss Juergen Gnoss made changes -
          Attachment mysqld.trace [ 44870 ]
          jgnoss Juergen Gnoss made changes -
          Attachment mysqld.trace [ 44871 ]
          jgnoss Juergen Gnoss made changes -
          Attachment my.cnf [ 44872 ]
          jgnoss Juergen Gnoss made changes -
          Attachment jgnoss_first_pages_001.bin [ 44873 ]
          jgnoss Juergen Gnoss made changes -
          Attachment mysqld.debug_outputs.txt [ 44875 ]
          jgnoss Juergen Gnoss made changes -
          Attachment mysqld.trace [ 45100 ]
          jgnoss Juergen Gnoss made changes -
          Attachment mdb_dbg.tgz [ 45105 ]
          serg Sergei Golubchik made changes -
          Priority Blocker [ 1 ] Critical [ 2 ]
          jplindst Jan Lindström (Inactive) made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          serg Sergei Golubchik made changes -
          Sprint 10.2.13 [ 228 ]
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Jan Lindström [ jplindst ] Seppo Jaakola [ seppo ]
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Seppo Jaakola [ seppo ] Jan Lindström [ jplindst ]
          jplindst Jan Lindström (Inactive) made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2018-02-08 09:15:16.0 2018-02-08 09:15:16.574
          jplindst Jan Lindström (Inactive) made changes -
          Component/s Storage Engine - InnoDB [ 10129 ]
          Component/s Admin statements [ 11400 ]
          Fix Version/s 10.2.13 [ 22910 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 84742 ] MariaDB v4 [ 153513 ]

          People

            jplindst Jan Lindström (Inactive)
            jgnoss Juergen Gnoss
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.