# The JSON object contains a key name that is too long

**URL:** <https://forums.percona.com/t/the-json-object-contains-a-key-name-that-is-too-long/16453>\
**Category:** MySQL & MariaDB\
**Created:** [July 6, 2022, 11:13am UTC](https://forums.percona.com/t/the-json-object-contains-a-key-name-that-is-too-long/16453 "2022-07-06T11:13:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nanuka](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@Nanuka](https://forums.percona.com/u/Nanuka)\
**Post date:** [July 6, 2022, 11:13am UTC](https://forums.percona.com/t/the-json-object-contains-a-key-name-that-is-too-long/16453/1 "2022-07-06T11:13:40Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 6, 2022, 3:39pm UTC](https://forums.percona.com/t/the-json-object-contains-a-key-name-that-is-too-long/16453/2 "2022-07-06T15:39:32Z")

</div>

[https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html#error\_er\_json\_key\_too\_big](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.