[MDEV-9501] rpl.rpl_binlog_index, rpl.rpl_gtid_crash, rpl.rpl_stm_multi_query fail sporadically in buildbot with Master command COM_REGISTER_SLAVE failed - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.5
Fix Version/s: 10.1.48, 10.2.35, 10.3.26, 10.4.16, 10.5.7
Component/s: Platform Debian, Tests
Labels:
None

Sprint:
5.5.59

Description

http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar/builds/1060/steps/test/logs/stdio

rpl.rpl_binlog_index 'row'               w4 [ fail ]  Found warnings/errors in server log file!

        Test ended at 2016-01-26 20:02:26

line

160126 20:02:17 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000002' at position 549, Internal MariaDB error code: 1597

^ Found warnings in /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/4/log/mysqld.2.err

ok

Attachments

Issue Links

blocks

MDEV-7069 Fix buildbot failures in main server trees

Closed

relates to

MDEV-12694 test failure: encryption.create_or_replace hangs during DROP for CREATE OR REPLACE TABLE

Closed

MDEV-28788 rpl.rpl_checksum_cache sometimes fails in bb with Master command COM_REGISTER_SLAVE failed

Open

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2016-02-01 00:11

Elena Stepanova made changes - 2016-02-01 00:11

Field	Original Value	New Value
Link		This issue blocks ~~MDEV-7069~~ [ ~~MDEV-7069~~ ]

Otto Kekäläinen made changes - 2016-03-11 08:52

Component/s

Platform Debian [ 10136 ]

Otto Kekäläinen added a comment - 2016-03-11 08:59

This also happened in a Debian production build: https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=powerpc&ver=10.0.24-4&stamp=1457659375
Disabled for official Debian builds in: https://github.com/ottok/mariadb-10.0/commit/b1a48e7eba6681890b44756f6b6feb3ad0f3b62a

FYI also bar

Otto Kekäläinen added a comment - 2016-03-11 08:59 This also happened in a Debian production build: https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=powerpc&ver=10.0.24-4&stamp=1457659375 Disabled for official Debian builds in: https://github.com/ottok/mariadb-10.0/commit/b1a48e7eba6681890b44756f6b6feb3ad0f3b62a FYI also bar

Elena Stepanova made changes - 2016-08-21 13:36

Summary

rpl.rpl_binlog_index fails sporadically in buildbot

rpl.rpl_binlog_index, rpl.rpl_gtid_crash fail sporadically in buildbot

Daniel Black made changes - 2017-05-05 02:03

Link

This issue relates to ~~MDEV-12694~~ [ ~~MDEV-12694~~ ]

Elena Stepanova added a comment - 2017-05-08 15:50

Recent occurrence on 10.2:
http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar-debug/builds/2435/steps/test/logs/stdio

Elena Stepanova added a comment - 2017-05-08 15:50 Recent occurrence on 10.2: http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar-debug/builds/2435/steps/test/logs/stdio

Elena Stepanova made changes - 2017-05-08 15:50

Fix Version/s		10.2 [ 14601 ]
Affects Version/s		10.2 [ 14601 ]

Elena Stepanova made changes - 2017-05-09 10:42

Summary

rpl.rpl_binlog_index, rpl.rpl_gtid_crash fail sporadically in buildbot

rpl.rpl_binlog_index, rpl.rpl_gtid_crash, rpl.rpl_stm_multi_query fail sporadically in buildbot with

Elena Stepanova made changes - 2017-05-09 10:42

Summary

rpl.rpl_binlog_index, rpl.rpl_gtid_crash, rpl.rpl_stm_multi_query fail sporadically in buildbot with

rpl.rpl_binlog_index, rpl.rpl_gtid_crash, rpl.rpl_stm_multi_query fail sporadically in buildbot with Master command COM_REGISTER_SLAVE failed

Elena Stepanova added a comment - 2017-05-09 10:43

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/5119/steps/test/logs/stdio

rpl.rpl_stm_multi_query 'mix'            w3 [ fail ]  Found warnings/errors in server log file!

        Test ended at 2017-05-05 09:35:43

line

2017-05-05  9:35:43 1331239232 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000001' at position 4, Internal MariaDB error code: 1597

^ Found warnings in /usr/local/mariadb-10.2.6-linux-x86_64/mysql-test/var/3/log/mysqld.2.err

Elena Stepanova added a comment - 2017-05-09 10:43 http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/5119/steps/test/logs/stdio rpl.rpl_stm_multi_query 'mix' w3 [ fail ] Found warnings/errors in server log file! Test ended at 2017-05-05 09:35:43 line 2017-05-05 9:35:43 1331239232 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000001' at position 4, Internal MariaDB error code: 1597 ^ Found warnings in /usr/local/mariadb-10.2.6-linux-x86_64/mysql-test/var/3/log/mysqld.2.err

Elena Stepanova made changes - 2017-05-09 10:43

Assignee

Kristian Nielsen [ knielsen ]

Lixun Peng [ plinux ]

Elena Stepanova added a comment - 2017-05-09 23:55

