Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.7(EOL), 11.8
-
Q3/2025 Maintenance
Description
When using START SLAVE UNTIL, the UNTIL grammar rule uses master_file_def (through slave_until_opts), which is also used by CHANGE MASTER TO. This means that a START SLAVE UNTIL statement can use any option available to the master_file_def rule (e.g. master_use_gtid, master_demote_to_slave), despite not being valid for START SLAVE. For example:
START SLAVE UNTIL relay_log_file='mariadb-bin.000002', relay_log_pos=50, master_demote_to_slave=1, master_use_gtid=no;
|
The only constraint is that the master/relay log file/pos have to be set:
| UNTIL_SYM slave_until_opts
|
{
|
LEX *lex=Lex;
|
if (unlikely(((lex->mi.log_file_name || lex->mi.pos) &&
|
(lex->mi.relay_log_name || lex->mi.relay_log_pos)) ||
|
!((lex->mi.log_file_name && lex->mi.pos) ||
|
(lex->mi.relay_log_name && lex->mi.relay_log_pos))))
|
my_yyabort_error((ER_BAD_SLAVE_UNTIL_COND, MYF(0)));
|
}
|
The valid options for START SLAVE UNTIL should be split from master_file_def to disallow this.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | START SLAVE UNTIL uses CHANGE MASTER TO syntax | START SLAVE UNTIL uses CHANGE MASTER TO options |
| Summary | START SLAVE UNTIL uses CHANGE MASTER TO options | START SLAVE UNTIL allows CHANGE MASTER TO options |
| Labels | beginner-friendly |
| Fix Version/s | 12.1 [ 29992 ] | |
| Fix Version/s | 12.0 [ 29945 ] |
| Labels | beginner-friendly | beginner-friendly contribution |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Susil Behera [ JIRAUSER40751 ] |
| Assignee | Susil Behera [ JIRAUSER40751 ] | Brandon Nesterenko [ JIRAUSER48702 ] |
| Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Susil Behera [ JIRAUSER40751 ] |
| Assignee | Susil Behera [ JIRAUSER40751 ] | Brandon Nesterenko [ JIRAUSER48702 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Sprint | Q3/2025 Maintenance [ 797 ] |