krispcbc Posted June 1, 2017 Report Share Posted June 1, 2017 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? Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted June 5, 2017 Report Share Posted June 5, 2017 Hi @krispcbc, What version of Revive Adserver are you running? I think this issue was hopefully fixed in Revive Adserver 4.0.2: https://github.com/revive-adserver/revive-adserver/issues/811 Quote Link to comment Share on other sites More sharing options...
krispcbc Posted June 7, 2017 Author Report Share Posted June 7, 2017 I upgraded the first week of May and just missed this update. I applied this update Monday and yes it is fixed. Thank you sorry I didn't notice the change. andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.