krispcbc Posted June 1, 2017 Report 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
andrewatfornax Posted June 5, 2017 Report 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
krispcbc Posted June 7, 2017 Author Report 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
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.