Sfrgttk

How to play a character with a disability or mental disorder without being offensive?

Amount of permutations on an NxNxN Rubik's Cube

What order were files/directories outputted in dir?

Do I really need to have a message in a novel to appeal to readers?

File name problem(?)

Crossing US/Canada Border for less than 24 hours

An adverb for when you're not exaggerating

What happened to Thoros of Myr's flaming sword?

Quadrilaterals with equal sides

Can a new player join a group only when a new campaign starts?

Why limits give us the exact value of the slope of the tangent line?

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

How do I find out the mythology and history of my Fortress?

How many time has Arya actually used Needle?

Belief In God or Knowledge Of God. Which is better?

Would it be possible to dictate a bech32 address as a list of English words?

What does the power rating of 10W mean?

How to draw/optimize this graph with tikz

Sum letters are not two different

Putting class ranking in CV, but against dept guidelines

Exposing GRASS GIS add-on in QGIS Processing framework?

How to plot logistic regression decision boundary?

Would it be easier to apply for a UK visa if there is a host family to sponsor for you in going there?

How to unroll a parameter pack from right to left

Where is pt-table-checksum finding this hostname?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range is 172.0.0.0/8.

Somehow the slave got out of sync and I'm getting this error when I do SHOW SLAVE STATUS:

Could not execute Update_rows event on table db37708.general; Can't find record in 'general', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log newprod.000106, end_log_pos 285712203

I compared the master and slave tables and yes, there is some data out of sync. Not schema, just text data. Okay, fine, I'll just run my script that wraps pt-table-checksum and I get this:

[ubuntu@fabersubuntu utils ]$ ./checksumSpecificTable.sh db37708 general

Replica ip-10-3-2-119 is stopped.  Waiting.

Replica ip-10-3-2-119 is stopped.  Waiting.

^C# Caught SIGINT.

            TS ERRORS  DIFFS     ROWS  CHUNKS SKIPPED    TIME TABLE

04-19T12:09:50      0      0        1       1       0  32.282 db37708.general

So I run the script again after adding PTDEBUG=1 to it and I see things like this:

# DSNParser:1638 30974 DBI::db=HASH(0x21aae58) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/

# DSNParser:1652 30974 DBH info:  DBI::db=HASH(0x21aae58) $VAR1 = {

#   '@@hostname' => 'ip-10-3-2-119',

#   'CONNECTION_ID()' => '351452',

#   'DATABASE()' => undef,

#   'VERSION()' => '5.6.40-log'

My questions are:

1. Where is this "hostname" coming from? Assuming it's an IP address format, it makes sense that it is waiting because I don't have any hosts in a 10.0.0.0 range.




2. If I CALL mysql.skip_repl_error, I get another error; apparently I have lots of errors all of a similar type (so far). I assume pt-table-checksum can't do anything for me if replication isn't working, so what would be next step be other than rebuild my RDS slave?

mysql master-slave-replication percona-toolkit

share

asked 5 mins ago

faberfedorfaberfedor

112

add a comment | 

0

The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range is 172.0.0.0/8.

Somehow the slave got out of sync and I'm getting this error when I do SHOW SLAVE STATUS:

Could not execute Update_rows event on table db37708.general; Can't find record in 'general', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log newprod.000106, end_log_pos 285712203

I compared the master and slave tables and yes, there is some data out of sync. Not schema, just text data. Okay, fine, I'll just run my script that wraps pt-table-checksum and I get this:

[ubuntu@fabersubuntu utils ]$ ./checksumSpecificTable.sh db37708 general

Replica ip-10-3-2-119 is stopped.  Waiting.

Replica ip-10-3-2-119 is stopped.  Waiting.

^C# Caught SIGINT.

            TS ERRORS  DIFFS     ROWS  CHUNKS SKIPPED    TIME TABLE

04-19T12:09:50      0      0        1       1       0  32.282 db37708.general

So I run the script again after adding PTDEBUG=1 to it and I see things like this:

