Bug #103275 | MySQL starup hangs when used with memcached | ||
---|---|---|---|
Submitted: | 12 Apr 2021 5:41 | Modified: | 21 Apr 2021 12:02 |
Reporter: | Mershad Irani | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Memcached | Severity: | S2 (Serious) |
Version: | 8.0.23, 8.0.24 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[12 Apr 2021 5:41]
Mershad Irani
[20 Apr 2021 7:30]
MySQL Verification Team
Hello Mershad Irani, Thank you for the report and feedback. Could you please provide the configuration(my.cnf) details from your environment to reproduce this issue at our end? You may want to mark it as a private if you wish after posting here. Thank you. regards, Umesh
[20 Apr 2021 14:41]
Mershad Irani
Hi Umesh, Thank you for getting back. I am able to reproduce this with minimal configuration and no configuration specific to memcached. innodb_data_file_path = ibdata1:12M:autoextend innodb-file-per-table = 1 innodb_log_files_in_group = 2 innodb_log_file_size = 134217728 pid-file = <path> basedir = <path> datadir = <path> innodb-data-home-dir = <path> innodb-log-group-home-dir = <path> tmpdir = <path>
[21 Apr 2021 8:43]
MySQL Verification Team
Thank you for the details. Verified as described with 8.0.24 build. regards, Umesh
[21 Apr 2021 12:02]
Mershad Irani
Correction to the description: On further investigation, we found that this happens when there are a large number of tables and the tables are present in innodb_memcache.containers table and not in the mysql/innodb data dictionary. -- changes to -- On further investigation, we found that this happens when there are a large number of entries present in innodb_memcache.containers table. The issue is reproducible even if there are a no state entries innodb_memcache.containers table.
[30 Oct 2023 14:24]
OCA Admin
Contribution submitted via Github - Bug #103275: Fix startup hang when memcached enabled and DB has many tables (*) Contribution by Nicholas Othieno (Github lottaquestions, mysql-server/pull/500#issuecomment-1785241299): > Hi, thank you for your contribution. Please confirm this code is submitted under the terms of the OCA (Oracle''s Contribution Agreement) you have previously signed by cutting and pasting the following text as a comment: "I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it." Thanks This contribution is under the OCA signed by Amazon and covering submissions to the MySQL project.
Contribution: git_patch_1577283156.txt (text/plain), 11.05 KiB.
[6 Mar 14:56]
Nicholas Othieno
Hi MySQL Open source team, Checking on the status of the code contribution we sent. The bug is still appearing in MySQL 8.0.36. Would we be able to get feedback, on the submission?