Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL)
-
None
-
Linux
Description
I encountered a failure in the replication to a spider table that is not mentioned in the recommendations at https://mariadb.com/kb/en/library/spider-storage-engine-overview/#some-server-variables-to-set-when-using-spider.
From 'show slave status\G':
Last_SQL_Errno: 1429
|
Last_SQL_Error: Could not execute Update_rows_v1 event on table db.t3; Unable to connect to foreign data source: spider-datanode3, Error_code: 1429; handler error No Error!; the event's master log binlog.000164, end_log_pos 52742152
|
It did work again after:
start slave sql_thread;
|
Can these issues be retried within the spider engine instead of failing in the engine and retried in the replication? (or are they failing after multiple attempts in the engine and the replication just continues to retry until it succeeds?)
Also I would expect the default settings to handle this, rather than having to add configuration mentioned in the link above.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Jacob Mathew [ jacob-mathew ] |
| Assignee | Jacob Mathew [ jacob-mathew ] | Kentoku [ kentoku ] |
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Kentoku [ kentoku ] | Michael Widenius [ monty ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Fix Version/s | 10.4 [ 22408 ] |
| Assignee | Michael Widenius [ monty ] | Kentoku [ kentoku ] |
| issue.field.resolutiondate | 2019-04-12 14:02:07.0 | 2019-04-12 14:02:07.733 |
| Fix Version/s | 10.4.5 [ 23311 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Review [ 10002 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 87973 ] | MariaDB v4 [ 154547 ] |
| Zendesk Related Tickets | 177946 |