Rebuilding checksums broken with Integrity constraint violation: 1048 Column 'default_langcode' cannot be null

Created on 4 April 2023, about 2 years ago
Updated 26 February 2024, over 1 year ago

Problem/Motivation

Rebuilding checksums leads to:
Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'default_langcode' cannot be null: INSERT INTO "wd_media_field_data" ("mid", "vid", "bundle", "langcode", "status", "uid", "name", "thumbnail__target_id", "thumbnail__alt", "thumbnail__title", "thumbnail__width", "thumbnail__height", "created", "changed", "default_langcode", "revision_translation_affected", "content_translation_source", "content_translation_outdated", "duplicates_checksum") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18); Array ( [:db_insert_placeholder_0] => 489 [:db_insert_placeholder_1] => 489 [:db_insert_placeholder_2] => slide [:db_insert_placeholder_3] => en [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => generateImage_AhcIzb.gif [:db_insert_placeholder_7] => 702 [:db_insert_placeholder_8] => Comis luctus nutus occuro quibus suscipere tamen veniam vindico. [:db_insert_placeholder_9] => [:db_insert_placeholder_10] => 3287 [:db_insert_placeholder_11] => 1280 [:db_insert_placeholder_12] => [:db_insert_placeholder_13] => [:db_insert_placeholder_14] => [:db_insert_placeholder_15] => 1 [:db_insert_placeholder_16] => [:db_insert_placeholder_17] => [:db_insert_placeholder_18] => iqWeEOmxAds5g1fbJ9vZzoZW44bNYLWddukt6Sol-lE ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (Zeile 815 in /web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

I guess the reason is within one of the media files, but that shouldn't break rebuilding checksums.
Instead the iteration should be skipped and an error should be logged.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

2.0

Component

Code

Created by

🇩🇪Germany Anybody Porta Westfalica

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @Anybody
  • 🇩🇪Germany Anybody Porta Westfalica

    This was existing dummy content generated by devel_generate in Drupal 7 and migrated into Drupal 10. So won't be that easy to reproduce, perhaps we can solve this from the code side?

  • 🇩🇪Germany Anybody Porta Westfalica

    Just ran into this again in a different project. wd_ is our table prefix.

Production build 0.71.5 2024