SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry for key 'tracker_cookies_uuid_unique'

[karlmonson]

I'm getting this issue when a user is visiting the same page multiple times. Any ideas for how to fix?

[jakebooy2]

I'm getting this issue too :/

[alexandreMesle]

I had this isssue too in a developpment environment, but emptying the cookies in the navigator solved the problem. I don't know if this problem can happen in production.

[emadrashad]

i think that this problem related to local development !

[felipesilvame]

Just figured that the cookie length is trimmed to 191 chars, some cookies has 244 chars, a simple fix is increasing the tracker_cookie uuid length to 244.

I've created a gist... Greetings!
https://gist.github.com/felipesilvame/c85ab9ab3805e9182a5f20a8d58125fa

Edit: this is a limitation for MySQL utf8mb4 limit...
https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

[MadMikeyB]

Thanks @felipesilvame - this helped a lot!