This happened once from ~100 runs of a test (the insert benchmark). The index is being created on a table with much data. I was using MyRocks from FB MySQL 8.0.28 compiled from source a few weeks ago.
The error message in the MySQL error log is: "Error retrieving index entry from primary key"
This issue is filed to get a few more details into that error message -- the table name, the value of res that triggers the error code, the command being run, maybe more.
The command has been running for ~100k seconds prior to the error. On the client side I have this text, which comes from the mysql client (see here).
This SQL failed
alter table pi1
add index pi1_marketsegment (price, customerid),
add index pi1_registersegment (cashregisterid, price, customerid),
add index pi1_pdc (price, dateandtime, customerid), algorithm=inplace
This happened once from ~100 runs of a test (the insert benchmark). The index is being created on a table with much data. I was using MyRocks from FB MySQL 8.0.28 compiled from source a few weeks ago.
The error message in the MySQL error log is: "Error retrieving index entry from primary key"
This issue is filed to get a few more details into that error message -- the table name, the value of res that triggers the error code, the command being run, maybe more.
The command has been running for ~100k seconds prior to the error. On the client side I have this text, which comes from the mysql client (see here).
This SQL failed
The error message comes from this line.