web__mysql | 2022-08-05 23:02:16 4 [ERROR] InnoDB: preallocating 147456 bytes for file ./db/events_places.ibd failed with error 2 web__mysql | 2022-08-05 23:02:16 0x7fc26018d640 InnoDB: Assertion failure in file ./storage/innobase/fil/fil0fil.cc line 610 web__mysql | InnoDB: Failing assertion: fsize != os_offset_t(-1) web__mysql | InnoDB: We intentionally generate a memory trap. web__mysql | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ web__mysql | InnoDB: If you get repeated assertion failures or crashes, even web__mysql | InnoDB: immediately after the mariadbd startup, there may be web__mysql | InnoDB: corruption in the InnoDB tablespace. Please refer to web__mysql | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ web__mysql | InnoDB: about forcing recovery. web__mysql | 220805 23:02:16 [ERROR] mysqld got signal 6 ; web__mysql | This could be because you hit a bug. It is also possible that this binary web__mysql | or one of the libraries it was linked against is corrupt, improperly built, web__mysql | or misconfigured. This error can also be caused by malfunctioning hardware. web__mysql | web__mysql | To report this bug, see https://mariadb.com/kb/en/reporting-bugs web__mysql | web__mysql | We will try our best to scrape up some info that will hopefully help web__mysql | diagnose the problem, but since we have already crashed, web__mysql | something is definitely wrong and this may fail. web__mysql | web__mysql | Server version: 10.8.3-MariaDB-1:10.8.3+maria~jammy web__mysql | key_buffer_size=134217728 web__mysql | read_buffer_size=131072 web__mysql | max_used_connections=2 web__mysql | max_threads=153 web__mysql | thread_count=2 web__mysql | It is possible that mysqld could use up to web__mysql | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467997 K bytes of memory web__mysql | Hope that's ok; if not, decrease some variables in the equation. web__mysql | web__mysql | Thread pointer: 0x7fc218000c68 web__mysql | Attempting backtrace. You can use the following information to find out web__mysql | where mysqld died. If you see no messages after this, something went web__mysql | terribly wrong... web__mysql | stack_bottom = 0x7fc26018cc78 thread_stack 0x49000 web__mysql | Printing to addr2line failed web__mysql | mariadbd(my_print_stacktrace+0x32)[0x55ff6980f212] web__mysql | mariadbd(handle_fatal_signal+0x478)[0x55ff692e47e8] web__mysql | /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7fc278bfe520] web__mysql | /lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x12c)[0x7fc278c52a7c] web__mysql | /lib/x86_64-linux-gnu/libc.so.6(raise+0x16)[0x7fc278bfe476] web__mysql | /lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7fc278be47f3] web__mysql | mariadbd(+0x673d9d)[0x55ff68f18d9d] web__mysql | mariadbd(+0x684e70)[0x55ff68f29e70] web__mysql | mariadbd(+0x6858e4)[0x55ff68f2a8e4] web__mysql | mariadbd(+0x688581)[0x55ff68f2d581] web__mysql | mariadbd(+0xeb8d28)[0x55ff6975dd28] web__mysql | mariadbd(+0xe319a4)[0x55ff696d69a4] web__mysql | mariadbd(+0xe7815d)[0x55ff6971d15d] web__mysql | mariadbd(+0xe78af7)[0x55ff6971daf7] web__mysql | mariadbd(+0xda9151)[0x55ff6964e151] web__mysql | mariadbd(+0xd3476e)[0x55ff695d976e] web__mysql | mariadbd(+0xd3c84d)[0x55ff695e184d] web__mysql | mariadbd(+0xd3ed65)[0x55ff695e3d65] web__mysql | mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderbb+0x5056)[0x55ff69156536] web__mysql | mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3c7)[0x55ff691c20a7] web__mysql | mariadbd(_Z21mysql_execute_commandP3THDb+0x4a53)[0x55ff6909a9a3] web__mysql | mariadbd(_ZN18Prepared_statement7executeEP6Stringb+0x4b2)[0x55ff690be022] web__mysql | mariadbd(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0xa1)[0x55ff690be241] web__mysql | mariadbd(+0x81a125)[0x55ff690bf125] web__mysql | mariadbd(_Z19mysqld_stmt_executeP3THDPcj+0x30)[0x55ff690bf300] web__mysql | mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xd76)[0x55ff6909dbc6] web__mysql | mariadbd(_Z10do_commandP3THDb+0x132)[0x55ff6909fff2] web__mysql | mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x55ff691bd18f] web__mysql | mariadbd(handle_one_connection+0x5d)[0x55ff691bd4dd] web__mysql | mariadbd(+0xc6a256)[0x55ff6950f256] web__mysql | /lib/x86_64-linux-gnu/libc.so.6(+0x94b43)[0x7fc278c50b43] web__mysql | /lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7fc278ce1bb4] web__mysql | web__mysql | Trying to get some variables. web__mysql | Some pointers may be invalid and cause the dump to abort. web__mysql | Query (0x7fc218039640): alter table `events_places` add unique `events_places_place_id_event_id_unique`(`place_id`, `event_id`) web__mysql | web__mysql | Connection ID (thread ID): 4 web__mysql | Status: NOT_KILLED web__mysql | web__mysql | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=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 web__mysql | web__mysql | The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains web__mysql | information that should help you find out what is causing the crash. web__mysql | Writing a core file... web__mysql | Working directory at /var/lib/mysql web__mysql | Resource Limits: web__mysql | Limit Soft Limit Hard Limit Units web__mysql | Max cpu time unlimited unlimited seconds web__mysql | Max file size unlimited unlimited bytes web__mysql | Max data size unlimited unlimited bytes web__mysql | Max stack size 8388608 unlimited bytes web__mysql | Max core file size 0 unlimited bytes web__mysql | Max resident set unlimited unlimited bytes web__mysql | Max processes unlimited unlimited processes web__mysql | Max open files 1048576 1048576 files web__mysql | Max locked memory 83968000 83968000 bytes web__mysql | Max address space unlimited unlimited bytes web__mysql | Max file locks unlimited unlimited locks web__mysql | Max pending signals 50913 50913 signals web__mysql | Max msgqueue size 819200 819200 bytes web__mysql | Max nice priority 0 0 web__mysql | Max realtime priority 0 0 web__mysql | Max realtime timeout unlimited unlimited us web__mysql | Core pattern: core web__mysql | web__mysql | Fatal signal 11 while backtracing web__mysql exited with code 139 web__mysql | 2022-08-05 23:02:19+03:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' web__mysql | 2022-08-05 23:02:19+03:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.8.3+maria~jammy started. web__mysql | 2022-08-05 23:02:19+03:00 [Note] [Entrypoint]: MariaDB upgrade not required web__mysql | 2022-08-05 23:02:19 0 [Note] mariadbd (server 10.8.3-MariaDB-1:10.8.3+maria~jammy) starting as process 1 ... web__mysql | 2022-08-05 23:02:19 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Number of transaction pools: 1 web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions web__mysql | 2022-08-05 23:02:19 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) web__mysql | 2022-08-05 23:02:19 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required) web__mysql | 2022-08-05 23:02:19 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Completed initialization of buffer pool web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=440269 web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Starting final batch to recover 60 pages from redo log. web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: 128 rollback segments are active. web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" web__mysql | 2022-08-05 23:02:19 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... web__mysql | 2022-08-05 23:02:20 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. web__mysql | 2022-08-05 23:02:20 0 [Note] InnoDB: log sequence number 655183; transaction id 838 web__mysql | 2022-08-05 23:02:20 0 [Note] Plugin 'FEEDBACK' is disabled. web__mysql | 2022-08-05 23:02:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool web__mysql | 2022-08-05 23:02:20 0 [Note] InnoDB: Buffer pool(s) load completed at 220805 23:02:20 web__mysql | 2022-08-05 23:02:20 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. web__mysql | 2022-08-05 23:02:20 0 [Note] DDL_LOG: Crash recovery executed 1 entries web__mysql | 2022-08-05 23:02:20 0 [Note] Server socket created on IP: '0.0.0.0'. web__mysql | 2022-08-05 23:02:20 0 [Note] Server socket created on IP: '::'. web__mysql | 2022-08-05 23:02:20 0 [Note] mariadbd: ready for connections. web__mysql | Version: '10.8.3-MariaDB-1:10.8.3+maria~jammy' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution