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

Slave thread stops unexpectedly without any explanations!?

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.8
    • 10.6
    • Galera, Replication
    • None

    Description

      For some reasons the slave SQL thread is existing very frequently and there is no indication why.

      I've set errors to be excluded:

      slave-skip-errors              = 1062,1032,1047
      

      Here is the last log within a minute of the exit:

      2022-07-19 12:30:10 21 [ERROR] mariadbd: Can't find record in 'wp_options'
      2022-07-19 12:30:10 21 [Warning] WSREP: Ignoring error 'Can't find record in 'wp_options'' on Delete_rows_v1 event. Error_code: 1032
      2022-07-19 12:30:10 21 [Warning] Slave SQL: Could not execute Delete_rows_v1 event on table 1check_front_www_v2.wp_options; Can't find record in 'wp_options', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.015840, end_log_pos 319557257, Gtid 100-1-167943177, Internal MariaDB error code: 1032
      2022-07-19 12:30:10 21 [ERROR] mariadbd: Can't find record in 'wp_options'
      2022-07-19 12:30:10 21 [Warning] WSREP: Ignoring error 'Can't find record in 'wp_options'' on Delete_rows_v1 event. Error_code: 1032
      2022-07-19 12:30:10 21 [Warning] Slave SQL: Could not execute Delete_rows_v1 event on table 1check_front_www_v2.wp_options; Can't find record in 'wp_options', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.015840, end_log_pos 319557617, Gtid 100-1-167943178, Internal MariaDB error code: 1032
      2022-07-19 12:30:10 21 [Warning] Slave SQL: Could not execute Write_rows_v1 event on table 1check_front_www_v2.wp_options; Duplicate entry '_transient_timeout_global_styles_bridge' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.015840, end_log_pos 319558729, Gtid 100-1-167943180, Internal MariaDB error code: 1062
      2022-07-19 12:30:10 21 [Warning] Slave SQL: Could not execute Write_rows_v1 event on table 1check_front_www_v2.wp_options; Duplicate entry '_transient_global_styles_bridge' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.015840, end_log_pos 319575350, Gtid 100-1-167943181, Internal MariaDB error code: 1062
      2022-07-19 12:30:39 21 [Warning] Slave SQL: Could not execute Write_rows_v1 event on table 1check_front_www_v2.wp_options; Duplicate entry '_transient_doing_cron' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.015840, end_log_pos 440189102, Gtid 100-1-167944746, Internal MariaDB error code: 1062
      2022-07-19 12:30:39 21 [ERROR] mariadbd: Can't find record in 'wp_options'
      2022-07-19 12:30:39 21 [Warning] WSREP: Ignoring error 'Can't find record in 'wp_options'' on Delete_rows_v1 event. Error_code: 1032
      2022-07-19 12:30:39 21 [Warning] Slave SQL: Could not execute Delete_rows_v1 event on table 1check_front_www_v2.wp_options; Can't find record in 'wp_options', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.015840, end_log_pos 440222785, Gtid 100-1-167944773, Internal MariaDB error code: 1032
      2022-07-19 12:31:11 21 [ERROR] mariadbd: Can't find record in 'wp_options'
      2022-07-19 12:31:11 21 [Warning] WSREP: Ignoring error 'Can't find record in 'wp_options'' on Delete_rows_v1 event. Error_code: 1032
      2022-07-19 12:31:11 21 [Warning] Slave SQL: Could not execute Delete_rows_v1 event on table 1check_front_www_v2.wp_options; Can't find record in 'wp_options', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.015840, end_log_pos 539979573, Gtid 100-1-167945639, Internal MariaDB error code: 1032
      2022-07-19 12:31:11 21 [ERROR] mariadbd: Can't find record in 'wp_options'
      2022-07-19 12:31:11 21 [Warning] WSREP: Ignoring error 'Can't find record in 'wp_options'' on Delete_rows_v1 event. Error_code: 1032
      2022-07-19 12:31:11 21 [Warning] Slave SQL: Could not execute Delete_rows_v1 event on table 1check_front_www_v2.wp_options; Can't find record in 'wp_options', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.015840, end_log_pos 539980855, Gtid 100-1-167945642, Internal MariaDB error code: 1032
      2022-07-19 12:31:11 21 [Warning] Slave SQL: Could not execute Write_rows_v1 event on table 1check_front_www_v2.wp_options; Duplicate entry '_transient_timeout_global_styles_bridge' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.015840, end_log_pos 539981402, Gtid 100-1-167945643, Internal MariaDB error code: 1062
      2022-07-19 12:31:11 21 [Warning] Slave SQL: Could not execute Write_rows_v1 event on table 1check_front_www_v2.wp_options; Duplicate entry '_transient_global_styles_bridge' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.015840, end_log_pos 539998023, Gtid 100-1-167945644, Internal MariaDB error code: 1062
      2022-07-19 12:31:15 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015840' at position 550737181; GTID position '100-1-167945768,300-3-522464027', master: ovh3.vlan:3306
      

      Here is the logs that shows how frequent this is happening:

      ~$ more /var/log/mysql/error.log | grep 'replication stopped'
      2022-07-06 17:49:29 22 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013854' at position 347058774; GTID position '100-1-134218455,300-3-522464027'
      2022-07-06 18:04:08 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013855' at position 551913802; GTID position '100-1-134237225,300-3-522464027'
      2022-07-06 18:15:05 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013856' at position 948013323; GTID position '100-1-134261406,300-3-522464027'
      2022-07-06 18:28:10 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013858' at position 599797962; GTID position '100-1-134289195,300-3-522464027'
      2022-07-06 20:38:20 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013867' at position 985099565; GTID position '100-1-134506530,300-3-522464027'
      2022-07-06 21:44:37 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013870' at position 365430870; GTID position '100-1-134605457,300-3-522464027'
      2022-07-06 23:45:16 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013873' at position 716870935; GTID position '100-1-134767146,300-3-522464027'
      2022-07-07  4:06:57 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013892' at position 791121282; GTID position '100-1-135164749,300-3-522464027'
      2022-07-07  4:07:27 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013892' at position 822745939; GTID position '100-1-135164925,300-3-522464027'
      2022-07-07  4:07:57 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013892' at position 824855727; GTID position '100-1-135165094,300-3-522464027'
      2022-07-07  5:20:19 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013894' at position 800282543; GTID position '100-1-135256821,300-3-522464027'
      2022-07-07  5:20:50 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013894' at position 813287407; GTID position '100-1-135256916,300-3-522464027'
      2022-07-07  5:23:50 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013894' at position 898051646; GTID position '100-1-135259070,300-3-522464027'
      2022-07-07  5:28:22 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013894' at position 1031459437; GTID position '100-1-135265887,300-3-522464027'
      2022-07-07  8:11:12 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013900' at position 878266524; GTID position '100-1-135498293,300-3-522464027'
      2022-07-07  8:47:23 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013902' at position 752607554; GTID position '100-1-135561142,300-3-522464027'
      2022-07-07  9:01:58 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013903' at position 893926874; GTID position '100-1-135589934,300-3-522464027'
      2022-07-07  9:35:27 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013907' at position 1020049656; GTID position '100-1-135667938,300-3-522464027'
      2022-07-07 10:00:08 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013911' at position 857263726; GTID position '100-1-135742580,300-3-522464027'
      2022-07-07 10:33:49 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013917' at position 267658649; GTID position '100-1-135832361,300-3-522464027'
      2022-07-07 10:47:54 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013918' at position 487479722; GTID position '100-1-135854613,300-3-522464027'
      2022-07-07 10:48:25 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013918' at position 787402344; GTID position '100-1-135858653,300-3-522464027'
      2022-07-07 15:36:33 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013948' at position 317738293; GTID position '100-1-136332521,300-3-522464027'
      2022-07-07 17:37:43 59 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013975' at position 782900365; GTID position '100-1-136777434,300-3-522464027'
      2022-07-07 19:29:19 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013983' at position 902605435; GTID position '100-1-136962996,300-3-522464027'
      2022-07-07 22:47:39 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013991' at position 833296796; GTID position '100-1-137255558,300-3-522464027'
      2022-07-07 22:50:40 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013991' at position 927743308; GTID position '100-1-137260576,300-3-522464027'
      2022-07-07 22:54:12 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013991' at position 1037138587; GTID position '100-1-137264386,300-3-522464027'
      2022-07-07 23:02:45 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013992' at position 232005892; GTID position '100-1-137274694,300-3-522464027'
      2022-07-07 23:06:17 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013992' at position 328495680; GTID position '100-1-137280679,300-3-522464027'
      2022-07-08  9:12:21 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013996' at position 5277789; GTID position '100-1-137414820,300-3-522464027'
      2022-07-08  9:14:23 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013996' at position 5277789; GTID position '100-1-137414820,300-3-522464027'
      2022-07-08  9:20:48 70 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013965' at position 211578591; GTID position '100-1-136668817,300-3-522464027'
      2022-07-08  9:27:50 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013979' at position 505754665; GTID position '100-1-136976554,300-3-522464027'
      2022-07-08  9:34:31 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013990' at position 60565725; GTID position '100-1-137402868,300-3-522464027'
      2022-07-08  9:37:25 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013990' at position 60565725; GTID position '100-1-137402868,300-3-522464027'
      2022-07-08  9:47:28 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013993' at position 452859518; GTID position '100-1-137509013,300-3-522464027'
      2022-07-08  9:47:58 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013993' at position 582197014; GTID position '100-1-137511511,300-3-522464027'
      2022-07-08  9:54:32 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.013999' at position 880992554; GTID position '100-1-137683031,300-3-522464027'
      2022-07-08 10:09:36 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014004' at position 387906761; GTID position '100-1-137765494,300-3-522464027'
      2022-07-08 12:20:47 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014030' at position 281115737; GTID position '100-1-138140602,300-3-522464027'
      2022-07-08 12:23:48 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014030' at position 858583553; GTID position '100-1-138147847,300-3-522464027'
      2022-07-08 15:12:10 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014061' at position 531894687; GTID position '100-1-138624468,300-3-522464027'
      2022-07-08 16:56:40 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014078' at position 1054248013; GTID position '100-1-138875425,300-3-522464027'
      2022-07-08 17:50:57 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014085' at position 519701971; GTID position '100-1-138976217,300-3-522464027'
      2022-07-08 20:12:11 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014098' at position 475373314; GTID position '100-1-139211697,300-3-522464027'
      2022-07-08 21:46:08 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014102' at position 237154437; GTID position '100-1-139344077,300-3-522464027'
      2022-07-08 21:47:38 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014102' at position 258213263; GTID position '100-1-139344634,300-3-522464027'
      2022-07-09  0:22:10 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014108' at position 274953307; GTID position '100-1-139582274,300-3-522464027'
      2022-07-09  0:28:12 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014109' at position 13657937; GTID position '100-1-139590545,300-3-522464027'
      2022-07-09  0:30:45 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014109' at position 273928366; GTID position '100-1-139592430,300-3-522464027'
      2022-07-09  0:55:27 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014126' at position 797697528; GTID position '100-1-139639947,300-3-522464027'
      2022-07-09  2:26:22 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014129' at position 499727303; GTID position '100-1-139781106,300-3-522464027'
      2022-07-09  4:22:26 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014132' at position 853830014; GTID position '100-1-139901574,300-3-522464027'
      2022-07-09  4:22:56 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014132' at position 869641905; GTID position '100-1-139901737,300-3-522464027'
      2022-07-09  4:23:27 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014132' at position 880291388; GTID position '100-1-139901842,300-3-522464027'
      2022-07-09  4:25:27 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014132' at position 947219704; GTID position '100-1-139904666,300-3-522464027'
      2022-07-09  4:27:58 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014132' at position 986408706; GTID position '100-1-139906403,300-3-522464027'
      2022-07-09  4:30:59 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014132' at position 1071433851; GTID position '100-1-139909140,300-3-522464027'
      2022-07-09  4:31:29 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014133' at position 10448181; GTID position '100-1-139909322,300-3-522464027'
      2022-07-09  4:32:30 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014133' at position 55819429; GTID position '100-1-139910325,300-3-522464027'
      2022-07-09  4:59:39 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014133' at position 782211245; GTID position '100-1-139934163,300-3-522464027'
      2022-07-09  6:32:37 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014136' at position 902681099; GTID position '100-1-140050541,300-3-522464027'
      2022-07-09  6:33:37 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014136' at position 949580070; GTID position '100-1-140051157,300-3-522464027'
      2022-07-09  9:09:56 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014150' at position 15407006; GTID position '100-1-140289490,300-3-522464027'
      2022-07-09  9:13:57 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014150' at position 949084494; GTID position '100-1-140298909,300-3-522464027'
      2022-07-09 10:04:44 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014162' at position 1011974601; GTID position '100-1-140422468,300-3-522464027'
      2022-07-09 10:05:14 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014163' at position 70355080; GTID position '100-1-140423458,300-3-522464027'
      2022-07-09 11:23:08 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014187' at position 428759254; GTID position '100-1-140658360,300-3-522464027'
      2022-07-09 11:34:11 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014190' at position 910627596; GTID position '100-1-140691114,300-3-522464027'
      2022-07-09 12:41:02 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014212' at position 403217461; GTID position '100-1-140887441,300-3-522464027'
      2022-07-09 18:38:53 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014316' at position 852783081; GTID position '100-1-141874680,300-3-522464027'
      2022-07-09 18:50:27 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014318' at position 882617374; GTID position '100-1-141899780,300-3-522464027'
      2022-07-09 20:31:01 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014329' at position 1037661281; GTID position '100-1-142073855,300-3-522464027'
      2022-07-10  1:38:29 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014352' at position 246754308; GTID position '100-1-142522329,300-3-522464027'
      2022-07-10  1:38:59 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014352' at position 247953583; GTID position '100-1-142522498,300-3-522464027'
      2022-07-10  1:39:29 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014352' at position 259472718; GTID position '100-1-142522742,300-3-522464027'
      2022-07-10  5:52:43 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014358' at position 607496970; GTID position '100-1-142769137,300-3-522464027'
      2022-07-10  6:00:16 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014358' at position 793426149; GTID position '100-1-142777242,300-3-522464027'
      2022-07-10  6:05:47 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014359' at position 14729850; GTID position '100-1-142785958,300-3-522464027'
      2022-07-10  8:01:53 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014363' at position 737694588; GTID position '100-1-142919641,300-3-522464027'
      2022-07-10 10:21:38 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014387' at position 840761781; GTID position '100-1-143230383,300-3-522464027'
      2022-07-10 12:39:16 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014429' at position 109573746; GTID position '100-1-143637637,300-3-522464027'
      2022-07-10 18:14:52 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014429' at position 109573746; GTID position '100-1-143637637,300-3-522464027'
      2022-07-11  8:44:47 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014551' at position 294791090; GTID position '100-1-145469726,300-3-522464027'
      2022-07-11  8:48:21 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014552' at position 885118139; GTID position '100-1-145513743,300-3-522464027'
      2022-07-11 10:30:08 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014568' at position 926489711; GTID position '100-1-145774324,300-3-522464027'
      2022-07-11 11:11:46 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014579' at position 44252420; GTID position '100-1-145894654,300-3-522464027'
      2022-07-11 11:32:22 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014584' at position 235857926; GTID position '100-1-145958787,300-3-522464027'
      2022-07-11 19:16:03 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014664' at position 763317574; GTID position '100-1-147117307,300-3-522464027'
      2022-07-11 21:16:05 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014672' at position 10152744; GTID position '100-1-147287275,300-3-522464027'
      2022-07-12  2:47:23 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014689' at position 924738131; GTID position '100-1-147688985,300-3-522464027'
      2022-07-12  4:17:51 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014691' at position 1044262328; GTID position '100-1-147775475,300-3-522464027'
      2022-07-12  6:41:04 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014696' at position 142102485; GTID position '100-1-147931797,300-3-522464027'
      2022-07-12  8:48:51 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014701' at position 5437072; GTID position '100-1-148086553,300-3-522464027'
      2022-07-12  8:55:34 22 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014701' at position 529058606; GTID position '100-1-148099317,300-3-522464027'
      2022-07-12  9:32:35 429 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014704' at position 716122069; GTID position '100-1-148162857,300-3-522464027'
      2022-07-12  9:53:47 2980 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014709' at position 72038348; GTID position '100-1-148207363,300-3-522464027'
      2022-07-12 10:37:23 4499 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014713' at position 76645001; GTID position '100-1-148275863,300-3-522464027'
      2022-07-14 11:15:27 56675 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.014713' at position 111426142; GTID position '100-1-148276354,300-3-522464027'
      2022-07-18 14:12:51 56746 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015715' at position 661692421; GTID position '100-1-165314276,300-3-522464027'
      2022-07-18 14:21:05 22 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015717' at position 150372704; GTID position '100-1-165338461,300-3-522464027', master: ovh3.vlan:3306
      2022-07-18 15:08:07 902 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015726' at position 487692437; GTID position '100-1-165473208,300-3-522464027', master: ovh3.vlan:3306
      2022-07-19 10:21:54 25565 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015765' at position 865046528; GTID position '100-1-166151933,300-3-522464027', master: ovh3.vlan:3306
      2022-07-19 10:23:55 36496 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015772' at position 680169945; GTID position '100-1-166397937,300-3-522464027', master: ovh3.vlan:3306
      2022-07-19 10:45:16 40620 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015778' at position 7598290; GTID position '100-1-166598994,300-3-522464027', master: ovh3.vlan:3306
      2022-07-19 11:18:53 45028 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015797' at position 960622933; GTID position '100-1-167003787,300-3-522464027', master: ovh3.vlan:3306
      2022-07-19 11:26:08 51933 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015828' at position 989643318; GTID position '100-1-167761986,300-3-522464027', master: ovh3.vlan:3306
      2022-07-19 12:31:15 21 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015840' at position 550737181; GTID position '100-1-167945768,300-3-522464027', master: ovh3.vlan:3306
      

      Attachments

        Activity

          Just found out that error 1047 is also still causing the slave to stop even though skip errors 1047 is set as detailed in OP!

          2022-07-20  9:03:40 34098 [ERROR] Slave SQL: Node has dropped from cluster, Gtid 100-1-168866636, Internal MariaDB error code: 1047
          2022-07-20  9:03:40 34098 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015887' at position 375663093; GTID position '100-1-168866635,300-3-522464027', master: ovh3.vlan:3306
          

          ccounotte COUNOTTE CEDRIC added a comment - Just found out that error 1047 is also still causing the slave to stop even though skip errors 1047 is set as detailed in OP! 2022 - 07 - 20 9 : 03 : 40 34098 [ERROR] Slave SQL: Node has dropped from cluster, Gtid 100 - 1 - 168866636 , Internal MariaDB error code: 1047 2022 - 07 - 20 9 : 03 : 40 34098 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.015887' at position 375663093 ; GTID position '100-1-168866635,300-3-522464027' , master: ovh3.vlan: 3306

          Is it Galera replication which aborts, or traditional replication, or both? What is your topology?

          elenst Elena Stepanova added a comment - Is it Galera replication which aborts, or traditional replication, or both? What is your topology?

          Galera doesn't seem to actually abort, the slave thread exits after this error is shown (or no error !?) but galera cluster is still sync'd just fine.

          I have 2 servers in a galera cluster, one of the node is a slave of another node being part of a 4-server galera cluster.

          That slave node is the one having this issue.

          ccounotte COUNOTTE CEDRIC added a comment - Galera doesn't seem to actually abort, the slave thread exits after this error is shown (or no error !?) but galera cluster is still sync'd just fine. I have 2 servers in a galera cluster, one of the node is a slave of another node being part of a 4-server galera cluster. That slave node is the one having this issue.

          People

            Elkin Andrei Elkin
            ccounotte COUNOTTE CEDRIC
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.