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

The cluster encounters serious errors while performing DDL operations and data synchronization

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.19
    • 10.6
    • wsrep
    • Ubuntu 22.04

    Description

      Error code 1067: indicates an attempt to set an invalid default value for column6. This could be due to a data type mismatch (e.g., assigning a string default value to an integer column) or non-compliance with a column constraint.
      WSREP ignores error: the WSREP layer of the Galera cluster ignored this error and did not prevent the propagation of the DDL operation. This could lead to inconsistent table structures across nodes.
      log:

      2024-10-26 21:12:56 2 [ERROR] mariadbd: Can't find record in 'test7'
      2024-10-26 21:12:56 2 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table mytest1.test7; Can't find record in 'test7', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log FIRST, end_log_pos 919, Internal MariaDB error code: 1032
      2024-10-26 21:12:56 2 [Warning] WSREP: Event 3 Update_rows_v1 apply failed: 137, seqno 157646
      2024-10-26 21:12:56 0 [Note] WSREP: Member 0(node4) initiates vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,d1c41988d9b35d55:  Can't find record in 'test7', Error_code: 1032;
      2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
         d1c41988d9b35d55:   1/4
      Waiting for more votes.
      2024-10-26 21:12:56 0 [Note] WSREP: Member 2(node2) initiates vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,d1c41988d9b35d55:  Can't find record in 'test7', Error_code: 1032;
      2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
         d1c41988d9b35d55:   2/4
      Waiting for more votes.
      2024-10-26 21:12:56 0 [Note] WSREP: Member 3(node1) responds to vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,0000000000000000: Success
      2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
         0000000000000000:   1/4
         d1c41988d9b35d55:   2/4
      Waiting for more votes.
      2024-10-26 21:12:56 0 [Note] WSREP: Member 1(node3) initiates vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,d1c41988d9b35d55:  Can't find record in 'test7', Error_code: 1032;
      2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
         0000000000000000:   1/4
         d1c41988d9b35d55:   3/4
      Winner: d1c41988d9b35d55
      

      Attachments

        1. maradb_0.7z
          913 kB
        2. maradb_1.7z
          613 kB
        3. maradb_2.7z
          709 kB
        4. maradb_3.7z
          651 kB
        5. maradb_4.7z
          716 kB

        Activity

          CunDi Fang Hi, could you please provide full error log and show create table for test7, thank you.

          janlindstrom Jan Lindström added a comment - CunDi Fang Hi, could you please provide full error log and show create table for test7, thank you.
          CunDi Fang CunDi Fang added a comment -

          maradb_0.7z maradb_1.7z maradb_2.7z maradb_3.7z maradb_4.7z
          Okay, sorry it's a little late, there's been some delays looking for these files.I found the error while running on a 5 node mariadb cluster, this is the log file and all the files inside the data folder at that time.

          CunDi Fang CunDi Fang added a comment - maradb_0.7z maradb_1.7z maradb_2.7z maradb_3.7z maradb_4.7z Okay, sorry it's a little late, there's been some delays looking for these files.I found the error while running on a 5 node mariadb cluster, this is the log file and all the files inside the data folder at that time.

          People

            janlindstrom Jan Lindström
            CunDi Fang CunDi Fang
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.