# DSNParser:1638 30974 DBI::db=HASH(0x21aae58) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/

# DSNParser:1652 30974 DBH info:  DBI::db=HASH(0x21aae58) $VAR1 = {

#   '@@hostname' => 'ip-10-3-2-119',

#   'CONNECTION_ID()' => '351452',

#   'DATABASE()' => undef,

#   'VERSION()' => '5.6.40-log'

My questions are:

1. Where is this "hostname" coming from? Assuming it's an IP address format, it makes sense that it is waiting because I don't have any hosts in a 10.0.0.0 range.




2. If I CALL mysql.skip_repl_error, I get another error; apparently I have lots of errors all of a similar type (so far). I assume pt-table-checksum can't do anything for me if replication isn't working, so what would be next step be other than rebuild my RDS slave?

mysql master-slave-replication percona-toolkit

share

asked 5 mins ago

faberfedorfaberfedor

112

add a comment | 

The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range is 172.0.0.0/8.

Somehow the slave got out of sync and I'm getting this error when I do SHOW SLAVE STATUS:

Could not execute Update_rows event on table db37708.general; Can't find record in 'general', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log newprod.000106, end_log_pos 285712203

I compared the master and slave tables and yes, there is some data out of sync. Not schema, just text data. Okay, fine, I'll just run my script that wraps pt-table-checksum and I get this:

[ubuntu@fabersubuntu utils ]$ ./checksumSpecificTable.sh db37708 general

Replica ip-10-3-2-119 is stopped.  Waiting.

Replica ip-10-3-2-119 is stopped.  Waiting.

^C# Caught SIGINT.

            TS ERRORS  DIFFS     ROWS  CHUNKS SKIPPED    TIME TABLE

04-19T12:09:50      0      0        1       1       0  32.282 db37708.general

So I run the script again after adding PTDEBUG=1 to it and I see things like this:

# DSNParser:1638 30974 DBI::db=HASH(0x21aae58) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/

# DSNParser:1652 30974 DBH info:  DBI::db=HASH(0x21aae58) $VAR1 = {

#   '@@hostname' => 'ip-10-3-2-119',

#   'CONNECTION_ID()' => '351452',

#   'DATABASE()' => undef,

#   'VERSION()' => '5.6.40-log'

My questions are:

1. Where is this "hostname" coming from? Assuming it's an IP address format, it makes sense that it is waiting because I don't have any hosts in a 10.0.0.0 range.




2. If I CALL mysql.skip_repl_error, I get another error; apparently I have lots of errors all of a similar type (so far). I assume pt-table-checksum can't do anything for me if replication isn't working, so what would be next step be other than rebuild my RDS slave?

mysql master-slave-replication percona-toolkit

share

asked 5 mins ago

faberfedorfaberfedor

112

Could not execute Update_rows event on table db37708.general; Can't find record in 'general', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log newprod.000106, end_log_pos 285712203

[ubuntu@fabersubuntu utils ]$ ./checksumSpecificTable.sh db37708 general

Replica ip-10-3-2-119 is stopped.  Waiting.

Replica ip-10-3-2-119 is stopped.  Waiting.

^C# Caught SIGINT.

            TS ERRORS  DIFFS     ROWS  CHUNKS SKIPPED    TIME TABLE

04-19T12:09:50      0      0        1       1       0  32.282 db37708.general

# DSNParser:1638 30974 DBI::db=HASH(0x21aae58) SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION'*/

# DSNParser:1652 30974 DBH info:  DBI::db=HASH(0x21aae58) $VAR1 = {

#   '@@hostname' => 'ip-10-3-2-119',

#   'CONNECTION_ID()' => '351452',

#   'DATABASE()' => undef,

#   'VERSION()' => '5.6.40-log'

share

asked 5 mins ago

faberfedorfaberfedor

112

share

asked 5 mins ago

faberfedorfaberfedor

112

asked 5 mins ago

faberfedorfaberfedor

112

asked 5 mins ago

faberfedorfaberfedor

112