rpl.rpl_temporal_mysql56_to_mariadb53 is also affected

Elena Stepanova added a comment - 2017-05-09 23:55 rpl.rpl_temporal_mysql56_to_mariadb53 is also affected

Alice Sherepa added a comment - 2017-09-08 08:11

rpl.rpl_gtid_crash on 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/9508/steps/test_3/logs/stdio

rpl.rpl_gtid_crash 'innodb,row'          w1 [ fail ]  Found warnings/errors in server log file!

        Test ended at 2017-09-08 03:53:39

line

2017-09-08  3:53:28 10 [ERROR] Slave I/O: Master command COM_REGISTER_SLAVE failed: Lost connection to MySQL server during query (Errno: 2013), Internal MariaDB error code: 1597

2017-09-08  3:53:28 10 [ERROR] Slave I/O thread couldn't register on master

2017-09-08  3:53:29 10 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000006' at position 785; GTID position '1-1-2,0-1-9,2-1-1', Internal MariaDB error code: 1597

^ Found warnings in /mnt/buildbot/build/mariadb-10.3.2/mysql-test/var/1/log/mysqld.2.err

Alice Sherepa added a comment - 2017-09-08 08:11 rpl.rpl_gtid_crash on 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/9508/steps/test_3/logs/stdio rpl.rpl_gtid_crash 'innodb,row' w1 [ fail ] Found warnings/errors in server log file! Test ended at 2017-09-08 03:53:39 line 2017-09-08 3:53:28 10 [ERROR] Slave I/O: Master command COM_REGISTER_SLAVE failed: Lost connection to MySQL server during query (Errno: 2013), Internal MariaDB error code: 1597 2017-09-08 3:53:28 10 [ERROR] Slave I/O thread couldn't register on master 2017-09-08 3:53:29 10 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000006' at position 785; GTID position '1-1-2,0-1-9,2-1-1', Internal MariaDB error code: 1597 ^ Found warnings in /mnt/buildbot/build/mariadb-10.3.2/mysql-test/var/1/log/mysqld.2.err

Alice Sherepa added a comment - 2017-11-17 10:18

on 5.5 http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/591/steps/mtr/logs/stdio

rpl.rpl_binlog_index 'row'               w2 [ fail ]  Found warnings/errors in server log file!

        Test ended at 2017-11-16 13:48:23

line

171116 13:48:08 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000002' at position 457, Error_code: 1597

^ Found warnings in /dev/shm/var/2/log/mysqld.2.err

Alice Sherepa added a comment - 2017-11-17 10:18 on 5.5 http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/591/steps/mtr/logs/stdio rpl.rpl_binlog_index 'row' w2 [ fail ] Found warnings/errors in server log file! Test ended at 2017-11-16 13:48:23 line 171116 13:48:08 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000002' at position 457, Error_code: 1597 ^ Found warnings in /dev/shm/var/2/log/mysqld.2.err

Elena Stepanova made changes - 2017-11-17 10:45

Fix Version/s		5.5 [ 15800 ]
Affects Version/s		5.5 [ 15800 ]
Assignee	Lixun Peng [ plinux ]	Andrei Elkin [ elkin ]

Andrei Elkin made changes - 2018-01-09 13:52

Sprint

2018-01 [ 218 ]

Sergei Golubchik made changes - 2018-01-09 22:12

Sprint

2018-01 [ 218 ]

5.5.59 [ 221 ]

Sergei Golubchik made changes - 2018-01-09 22:12

Rank

Ranked lower

Marko Mäkelä added a comment - 2020-06-10 07:02

This affects 10.5 as well:

10.5 17a7bafec068d6436f3f6c5ca67b9d6c98b31ef5
rpl.rpl_binlog_index 'row' w1 [ fail ] Found warnings/errors in server log file!
Test ended at 2020-06-10 08:46:08
line
2020-06-10 8:45:58 7 [Warning] Slave I/O: SET @master_heartbeat_period to master failed with error: Lost connection to server during query, Internal MariaDB error code: 2013
2020-06-10 8:45:59 7 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000002' at position 633, Internal MariaDB error code: 1597

I did not see a sign of a crash in the server logs, but the log of the replica server contains some error messages about failing to connect to the master.

Marko Mäkelä added a comment - 2020-06-10 07:02 This affects 10.5 as well : 10.5 17a7bafec068d6436f3f6c5ca67b9d6c98b31ef5 rpl.rpl_binlog_index 'row' w1 [ fail ] Found warnings/errors in server log file! Test ended at 2020-06-10 08:46:08 line 2020-06-10 8:45:58 7 [Warning] Slave I/O: SET @master_heartbeat_period to master failed with error: Lost connection to server during query, Internal MariaDB error code: 2013 2020-06-10 8:45:59 7 [Warning] Slave I/O: Master command COM_REGISTER_SLAVE failed: failed registering on master, reconnecting to try again, log 'master-bin.000002' at position 633, Internal MariaDB error code: 1597 I did not see a sign of a crash in the server logs, but the log of the replica server contains some error messages about failing to connect to the master.

Marko Mäkelä made changes - 2020-06-10 07:02

