Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in using IPv6 in session database driver MySQL 5.7 #4916

Closed
karenbchelp opened this issue Nov 22, 2016 · 0 comments
Closed

Error in using IPv6 in session database driver MySQL 5.7 #4916

karenbchelp opened this issue Nov 22, 2016 · 0 comments
Labels
Milestone

Comments

@karenbchelp
Copy link

Hi!

I am getting this error:

ERROR - 2016-11-20 09:59:03 --> Severity: Warning --> mysqli::query(): (42000/3057): Incorrect user-level lock name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_xxxx:xxxx:xxxx:x:xxx:xxxx:xxxx:xxxx'. /var/www/0/136120/www/system/database/drivers/mysqli/mysqli_driver.php 305 ERROR - 2016-11-20 09:59:03 --> Query error: Incorrect user-level lock name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_xxxx:xxxx:xxxx:x:xxx:xxxx:xxxx:xxxx'. - Invalid query: SELECT GET_LOCK('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_xxxx:xxxx:xxxx:x:xxx:xxxx:xxxx:xxxx', 300) AS ci_session_lock ERROR - 2016-11-20 09:59:03 --> Severity: Error --> Call to a member function row() on boolean /var/www/0/136120/www/system/libraries/Session/drivers/Session_database_driver.php 358

My guess is that the lock name string exceed the get_lock() maximum length of 64 characters that was implemented in MySQL 5.7. I am not getting this error when a user is using IPv4 since it does not make the lock name exceed 64 characters but when a user is using IPv6 it exceeds the limit.

Is there a way I could still use IPv6 in the session database driver?

@narfbg narfbg added the Bug label Nov 22, 2016
@narfbg narfbg added this to the 3.1.3 milestone Nov 22, 2016
narfbg added a commit that referenced this issue Nov 22, 2016
@narfbg narfbg closed this as completed Nov 22, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants