Migrations fail in a fresh development environment

[thilobillerbeck]

Describe the bug

When setting up a development environment with either the general purpose (1) guide or using the docker method (2) the migrations fail with the following error:

2024_05_21_000000_make_ibnr_nullable_on_stations .................................................................................... 31.59ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[HY000]: General error: 1833 Cannot change column 'ibnr': used in a foreign key constraint 'hafas_trips_destination_foreign' of table 'homestead.hafas_trips' (Connection: mysql, SQL: alter table `train_stations` modify `ibnr` bigint unsigned null)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
    821▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    822▕                 );
    823▕             }
    824▕ 
  ➜ 825▕             throw new QueryException(
    826▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    827▕             );
    828▕         }
    829▕     }

      +9 vendor frames 

  10  database/migrations/2024_05_21_000000_make_ibnr_nullable_on_stations.php:10
      Illuminate\Support\Facades\Facade::__callStatic("table")
      +25 vendor frames 

  36  artisan:35
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

Steps to reproduce

1. Clone the repo
2. Set up a docker environment either with everything in docker ort just the DB
3. choose the mariadb:10 or mariadb:11 container
4. Follow the general purpose or the docker guide until the migration happens
5. start a fresh migrationn with php artisan migrate or php artisan migrate:fresh --seed

Tools

• Mariadb 10/11
• PHP 8.3.15
• NodeJS 22.11.0
• Fedora 41 (Aurora Linux) / x86_64

[MrKrisKrisu]

I cannot reproduce this - it's working on my machine on current develop with

➜  traewelling git:(develop) mariadb --version
mariadb  Ver 15.1 Distrib 10.11.8-MariaDB, for debian-linux-gnu (x86_64)

