Error during create secondary index

[mdcallag]

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

The error message comes from this line.