Ryfujk

A word that means fill it to the required quantity

If a sorcerer casts the Banishment spell on a PC while in Avernus, does the PC return to their home plane?

Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?

What do hard-Brexiteers want with respect to the Irish border?

How to type a long/em dash `—`

Why “相同意思的词” is called “同义词” instead of "同意词"？

What is the most efficient way to store a numeric range?

What is the motivation for a law requiring 2 parties to consent for recording a conversation

Star Trek - X-shaped Item on Regula/Orbital Office Starbases

What's the name of these plastic connectors

If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?

How do you keep chess fun when your opponent constantly beats you?

Is it safe to harvest rainwater that fell on solar panels?

What do these terms in Caesar's Gallic wars mean?

Correct punctuation for showing a character's confusion

Can you cast a spell on someone in the Ethereal Plane, if you are on the Material Plane and have the True Seeing spell active?

What information about me do stores get via my credit card?

Is an up-to-date browser secure on an out-of-date OS?

Why didn't the Event Horizon Telescope team mention Sagittarius A*?

Kerning for subscripts of sigma?

Did any laptop computers have a built-in 5 1/4 inch floppy drive?

Will it cause any balance problems to have PCs level up and gain the benefits of a long rest mid-fight?

ODD NUMBER in Cognitive Linguistics of WILLIAM CROFT and D. ALAN CRUSE

Can withdrawing asylum be illegal?

Slave replication stops with Last_SQL_Errno: 1032

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

2

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the following error:

Last_SQL_Errno: 1032

Last_SQL_Error: Could not execute Update_rows event on table xxx.email_events; Can't find record in 'email_events', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysqld-bin.000410, end_log_pos 368808733

It will be fine for some hours after repairing.

Questions

• Can we permanently skip Last_SQL_Errno: 1032?


• Is there any issue with skipping this error?

mysql mysql-replication mysql5.5 amazon-linux

share|improve this question

asked Jul 15 '17 at 22:14

adminzadminz

87213

add a comment | 

2

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the following error:

Last_SQL_Errno: 1032

Last_SQL_Error: Could not execute Update_rows event on table xxx.email_events; Can't find record in 'email_events', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysqld-bin.000410, end_log_pos 368808733

It will be fine for some hours after repairing.

Questions

• Can we permanently skip Last_SQL_Errno: 1032?


• Is there any issue with skipping this error?

mysql mysql-replication mysql5.5 amazon-linux

share|improve this question

asked Jul 15 '17 at 22:14

adminzadminz

87213

add a comment | 

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the following error:

Last_SQL_Errno: 1032

Last_SQL_Error: Could not execute Update_rows event on table xxx.email_events; Can't find record in 'email_events', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysqld-bin.000410, end_log_pos 368808733

It will be fine for some hours after repairing.

Questions

• Can we permanently skip Last_SQL_Errno: 1032?


• Is there any issue with skipping this error?

mysql mysql-replication mysql5.5 amazon-linux

share|improve this question

asked Jul 15 '17 at 22:14

adminzadminz

87213

share|improve this question

asked Jul 15 '17 at 22:14

adminzadminz

87213

share|improve this question

asked Jul 15 '17 at 22:14

adminzadminz

87213

asked Jul 15 '17 at 22:14

adminzadminz

87213

asked Jul 15 '17 at 22:14

adminzadminz

87213

3 Answers
3

active

oldest

votes

0

You can set the following in your slave's my.cnf:
[mysqld]
slave-skip-errors=1032

But as the documentation says:
Do not use this option unless you fully understand why you are getting errors. One of the possible reason for this error could be due to “Slave_IO_Running: Yes” but “Slave_SQL_Running: No” that means your Slave IO process is running and retrieving data from Master but couldn’t execute due to Slave_SQL_Running process is stopped.
A monitoring tool like Monyog can be used to proactively monitor the replication and alert you to the error or a lag or disconnection between the Master and Slave servers.

share|improve this answer

answered Jul 28 '17 at 12:18

user428494user428494

91

add a comment | 

0

For people who have this as a one off error, you can try skipping the item:

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

START SLAVE;

share|improve this answer

answered May 4 '18 at 22:20

SteveSteve

1

add a comment | 

0

You can locate the sql clause code like /usr/bin/mysqlbinlog -v --start-position=142743807 --stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log