Fix Version/s		10.5 [ 23123 ]
Affects Version/s		10.5 [ 23123 ]

Sujatha Sivakumar (Inactive) made changes - 2020-06-11 07:54

Assignee

Andrei Elkin [ elkin ]

Sujatha Sivakumar [ sujatha.sivakumar ]

Sujatha Sivakumar (Inactive) made changes - 2020-06-11 07:54

Status

Open [ 1 ]

Confirmed [ 10101 ]

Sujatha Sivakumar (Inactive) made changes - 2020-06-11 07:54

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Sujatha Sivakumar (Inactive) made changes - 2020-06-11 10:51

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Julien Fritsch made changes - 2020-06-12 11:48

Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]

Sujatha Sivakumar (Inactive) made changes - 2020-06-24 15:28

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Sujatha Sivakumar (Inactive) added a comment - 2020-07-02 04:49

Hello Andrei,

Can you please review the fix for ~~MDEV-9501~~.

Patch: https://github.com/MariaDB/server/commit/965663f090c4af83e8c4aca913568f6065509ff4

BuildBot Testing: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.1-sujatha

Thank you.

Sujatha Sivakumar (Inactive) added a comment - 2020-07-02 04:49 Hello Andrei, Can you please review the fix for MDEV-9501 . Patch: https://github.com/MariaDB/server/commit/965663f090c4af83e8c4aca913568f6065509ff4 BuildBot Testing: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.1-sujatha Thank you.

Sujatha Sivakumar (Inactive) made changes - 2020-07-02 04:49

Assignee	Sujatha Sivakumar [ sujatha.sivakumar ]	Andrei Elkin [ elkin ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Andrei Elkin made changes - 2020-09-04 12:58

Assignee	Andrei Elkin [ elkin ]	Sujatha Sivakumar [ sujatha.sivakumar ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Sujatha Sivakumar (Inactive) added a comment - 2020-09-08 08:24

Merged patch to higher versions and tested the changes.

Minor merge conflicts were observed from 10.1 to 10.2.
The result files need to be re-recorded.

10.2: https://github.com/MariaDB/server/commit/37273575004598b459d7bbdd453ed3a28df66037

The patch remains the same for 10.3+ versions.
10.3: https://github.com/MariaDB/server/commit/5b2540397ca45a124027f0b276a6f7b00d0b80b8

Sujatha Sivakumar (Inactive) added a comment - 2020-09-08 08:24 Merged patch to higher versions and tested the changes. Minor merge conflicts were observed from 10.1 to 10.2. The result files need to be re-recorded. 10.2: https://github.com/MariaDB/server/commit/37273575004598b459d7bbdd453ed3a28df66037 The patch remains the same for 10.3+ versions. 10.3: https://github.com/MariaDB/server/commit/5b2540397ca45a124027f0b276a6f7b00d0b80b8

Sujatha Sivakumar (Inactive) made changes - 2020-09-08 08:24

issue.field.resolutiondate

2020-09-08 08:24:54.0

2020-09-08 08:24:54.107

Sujatha Sivakumar (Inactive) made changes - 2020-09-08 08:24

Fix Version/s		10.1.47 [ 24510 ]
Fix Version/s		10.2.34 [ 24505 ]
Fix Version/s		10.3.25 [ 24506 ]
Fix Version/s		10.4.15 [ 24507 ]
Fix Version/s		10.5.6 [ 24508 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	5.5 [ 15800 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Ralf Gebhardt made changes - 2020-10-06 18:35

Fix Version/s

10.5.7 [ 25019 ]

Ralf Gebhardt made changes - 2020-10-06 18:37

Fix Version/s

10.5.6 [ 24508 ]

Ralf Gebhardt made changes - 2020-10-06 18:40

Fix Version/s

10.4.16 [ 25020 ]

Ralf Gebhardt made changes - 2020-10-06 18:42

Fix Version/s

10.4.15 [ 24507 ]

Ralf Gebhardt made changes - 2020-10-06 18:43

Fix Version/s

10.3.26 [ 25021 ]

Ralf Gebhardt made changes - 2020-10-06 18:45

Fix Version/s

10.3.25 [ 24506 ]

Ralf Gebhardt made changes - 2020-10-06 18:47

Fix Version/s

10.2.35 [ 25022 ]

Ralf Gebhardt made changes - 2020-10-06 18:48

Fix Version/s

10.2.34 [ 24505 ]

Ralf Gebhardt made changes - 2020-10-06 18:50

Fix Version/s

10.1.48 [ 25108 ]

Ralf Gebhardt made changes - 2020-10-06 18:52

Fix Version/s

10.1.47 [ 24510 ]

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

Workflow

MariaDB v3 [ 73853 ]

MariaDB v4 [ 150067 ]

Angelique Sklavounos (Inactive) made changes - 2022-06-09 16:34

Link

This issue relates to MDEV-28788 [ MDEV-28788 ]

People

Assignee:: Sujatha Sivakumar (Inactive)

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2016-02-01 00:11

Updated:: 2022-06-09 16:34

Resolved:: 2020-09-08 08:24

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration