I am running Laravel Migration and this is how it looks on terminals
First Terminal – adding a column state_id on the click table which contains millions of records. state_id is nullable and has no default value with an index set on it
2024_04_29_125513_add_state_id_column_to_click_table
Schema::table('click', function (Blueprint $table) {
$table->foreignId('state_id')->nullable()->constrained('state')->after('country_id');
});
Second Terminal – running seeder for state table and it’s not linked to click table but it stuck because of the first process which is creating a new state_id column as it says in image waiting for table metadata lock
DatabaseSeedersCountryUsStateSeeder …………………………….. RUNNING