the issue was that InnoDB table had corrupted secondary index named “option_name” (the corruption was a duplicate entry which is not allowed in indexes).
The only way to fix it without destroying everything is deleting that key and recreate it using commands
ALTER TABLE <NAME> DROP/ADD KEY <NAME>(PARAMS)