{"data":{"id":"magento2-40563","source":"github-pr","sourceRef":"magento/magento2#40563","title":"Fix: Increase IP column length for IPv6 support in admin_user_session","pr":{"number":40563,"url":"https://github.com/magento/magento2/pull/40563","author":"PaulMcGregory","mergedAt":"2026-03-27T13:51:00Z","mergeCommit":"6001f4306d801d3b44c7e9938c17990b68fa1164","headCommit":"a40f13677898ba31a0f4b9eb33490c71ed212514","baseRef":"2.4-develop","diffSha256":"3441ea8a19c15e8024d3c69c0d0be79ad5afcd68faf69a5edc942dae4cb60978"},"issues":[{"number":40570,"url":"https://github.com/magento/magento2/issues/40570","title":"[Issue] Fix: Increase IP column length for IPv6 support in admin_user_session","labels":["Area: Account","Component: Admin","Issue: Confirmed","Priority: P3","Progress: PR Created","Progress: done","Reported on 2.4.x","Reproduced on 2.4.x"],"kind":"pr-derived"}],"fixedIn":"2.4.9","containingTags":["2.4.9"],"reportedOn":null,"codeMatch":{"2.4.6":"clean","2.4.6-p1":"clean","2.4.6-p2":"clean","2.4.6-p3":"clean","2.4.6-p4":"clean","2.4.6-p5":"clean","2.4.6-p6":"clean","2.4.6-p7":"clean","2.4.6-p8":"clean","2.4.6-p9":"clean","2.4.6-p10":"clean","2.4.6-p11":"clean","2.4.6-p12":"clean","2.4.6-p13":"clean","2.4.6-p14":"clean","2.4.6-p15":"clean","2.4.7":"clean","2.4.7-p1":"clean","2.4.7-p2":"clean","2.4.7-p3":"clean","2.4.7-p4":"clean","2.4.7-p5":"clean","2.4.7-p6":"clean","2.4.7-p7":"clean","2.4.7-p8":"clean","2.4.7-p9":"clean","2.4.7-p10":"clean","2.4.8":"clean","2.4.8-p1":"clean","2.4.8-p2":"clean","2.4.8-p3":"clean","2.4.8-p4":"clean","2.4.8-p5":"clean","2.4.9":"conflict"},"affectedVersions":["2.4.6","2.4.6-p1","2.4.6-p2","2.4.6-p3","2.4.6-p4","2.4.6-p5","2.4.6-p6","2.4.6-p7","2.4.6-p8","2.4.6-p9","2.4.6-p10","2.4.6-p11","2.4.6-p12","2.4.6-p13","2.4.6-p14","2.4.6-p15","2.4.7","2.4.7-p1","2.4.7-p2","2.4.7-p3","2.4.7-p4","2.4.7-p5","2.4.7-p6","2.4.7-p7","2.4.7-p8","2.4.7-p9","2.4.7-p10","2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5"],"components":["magento/module-security"],"files":[{"path":"app/code/Magento/Security/etc/db_schema.xml","change":"modified","package":"magento/module-security"}],"stripped":{"tests":[],"docs":[],"outsideCode":[]},"linesChanged":4,"mergeBatched":false,"excluded":null,"sections":{"description":null,"stepsToReproduce":null,"expectedResult":null,"actualResult":null,"source":null},"signatures":[],"labels":{"area":["Account"],"component":["Admin"],"priority":"P3","severity":null,"reportedOn":["2.4.x"]},"categories":["Admin"],"triage":{"model":"@cf/cloudflare/clef","requestHash":"cff97857b69f668c60e1d1f1a16b4fb971de1a8454ac03568819f2105dfa9edb","isBugfix":0.9456,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.9279,"feature":0.0259,"refactor":0.0231,"tests_only":0.0079,"docs_only":0.0063,"dependency":0.0089},"confidence":0.8349},"scope":{"score":0.1527,"probabilities":{"0":0.8822,"1":0.0828,"2":0.035},"confidence":0.6797},"risk":{"score":1.4951,"probabilities":{"0":0.2206,"1":0.0637,"2":0.7157},"confidence":0.3475},"area":{"choice":"admin","probabilities":{"catalog":0.0179,"checkout":0.0184,"customer":0.2472,"admin":0.5461,"graphql_api":0.0136,"framework":0.0807,"frontend":0.0151,"other":0.061},"confidence":0.2808},"securityRelevant":0.9135,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.0036,"2.4.0-p1":0.0039,"2.4.1":0.0033,"2.4.1-p1":0.003,"2.4.2":0.0042,"2.4.2-p1":0.0044,"2.4.2-p2":0.0051,"2.4.3":0.0084,"2.4.3-p1":0.0091,"2.4.3-p2":0.0093,"2.4.3-p3":0.0064,"2.4.4":0.01,"2.4.4-p1":0.0067,"2.4.4-p10":0.0052,"2.4.4-p11":0.0064,"2.4.4-p12":0.0056,"2.4.4-p13":0.0058,"2.4.4-p14":0.0075,"2.4.4-p15":0.005,"2.4.4-p16":0.0065,"2.4.4-p17":0.0056,"2.4.4-p18":0.0042,"2.4.4-p2":0.0023,"2.4.4-p3":0.0026,"2.4.4-p4":0.0026,"2.4.4-p5":0.0032,"2.4.4-p6":0.0039,"2.4.4-p7":0.0037,"2.4.4-p8":0.0036,"2.4.4-p9":0.0034,"2.4.5":0.0164,"2.4.5-p1":0.0094,"2.4.5-p10":0.0071,"2.4.5-p11":0.0131,"2.4.5-p12":0.0095,"2.4.5-p13":0.0075,"2.4.5-p14":0.0086,"2.4.5-p15":0.0068,"2.4.5-p16":0.0083,"2.4.5-p17":0.0078,"2.4.5-p2":0.0028,"2.4.5-p3":0.0041,"2.4.5-p4":0.0041,"2.4.5-p5":0.0034,"2.4.5-p6":0.0056,"2.4.5-p7":0.0054,"2.4.5-p8":0.0049,"2.4.5-p9":0.0046,"2.4.6":0.0349,"2.4.6-p1":0.0243,"2.4.6-p10":0.0111,"2.4.6-p11":0.0152,"2.4.6-p12":0.0135,"2.4.6-p13":0.0109,"2.4.6-p14":0.0108,"2.4.6-p15":0.0082,"2.4.6-p2":0.0049,"2.4.6-p3":0.0072,"2.4.6-p4":0.0075,"2.4.6-p5":0.0081,"2.4.6-p6":0.012,"2.4.6-p7":0.0088,"2.4.6-p8":0.0065,"2.4.6-p9":0.0052,"2.4.7":0.0187,"2.4.7-p1":0.0237,"2.4.7-p10":0.0103,"2.4.7-p2":0.0088,"2.4.7-p3":0.0123,"2.4.7-p4":0.0188,"2.4.7-p5":0.0133,"2.4.7-p6":0.0187,"2.4.7-p7":0.0139,"2.4.7-p8":0.0107,"2.4.7-p9":0.0071,"2.4.8":0.0337,"2.4.8-p1":0.0266,"2.4.8-p2":0.0263,"2.4.8-p3":0.0209,"2.4.8-p4":0.0168,"2.4.8-p5":0.016,"2.4.9":0.0224,"unspecified":0.208},"confidence":0.0434},"backportWorthy":{"score":1.4225,"probabilities":{"0":0.1095,"1":0.3585,"2":0.532},"confidence":0.1353}},"curated":{"title":"Increases the admin_user_session ip column length so IPv6 addresses fit","description":"The ip column in admin_user_session was limited to 15 characters, which is insufficient for IPv6 addresses (up to 45 characters) and can lead to data truncation or errors. The fix increases the ip column length to 45 in the Security db_schema.xml, for admin_user_session and one more table in that file.","categories":["Admin"],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":null},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-40563 details"}