I have such a json structure in the payload field

 { "opened": "none", "shopId": "158" }

The task is to calculate how many errors in each store according to the log table. I make such a request:

 "SELECT count(*) as count, JSON_VALUE(payload, '$.shopId') as shopId FROM warning_logs group by JSON_VALUE(payload, '$.shopId')"

I get the error:

 Unhandled exception: SQL error: HY000 1548 Cannot load from mysql.proc. The table is probably corrupted. SQL: SELECT count(*) as count, JSON_VALUE(payload, '$.shopId') as shopId FROM `warning_logs` where module = 'Shop' group by JSON_VALUE(payload, '$.shopId')

advise how to get out of the situation

  • The table is probably corrupted. - Do you have a live table at all? If yes, then most likely your version of MySQL server does not support this functionality. - Axenow
  • the table is live. probably the reason in the configuration or the old version of muscle - Pavel Zolotarev

0