Problem/Motivation

After recent codebase and database updates ran, any cache reload results in:

Numeric value out of range: 1264 Out of range value for column 'fit' at row 3: INSERT INTO "router" ("name", "fit", "path", "pattern_outline", "number_parts", "route")

Steps to reproduce

Still debugging, but it is happening on a facets_query with 40+ parts (/node/{node}/{facets_query}/{f0}/{f1}/{f2}/…) (and entityqueue thrown in at the end somehow?)

Proposed resolution

Has to be something unique to this site/configuration for this error to never have made it onto the Internet before, but possibly there is something Drupal/Symfony could do to catch this problem, or simply change the fit column to a signed integer to push the problem out to even more extreme cases.

Remaining tasks

User interface changes

Introduced terminology

API changes

Data model changes

Release notes snippet

Comments

mlncn created an issue.

mlncn’s picture

mlncn commented

OK, so this was happening after a change in Entityqueue started getting the base path of canonical entity links from $entity_route->getPath(); instead of $entity_type->getLinkTemplate('canonical');, which triggered this error when combined with an admittedly horrific workaround in my facets_pretty_paths issue fork 3554818-no-query-embed. That workaround is only necessary due to the core bug / incomplete feature #2741939: Cannot use a / in route parameter