Server crashes during laravel migration running

2024-10-14 11:53:20 2024-10-14  9:53:20 6 [ERROR] InnoDB: preallocating 98304 bytes for file ./poseidon/app_tour_shift_definitions.ibd failed with error 2

2024-10-14 11:53:20 2024-10-14 09:53:20 0x7f87bc07c6c0  InnoDB: Assertion failure in file ./storage/innobase/fil/fil0fil.cc line 629

2024-10-14 11:53:20 InnoDB: Failing assertion: fsize != os_offset_t(-1)

2024-10-14 11:53:20 InnoDB: We intentionally generate a memory trap.

2024-10-14 11:53:20 InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2024-10-14 11:53:20 InnoDB: If you get repeated assertion failures or crashes, even

2024-10-14 11:53:20 InnoDB: immediately after the mariadbd startup, there may be

2024-10-14 11:53:20 InnoDB: corruption in the InnoDB tablespace. Please refer to

2024-10-14 11:53:20 InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/

2024-10-14 11:53:20 InnoDB: about forcing recovery.

2024-10-14 11:53:20 241014  9:53:20 [ERROR] mysqld got signal 6 ;

2024-10-14 11:53:20 Sorry, we probably made a mistake, and this is a bug.

2024-10-14 11:53:20 

2024-10-14 11:53:20 Your assistance in bug reporting will enable us to fix this for the next release.

2024-10-14 11:53:20 To report this bug, see https://mariadb.com/kb/en/reporting-bugs

2024-10-14 11:53:20 

2024-10-14 11:53:20 We will try our best to scrape up some info that will hopefully help

2024-10-14 11:53:20 diagnose the problem, but since we have already crashed, 

2024-10-14 11:53:20 something is definitely wrong and this may fail.

2024-10-14 11:53:20 

2024-10-14 11:53:20 Server version: 11.4.3-MariaDB-ubu2404 source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3

2024-10-14 11:53:20 key_buffer_size=134217728

2024-10-14 11:53:20 read_buffer_size=131072

2024-10-14 11:53:20 max_used_connections=2

2024-10-14 11:53:20 max_threads=153

2024-10-14 11:53:20 thread_count=2

2024-10-14 11:53:20 It is possible that mysqld could use up to 

2024-10-14 11:53:20 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468068 K  bytes of memory

2024-10-14 11:53:20 Hope that's ok; if not, decrease some variables in the equation.

2024-10-14 11:53:20 

2024-10-14 11:53:20 Thread pointer: 0x7f8764000c68

2024-10-14 11:53:20 Attempting backtrace. You can use the following information to find out

2024-10-14 11:53:20 where mysqld died. If you see no messages after this, something went

2024-10-14 11:53:20 terribly wrong...

2024-10-14 11:53:20 stack_bottom = 0x7f87bc07bce8 thread_stack 0x49000

2024-10-14 11:53:20 Printing to addr2line failed

2024-10-14 11:53:20 mariadbd(my_print_stacktrace+0x32)[0x56458a1794e2]

2024-10-14 11:53:20 mariadbd(handle_fatal_signal+0x2c3)[0x564589c26283]

2024-10-14 11:53:20 /lib/x86_64-linux-gnu/libc.so.6(+0x45320)[0x7f87bed58320]

2024-10-14 11:53:20 /lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x11c)[0x7f87bedb1b1c]

2024-10-14 11:53:20 /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x1e)[0x7f87bed5826e]

2024-10-14 11:53:20 /lib/x86_64-linux-gnu/libc.so.6(abort+0xdf)[0x7f87bed3b8ff]

2024-10-14 11:53:20 mariadbd(+0x6ef876)[0x564589801876]

2024-10-14 11:53:20 mariadbd(+0x700a1a)[0x564589812a1a]

2024-10-14 11:53:20 mariadbd(+0x7020f2)[0x5645898140f2]

2024-10-14 11:53:20 mariadbd(+0x7040ba)[0x5645898160ba]

2024-10-14 11:53:20 mariadbd(+0x7049d1)[0x5645898169d1]

2024-10-14 11:53:20 mariadbd(+0xfb33bf)[0x56458a0c53bf]

2024-10-14 11:53:20 mariadbd(+0xfb4722)[0x56458a0c6722]

2024-10-14 11:53:20 mariadbd(+0xf347de)[0x56458a0467de]

2024-10-14 11:53:20 mariadbd(+0xf77107)[0x56458a089107]

2024-10-14 11:53:20 mariadbd(+0xf77995)[0x56458a089995]

2024-10-14 11:53:20 mariadbd(+0xea98d0)[0x564589fbb8d0]

2024-10-14 11:53:20 mariadbd(+0xe32880)[0x564589f44880]

2024-10-14 11:53:20 mariadbd(+0xe3b528)[0x564589f4d528]

2024-10-14 11:53:20 mariadbd(+0xe3de79)[0x564589f4fe79]

2024-10-14 11:53:20 mariadbd(+0x946a93)[0x564589a58a93]

2024-10-14 11:53:20 mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x4fa8)[0x564589a69508]

2024-10-14 11:53:20 mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3b8)[0x564589ad9e38]

2024-10-14 11:53:20 mariadbd(_Z21mysql_execute_commandP3THDb+0xe96)[0x564589994b36]

