Oct 31 15:25:21 snehurka systemd[1]: Starting MariaDB 10.6.7 database server...
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] /usr/sbin/mariadbd (server 10.6.7-MariaDB-2ubuntu1.1) starting as process 142393 ...
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Number of pools: 1
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Using generic crc32 instructions
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Using liburing
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Upgrading redo log: 100663296 bytes; LSN=12334837215
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Starting to delete and rewrite log file.
Oct 31 15:25:22 snehurka mariadbd[142393]: 2022-10-31 15:25:22 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: New log file created, LSN=12334837215
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: 128 rollback segments are active.
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait
...
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: 10.6.7 started; log sequence number 12334837215; transaction id 71917291
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Oct 31 15:25:25 snehurka mariadbd[142393]: 2022-10-31 15:25:25 0 [Note] Server socket created on IP: '127.0.0.1'.
Oct 31 15:25:25 snehurka mariadbd[142393]: 221031 15:25:25 [ERROR] mysqld got signal 11 ;
Oct 31 15:25:25 snehurka mariadbd[142393]: This could be because you hit a bug. It is also possible that this binary
Oct 31 15:25:25 snehurka mariadbd[142393]: or one of the libraries it was linked against is corrupt, improperly built,
Oct 31 15:25:25 snehurka mariadbd[142393]: or misconfigured. This error can also be caused by malfunctioning hardware.
Oct 31 15:25:25 snehurka mariadbd[142393]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Oct 31 15:25:25 snehurka mariadbd[142393]: We will try our best to scrape up some info that will hopefully help
Oct 31 15:25:25 snehurka mariadbd[142393]: diagnose the problem, but since we have already crashed,
Oct 31 15:25:25 snehurka mariadbd[142393]: something is definitely wrong and this may fail.
Oct 31 15:25:25 snehurka mariadbd[142393]: Server version: 10.6.7-MariaDB-2ubuntu1.1
Oct 31 15:25:25 snehurka mariadbd[142393]: key_buffer_size=134217728
Oct 31 15:25:25 snehurka mariadbd[142393]: read_buffer_size=131072
Oct 31 15:25:25 snehurka mariadbd[142393]: max_used_connections=0
Oct 31 15:25:25 snehurka mariadbd[142393]: max_threads=153
Oct 31 15:25:25 snehurka mariadbd[142393]: thread_count=1
Oct 31 15:25:25 snehurka mariadbd[142393]: It is possible that mysqld could use up to
Oct 31 15:25:25 snehurka mariadbd[142393]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467957 K  bytes of memory
Oct 31 15:25:25 snehurka mariadbd[142393]: Hope that's ok; if not, decrease some variables in the equation.
Oct 31 15:25:25 snehurka mariadbd[142393]: Thread pointer: 0x55dacab6e1f8
Oct 31 15:25:25 snehurka mariadbd[142393]: Attempting backtrace. You can use the following information to find out
Oct 31 15:25:25 snehurka mariadbd[142393]: where mysqld died. If you see no messages after this, something went
Oct 31 15:25:25 snehurka mariadbd[142393]: terribly wrong...
Oct 31 15:25:25 snehurka mariadbd[142393]: stack_bottom = 0x7ffcc31c38e8 thread_stack 0x49000
Oct 31 15:25:25 snehurka mariadbd[142393]: ??:0(my_print_stacktrace)[0x55dac80ce702]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(handle_fatal_signal)[0x55dac7c094d8]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(__sigaction)[0x7f3eda91d520]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(create_virtual_tmp_table(THD*, List<Spvar_definition>&))[0x55dac795edae]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(acl_reload(THD*))[0x55dac7972783]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(acl_init(bool))[0x55dac797393e]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(mysqld_main(int, char**))[0x55dac792b7d6]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(__libc_init_first)[0x7f3eda904d90]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(__libc_start_main)[0x7f3eda904e40]
Oct 31 15:25:26 snehurka mariadbd[142393]: ??:0(_start)[0x55dac7920665]
Oct 31 15:25:26 snehurka mariadbd[142393]: Trying to get some variables.
Oct 31 15:25:26 snehurka mariadbd[142393]: Some pointers may be invalid and cause the dump to abort.
Oct 31 15:25:26 snehurka mariadbd[142393]: Query (0x0): (null)
Oct 31 15:25:26 snehurka mariadbd[142393]: Connection ID (thread ID): 0
Oct 31 15:25:26 snehurka mariadbd[142393]: Status: NOT_KILLED
Oct 31 15:25:26 snehurka mariadbd[142393]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_so
rt_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_cach
e=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,exist
s_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_f
rom_having=on,not_null_range_scan=off
Oct 31 15:25:26 snehurka mariadbd[142393]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Oct 31 15:25:26 snehurka mariadbd[142393]: information that should help you find out what is causing the crash.
Oct 31 15:25:26 snehurka mariadbd[142393]: We think the query pointer is invalid, but we will try to print it anyway.
Oct 31 15:25:26 snehurka mariadbd[142393]: Query:
Oct 31 15:25:26 snehurka mariadbd[142393]: Writing a core file...
Oct 31 15:25:26 snehurka mariadbd[142393]: Working directory at /var/lib/mysql
Oct 31 15:25:26 snehurka mariadbd[142393]: Resource Limits:
Oct 31 15:25:26 snehurka mariadbd[142393]: Limit                     Soft Limit           Hard Limit           Units
Oct 31 15:25:26 snehurka mariadbd[142393]: Max cpu time              unlimited            unlimited            seconds
Oct 31 15:25:26 snehurka mariadbd[142393]: Max file size             unlimited            unlimited            bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max data size             unlimited            unlimited            bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max stack size            8388608              unlimited            bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max core file size        0                    unlimited            bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max resident set          unlimited            unlimited            bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max processes             14728                14728                processes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max open files            32768                32768                files
Oct 31 15:25:26 snehurka mariadbd[142393]: Max locked memory         524288               524288               bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max address space         unlimited            unlimited            bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max file locks            unlimited            unlimited            locks
Oct 31 15:25:26 snehurka mariadbd[142393]: Max pending signals       14728                14728                signals
Oct 31 15:25:26 snehurka mariadbd[142393]: Max msgqueue size         819200               819200               bytes
Oct 31 15:25:26 snehurka mariadbd[142393]: Max nice priority         0                    0
Oct 31 15:25:26 snehurka mariadbd[142393]: Max realtime priority     0                    0
Oct 31 15:25:26 snehurka mariadbd[142393]: Max realtime timeout      unlimited            unlimited            us
Oct 31 15:25:26 snehurka mariadbd[142393]: Core pattern: core
Oct 31 15:25:26 snehurka systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Oct 31 15:25:26 snehurka systemd[1]: mariadb.service: Failed with result 'signal'.
Oct 31 15:25:26 snehurka systemd[1]: Failed to start MariaDB 10.6.7 database server.
Oct 31 15:25:29 snehurka systemd[1]: Reloading.
Oct 31 15:25:31 snehurka systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.
Oct 31 15:25:31 snehurka systemd[1]: Stopped MariaDB 10.6.7 database server.
Oct 31 15:25:31 snehurka systemd[1]: Starting MariaDB 10.6.7 database server...
Oct 31 15:25:31 snehurka systemd[1]: Reloading.
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] /usr/sbin/mariadbd (server 10.6.7-MariaDB-2ubuntu1.1) starting as process 142634 ...
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: Number of pools: 1
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: Using generic crc32 instructions
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: Using liburing
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 31 15:25:32 snehurka mariadbd[142634]: 2022-10-31 15:25:32 0 [Note] InnoDB: The log sequence number 12334837215 in the system tablespace does not match the log s
equence number 12334837260 in the ib_logfile0!
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: 128 rollback segments are active.
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait
...
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: 10.6.7 started; log sequence number 12334837260; transaction id 71917291
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Oct 31 15:25:33 snehurka mariadbd[142634]: 2022-10-31 15:25:33 0 [Note] Server socket created on IP: '127.0.0.1'.
Oct 31 15:25:33 snehurka mariadbd[142634]: 221031 15:25:33 [ERROR] mysqld got signal 11 ;
Oct 31 15:25:33 snehurka mariadbd[142634]: This could be because you hit a bug. It is also possible that this binary
Oct 31 15:25:33 snehurka mariadbd[142634]: or one of the libraries it was linked against is corrupt, improperly built,
Oct 31 15:25:33 snehurka mariadbd[142634]: or misconfigured. This error can also be caused by malfunctioning hardware.
Oct 31 15:25:33 snehurka mariadbd[142634]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Oct 31 15:25:33 snehurka mariadbd[142634]: We will try our best to scrape up some info that will hopefully help
Oct 31 15:25:33 snehurka mariadbd[142634]: diagnose the problem, but since we have already crashed,
Oct 31 15:25:33 snehurka mariadbd[142634]: something is definitely wrong and this may fail.
Oct 31 15:25:33 snehurka mariadbd[142634]: Server version: 10.6.7-MariaDB-2ubuntu1.1
Oct 31 15:25:33 snehurka mariadbd[142634]: key_buffer_size=134217728
Oct 31 15:25:33 snehurka mariadbd[142634]: read_buffer_size=131072
Oct 31 15:25:33 snehurka mariadbd[142634]: max_used_connections=0
Oct 31 15:25:33 snehurka mariadbd[142634]: max_threads=153
Oct 31 15:25:33 snehurka mariadbd[142634]: thread_count=1
Oct 31 15:25:33 snehurka mariadbd[142634]: It is possible that mysqld could use up to
Oct 31 15:25:33 snehurka mariadbd[142634]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467957 K  bytes of memory
Oct 31 15:25:33 snehurka mariadbd[142634]: Hope that's ok; if not, decrease some variables in the equation.
Oct 31 15:25:33 snehurka mariadbd[142634]: Thread pointer: 0x5634e324a5d8
Oct 31 15:25:33 snehurka mariadbd[142634]: Attempting backtrace. You can use the following information to find out
Oct 31 15:25:33 snehurka mariadbd[142634]: where mysqld died. If you see no messages after this, something went
Oct 31 15:25:33 snehurka mariadbd[142634]: terribly wrong...
Oct 31 15:25:33 snehurka mariadbd[142634]: stack_bottom = 0x7ffe72954ba8 thread_stack 0x49000
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(my_print_stacktrace)[0x5634dfe26702]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(handle_fatal_signal)[0x5634df9614d8]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(__sigaction)[0x7f8518c4a520]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(create_virtual_tmp_table(THD*, List<Spvar_definition>&))[0x5634df6b6dae]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(acl_reload(THD*))[0x5634df6ca783]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(acl_init(bool))[0x5634df6cb93e]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(mysqld_main(int, char**))[0x5634df6837d6]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(__libc_init_first)[0x7f8518c31d90]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(__libc_start_main)[0x7f8518c31e40]
Oct 31 15:25:33 snehurka mariadbd[142634]: ??:0(_start)[0x5634df678665]
Oct 31 15:25:33 snehurka mariadbd[142634]: Trying to get some variables.
Oct 31 15:25:33 snehurka mariadbd[142634]: Some pointers may be invalid and cause the dump to abort.
Oct 31 15:25:33 snehurka mariadbd[142634]: Query (0x0): (null)
Oct 31 15:25:33 snehurka mariadbd[142634]: Connection ID (thread ID): 0
Oct 31 15:25:33 snehurka mariadbd[142634]: Status: NOT_KILLED
Oct 31 15:25:33 snehurka mariadbd[142634]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_so
rt_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_cach
e=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,exist
s_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_f
rom_having=on,not_null_range_scan=off
Oct 31 15:25:33 snehurka mariadbd[142634]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Oct 31 15:25:33 snehurka mariadbd[142634]: information that should help you find out what is causing the crash.
Oct 31 15:25:33 snehurka mariadbd[142634]: We think the query pointer is invalid, but we will try to print it anyway.
Oct 31 15:25:33 snehurka mariadbd[142634]: Query:
Oct 31 15:25:33 snehurka mariadbd[142634]: Writing a core file...
Oct 31 15:25:33 snehurka mariadbd[142634]: Working directory at /var/lib/mysql
Oct 31 15:25:33 snehurka mariadbd[142634]: Resource Limits:
Oct 31 15:25:33 snehurka mariadbd[142634]: Limit                     Soft Limit           Hard Limit           Units
Oct 31 15:25:33 snehurka mariadbd[142634]: Max cpu time              unlimited            unlimited            seconds
Oct 31 15:25:33 snehurka mariadbd[142634]: Max file size             unlimited            unlimited            bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max data size             unlimited            unlimited            bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max stack size            8388608              unlimited            bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max core file size        0                    unlimited            bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max resident set          unlimited            unlimited            bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max processes             14728                14728                processes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max open files            32768                32768                files
Oct 31 15:25:33 snehurka mariadbd[142634]: Max locked memory         524288               524288               bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max address space         unlimited            unlimited            bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max file locks            unlimited            unlimited            locks
Oct 31 15:25:33 snehurka mariadbd[142634]: Max pending signals       14728                14728                signals
Oct 31 15:25:33 snehurka mariadbd[142634]: Max msgqueue size         819200               819200               bytes
Oct 31 15:25:33 snehurka mariadbd[142634]: Max nice priority         0                    0
Oct 31 15:25:33 snehurka mariadbd[142634]: Max realtime priority     0                    0
Oct 31 15:25:33 snehurka mariadbd[142634]: Max realtime timeout      unlimited            unlimited            us
Oct 31 15:25:33 snehurka mariadbd[142634]: Core pattern: core
Oct 31 15:25:33 snehurka systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Oct 31 15:25:33 snehurka systemd[1]: mariadb.service: Failed with result 'signal'.
Oct 31 15:25:33 snehurka systemd[1]: Failed to start MariaDB 10.6.7 database server.
Oct 31 15:25:38 snehurka systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 2.
Oct 31 15:25:38 snehurka systemd[1]: Stopped MariaDB 10.6.7 database server.
Oct 31 15:25:38 snehurka systemd[1]: Starting MariaDB 10.6.7 database server...
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] /usr/sbin/mariadbd (server 10.6.7-MariaDB-2ubuntu1.1) starting as process 142725 ...
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Number of pools: 1
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Using generic crc32 instructions
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Using liburing
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: The log sequence number 12334837215 in the system tablespace does not match the log s
equence number 12334837260 in the ib_logfile0!
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: 128 rollback segments are active.
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait
...
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: 10.6.7 started; log sequence number 12334837260; transaction id 71917291
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Oct 31 15:25:39 snehurka mariadbd[142725]: 2022-10-31 15:25:39 0 [Note] Server socket created on IP: '127.0.0.1'.
Oct 31 15:25:39 snehurka mariadbd[142725]: 221031 15:25:39 [ERROR] mysqld got signal 11 ;
Oct 31 15:25:39 snehurka mariadbd[142725]: This could be because you hit a bug. It is also possible that this binary
Oct 31 15:25:39 snehurka mariadbd[142725]: or one of the libraries it was linked against is corrupt, improperly built,
Oct 31 15:25:39 snehurka mariadbd[142725]: or misconfigured. This error can also be caused by malfunctioning hardware.
Oct 31 15:25:39 snehurka mariadbd[142725]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Oct 31 15:25:39 snehurka mariadbd[142725]: We will try our best to scrape up some info that will hopefully help
Oct 31 15:25:39 snehurka mariadbd[142725]: diagnose the problem, but since we have already crashed,
Oct 31 15:25:39 snehurka mariadbd[142725]: something is definitely wrong and this may fail.
Oct 31 15:25:39 snehurka mariadbd[142725]: Server version: 10.6.7-MariaDB-2ubuntu1.1
Oct 31 15:25:39 snehurka mariadbd[142725]: key_buffer_size=134217728
Oct 31 15:25:39 snehurka mariadbd[142725]: read_buffer_size=131072
Oct 31 15:25:39 snehurka mariadbd[142725]: max_used_connections=0
Oct 31 15:25:39 snehurka mariadbd[142725]: max_threads=153
Oct 31 15:25:39 snehurka mariadbd[142725]: thread_count=1
Oct 31 15:25:39 snehurka mariadbd[142725]: It is possible that mysqld could use up to
Oct 31 15:25:39 snehurka mariadbd[142725]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467957 K  bytes of memory
Oct 31 15:25:39 snehurka mariadbd[142725]: Hope that's ok; if not, decrease some variables in the equation.
Oct 31 15:25:39 snehurka mariadbd[142725]: Thread pointer: 0x564dcb671528
Oct 31 15:25:39 snehurka mariadbd[142725]: Attempting backtrace. You can use the following information to find out
Oct 31 15:25:39 snehurka mariadbd[142725]: where mysqld died. If you see no messages after this, something went
Oct 31 15:25:39 snehurka mariadbd[142725]: terribly wrong...
Oct 31 15:25:39 snehurka mariadbd[142725]: stack_bottom = 0x7ffe7b75d928 thread_stack 0x49000
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(my_print_stacktrace)[0x564dc88bb702]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(handle_fatal_signal)[0x564dc83f64d8]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(__sigaction)[0x7fcea591d520]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(create_virtual_tmp_table(THD*, List<Spvar_definition>&))[0x564dc814bdae]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(acl_reload(THD*))[0x564dc815f783]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(acl_init(bool))[0x564dc816093e]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(mysqld_main(int, char**))[0x564dc81187d6]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(__libc_init_first)[0x7fcea5904d90]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(__libc_start_main)[0x7fcea5904e40]
Oct 31 15:25:39 snehurka mariadbd[142725]: ??:0(_start)[0x564dc810d665]
Oct 31 15:25:39 snehurka mariadbd[142725]: Trying to get some variables.
Oct 31 15:25:39 snehurka mariadbd[142725]: Some pointers may be invalid and cause the dump to abort.
Oct 31 15:25:39 snehurka mariadbd[142725]: Query (0x0): (null)
Oct 31 15:25:39 snehurka mariadbd[142725]: Connection ID (thread ID): 0
Oct 31 15:25:39 snehurka mariadbd[142725]: Status: NOT_KILLED
Oct 31 15:25:39 snehurka mariadbd[142725]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_so
rt_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_cach
e=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,exist
s_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_f
rom_having=on,not_null_range_scan=off
Oct 31 15:25:39 snehurka mariadbd[142725]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Oct 31 15:25:39 snehurka mariadbd[142725]: information that should help you find out what is causing the crash.
Oct 31 15:25:39 snehurka mariadbd[142725]: We think the query pointer is invalid, but we will try to print it anyway.
Oct 31 15:25:39 snehurka mariadbd[142725]: Query:
Oct 31 15:25:39 snehurka mariadbd[142725]: Writing a core file...
Oct 31 15:25:39 snehurka mariadbd[142725]: Working directory at /var/lib/mysql
Oct 31 15:25:39 snehurka mariadbd[142725]: Resource Limits:
Oct 31 15:25:39 snehurka mariadbd[142725]: Limit                     Soft Limit           Hard Limit           Units
Oct 31 15:25:39 snehurka mariadbd[142725]: Max cpu time              unlimited            unlimited            seconds
Oct 31 15:25:39 snehurka mariadbd[142725]: Max file size             unlimited            unlimited            bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max data size             unlimited            unlimited            bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max stack size            8388608              unlimited            bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max core file size        0                    unlimited            bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max resident set          unlimited            unlimited            bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max processes             14728                14728                processes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max open files            32768                32768                files
Oct 31 15:25:39 snehurka mariadbd[142725]: Max locked memory         524288               524288               bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max address space         unlimited            unlimited            bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max file locks            unlimited            unlimited            locks
Oct 31 15:25:39 snehurka mariadbd[142725]: Max pending signals       14728                14728                signals
Oct 31 15:25:39 snehurka mariadbd[142725]: Max msgqueue size         819200               819200               bytes
Oct 31 15:25:39 snehurka mariadbd[142725]: Max nice priority         0                    0
Oct 31 15:25:39 snehurka mariadbd[142725]: Max realtime priority     0                    0
Oct 31 15:25:39 snehurka mariadbd[142725]: Max realtime timeout      unlimited            unlimited            us
Oct 31 15:25:39 snehurka mariadbd[142725]: Core pattern: core
Oct 31 15:25:39 snehurka systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Oct 31 15:25:39 snehurka systemd[1]: mariadb.service: Failed with result 'signal'.
Oct 31 15:25:39 snehurka systemd[1]: Failed to start MariaDB 10.6.7 database server.
Oct 31 15:25:43 snehurka avahi-daemon[781]: Files changed, reloading.
Oct 31 15:25:43 snehurka avahi-daemon[781]: Loading service file /services/phpmyadmin.service.
Oct 31 15:25:43 snehurka avahi-daemon[781]: open("/services/phpmyadmin.service", O_RDONLY): No such file or directory
Oct 31 15:25:43 snehurka avahi-daemon[781]: Failed to load service group file /services/phpmyadmin.service, ignoring.
Oct 31 15:25:43 snehurka avahi-daemon[781]: Files changed, reloading.
Oct 31 15:25:43 snehurka avahi-daemon[781]: Loading service file /services/phpmyadmin.service.
Oct 31 15:25:43 snehurka avahi-daemon[781]: open("/services/phpmyadmin.service", O_RDONLY): No such file or directory
Oct 31 15:25:43 snehurka avahi-daemon[781]: Failed to load service group file /services/phpmyadmin.service, ignoring.
Oct 31 15:25:43 snehurka dbus-daemon[784]: Unknown group "power" in message bus configuration file
Oct 31 15:25:43 snehurka dbus-daemon[784]: [system] Reloaded configuration
Oct 31 15:25:44 snehurka systemd[1]: Reloading D-Bus System Message Bus...
Oct 31 15:25:44 snehurka dbus-daemon[784]: Unknown group "power" in message bus configuration file
Oct 31 15:25:44 snehurka dbus-daemon[784]: [system] Reloaded configuration
Oct 31 15:25:44 snehurka dbus-send[142762]: method return time=1667226344.535772 sender=org.freedesktop.DBus -> destination=:1.73 serial=3 reply_serial=2
Oct 31 15:25:44 snehurka systemd[1]: Reloaded D-Bus System Message Bus.
Oct 31 15:25:44 snehurka systemd[1]: Reloading.
Oct 31 15:25:45 snehurka systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 3.
Oct 31 15:25:45 snehurka systemd[1]: Stopped MariaDB 10.6.7 database server.
Oct 31 15:25:45 snehurka systemd[1]: Starting MariaDB 10.6.7 database server...