[MDEV-4906] stop slave; start slave; increments the GTId on a slave - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.4
Fix Version/s: 10.0.5
Component/s: None
Labels:
- gtid
Environment:

Hide
Linux pa1-lda-001.dev.tradingscreen.com 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux

+--------------------+
| @@version |
+--------------------+
| 10.0.3-MariaDB-log |
+--------------------+

Show
Linux pa1-lda-001.dev.tradingscreen.com 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux +--------------------+ | @@version | +--------------------+ | 10.0.3-MariaDB-log | +--------------------+

Description

With a simple test table, shown here on the slave:

mysql 15:39:00 [PA DEV 002] [eis] [3202]> select * from mfp;

+------+

| c1   |

+------+

|   11 |

|   22 |

|   33 |

|   44 |

|   55 |

+------+

5 rows in set (0.00 sec)

mysql 15:39:02 [PA DEV 002] [eis] [3202]> delete from mfp;

Query OK, 5 rows affected (0.00 sec)

I then also deleted all these rows on the master simply to explore the options for repairing replication using

SET GLOBAL gtid_slave_pos = 'XXX'

However, simply stopping and starting the slave ( sometimes twice ) skipped the transactions with no other actions required:

mysql 15:39:09 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1412 |

| gtid_current_pos | 3102-223202-1412 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-409  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:40:24 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql 15:45:21 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-410  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:45:24 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql 15:45:28 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-410  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:45:30 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql 15:45:32 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-411  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:45:34 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql 15:45:36 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-411  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:45:37 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql 15:45:39 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-412  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:45:41 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql 15:45:43 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-412  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:45:44 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql 15:45:47 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-413  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:46:23 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql 15:46:26 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-413  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:46:28 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql 15:46:29 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-414  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:46:31 [PA DEV 002] [eis] [3202]> stop slave; start slave;

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql 15:46:39 [PA DEV 002] [eis] [3202]> show variables like "%gtid%";

+------------------+------------------+

| Variable_name    | Value            |

+------------------+------------------+

| gtid_binlog_pos  | 3102-223202-1413 |

| gtid_current_pos | 3102-223202-1413 |

| gtid_domain_id   | 3102             |

| gtid_seq_no      | 0                |

| gtid_slave_pos   | 3102-223102-416  |

| gtid_strict_mode | OFF              |

+------------------+------------------+

6 rows in set (0.00 sec)

mysql 15:46:41 [PA DEV 002] [eis] [3202]>

Attachments

Activity

Ascending order - Click to sort in descending order

Michael Pattison created issue - 2013-08-16 16:58

Elena Stepanova made changes - 2013-08-16 17:00

Field	Original Value	New Value
Key	~~CONC-47~~	~~MDEV-4906~~
Project	MariaDB Client Library for C [ 10300 ]	MariaDB Development [ 10000 ]

Elena Stepanova made changes - 2013-08-16 17:03

Assignee	Georg Richter [ georg ]	Elena Stepanova [ elenst ]
Description	With a simple test table, shown here on the slave: mysql 15:39:00 [PA DEV 002] [eis] [3202]> select * from mfp; +------+ \| c1 \| +------+ \| 11 \| \| 22 \| \| 33 \| \| 44 \| \| 55 \| +------+ 5 rows in set (0.00 sec) mysql 15:39:02 [PA DEV 002] [eis] [3202]> delete from mfp; Query OK, 5 rows affected (0.00 sec) I then also deleted all these rows on the master simply to explore the options for repairing replication using SET GLOBAL gtid_slave_pos = 'XXX' However, simply stopping and starting the slave ( sometimes twice ) skipped the transactions with no other actions required: mysql 15:39:09 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1412 \| \| gtid_current_pos \| 3102-223202-1412 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-409 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:40:24 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:21 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-410 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:24 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:45:28 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-410 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:30 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:32 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-411 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:34 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:36 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-411 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:37 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:39 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-412 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:41 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:45:43 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-412 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:44 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:45:47 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-413 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:23 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:46:26 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-413 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:28 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:46:29 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-414 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:31 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:46:39 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-416 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:41 [PA DEV 002] [eis] [3202]>	With a simple test table, shown here on the slave: {code:sql} mysql 15:39:00 [PA DEV 002] [eis] [3202]> select * from mfp; +------+ \| c1 \| +------+ \| 11 \| \| 22 \| \| 33 \| \| 44 \| \| 55 \| +------+ 5 rows in set (0.00 sec) mysql 15:39:02 [PA DEV 002] [eis] [3202]> delete from mfp; Query OK, 5 rows affected (0.00 sec) {code} I then also deleted all these rows on the master simply to explore the options for repairing replication using {code:sql} SET GLOBAL gtid_slave_pos = 'XXX' {code} However, simply stopping and starting the slave ( sometimes twice ) skipped the transactions with no other actions required: {code:sql} mysql 15:39:09 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1412 \| \| gtid_current_pos \| 3102-223202-1412 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-409 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:40:24 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:21 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-410 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:24 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:45:28 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-410 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:30 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:32 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-411 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:34 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:36 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-411 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:37 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:45:39 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-412 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:41 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:45:43 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-412 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:45:44 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:45:47 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-413 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:23 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql 15:46:26 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-413 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:28 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:46:29 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-414 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:31 [PA DEV 002] [eis] [3202]> stop slave; start slave; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql 15:46:39 [PA DEV 002] [eis] [3202]> show variables like "%gtid%"; +------------------+------------------+ \| Variable_name \| Value \| +------------------+------------------+ \| gtid_binlog_pos \| 3102-223202-1413 \| \| gtid_current_pos \| 3102-223202-1413 \| \| gtid_domain_id \| 3102 \| \| gtid_seq_no \| 0 \| \| gtid_slave_pos \| 3102-223102-416 \| \| gtid_strict_mode \| OFF \| +------------------+------------------+ 6 rows in set (0.00 sec) mysql 15:46:41 [PA DEV 002] [eis] [3202]> {code}

Elena Stepanova made changes - 2013-08-16 18:31

Fix Version/s		10.0.5 [ 13201 ]
Affects Version/s		10.0.4 [ 13101 ]
Assignee	Elena Stepanova [ elenst ]	Kristian Nielsen [ knielsen ]
Labels		gtid

Kristian Nielsen made changes - 2013-08-20 15:10

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 28421 ]

MariaDB v2 [ 43975 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43975 ]

MariaDB v3 [ 64211 ]

Sergei Golubchik made changes - 2021-12-06 21:39

Workflow

MariaDB v3 [ 64211 ]

MariaDB v4 [ 146951 ]

People

Assignee:: Kristian Nielsen

Reporter:: Michael Pattison

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2013-08-16 16:58

Updated:: 2015-11-04 08:25

Resolved:: 2013-08-20 15:10

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration