Postgres error 500 on paths when supplied entity ID gte 2147483647 and lte 9223372036854776832

# MySQL passes SIMPLETEST_DB=mysql://drupal9:drupal9@database/drupal9 php /app/web/vendor/bin/phpunit -c /app/phpunit.xml web/core/tests/Drupal/FunctionalTests/Routing --filter EntityIdValidationTest # SQLite passes SIMPLETEST_DB=sqlite://tmp/test.sqlite php /app/web/vendor/bin/phpunit -c /app/phpunit.xml web/core/tests/Drupal/FunctionalTests/Routing --filter EntityIdValidationTest # Postgres fails SIMPLETEST_DB=pgsql://postgres:postgres@postgres:5432/database php /app/web/vendor/bin/phpunit -c /app/phpunit.xml web/core/tests/Drupal/FunctionalTests/Routing --filter EntityIdValidationTest

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment almost 2 years ago →
🇷🇺Russia Chi
@andypost, how could this duplicate 🐛 Database primary keys can exceed maximum integer storeable (has actually occurred, in watchdog) Fixed ? The problem described here still exists. Even though 🐛 Database primary keys can exceed maximum integer storeable (has actually occurred, in watchdog) Fixed is marked as fixed.
Status changed to Needs review almost 2 years ago1:22pm 16 May 2023
Open in Jenkins → Open on Drupal.org →
Environment: PHP 8.1 & MySQL 5.7
last update almost 2 years ago
29,383 pass, 2 fail
Comment almost 2 years ago →
🇷🇺Russia Chi
@daffie, this issue is specifically about content entity IDs. So we can fix on entity storage level.

The patch sets upper limit for allowed entity IDs.

The only concern here is possible BC break. MySQL unsigned int has two times bigger range. So that, theoretically there could be Drupal sites that have entity IDs bigger than 2147483647.
Comment almost 2 years ago →
System Message
The last submitted patch, 21: postgres_entity_key_limit-3327520-21.patch, failed testing. View results →

Postgres error 500 on paths when supplied entity ID gte 2147483647 and lte 9223372036854776832

Problem/Motivation

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Comments & Activities