➜  traewelling git:(dev-ks/moderation) php artisan migrate:fresh --seed

  Dropping all tables ................................................................................................................. 97.88ms DONE

   INFO  Preparing database.  

  Creating migration table ............................................................................................................. 7.99ms DONE

   INFO  Running migrations.  

  2014_10_12_000000_create_users_table ................................................................................................ 10.38ms DONE
  2014_10_12_100000_create_password_resets_table ....................................................................................... 7.37ms DONE
  2016_06_01_000001_create_oauth_auth_codes_table ...................................................................................... 3.32ms DONE
  2016_06_01_000002_create_oauth_access_tokens_table ................................................................................... 7.20ms DONE
  2016_06_01_000003_create_oauth_refresh_tokens_table .................................................................................. 7.40ms DONE
  2016_06_01_000004_create_oauth_clients_table ......................................................................................... 7.15ms DONE
  2016_06_01_000005_create_oauth_personal_access_clients_table ......................................................................... 3.16ms DONE
  2018_02_05_000000_create_queue_monitor_table ........................................................................................ 20.59ms DONE
  2019_08_06_184725_create_social_login_profiles_table ................................................................................. 3.16ms DONE
  2019_08_09_003647_create_statuses_table .............................................................................................. 3.05ms DONE
  2019_08_09_003814_create_likes_table ................................................................................................. 3.23ms DONE
  2019_08_09_003837_create_follows_table ............................................................................................... 3.12ms DONE
  2019_08_11_233556_create_mastodon_servers_table ...................................................................................... 7.08ms DONE
  2019_08_13_155546_create_hafas_trips_table ........................................................................................... 3.91ms DONE
  2019_08_13_162744_create_train_stations_table ........................................................................................ 7.22ms DONE
  2019_08_14_013806_create_train_checkins_table ........................................................................................ 7.76ms DONE
  2019_08_19_173342_create_sessions_table .............................................................................................. 8.21ms DONE
  2019_11_04_200120_create_privacy_agreements_table .................................................................................... 3.59ms DONE
  2019_11_22_220440_create_poly_lines_table ........................................................................................... 10.15ms DONE
  2019_12_14_130742_create_events_table ................................................................................................ 9.54ms DONE
  2019_12_18_222050_connect_statuses_and_events ........................................................................................ 4.43ms DONE
  2019_12_20_221724_create_user_roles .................................................................................................. 4.45ms DONE
  2020_02_20_162218_create_notifications_table ......................................................................................... 7.00ms DONE
  2020_08_05_151702_change_train_station_table ........................................................................................ 12.80ms DONE
  2020_09_27_190346_migrate_laravel_passport_to_v9 ..................................................................................... 2.26ms DONE
  2020_09_28_150313_migrate_notifications_to_laravel8 .................................................................................. 2.04ms DONE
  2020_09_28_170000_add_foreign_keys_to_social_login_profiles ......................................................................... 23.48ms DONE
  2020_09_28_170001_unify_columns_from_train_stations .................................................................................. 6.92ms DONE
  2020_09_28_170002_add_foreign_keys_to_events ......................................................................................... 0.07ms DONE
  2020_09_28_170003_add_foreign_keys_to_follows ....................................................................................... 24.87ms DONE
  2020_09_28_170004_add_keys_to_poly_lines ............................................................................................. 4.69ms DONE
  2020_09_28_170005_add_foreign_keys_to_hafas_trips ................................................................................... 29.11ms DONE
  2020_09_28_170006_add_foreign_keys_to_likes ......................................................................................... 23.12ms DONE
  2020_09_28_170007_add_foreign_keys_to_sessions ....................................................................................... 6.86ms DONE
  2020_09_28_170008_add_foreign_keys_to_statuses ...................................................................................... 18.01ms DONE
  2020_09_28_170009_add_foreign_keys_to_train_checkins ................................................................................ 42.15ms DONE
  2020_09_28_170010_add_foreign_keys_to_users ......................................................................................... 17.15ms DONE
  2020_10_05_184500_add_unique_key_to_events ........................................................................................... 4.82ms DONE
  2020_10_16_175602_add_unique_key_to_likes ............................................................................................ 4.41ms DONE
  2020_11_18_101929_add_user_private_profile_key ....................................................................................... 4.89ms DONE
  2021_01_26_203951_create_train_stopovers_table ...................................................................................... 20.87ms DONE
  2021_02_01_000000_add_unique_key_to_poly_lines ....................................................................................... 4.39ms DONE
  2021_02_15_000000_create_ics_tokens_table ........................................................................................... 14.66ms DONE
  2021_02_20_155443_remove_static_points_from_users .................................................................................... 4.62ms DONE
  2021_02_20_213248_add_ril_identifier_to_train_stations ............................................................................... 5.09ms DONE
  2021_02_23_170640_create_hafas_operators_table ....................................................................................... 7.66ms DONE
  2021_02_23_171038_add_hafas_operator_to_hafas_trips ................................................................................. 10.93ms DONE
  2021_02_23_185026_change_avatar_to_be_null_on_users .................................................................................. 7.10ms DONE
  2021_04_21_102707_change_statuses_to_accept_business_checkin_as_integer .............................................................. 6.98ms DONE
  2021_04_28_230708_add_last_accessed_and_name_to_ics_tokens ........................................................................... 7.19ms DONE
  2021_04_29_150026_create_follow_requests_table ...................................................................................... 18.92ms DONE
  2021_05_01_165202_add_privacy_search_engine_to_users ................................................................................. 3.87ms DONE
  2021_05_10_201216_add_language_to_users .............................................................................................. 3.87ms DONE
  2021_05_12_211411_create_user_mutes_table ........................................................................................... 21.10ms DONE
  2021_05_26_134022_remove_train_distance_and_duration_from_users ...................................................................... 4.42ms DONE
  2021_05_26_172817_create_event_suggestions_table .................................................................................... 16.15ms DONE
  2021_06_07_145349_add_visibility_to_statuses ......................................................................................... 4.53ms DONE
  2021_06_08_200223_add_index_to_sessions_table ....................................................................................... 19.98ms DONE
  2021_07_03_222039_add_last_login_to_users ............................................................................................ 5.98ms DONE
  2021_07_04_002719_drop_points_calculation_table ...................................................................................... 3.53ms DONE
  2021_07_24_124933_create_default_visibility_on_users ................................................................................. 4.89ms DONE
  2021_08_05_211128_change_column_for_train_checkins ................................................................................... 7.92ms DONE
  2021_08_05_214231_remove_delay_from_train_checkins ................................................................................... 4.41ms DONE
  2021_08_05_220132_add_user_id_to_train_checkins ..................................................................................... 10.99ms DONE
  2021_10_08_132506_make_twitter_id_unique_in_social_login_profiles .................................................................... 4.43ms DONE
  2021_10_08_160350_add_foreign_key_to_social_login_profiles .......................................................................... 12.83ms DONE
  2021_10_12_143849_drop-blogposts-table ............................................................................................... 2.44ms DONE
  2021_11_03_211948_add_unique_key_to_train_checkins ................................................................................... 4.71ms DONE
  2021_11_06_193343_make_url_nullable_at_events ....................................................................................... 11.88ms DONE
  2021_12_14_143156_add_user_arrival_index_to_train_checkins ........................................................................... 4.32ms DONE
  2022_01_06_224610_add_index_to_train_stopovers ....................................................................................... 4.58ms DONE
  2022_01_06_230418_add_index_to_hafas_trips ........................................................................................... 5.51ms DONE
  2022_03_03_104050_add_cancelled_attribute_to_stopover ................................................................................ 4.46ms DONE
  2022_03_07_000000_add_hide_status_days_to_users ...................................................................................... 4.37ms DONE
  2022_03_11_000000_migrate_train_checkin_category .................................................................................... 10.56ms DONE
  2022_03_18_000000_migrate_encryptables ............................................................................................... 6.76ms DONE
  2022_03_28_000000_add_support_code_to_users .......................................................................................... 5.09ms DONE
  2022_03_29_000000_add_index_to_train_stopovers ....................................................................................... 4.64ms DONE
  2022_04_01_000000_remove_support_code_from_users ..................................................................................... 4.47ms DONE
  2022_04_02_000000_change_unique_key_to_support_multiple_stopovers_per_station ....................................................... 12.60ms DONE
  2022_04_02_000000_create_remarks_table ............................................................................................... 3.32ms DONE
  2022_04_02_000001_create_trip_remarks_table ......................................................................................... 19.53ms DONE
  2022_04_03_000000_create_user_agents_table ........................................................................................... 7.49ms DONE
  2022_04_03_000001_create_api_logs_table ............................................................................................. 13.63ms DONE
  2022_04_07_085923_change_status_code_datatype_in_api_logs_table ...................................................................... 7.33ms DONE
  2022_05_22_000000_add_station_id_to_events ........................................................................................... 0.08ms DONE
  2022_05_29_000000_create_carriage_sequences_table ................................................................................... 22.29ms DONE
  2022_06_04_000000_create_jobs_table .................................................................................................. 7.43ms DONE
  2022_06_04_000001_make_order_number_nullable_at_carriage_sequences ................................................................... 6.08ms DONE
  2022_07_21_000000_add_index_to_api_logs ............................................................................................. 12.82ms DONE
  2022_07_21_000001_add_index_to_user_agents ........................................................................................... 4.89ms DONE
  2022_07_23_000000_add_forced_to_train_checkins ....................................................................................... 4.64ms DONE
  2022_08_31_000000_add_last_refreshed_to_hafas_trips .................................................................................. 5.14ms DONE
  2022_08_31_000001_add_index2_to_train_stopovers ..................................................................................... 16.71ms DONE
  2022_09_08_000000_create_locations_table ............................................................................................. 3.17ms DONE
  2022_09_25_000000_create_cache_table ................................................................................................. 6.17ms DONE
  2022_09_26_000000_fill_planned_departure_and_arrival_at_train_stopovers .............................................................. 1.60ms DONE
  2022_09_26_000001_add_tweet_id_to_statuses ........................................................................................... 3.92ms DONE
  2022_10_11_000000_create_failed_jobs_table ........................................................................................... 7.61ms DONE
  2022_10_17_000000_default_uuid_field ................................................................................................. 3.83ms DONE
  2022_10_22_000000_add_unique_key_to_train_stopovers .................................................................................. 9.59ms DONE
  2022_11_25_223003_add_toot_id_to_status_table ........................................................................................ 4.35ms DONE
  2022_12_11_000000_drop_trip_remarks .................................................................................................. 3.30ms DONE
  2022_12_11_000001_drop_remarks ....................................................................................................... 2.49ms DONE
  2022_12_23_000000_create_status_tags_table .......................................................................................... 16.06ms DONE
  2022_12_25_000000_create_user_blocks_table .......................................................................................... 19.15ms DONE
  2022_19_10_000000_add_twitter_refresh_token .......................................................................................... 8.53ms DONE
  2023_01_08_202020_remove_always_dbl_flag_from_users_table ............................................................................ 4.20ms DONE
  2023_01_21_000000_add_journey_number_to_hafas_trips .................................................................................. 4.34ms DONE
  2023_01_28_000000_migrate_passport_from_v7_to_v8 ..................................................................................... 3.76ms DONE
  2023_01_30_173822_add_scopes_to_existing_oauth_access_tokens ......................................................................... 0.72ms DONE
  2023_02_04_184426_extend_oauth_clients_with_custom_data ............................................................................. 11.85ms DONE
  2023_02_07_202300_add_mastodon_visibility_field_to_social_login_profiles_table ....................................................... 4.86ms DONE
  2023_02_11_000000_remove_api_usage ................................................................................................... 2.84ms DONE
  2023_02_11_000001_remove_locations_table ............................................................................................. 2.72ms DONE
  2023_03_01_000000_update_queue_monitor_table ........................................................................................ 10.38ms DONE
  2023_03_06_000000_add_override_arrival_and_departure_to_train_checkins ............................................................... 7.75ms DONE
  2023_03_23_000000_add_index_to_train_checkins ........................................................................................ 4.51ms DONE
  2023_03_23_000000_migrate_oauth_access_tokens ....................................................................................... 11.83ms DONE
  2023_03_23_000000_migrate_oauth_auth_codes .......................................................................................... 16.70ms DONE
  2023_03_23_000000_migrate_oauth_clients ............................................................................................. 13.83ms DONE
  2023_03_23_000000_migrate_oauth_personal_access_clients .............................................................................. 6.36ms DONE
  2023_03_23_000001_add_index_to_users ................................................................................................. 4.73ms DONE
  2023_03_23_000002_add_index_to_train_stations ........................................................................................ 4.41ms DONE
  2023_03_23_000003_create_webhooks_table ............................................................................................. 16.93ms DONE
  2023_03_23_000004_create_webhook_creation_requests_table ............................................................................ 15.38ms DONE
  2023_03_23_215105_change_index_at_train_checkins ..................................................................................... 7.89ms DONE
  2023_04_25_000000_add_source_to_poly_lines ........................................................................................... 4.38ms DONE
  2023_05_03_144452_add_job_uuid_and_retried_to_queue_monitor_table .................................................................... 7.77ms DONE
  2023_05_05_000000_drop_carriage_sequences ............................................................................................ 2.46ms DONE
  2023_05_07_135454_add_likes_enabled_field_to_users_table ............................................................................. 4.50ms DONE
  2023_05_09_000000_make_station_id_null_on_events ..................................................................................... 6.95ms DONE
  2023_05_10_000000_default_uuid_field ................................................................................................. 3.68ms DONE
  2023_06_06_000000_delete_all_notifications ........................................................................................... 0.31ms DONE
  2023_06_09_161642_add_mapprovider_field_to_users_table ............................................................................... 4.80ms DONE
  2023_06_13_213444_expand_event_date_restrictions .................................................................................... 17.08ms DONE
  2023_07_06_201721_rename_legacy_stopovers ............................................................................................ 4.30ms DONE
  2023_07_07_183520_add_timezone_to_users .............................................................................................. 4.27ms DONE
  2023_07_08_090008_add_time_information_to_stations ................................................................................... 7.15ms DONE
  2023_07_09_000000_make_hashtag_nullable_on_events .................................................................................... 6.87ms DONE
  2023_07_13_144452_add_queued_at_column_to_queue_monitor_table ........................................................................ 4.18ms DONE
  2023_07_24_000000_add_user_mastodon_index_to_statuses ................................................................................ 4.71ms DONE
  2023_07_26_000000_add_duration_to_train_checkins ..................................................................................... 4.58ms DONE
  2023_08_06_000000_rename_manual_arrival_and_departure_at_train_checkins .............................................................. 8.32ms DONE
  2023_08_06_000001_add_hashtag_to_event_suggestions ................................................................................... 4.12ms DONE
  2023_08_06_000002_rename_station_id_at_event_suggestions ............................................................................. 3.78ms DONE
  2023_08_19_160842_add_webhook_events_table ........................................................................................... 8.36ms DONE
  2023_08_19_161454_migrate_webhook_events_from_bitmasks_to_table ...................................................................... 1.04ms DONE
  2023_08_19_174051_drop_webhook_events_column ......................................................................................... 3.86ms DONE
  2023_09_22_194607_add_experimental_setting_to_users .................................................................................. 3.95ms DONE
  2023_09_23_162754_add-parent-to-polylines ........................................................................................... 11.07ms DONE
  2023_11_20_000000_drop_user_agents ................................................................................................... 2.33ms DONE
  2023_11_20_000001_drop_locations ..................................................................................................... 1.97ms DONE
  2023_11_20_000002_drop_remarks ....................................................................................................... 2.11ms DONE
  2023_11_21_000000_drop_twitter_secrets ............................................................................................... 3.76ms DONE
  2023_11_21_000001_create_permission_tables .......................................................................................... 66.36ms DONE
  2023_11_21_000003_drop_role_from_users ............................................................................................... 4.34ms DONE
  2023_11_21_000004_drop_experimental_from_users ....................................................................................... 3.79ms DONE
  2023_11_22_000000_add_source_to_trips ................................................................................................ 5.04ms DONE
  2023_11_23_000000_remove_type_from_statuses .......................................................................................... 3.63ms DONE
  2023_11_23_000001_fix_departure_column_on_train_checkins ............................................................................ 14.20ms DONE
  2023_11_23_000002_add_user_id_to_hafas_trips ........................................................................................ 10.10ms DONE
  2023_11_27_000000_drop_delay_column_in_hafas_trips ................................................................................... 2.15ms DONE
  2023_12_17_000000_create_activity_log_table ......................................................................................... 16.37ms DONE
  2023_12_17_000001_add_event_column_to_activity_log_table ............................................................................. 3.99ms DONE
  2023_12_17_000002_add_batch_uuid_column_to_activity_log_table ........................................................................ 3.60ms DONE
  2023_12_18_000000_add_origin_and_destination_stopover_foreign_to_train_checkins ..................................................... 22.50ms DONE
  2023_12_20_000000_migrate_stopover_relation_id_in_train_checkins ..................................................................... 2.08ms DONE
  2023_12_29_000000_add_client_id_to_statuses ......................................................................................... 10.52ms DONE
  2024_01_30_000001_create_reports_table .............................................................................................. 18.69ms DONE
  2024_02_08_000000_create_mentions_table ............................................................................................. 23.46ms DONE
  2024_03_01_000000_create_wikidata_entities_table ..................................................................................... 4.07ms DONE
  2024_03_01_000001_add_wikidata_id_to_stations ....................................................................................... 12.47ms DONE
  2024_03_10_211526_add_ifopt_to_stations ............................................................................................. 29.67ms DONE
  2024_03_22_000000_add_origin_and_destination_id_to_trips ............................................................................ 27.97ms DONE
  2024_03_22_000001_migrate_origin_and_destination_id_in_trips ......................................................................... 2.04ms DONE
  2024_03_22_000002_make_trip_origin_id_and_destination_id_not_nullable ............................................................... 15.75ms DONE
  2024_04_19_131906_add_index_to_poly_line_parent_id ................................................................................... 6.16ms DONE
  2024_05_21_000000_make_ibnr_nullable_on_stations ..................................................................................... 8.50ms DONE
  2024_05_21_000001_remove_station_ibnr_from_hafas_trips .............................................................................. 18.25ms DONE
  2024_05_22_000003_drop_origin_destination_from_check_in ............................................................................. 23.97ms DONE
  2024_05_22_000004_add_index_operator_id_category_to_hafas_trips ...................................................................... 5.85ms DONE
  2024_05_22_000005_add_index_name_status_queue_on_queue_monitor ....................................................................... 5.39ms DONE
  2024_05_22_000008_add_index_user_id_visibility_on_statuses ........................................................................... 5.83ms DONE
  2024_05_25_000000_add_source_index_to_polylines ...................................................................................... 5.87ms DONE
  2024_05_25_000001_add_trip_id_arrival_departure_index_to_train_stopovers ............................................................. 4.47ms DONE
  2024_05_27_000000_drop_shadow_banned_from_users ...................................................................................... 2.22ms DONE
  2024_05_30_000000_add_prefix_to_begin_end_on_events ................................................................................. 41.14ms DONE
  2024_06_28_000000_add_friend_checkin_setting_to_users ................................................................................ 5.63ms DONE
  2024_07_07_000000_make_display_name_not_nullable_at_users ............................................................................ 8.19ms DONE
  2024_07_07_000000_set_size_of_username_at_users ..................................................................................... 10.03ms DONE
  2024_07_14_081815_add_points_setting_to_users ........................................................................................ 4.94ms DONE
  2024_07_28_000001_add_trusted_users_table ........................................................................................... 27.36ms DONE
  2024_07_30_000000_add_admin_notification_id_to_reports ............................................................................... 4.94ms DONE
  2024_08_07_000000_create_station_names_table ........................................................................................ 15.36ms DONE
  2024_08_07_000001_drop_foreign_wikidata_entity_on_station ............................................................................ 4.22ms DONE
  2024_08_07_000002_drop_wikidata_entities ............................................................................................. 3.06ms DONE
  2024_08_11_000000_drop_tweet_id_from_statuses ........................................................................................ 4.28ms DONE
  2024_08_13_000000_add_admin_notification_id_to_event_suggestions ..................................................................... 4.69ms DONE
  2025_01_08_000000_add_source_to_stations ............................................................................................. 4.79ms DONE
  2025_01_08_000001_what_the_fuck_twitter_id .......................................................................................... 24.09ms DONE


   INFO  Seeding database.  

  Database\Seeders\Constants\PermissionSeeder .............................................................................................. RUNNING  
  Database\Seeders\Constants\PermissionSeeder .......................................................................................... 115 ms DONE  

  Database\Seeders\UsersTableSeeder ........................................................................................................ RUNNING  
  Database\Seeders\UsersTableSeeder .................................................................................................... 631 ms DONE  

  Database\Seeders\ClientSeeder ............................................................................................................ RUNNING  
  Database\Seeders\ClientSeeder .......................................................................................................... 4 ms DONE  

  Database\Seeders\FollowTableSeeder ....................................................................................................... RUNNING  
  Database\Seeders\FollowTableSeeder ..................................................................................................... 2 ms DONE  

  Database\Seeders\EventSeeder ............................................................................................................. RUNNING  
  Database\Seeders\EventSeeder .......................................................................................................... 19 ms DONE  

  Database\Seeders\CheckinSeeder ........................................................................................................... RUNNING  
  Database\Seeders\CheckinSeeder ....................................................................................................... 285 ms DONE  

  Database\Seeders\PrivacyAgreementSeeder .................................................................................................. RUNNING  
  Database\Seeders\PrivacyAgreementSeeder ................................................................................................ 2 ms DONE  

[HerrLevin]

I can fully recreate it inside docker but I don't know why this happens.

On the left side you can see my migration log on bare metal, on the right side the log out of docker. They're identical up until the failure. I also use mariaDB on bare metal.