Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Slave UUID in replica for gh-ost shows java.lang.ArrayIndexOutOfBoundsException #1492

Open
vicmac opened this issue Jan 23, 2025 · 0 comments

Comments

@vicmac
Copy link

vicmac commented Jan 23, 2025

While using v.1.1.5 (due to compatibility issues of gh-ost's latest version with MySQL 5.7) everything runs fine, but we noticed, after issuing a

show slave hosts ;

command in the replica gh-ost uses to read the binlog, that the "Slave_UUID" column shows an error message rather than a proper value

Server_id 99999
Host ip-10-0-0-113.ec2.internal
Port 3306
Master_id 1778116519
Slave_UUID  <failed to load>
java.lang.ArrayIndexOutOfBoundsException: Index 49 out of bounds for length 49
	at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.setPosition(TextRowProtocol.java:135)
	at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.checkObjectRange(SelectResultSet.java:635)
	at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getString(SelectResultSet.java:943)
	in JdbcHelperImpl.getObject(JdbcHelperImpl.java:337)

Is this a known issue that is fixed in newer versions? Or maybe a DBMS issue rather than a gh-ost issue?

Again, migrations run fine, we've moved several tables and around 700M rows with no issues so far.

We're using AWS RDS, our setup is as follows:

Master cluster, hosting the master writer and 3 Aurora read replicas
binglog format is MIXED
Engine is 5.7.mysql_aurora.2.11.3
5.7.12-log

Replica cluster, set up manually to replicate via binlog from the master writer, only 1 writer
binlog format is ROW
filtering is OFF (0)
Engine is 5.7.mysql_aurora.2.11.3
5.7.12-log

I'll gladly give more info on the issue if needed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant