The JSON object contains a key name that is too long

MySQL & MariaDB
1

In the proxysql error log have those errors:
2022-07-06 09:49:13 MySQL_Session.cpp:3989:handler_minus1_LogErrorDuringQuery(): [WARNING] Error during query on (10,172...*,3306,528547): 3151, The JSON object contains a key name that is too long.
What should be caused this issue?

2

https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html#error_er_json_key_too_big

In your JSON string, you have a key that is too large. Example:

{ 'this is a very long key which is causing an error': 'this is a value' }

You need to examine your JSON and reduce the key size.

1 Like