2024-10-14 11:53:20 mariadbd(_ZN18Prepared_statement7executeEP6Stringb+0x57d)[0x5645899bc4cd]

2024-10-14 11:53:20 mariadbd(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0xa2)[0x5645899bc662]

2024-10-14 11:53:20 mariadbd(+0x8ab675)[0x5645899bd675]

2024-10-14 11:53:20 mariadbd(_Z19mysqld_stmt_executeP3THDPcj+0x2f)[0x5645899bd85f]

2024-10-14 11:53:20 mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1b50)[0x56458999c190]

2024-10-14 11:53:20 mariadbd(_Z10do_commandP3THDb+0x13a)[0x56458999d9fa]

2024-10-14 11:53:20 mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3b7)[0x564589ad3da7]

2024-10-14 11:53:20 mariadbd(handle_one_connection+0x5d)[0x564589ad411d]

2024-10-14 11:53:20 mariadbd(+0xd5d2c8)[0x564589e6f2c8]

2024-10-14 11:53:20 /lib/x86_64-linux-gnu/libc.so.6(+0x9ca94)[0x7f87bedafa94]

2024-10-14 11:53:20 /lib/x86_64-linux-gnu/libc.so.6(+0x129c3c)[0x7f87bee3cc3c]

2024-10-14 11:53:20 

2024-10-14 11:53:20 Trying to get some variables.

2024-10-14 11:53:20 Some pointers may be invalid and cause the dump to abort.

2024-10-14 11:53:20 Query (0x7f876403d338): alter table `app_tour_shift_definitions` add unique `app_trd_tour_route_id_tour_shift_role_id_unique`(`tour_route_id`, `tour_shift_role_id`)

2024-10-14 11:53:20 

2024-10-14 11:53:20 Connection ID (thread ID): 6

2024-10-14 11:53:20 Status: NOT_KILLED

2024-10-14 11:53:20 

2024-10-14 11:53:20 Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=off,sargable_casefold=on

2024-10-14 11:53:20 

2024-10-14 11:53:20 The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains

2024-10-14 11:53:20 information that should help you find out what is causing the crash.

2024-10-14 11:53:20 Writing a core file...

2024-10-14 11:53:20 Working directory at /var/lib/mysql

2024-10-14 11:53:20 Resource Limits:

2024-10-14 11:53:20 Limit                     Soft Limit           Hard Limit           Units     

2024-10-14 11:53:20 Max cpu time              unlimited            unlimited            seconds   

2024-10-14 11:53:20 Max file size             unlimited            unlimited            bytes     

2024-10-14 11:53:20 Max data size             unlimited            unlimited            bytes     

2024-10-14 11:53:20 Max stack size            8388608              unlimited            bytes     

2024-10-14 11:53:20 Max core file size        0                    unlimited            bytes     

2024-10-14 11:53:20 Max resident set          unlimited            unlimited            bytes     

2024-10-14 11:53:20 Max processes             unlimited            unlimited            processes 

2024-10-14 11:53:20 Max open files            1048576              1048576              files     

2024-10-14 11:53:20 Max locked memory         unlimited            unlimited            bytes     

2024-10-14 11:53:20 Max address space         unlimited            unlimited            bytes     

2024-10-14 11:53:20 Max file locks            unlimited            unlimited            locks     

2024-10-14 11:53:20 Max pending signals       127756               127756               signals   

2024-10-14 11:53:20 Max msgqueue size         819200               819200               bytes     

2024-10-14 11:53:20 Max nice priority         0                    0                    

2024-10-14 11:53:20 Max realtime priority     0                    0                    

2024-10-14 11:53:20 Max realtime timeout      unlimited            unlimited            us        

2024-10-14 11:53:20 Core pattern: |/wsl-capture-crash %t %E %p %s

2024-10-14 11:53:20 

2024-10-14 11:53:20 Kernel version: Linux version 5.15.153.1-microsoft-standard-WSL2 (root@941d701f84f1) (gcc (GCC) 11.2.0, GNU ld (GNU Binutils) 2.37) #1 SMP Fri Mar 29 23:14:13 UTC 2024

2024-10-14 11:53:20 

2024-10-14 11:53:20 Fatal signal 11 while backtracing

2024-10-14 11:37:26 2024-10-14 09:37:26+00:00 [Note] [Entrypoint]: Temporary server stopped

<?php

use App\Migrations\BaseMigration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

return new class extends BaseMigration

{

    /**

     * Run the migrations.

     */

    public function up(): void

    {

        Schema::create('app_import_batches', function (Blueprint $table) {

            $table->innoDb(); // Set default engine

            $table->charset('utf8mb4'); // Set default charset

            $table->collation('utf8mb4_general_ci'); // Set default collation

            $table->ulid('id')->primary();

            $table->foreignUlid('user_id')->constrained('users');

            $table->string("batch_type")->comment('ex: TOURS|GUIDES|...');

            $table->string('file_orig_name');

            $table->string('file_path');

            $table->string('file_hash', length: 128);

            $table->string('batch_status');

            $table->timestamp('processing_started_at')->nullable();

            $table->timestamp('processing_ended_at')->nullable();

            $table->timestamps();

        });

        Schema::table('app_import_batches', function (Blueprint $table) {

            $table->unique('file_hash');

        });

    }

    /**

     * Reverse the migrations.

     */

    public function down(): void

    {

        Schema::dropIfExists('app_import_batches');

    }

};