Then compare slave and master database difference according to temp.log on specific pos.
Then update slave database.

Then skip that line with mysql -e "stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;";

share

answered 3 mins ago

Kris RoofeKris Roofe

1487

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f862351%2fslave-replication-stops-with-last-sql-errno-1032%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

You can set the following in your slave's my.cnf:
[mysqld]
slave-skip-errors=1032

But as the documentation says:
Do not use this option unless you fully understand why you are getting errors. One of the possible reason for this error could be due to “Slave_IO_Running: Yes” but “Slave_SQL_Running: No” that means your Slave IO process is running and retrieving data from Master but couldn’t execute due to Slave_SQL_Running process is stopped.
A monitoring tool like Monyog can be used to proactively monitor the replication and alert you to the error or a lag or disconnection between the Master and Slave servers.

share|improve this answer

answered Jul 28 '17 at 12:18

user428494user428494

91

add a comment | 

0

You can set the following in your slave's my.cnf:
[mysqld]
slave-skip-errors=1032

But as the documentation says:
Do not use this option unless you fully understand why you are getting errors. One of the possible reason for this error could be due to “Slave_IO_Running: Yes” but “Slave_SQL_Running: No” that means your Slave IO process is running and retrieving data from Master but couldn’t execute due to Slave_SQL_Running process is stopped.
A monitoring tool like Monyog can be used to proactively monitor the replication and alert you to the error or a lag or disconnection between the Master and Slave servers.

share|improve this answer

answered Jul 28 '17 at 12:18

user428494user428494

91

add a comment | 

You can set the following in your slave's my.cnf:
[mysqld]
slave-skip-errors=1032

But as the documentation says:
Do not use this option unless you fully understand why you are getting errors. One of the possible reason for this error could be due to “Slave_IO_Running: Yes” but “Slave_SQL_Running: No” that means your Slave IO process is running and retrieving data from Master but couldn’t execute due to Slave_SQL_Running process is stopped.
A monitoring tool like Monyog can be used to proactively monitor the replication and alert you to the error or a lag or disconnection between the Master and Slave servers.

share|improve this answer

answered Jul 28 '17 at 12:18

user428494user428494

91

share|improve this answer

answered Jul 28 '17 at 12:18

user428494user428494

91

answered Jul 28 '17 at 12:18

user428494user428494

91

answered Jul 28 '17 at 12:18

user428494user428494

91

0

For people who have this as a one off error, you can try skipping the item:

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

START SLAVE;

share|improve this answer

answered May 4 '18 at 22:20

SteveSteve

1

add a comment | 

0

For people who have this as a one off error, you can try skipping the item:

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

START SLAVE;

share|improve this answer

answered May 4 '18 at 22:20

SteveSteve

1

add a comment | 

For people who have this as a one off error, you can try skipping the item:

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

START SLAVE;

share|improve this answer

answered May 4 '18 at 22:20

SteveSteve

1

share|improve this answer

answered May 4 '18 at 22:20

SteveSteve

1

answered May 4 '18 at 22:20

SteveSteve

1

answered May 4 '18 at 22:20

SteveSteve

1

0

You can locate the sql clause code like /usr/bin/mysqlbinlog -v --start-position=142743807 --stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log

Then compare slave and master database difference according to temp.log on specific pos.
Then update slave database.

Then skip that line with mysql -e "stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;";

share

answered 3 mins ago

Kris RoofeKris Roofe

1487

add a comment | 

0

You can locate the sql clause code like /usr/bin/mysqlbinlog -v --start-position=142743807 --stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log

Then compare slave and master database difference according to temp.log on specific pos.
Then update slave database.

Then skip that line with mysql -e "stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;";

share

answered 3 mins ago

Kris RoofeKris Roofe

1487

add a comment | 

You can locate the sql clause code like /usr/bin/mysqlbinlog -v --start-position=142743807 --stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log

Then compare slave and master database difference according to temp.log on specific pos.
Then update slave database.

Then skip that line with mysql -e "stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;";

share

answered 3 mins ago

Kris RoofeKris Roofe

1487

share

answered 3 mins ago

Kris RoofeKris Roofe

1487

answered 3 mins ago

Kris RoofeKris Roofe

1487

answered 3 mins ago

Kris RoofeKris Roofe

1487