● mariadb.service - MariaDB 10.7.6 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: activating (start-pre) since Mon 2022-10-31 22:07:10 CET; 9ms ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Cntrl PID: 100854 ((install)) Tasks: 1 (limit: 4390) Memory: 776.0K CPU: 5ms CGroup: /system.slice/mariadb.service └─100854 "[(install)]" říj 31 22:07:10 snehurka systemd[1]: Starting MariaDB 10.7.6 database server... říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] /usr/sbin/mariadbd (server 10.7.6-MariaDB-1:10.7.6+maria~ubu2204) starting as process 100865> říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Number of transaction pools: 1 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Using generic crc32 instructions říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Completed initialization of buffer pool říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=13571,13571 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Starting final batch to recover 3 pages from redo log. říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: 128 rollback segments are active. říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait> říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: 10.7.6 started; log sequence number 46340; transaction id 4 říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] Plugin 'FEEDBACK' is disabled. říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] Server socket created on IP: '0.0.0.0'. říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] Server socket created on IP: '::'. říj 31 22:07:11 snehurka mariadbd[100865]: 221031 22:07:11 [ERROR] mysqld got signal 11 ; říj 31 22:07:11 snehurka mariadbd[100865]: This could be because you hit a bug. It is also possible that this binary říj 31 22:07:11 snehurka mariadbd[100865]: or one of the libraries it was linked against is corrupt, improperly built, říj 31 22:07:11 snehurka mariadbd[100865]: or misconfigured. This error can also be caused by malfunctioning hardware. říj 31 22:07:11 snehurka mariadbd[100865]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs říj 31 22:07:11 snehurka mariadbd[100865]: We will try our best to scrape up some info that will hopefully help říj 31 22:07:11 snehurka mariadbd[100865]: diagnose the problem, but since we have already crashed, říj 31 22:07:11 snehurka mariadbd[100865]: something is definitely wrong and this may fail. říj 31 22:07:11 snehurka mariadbd[100865]: Server version: 10.7.6-MariaDB-1:10.7.6+maria~ubu2204 říj 31 22:07:11 snehurka mariadbd[100865]: key_buffer_size=134217728 říj 31 22:07:11 snehurka mariadbd[100865]: read_buffer_size=131072 ● mariadb.service - MariaDB 10.7.6 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: activating (start-pre) since Mon 2022-10-31 22:07:10 CET; 9ms ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Cntrl PID: 100854 ((install)) Tasks: 1 (limit: 4390) Memory: 776.0K CPU: 5ms CGroup: /system.slice/mariadb.service └─100854 "[(install)]" říj 31 22:07:10 snehurka systemd[1]: Starting MariaDB 10.7.6 database server... říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] /usr/sbin/mariadbd (server 10.7.6-MariaDB-1:10.7.6+maria~ubu2204) starting as process 100865> říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Number of transaction pools: 1 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Using generic crc32 instructions říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Completed initialization of buffer pool říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=13571,13571 říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Starting final batch to recover 3 pages from redo log. říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: 128 rollback segments are active. říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables říj 31 22:07:10 snehurka mariadbd[100865]: 2022-10-31 22:07:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait> říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: 10.7.6 started; log sequence number 46340; transaction id 4 říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] Plugin 'FEEDBACK' is disabled. říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] Server socket created on IP: '0.0.0.0'. říj 31 22:07:11 snehurka mariadbd[100865]: 2022-10-31 22:07:11 0 [Note] Server socket created on IP: '::'. říj 31 22:07:11 snehurka mariadbd[100865]: 221031 22:07:11 [ERROR] mysqld got signal 11 ; říj 31 22:07:11 snehurka mariadbd[100865]: This could be because you hit a bug. It is also possible that this binary říj 31 22:07:11 snehurka mariadbd[100865]: or one of the libraries it was linked against is corrupt, improperly built, říj 31 22:07:11 snehurka mariadbd[100865]: or misconfigured. This error can also be caused by malfunctioning hardware. říj 31 22:07:11 snehurka mariadbd[100865]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs říj 31 22:07:11 snehurka mariadbd[100865]: We will try our best to scrape up some info that will hopefully help říj 31 22:07:11 snehurka mariadbd[100865]: diagnose the problem, but since we have already crashed, říj 31 22:07:11 snehurka mariadbd[100865]: something is definitely wrong and this may fail. říj 31 22:07:11 snehurka mariadbd[100865]: Server version: 10.7.6-MariaDB-1:10.7.6+maria~ubu2204 říj 31 22:07:11 snehurka mariadbd[100865]: key_buffer_size=134217728 říj 31 22:07:11 snehurka mariadbd[100865]: read_buffer_size=131072 říj 31 22:07:11 snehurka mariadbd[100865]: max_used_connections=0 říj 31 22:07:11 snehurka mariadbd[100865]: max_threads=153 říj 31 22:07:11 snehurka mariadbd[100865]: thread_count=1 říj 31 22:07:11 snehurka mariadbd[100865]: It is possible that mysqld could use up to říj 31 22:07:11 snehurka mariadbd[100865]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467995 K bytes of memory říj 31 22:07:11 snehurka mariadbd[100865]: Hope that's ok; if not, decrease some variables in the equation. říj 31 22:07:11 snehurka mariadbd[100865]: Thread pointer: 0x563c386e9fc8 říj 31 22:07:11 snehurka mariadbd[100865]: Attempting backtrace. You can use the following information to find out říj 31 22:07:11 snehurka mariadbd[100865]: where mysqld died. If you see no messages after this, something went říj 31 22:07:11 snehurka mariadbd[100865]: terribly wrong... říj 31 22:07:11 snehurka mariadbd[100865]: stack_bottom = 0x7ffd56f65ad8 thread_stack 0x49000 říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(my_print_stacktrace)[0x563c358eba12] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(handle_fatal_signal)[0x563c353c5c28] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(__sigaction)[0x7f771622a520] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(Item_field_row::get_copy(THD*))[0x563c350d7d28] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(acl_reload(THD*))[0x563c350e703f] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(acl_init(bool))[0x563c350e863e] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(mysqld_main(int, char**))[0x563c35079665] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(__libc_init_first)[0x7f7716211d90] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(__libc_start_main)[0x7f7716211e40] říj 31 22:07:11 snehurka mariadbd[100865]: ??:0(_start)[0x563c3506daf5] říj 31 22:07:11 snehurka mariadbd[100865]: Trying to get some variables. říj 31 22:07:11 snehurka mariadbd[100865]: Some pointers may be invalid and cause the dump to abort. říj 31 22:07:11 snehurka mariadbd[100865]: Query (0x0): (null) říj 31 22:07:11 snehurka mariadbd[100865]: Connection ID (thread ID): 0 říj 31 22:07:11 snehurka mariadbd[100865]: Status: NOT_KILLED říj 31 22:07:11 snehurka mariadbd[100865]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_s> říj 31 22:07:11 snehurka mariadbd[100865]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains říj 31 22:07:11 snehurka mariadbd[100865]: information that should help you find out what is causing the crash. říj 31 22:07:11 snehurka mariadbd[100865]: We think the query pointer is invalid, but we will try to print it anyway. říj 31 22:07:11 snehurka mariadbd[100865]: Query: říj 31 22:07:11 snehurka mariadbd[100865]: Writing a core file... říj 31 22:07:11 snehurka mariadbd[100865]: Working directory at /var/lib/mysql říj 31 22:07:11 snehurka mariadbd[100865]: Resource Limits: říj 31 22:07:11 snehurka mariadbd[100865]: Limit Soft Limit Hard Limit Units říj 31 22:07:11 snehurka mariadbd[100865]: Max cpu time unlimited unlimited seconds říj 31 22:07:11 snehurka mariadbd[100865]: Max file size unlimited unlimited bytes říj 31 22:07:11 snehurka mariadbd[100865]: Max data size unlimited unlimited bytes říj 31 22:07:11 snehurka mariadbd[100865]: Max stack size 8388608 unlimited bytes root@snehurka:~# systemctl status mariadb ● mariadb.service - MariaDB 10.7.6 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: activating (auto-restart) (Result: core-dump) since Mon 2022-10-31 22:08:23 CET; 2s ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 101176 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 101177 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 101179 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemc> Process: 101187 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=SEGV) Main PID: 101187 (code=dumped, signal=SEGV) Status: "Starting final batch to recover 3 pages from redo log" CPU: 501ms