Jul 28 06:05:34 systemd[1]: Stopping MariaDB 10.4.13 database server... Jul 28 06:05:34 mysqld[1723646]: 2020-07-28 6:05:34 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown Jul 28 06:05:34 mysqld[1723646]: 2020-07-28 6:05:34 0 [Note] Event Scheduler: Purging the queue. 0 events Jul 28 06:05:34 mysqld[1723646]: 2020-07-28 6:05:34 0 [Note] InnoDB: FTS optimize thread exiting. Jul 28 06:05:34 mysqld[1723646]: 2020-07-28 6:05:34 0 [Note] InnoDB: Starting shutdown... Jul 28 06:05:34 mysqld[1723646]: 2020-07-28 6:05:34 0 [Note] InnoDB: Dumping buffer pool(s) to /var/opt/ibm/powervc/db/ib_buffer_pool Jul 28 06:05:34 mysqld[1723646]: 2020-07-28 6:05:34 0 [Note] InnoDB: Buffer pool(s) dump completed at 200728 6:05:34 Jul 28 06:05:36 mysqld[1723646]: 2020-07-28 6:05:36 0 [Note] InnoDB: Shutdown completed; log sequence number 140585; transaction id 155 Jul 28 06:05:36 mysqld[1723646]: 2020-07-28 6:05:36 0 [Note] /usr/sbin/mysqld: Shutdown complete Jul 28 06:05:36 systemd[1]: Stopped MariaDB 10.4.13 database server. Jul 28 06:05:36 systemd[1]: Starting MariaDB 10.4.13 database server... Jul 28 06:05:36 mysqld[1725803]: 2020-07-28 6:05:36 0 [Note] Using unique option prefix 'd...' is error-prone and can break in the future. Please use the full name 'datadir' instead. Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:36 0 [Note] /usr/sbin/mysqld (mysqld 10.4.13-MariaDB) starting as process 1725803 ... Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:36 0 [Warning] Could not increase number of max_open_files to more than 8192 (request: 34095) Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Using Linux native AIO Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Uses event mutexes Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Number of pools: 1 Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Using POWER8 crc32 instructions Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Completed initialization of buffer pool Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Waiting for purge to start Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: 10.4.13 started; log sequence number 60972; transaction id 21 Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/opt/ibm/powervc/db/ib_buffer_pool Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] Plugin 'FEEDBACK' is disabled. Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] InnoDB: Buffer pool(s) load completed at 200728 6:05:37 Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] Server socket created on IP: '127.0.0.1'. Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] Reading of all Master_info entries succeeded Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] Added new Master_info '' to hash table Jul 28 06:05:37 mysqld[1725803]: 2020-07-28 6:05:37 0 [Note] /usr/sbin/mysqld: ready for connections. Jul 28 06:05:37 mysqld[1725803]: Version: '10.4.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 50110 MariaDB Server Jul 28 06:05:37 systemd[1]: Started MariaDB 10.4.13 database server. Jul 28 06:05:44 mysqld[1725803]: 200728 6:05:44 [ERROR] mysqld got signal 11 ; Jul 28 06:05:44 mysqld[1725803]: This could be because you hit a bug. It is also possible that this binary Jul 28 06:05:44 mysqld[1725803]: or one of the libraries it was linked against is corrupt, improperly built, Jul 28 06:05:44 mysqld[1725803]: or misconfigured. This error can also be caused by malfunctioning hardware. Jul 28 06:05:44 mysqld[1725803]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Jul 28 06:05:44 mysqld[1725803]: We will try our best to scrape up some info that will hopefully help Jul 28 06:05:44 mysqld[1725803]: diagnose the problem, but since we have already crashed, Jul 28 06:05:44 mysqld[1725803]: something is definitely wrong and this may fail. Jul 28 06:05:44 mysqld[1725803]: Server version: 10.4.13-MariaDB Jul 28 06:05:44 mysqld[1725803]: key_buffer_size=134217728 Jul 28 06:05:44 mysqld[1725803]: read_buffer_size=131072 Jul 28 06:05:44 mysqld[1725803]: max_used_connections=1 Jul 28 06:05:44 mysqld[1725803]: max_threads=2050 Jul 28 06:05:44 mysqld[1725803]: thread_count=7 Jul 28 06:05:44 mysqld[1725803]: It is possible that mysqld could use up to Jul 28 06:05:44 mysqld[1725803]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4642504 K bytes of memory Jul 28 06:05:44 mysqld[1725803]: Hope that's ok; if not, decrease some variables in the equation. Jul 28 06:05:44 mysqld[1725803]: Thread pointer: 0x7fff2c000c48 Jul 28 06:05:44 mysqld[1725803]: Attempting backtrace. You can use the following information to find out Jul 28 06:05:44 mysqld[1725803]: where mysqld died. If you see no messages after this, something went Jul 28 06:05:44 mysqld[1725803]: terribly wrong... Jul 28 06:05:44 mysqld[1725803]: stack_bottom = 0x7fff94467488 thread_stack 0x49000 Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(my_print_stacktrace+0x44)[0x13bc20bc4] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x13b5480d8] Jul 28 06:05:44 mysqld[1725803]: addr2line: 'linux-vdso64.so.1': No such file Jul 28 06:05:44 mysqld[1725803]: linux-vdso64.so.1(__kernel_sigtramp_rt64+0x0)[0x7fff98c704d8] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_ZN12Item_func_in7cleanupEv+0x54)[0x13b6f9634] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_ZN11Query_arena10free_itemsEv+0x5c)[0x13b22fabc] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_ZN3THD19cleanup_after_queryEv+0x140)[0x13b232b70] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x320)[0x13b2981b0] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x13d4)[0x13b29a7d4] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x124)[0x13b29c2c4] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x3e0)[0x13b3b65a0] Jul 28 06:05:44 mysqld[1725803]: /usr/sbin/mysqld(handle_one_connection+0x70)[0x13b3b66d0] Jul 28 06:05:44 mysqld[1725803]: pthread_create.c:0(start_thread)[0x7fff98c08ba0] Jul 28 06:05:44 mysqld[1725803]: :0(__GI___clone)[0x7fff98041258] Jul 28 06:05:44 mysqld[1725803]: Trying to get some variables. Jul 28 06:05:44 mysqld[1725803]: Some pointers may be invalid and cause the dump to abort. Jul 28 06:05:44 mysqld[1725803]: Query (0x7fff2c012b50): ALTER TABLE user ADD CONSTRAINT ixu_user_name_domain_id UNIQUE (domain_id, name) Jul 28 06:05:44 mysqld[1725803]: Connection ID (thread ID): 20 Jul 28 06:05:44 mysqld[1725803]: Status: NOT_KILLED Jul 28 06:05:44 mysqld[1725803]: 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 Jul 28 06:05:44 mysqld[1725803]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Jul 28 06:05:44 mysqld[1725803]: information that should help you find out what is causing the crash. Jul 28 06:05:44 mysqld[1725803]: Writing a core file... Jul 28 06:05:44 mysqld[1725803]: Working directory at /var/opt/ibm/powervc/db Jul 28 06:05:44 mysqld[1725803]: Resource Limits: Jul 28 06:05:44 mysqld[1725803]: Limit Soft Limit Hard Limit Units Jul 28 06:05:44 mysqld[1725803]: Max cpu time unlimited unlimited seconds Jul 28 06:05:44 mysqld[1725803]: Max file size unlimited unlimited bytes Jul 28 06:05:44 mysqld[1725803]: Max data size unlimited unlimited bytes Jul 28 06:05:44 mysqld[1725803]: Max stack size 8388608 unlimited bytes Jul 28 06:05:44 mysqld[1725803]: Max core file size unlimited unlimited bytes Jul 28 06:05:44 mysqld[1725803]: Max resident set unlimited unlimited bytes Jul 28 06:05:44 mysqld[1725803]: Max processes 77267 77267 processes Jul 28 06:05:44 mysqld[1725803]: Max open files 8192 8192 files Jul 28 06:05:44 mysqld[1725803]: Max locked memory 65536 65536 bytes Jul 28 06:05:44 mysqld[1725803]: Max address space unlimited unlimited bytes Jul 28 06:05:44 mysqld[1725803]: Max file locks unlimited unlimited locks Jul 28 06:05:44 mysqld[1725803]: Max pending signals 77267 77267 signals Jul 28 06:05:44 mysqld[1725803]: Max msgqueue size 819200 819200 bytes Jul 28 06:05:44 mysqld[1725803]: Max nice priority 0 0 Jul 28 06:05:44 mysqld[1725803]: Max realtime priority 0 0 Jul 28 06:05:44 mysqld[1725803]: Max realtime timeout unlimited unlimited us Jul 28 06:05:44 kernel: mysqld[1725837]: unhandled signal 11 at 0000000000000008 nip 000000013b6f9634 lr 000000013b6f9610 code 1 Jul 28 06:05:44 systemd[1]: Started Process Core Dump (PID 1725859/UID 0). Jul 28 06:05:45 systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV Jul 28 06:05:45 systemd[1]: mariadb.service: Failed with result 'signal'. Jul 28 06:05:46 systemd-coredump[1725860]: Process 1725803 (mysqld) of user 27 dumped core.#012#012Stack trace of thread 1725837:#012#0 0x000000013b6f9634 _ZN12Item_func_in7cleanupEv (mysqld)#012#1 0x000000013b22fabc _ZN11Query_arena10free_itemsEv (mysqld)#012#2 0x000000013b232b70 _ZN3THD19cleanup_after_queryEv (mysqld)#012#3 0x000000013b2981b0 _Z11mysql_parseP3THDPcjP12Parser_statebb (mysqld)#012#4 0x000000013b29a7d4 _Z16dispatch_command19enum_server_commandP3THDPcjbb (mysqld)#012#5 0x000000013b29c2c4 _Z10do_commandP3THD (mysqld)#012#6 0x000000013b3b65a0 _Z24do_handle_one_connectionP7CONNECT (mysqld)#012#7 0x000000013b3b66d0 handle_one_connection (mysqld)#012#8 0x00007fff98c08ba0 start_thread (libpthread.so.0)#012#9 0x00007fff98041258 __clone (libc.so.6) Jul 28 06:05:46 dbus-daemon[1664]: [system] Activating service name='org.fedoraproject.Setroubleshootd' requested by ':1.167' (uid=0 pid=1617 comm="/usr/sbin/sedispatch " label="system_u:system_r:auditd_t:s0") (using servicehelper) Jul 28 06:05:46 dbus-daemon[1725868]: [system] Failed to reset fd limit before activating service: org.freedesktop.DBus.Error.AccessDenied: Failed to restore old fd limit: Operation not permitted Jul 28 06:05:47 dbus-daemon[1664]: [system] Successfully activated service 'org.fedoraproject.Setroubleshootd' Jul 28 06:05:50 setroubleshoot[1725868]: SELinux is preventing mysqld from read access on the file core_pattern. For complete SELinux messages run: sealert -l b3a5d05b-bddb-4931-a02d-271124605156 Jul 28 06:05:50 platform-python[1725868]: SELinux is preventing mysqld from read access on the file core_pattern.#012#012***** Plugin catchall (100. confidence) suggests **************************#012#012If you believe that mysqld should be allowed read access on the core_pattern file by default.#012Then you should report this as a bug.#012You can generate a local policy module to allow this access.#012Do#012allow this access for now by executing:#012# ausearch -c 'mysqld' --raw | audit2allow -M my-mysqld#012# semodule -X 300 -i my-mysqld.pp#012 Jul 28 06:05:51 systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart. Jul 28 06:05:51 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1. Jul 28 06:05:51 systemd[1]: Stopped MariaDB 10.4.13 database server. Jul 28 06:05:51 systemd[1]: Starting MariaDB 10.4.13 database server... Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] Using unique option prefix 'd...' is error-prone and can break in the future. Please use the full name 'datadir' instead. Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] /usr/sbin/mysqld (mysqld 10.4.13-MariaDB) starting as process 1725905 ... Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Warning] Could not increase number of max_open_files to more than 8192 (request: 34095) Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] mysqld: Aria engine: starting recovery Jul 28 06:05:51 mysqld[1725905]: recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (0.0 seconds); tables to flush: 2 1 0 Jul 28 06:05:51 mysqld[1725905]: (0.0 seconds); Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] mysqld: Aria engine: recovery done Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Using Linux native AIO Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Uses event mutexes Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Number of pools: 1 Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Using POWER8 crc32 instructions Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Completed initialization of buffer pool Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=60972 Jul 28 06:05:51 mysqld[1725905]: 2020-07-28 6:05:51 0 [Note] InnoDB: Starting final batch to recover 88 pages from redo log. Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: Waiting for purge to start Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: 10.4.13 started; log sequence number 138390; transaction id 154 Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: Loading buffer pool(s) from /var/opt/ibm/powervc/db/ib_buffer_pool Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] Plugin 'FEEDBACK' is disabled. Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] InnoDB: Buffer pool(s) load completed at 200728 6:05:52 Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] Server socket created on IP: '127.0.0.1'. Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] Reading of all Master_info entries succeeded Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] Added new Master_info '' to hash table Jul 28 06:05:52 mysqld[1725905]: 2020-07-28 6:05:52 0 [Note] /usr/sbin/mysqld: ready for connections. Jul 28 06:05:52 mysqld[1725905]: Version: '10.4.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 50110 MariaDB Server Jul 28 06:05:52 systemd[1]: Started MariaDB 10.4.13 database server.