Jump to content

mysql-5.7 and lock table name on login


Recommended Posts

In December we upgraded to php7, and in April we upgraded to mysql-5.7, we also now have the ads server as an https with a certificate and the machine has ipv6 enabled.   Now when we login into the revive ads server we have a delayed login time,  after reviewing the debug log we found errors like this "Jun 01 09:26:54 -0700 OX-5930404e6f364 [  warning]  mysqli_query(): (42000/3057): Incorrect user-level lock name 'OA_auth.xxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'."  per some research it appears to be caused by mysql 5.7 the get_lock() maximum length of 64 characters is being exceeded.  How can I work around this so I can login and not get this error?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...