[MDEV-16775] mysql restart with crash dump Created: 2018-07-19  Updated: 2018-07-19  Resolved: 2018-07-19

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.2.15
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: ssauravy Assignee: Axel Schwenke
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

CentOS Linux release 7.3.1611 (Core)
3.10.0-514.26.2.el7.x86_64



 Description   

MariaDB has been restarted since server crash on 2018-07-18-21: 45: 23.
I want to know what caused the crash.

DB : 10.2.15-MariaDB

OS :

[root@BStonegmdb08 59306]# grep . /etc/*-release

/etc/centos-release:CentOS Linux release 7.3.1611 (Core)

/etc/os-release:NAME="CentOS Linux"

/etc/os-release:VERSION="7 (Core)"

/etc/os-release:ID="centos"

/etc/os-release:ID_LIKE="rhel fedora"

/etc/os-release:VERSION_ID="7"

/etc/os-release:PRETTY_NAME="CentOS Linux 7 (Core)"

/etc/os-release:ANSI_COLOR="0;31"

/etc/os-release:CPE_NAME="cpe:/o:centos:centos:7"

/etc/os-release:HOME_URL="https://www.centos.org/"

/etc/os-release:BUG_REPORT_URL="https://bugs.centos.org/"

/etc/os-release:CENTOS_MANTISBT_PROJECT="CentOS-7"

/etc/os-release:CENTOS_MANTISBT_PROJECT_VERSION="7"

/etc/os-release:REDHAT_SUPPORT_PRODUCT="centos"

/etc/os-release:REDHAT_SUPPORT_PRODUCT_VERSION="7"

/etc/redhat-release:CentOS Linux release 7.3.1611 (Core)

/etc/system-release:CentOS Linux release 7.3.1611 (Core)

kernel-version : 3.10.0-514.26.2.el7.x86_64

– maradb

[root@BStonegmdb08 59306]# cat a.txt

Variable_name Value

aria_block_size 8192

aria_checkpoint_interval 30

aria_checkpoint_log_activity 1048576

aria_encrypt_tables OFF

aria_force_start_after_recovery_failures 0

aria_group_commit none

aria_group_commit_interval 0

aria_log_file_size 1073741824

aria_log_purge_type immediate

aria_max_sort_file_size 9223372036853727232

aria_page_checksum ON

aria_pagecache_age_threshold 300

aria_pagecache_buffer_size 134217728

aria_pagecache_division_limit 100

aria_pagecache_file_hash_size 512

aria_recover_options BACKUP,QUICK

aria_repair_threads 1

aria_sort_buffer_size 268434432

aria_stats_method nulls_unequal

aria_sync_log_dir NEWFILE

aria_used_for_temp_tables ON

auto_increment_increment 1

auto_increment_offset 1

autocommit ON

automatic_sp_privileges ON

back_log 150

basedir /usr/local/mysql

big_tables OFF

binlog_annotate_row_events ON

binlog_cache_size 1048576

binlog_checksum CRC32

binlog_commit_wait_count 0

binlog_commit_wait_usec 100000

binlog_direct_non_transactional_updates OFF

binlog_format MIXED

binlog_optimize_thread_scheduling ON

binlog_row_image FULL

binlog_stmt_cache_size 32768

bulk_insert_buffer_size 8388608

character_set_client utf8mb4

character_set_connection utf8mb4

character_set_database utf8mb4

character_set_filesystem binary

character_set_results utf8mb4

character_set_server utf8mb4

character_set_system utf8

character_sets_dir /usr/local/mariadb-10.2.15-linux-x86_64/share/charsets/

check_constraint_checks ON

collation_connection utf8mb4_general_ci

collation_database utf8mb4_general_ci

collation_server utf8mb4_general_ci

completion_type NO_CHAIN

concurrent_insert AUTO

connect_timeout 10

datadir /data/59306/

date_format %Y-%m-%d

datetime_format %Y-%m-%d %H:%i:%s

deadlock_search_depth_long 15

deadlock_search_depth_short 4

deadlock_timeout_long 50000000

deadlock_timeout_short 10000

debug_no_thread_alarm OFF

default_regex_flags

default_storage_engine InnoDB

default_tmp_storage_engine

default_week_format 0

delay_key_write ON

delayed_insert_limit 100

delayed_insert_timeout 300

delayed_queue_size 1000

div_precision_increment 4

encrypt_binlog OFF

encrypt_tmp_disk_tables OFF

encrypt_tmp_files OFF

enforce_storage_engine

event_scheduler ON

expensive_subquery_limit 100

expire_logs_days 2

explicit_defaults_for_timestamp OFF

extra_max_connections 1

extra_port 0

flush OFF

flush_time 0

foreign_key_checks ON

ft_boolean_syntax + -><()~*:""&|

ft_max_word_len 84

ft_min_word_len 4

ft_query_expansion_limit 20

ft_stopword_file (built-in)

general_log OFF

general_log_file BStonegmdb08.log

group_concat_max_len 1048576

gtid_binlog_pos 0-1281591-49296747

gtid_binlog_state 0-1281591-49296747

gtid_current_pos 0-1281591-49296747

gtid_domain_id 0

gtid_ignore_duplicates OFF

gtid_slave_pos

gtid_strict_mode OFF

have_compress YES

have_crypt YES

have_dynamic_loading YES

have_geometry YES

have_openssl NO

have_profiling YES

have_query_cache YES

have_rtree_keys YES

have_ssl DISABLED

have_symlink YES

histogram_size 0

histogram_type SINGLE_PREC_HB

host_cache_size 678

hostname BStonegmdb08

ignore_builtin_innodb OFF

ignore_db_dirs lost+found

init_connect

init_file

init_slave

innodb_adaptive_flushing ON

innodb_adaptive_flushing_lwm 10.000000

innodb_adaptive_hash_index ON

innodb_adaptive_hash_index_partitions 8

innodb_adaptive_hash_index_parts 8

innodb_adaptive_max_sleep_delay 150000

innodb_autoextend_increment 64

innodb_autoinc_lock_mode 1

innodb_background_scrub_data_check_interval 3600

innodb_background_scrub_data_compressed OFF

innodb_background_scrub_data_interval 604800

innodb_background_scrub_data_uncompressed OFF

innodb_buf_dump_status_frequency 0

innodb_buffer_pool_chunk_size 134217728

innodb_buffer_pool_dump_at_shutdown ON

innodb_buffer_pool_dump_now OFF

innodb_buffer_pool_dump_pct 25

innodb_buffer_pool_filename ib_buffer_pool

innodb_buffer_pool_instances 2

innodb_buffer_pool_load_abort OFF

innodb_buffer_pool_load_at_startup ON

innodb_buffer_pool_load_now OFF

innodb_buffer_pool_populate OFF

innodb_buffer_pool_size 17179869184

innodb_change_buffer_max_size 25

innodb_change_buffering all

innodb_checksum_algorithm crc32

innodb_checksums ON

innodb_cleaner_lsn_age_factor DEPRECATED

innodb_cmp_per_index_enabled OFF

innodb_commit_concurrency 0

innodb_compression_algorithm zlib

innodb_compression_default OFF

innodb_compression_failure_threshold_pct 5

innodb_compression_level 6

innodb_compression_pad_pct_max 50

innodb_concurrency_tickets 5000

innodb_corrupt_table_action deprecated

innodb_data_file_path ibdata1:100M:autoextend

innodb_data_home_dir

innodb_deadlock_detect ON

innodb_default_encryption_key_id 1

innodb_default_row_format dynamic

innodb_defragment OFF

innodb_defragment_fill_factor 0.900000

innodb_defragment_fill_factor_n_recs 20

innodb_defragment_frequency 40

innodb_defragment_n_pages 7

innodb_defragment_stats_accuracy 0

innodb_disable_sort_file_cache OFF

innodb_disallow_writes OFF

innodb_doublewrite OFF

innodb_empty_free_list_algorithm DEPRECATED

innodb_encrypt_log OFF

innodb_encrypt_tables OFF

innodb_encryption_rotate_key_age 1

innodb_encryption_rotation_iops 100

innodb_encryption_threads 0

innodb_fake_changes OFF

innodb_fast_shutdown 1

innodb_fatal_semaphore_wait_threshold 600

innodb_file_format Barracuda

innodb_file_format_check ON

innodb_file_format_max Barracuda

innodb_file_per_table ON

innodb_fill_factor 100

innodb_flush_log_at_timeout 1

innodb_flush_log_at_trx_commit 0

innodb_flush_method O_DIRECT

innodb_flush_neighbors 1

innodb_flush_sync ON

innodb_flushing_avg_loops 30

innodb_force_load_corrupted OFF

innodb_force_primary_key OFF

innodb_force_recovery 0

innodb_foreground_preflush DEPRECATED

innodb_ft_aux_table

innodb_ft_cache_size 8000000

innodb_ft_enable_diag_print OFF

innodb_ft_enable_stopword ON

innodb_ft_max_token_size 84

innodb_ft_min_token_size 3

innodb_ft_num_word_optimize 2000

innodb_ft_result_cache_limit 2000000000

innodb_ft_server_stopword_table

innodb_ft_sort_pll_degree 2

innodb_ft_total_cache_size 640000000

innodb_ft_user_stopword_table

innodb_idle_flush_pct 100

innodb_immediate_scrub_data_uncompressed OFF

innodb_instrument_semaphores OFF

innodb_io_capacity 2000

innodb_io_capacity_max 20000

innodb_kill_idle_transaction 0

innodb_large_prefix ON

innodb_lock_schedule_algorithm vats

innodb_lock_wait_timeout 50

innodb_locking_fake_changes OFF

innodb_locks_unsafe_for_binlog OFF

innodb_log_arch_dir

innodb_log_arch_expire_sec 0

innodb_log_archive OFF

innodb_log_block_size 0

innodb_log_buffer_size 16777216

innodb_log_checksum_algorithm DEPRECATED

innodb_log_checksums ON

innodb_log_compressed_pages ON

innodb_log_file_size 1073741824

innodb_log_files_in_group 3

innodb_log_group_home_dir /log/59306

innodb_log_write_ahead_size 8192

innodb_lru_scan_depth 1024

innodb_max_bitmap_file_size 0

innodb_max_changed_pages 0

innodb_max_dirty_pages_pct 90.000000

innodb_max_dirty_pages_pct_lwm 0.000000

innodb_max_purge_lag 0

innodb_max_purge_lag_delay 0

innodb_max_undo_log_size 10485760

innodb_mirrored_log_groups 0

innodb_monitor_disable

innodb_monitor_enable

innodb_monitor_reset

innodb_monitor_reset_all

innodb_mtflush_threads 8

innodb_old_blocks_pct 37

innodb_old_blocks_time 1000

innodb_online_alter_log_max_size 134217728

innodb_open_files 2048

innodb_optimize_fulltext_only OFF

innodb_page_cleaners 2

innodb_page_size 16384

innodb_prefix_index_cluster_optimization OFF

innodb_print_all_deadlocks OFF

innodb_purge_batch_size 300

innodb_purge_rseg_truncate_frequency 128

innodb_purge_threads 4

innodb_random_read_ahead OFF

innodb_read_ahead_threshold 56

innodb_read_io_threads 8

innodb_read_only OFF

innodb_replication_delay 0

innodb_rollback_on_timeout OFF

innodb_rollback_segments 35

innodb_sched_priority_cleaner 0

innodb_scrub_log OFF

innodb_scrub_log_speed 256

innodb_show_locks_held 0

innodb_show_verbose_locks 0

innodb_sort_buffer_size 1048576

innodb_spin_wait_delay 6

innodb_stats_auto_recalc ON

innodb_stats_include_delete_marked OFF

innodb_stats_method nulls_equal

innodb_stats_modified_counter 0

innodb_stats_on_metadata OFF

innodb_stats_persistent ON

innodb_stats_persistent_sample_pages 20

innodb_stats_sample_pages 8

innodb_stats_traditional ON

innodb_stats_transient_sample_pages 8

innodb_status_output OFF

innodb_status_output_locks OFF

innodb_strict_mode ON

innodb_support_xa ON

innodb_sync_array_size 1

innodb_sync_spin_loops 30

innodb_table_locks ON

innodb_temp_data_file_path ibtmp1:12M:autoextend

innodb_thread_concurrency 16

innodb_thread_sleep_delay 0

innodb_tmpdir

innodb_track_changed_pages OFF

innodb_track_redo_log_now OFF

innodb_undo_directory /data/59306

innodb_undo_log_truncate ON

innodb_undo_logs 35

innodb_undo_tablespaces 0

innodb_use_atomic_writes ON

innodb_use_fallocate OFF

innodb_use_global_flush_log_at_trx_commit OFF

innodb_use_mtflush OFF

innodb_use_native_aio ON

innodb_use_stacktrace OFF

innodb_use_trim ON

innodb_version 5.7.22

innodb_write_io_threads 8

interactive_timeout 28800

join_buffer_size 262144

join_buffer_space_limit 2097152

join_cache_level 2

keep_files_on_create OFF

key_buffer_size 33554432

key_cache_age_threshold 300

key_cache_block_size 1024

key_cache_division_limit 100

key_cache_file_hash_size 512

key_cache_segments 0

large_files_support ON

large_page_size 0

large_pages OFF

lc_messages en_US

lc_messages_dir

lc_time_names en_US

license GPL

local_infile ON

lock_wait_timeout 86400

locked_in_memory OFF

log_bin ON

log_bin_basename /log/59306/mysql-bin

log_bin_compress OFF

log_bin_compress_min_len 256

log_bin_index /log/59306/mysql-bin.index

log_bin_trust_function_creators ON

log_error /data/59306/BStonegmdb08.err

log_output FILE,TABLE

log_queries_not_using_indexes OFF

log_slave_updates OFF

log_slow_admin_statements ON

log_slow_filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk

log_slow_rate_limit 1

log_slow_slave_statements ON

log_slow_verbosity

log_tc_size 24576

log_warnings 2

long_query_time 1.000000

low_priority_updates OFF

lower_case_file_system OFF

lower_case_table_names 1

master_verify_checksum ON

max_allowed_packet 16777216

max_binlog_cache_size 18446744073709547520

max_binlog_size 1073741824

max_binlog_stmt_cache_size 18446744073709547520

max_connect_errors 99999

max_connections 1500

max_delayed_threads 20

max_digest_length 1024

max_error_count 64

max_heap_table_size 16777216

max_insert_delayed_threads 20

max_join_size 18446744073709551615

max_length_for_sort_data 1024

max_long_data_size 16777216

max_prepared_stmt_count 16382

max_recursive_iterations 4294967295

max_relay_log_size 1073741824

max_seeks_for_key 4294967295

max_session_mem_used 9223372036854775807

max_sort_length 1024

max_sp_recursion_depth 0

max_statement_time 0.000000

max_tmp_tables 32

max_user_connections 0

max_write_lock_count 4294967295

metadata_locks_cache_size 1024

metadata_locks_hash_instances 8

min_examined_row_limit 0

mrr_buffer_size 262144

multi_range_count 256

myisam_block_size 1024

myisam_data_pointer_size 6

myisam_max_sort_file_size 9223372036853727232

myisam_mmap_size 18446744073709551615

myisam_recover_options BACKUP,QUICK

myisam_repair_threads 1

myisam_sort_buffer_size 134216704

myisam_stats_method NULLS_UNEQUAL

myisam_use_mmap OFF

mysql56_temporal_format ON

net_buffer_length 16384

net_read_timeout 30

net_retry_count 10

net_write_timeout 60

old OFF

old_alter_table OFF

old_mode

old_passwords OFF

open_files_limit 65000

optimizer_prune_level 1

optimizer_search_depth 62

optimizer_selectivity_sampling_limit 100

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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

optimizer_use_condition_selectivity 1

performance_schema OFF

performance_schema_accounts_size -1

performance_schema_digests_size -1

performance_schema_events_stages_history_long_size -1

performance_schema_events_stages_history_size -1

performance_schema_events_statements_history_long_size -1

performance_schema_events_statements_history_size -1

performance_schema_events_waits_history_long_size -1

performance_schema_events_waits_history_size -1

performance_schema_hosts_size -1

performance_schema_max_cond_classes 80

performance_schema_max_cond_instances -1

performance_schema_max_digest_length 1024

performance_schema_max_file_classes 50

performance_schema_max_file_handles 32768

performance_schema_max_file_instances -1

performance_schema_max_mutex_classes 200

performance_schema_max_mutex_instances -1

performance_schema_max_rwlock_classes 40

performance_schema_max_rwlock_instances -1

performance_schema_max_socket_classes 10

performance_schema_max_socket_instances -1

performance_schema_max_stage_classes 150

performance_schema_max_statement_classes 188

performance_schema_max_table_handles -1

performance_schema_max_table_instances -1

performance_schema_max_thread_classes 50

performance_schema_max_thread_instances -1

performance_schema_session_connect_attrs_size -1

performance_schema_setup_actors_size 100

performance_schema_setup_objects_size 100

performance_schema_users_size -1

pid_file /data/59306/mysql.pid

plugin_dir /usr/local/mysql/lib/plugin/

plugin_maturity unknown

port 59306

preload_buffer_size 32768

profiling OFF

profiling_history_size 15

progress_report_time 5

protocol_version 10

query_alloc_block_size 16384

query_cache_limit 1048576

query_cache_min_res_unit 4096

query_cache_size 0

query_cache_strip_comments OFF

query_cache_type OFF

query_cache_wlock_invalidate OFF

query_prealloc_size 24576

range_alloc_block_size 4096

read_binlog_speed_limit 0

read_buffer_size 131072

read_only OFF

read_rnd_buffer_size 262144

relay_log

relay_log_basename

relay_log_index

relay_log_info_file relay-log.info

relay_log_purge ON

relay_log_recovery OFF

relay_log_space_limit 0

replicate_annotate_row_events ON

replicate_do_db

replicate_do_table

replicate_events_marked_for_skip REPLICATE

replicate_ignore_db

replicate_ignore_table

replicate_wild_do_table

replicate_wild_ignore_table

report_host 10.161.131.220

report_password

report_port 59306

report_user

rowid_merge_buff_size 8388608

secure_auth ON

secure_file_priv

server_id 1281591

session_track_schema ON

session_track_state_change OFF

session_track_system_variables

session_track_transaction_info OFF

skip_external_locking ON

skip_name_resolve ON

skip_networking OFF

skip_show_database OFF

slave_compressed_protocol OFF

slave_ddl_exec_mode IDEMPOTENT

slave_domain_parallel_threads 0

slave_exec_mode STRICT

slave_load_tmpdir /tmp

slave_max_allowed_packet 1073741824

slave_net_timeout 60

slave_parallel_max_queued 131072

slave_parallel_mode conservative

slave_parallel_threads 0

slave_parallel_workers 0

slave_run_triggers_for_rbr NO

slave_skip_errors OFF

slave_sql_verify_checksum ON

slave_transaction_retries 10

slave_type_conversions

slow_launch_time 2

slow_query_log ON

slow_query_log_file BStonegmdb08-slow.log

socket /tmp/mysql_59306.sock

sort_buffer_size 2097152

sql_auto_is_null OFF

sql_big_selects ON

sql_buffer_result OFF

sql_log_bin ON

sql_log_off OFF

sql_mode STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

sql_notes ON

sql_quote_show_create ON

sql_safe_updates OFF

sql_select_limit 18446744073709551615

sql_slave_skip_counter 0

sql_warnings OFF

ssl_ca

ssl_capath

ssl_cert

ssl_cipher

ssl_crl

ssl_crlpath

ssl_key

standard_compliant_cte ON

storage_engine InnoDB

stored_program_cache 256

strict_password_validation ON

sync_binlog 0

sync_frm ON

sync_master_info 1

sync_relay_log 10000

sync_relay_log_info 10000

system_time_zone HKT

table_definition_cache 2048

table_open_cache 2048

table_open_cache_instances 8

thread_cache_size 256

thread_concurrency 10

thread_handling pool-of-threads

thread_pool_idle_timeout 60

thread_pool_max_threads 65536

thread_pool_oversubscribe 3

thread_pool_prio_kickup_timer 1000

thread_pool_priority auto

thread_pool_size 20

thread_pool_stall_limit 500

thread_stack 299008

time_format %H:%i:%s

time_zone SYSTEM

timed_mutexes OFF

tmp_disk_table_size 18446744073709551615

tmp_memory_table_size 16777216

tmp_table_size 16777216

tmpdir /tmp

transaction_alloc_block_size 8192

transaction_prealloc_size 4096

tx_isolation READ-COMMITTED

tx_read_only OFF

unique_checks ON

updatable_views_with_limit YES

use_stat_tables NEVER

userstat OFF

version 10.2.15-MariaDB-log

version_comment MariaDB Server

version_compile_machine x86_64

version_compile_os Linux

version_malloc_library system

version_ssl_library YaSSL 2.4.4

wait_timeout 28800

wsrep_osu_method TOI

wsrep_auto_increment_control ON

wsrep_causal_reads OFF

wsrep_certify_nonpk ON

wsrep_cluster_address

wsrep_cluster_name my_wsrep_cluster

wsrep_convert_lock_to_trx OFF

wsrep_data_home_dir /data/59306/

wsrep_dbug_option

wsrep_debug OFF

wsrep_desync OFF

wsrep_dirty_reads OFF

wsrep_drupal_282555_workaround OFF

wsrep_forced_binlog_format NONE

wsrep_gtid_domain_id 0

wsrep_gtid_mode OFF

wsrep_load_data_splitting ON

wsrep_log_conflicts OFF

wsrep_max_ws_rows 0

wsrep_max_ws_size 2147483647

wsrep_mysql_replication_bundle 0

wsrep_node_address

wsrep_node_incoming_address AUTO

wsrep_node_name BStonegmdb08

wsrep_notify_cmd

wsrep_on OFF

wsrep_patch_version wsrep_25.23

wsrep_provider none

wsrep_provider_options

wsrep_recover OFF

wsrep_reject_queries NONE

wsrep_replicate_myisam OFF

wsrep_restart_slave OFF

wsrep_retry_autocommit 1

wsrep_slave_fk_checks ON

wsrep_slave_uk_checks OFF

wsrep_slave_threads 1

wsrep_sst_auth

wsrep_sst_donor

wsrep_sst_donor_rejects_queries OFF

wsrep_sst_method rsync

wsrep_sst_receive_address AUTO

wsrep_start_position 00000000-0000-0000-0000-000000000000:-1

wsrep_sync_wait 0

– maria db log

2018-07-18 21:37:18 140668366944000 [Warning] Aborted connection 14061 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:38:18 140686421403392 [Warning] Aborted connection 14063 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:39:18 140686421403392 [Warning] Aborted connection 14065 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:40:18 140686420797184 [Warning] Aborted connection 14067 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:41:18 140686422009600 [Warning] Aborted connection 14068 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:42:18 140686422009600 [Warning] Aborted connection 14070 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:43:18 140686420797184 [Warning] Aborted connection 14072 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:44:18 140668237940480 [Warning] Aborted connection 14074 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Uses event mutexes

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Using Linux native AIO

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Number of pools: 1

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Using SSE2 crc32 instructions

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Initializing buffer pool, total size = 16G, instances = 2, chunk size = 128M

2018-07-18 21:47:21 139827621287744 [Note] InnoDB: Completed initialization of buffer pool

2018-07-18 21:47:22 139808737433344 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-07-18 21:47:22 139827621287744 [Note] InnoDB: Highest supported file format is Barracuda.

2018-07-18 21:47:22 139827621287744 [Note] InnoDB: Starting crash recovery from checkpoint LSN=130927709873

2018-07-18 21:47:22 139827621287744 [Note] InnoDB: Starting final batch to recover 4256 pages from redo log.

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: Last binlog file '/log/59306/mysql-bin.000574', position 67318967

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: 35 out of 35 rollback segments are active.

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-07-18 21:47:23 139827621287744 [Note] InnoDB: 5.7.22 started; log sequence number 130935799686

2018-07-18 21:47:23 139809087543040 [Note] InnoDB: Loading buffer pool(s) from /data/59306/ib_buffer_pool

2018-07-18 21:47:23 139827621287744 [Note] Plugin 'FEEDBACK' is disabled.

2018-07-18 21:47:23 139827621287744 [Note] Recovering after a crash using /log/59306/mysql-bin

2018-07-18 21:47:23 139809087543040 [Note] InnoDB: Buffer pool(s) load completed at 180718 21:47:23

2018-07-18 21:47:27 139827621287744 [Note] Starting crash recovery...

2018-07-18 21:47:27 139827621287744 [Note] Crash recovery finished.

2018-07-18 21:47:27 139827621287744 [Note] Server socket created on IP: '::'.

2018-07-18 21:47:27 139827621287744 [Warning] 'proxies_priv' entry '@% root@bstonegmdb08' ignored in --skip-name-resolve mode.

2018-07-18 21:47:27 139827559905024 [Note] Event Scheduler: scheduler thread started with id 7

2018-07-18 21:47:27 139827621287744 [Note] Reading of all Master_info entries succeded

2018-07-18 21:47:27 139827621287744 [Note] Added new Master_info '' to hash table

2018-07-18 21:47:27 139827621287744 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Version: '10.2.15-MariaDB-log' socket: '/tmp/mysql_59306.sock' port: 59306 MariaDB Server

2018-07-18 21:48:24 139827294033664 [Note] Start binlog_dump to slave_server(1282071), pos(mysql-bin.000574, 71369004)

2018-07-18 21:48:56 139827293124352 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:49:27 139827294336768 [Note] Start binlog_dump to slave_server(1282071), pos(mysql-bin.000574, 71369004)

2018-07-18 21:49:56 139827292821248 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:50:56 139827293730560 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

2018-07-18 21:51:56 139827291911936 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Can't get hostname for your address)

– crash dump log

KERNEL: vmlinux

DUMPFILE: /var/crash/127.0.0.1-2018-07-18-21:45:23/vmcore [PARTIAL DUMP]

CPUS: 20

DATE: Wed Jul 18 21:45:08 2018

UPTIME: 17 days, 14:31:08

LOAD AVERAGE: 0.18, 0.15, 0.14

TASKS: 453

NODENAME: BStonegmdb08

RELEASE: 3.10.0-514.26.2.el7.x86_64

VERSION: #1 SMP Tue Jul 4 15:04:05 UTC 2017

MACHINE: x86_64 (2399 Mhz)

MEMORY: 31.9 GB

PANIC: "BUG: unable to handle kernel paging request at 000000000102005a"

PID: 162990

COMMAND: "mysqld"

TASK: ffff880663758fb0 [THREAD_INFO: ffff88064ea20000]

CPU: 13

STATE: TASK_RUNNING (PANIC)

crash> bt

PID: 162990 TASK: ffff880663758fb0 CPU: 13 COMMAND: "mysqld"

#0 [ffff88064ea23858] machine_kexec at ffffffff81059beb

#1 [ffff88064ea238b8] __crash_kexec at ffffffff81105822

#2 [ffff88064ea23988] crash_kexec at ffffffff81105910

#3 [ffff88064ea239a0] oops_end at ffffffff81690008

#4 [ffff88064ea239c8] no_context at ffffffff8167fc96

#5 [ffff88064ea23a18] __bad_area_nosemaphore at ffffffff8167fd2c

#6 [ffff88064ea23a60] bad_area_nosemaphore at ffffffff8167fe96

#7 [ffff88064ea23a70] __do_page_fault at ffffffff81692e4e

#8 [ffff88064ea23ad0] do_page_fault at ffffffff81692ff5

#9 [ffff88064ea23b00] page_fault at ffffffff8168f208

[exception RIP: unknown or invalid address]

RIP: 000000000102005a RSP: ffff88064ea23bb8 RFLAGS: 00010246

RAX: ffffea00169e8e00 RBX: 000000003c6f2000 RCX: ffff88064ea23fd8

RDX: 0000000000000000 RSI: ffff8806c262af58 RDI: 0000000000000003

RBP: 000000000102005a R8: 0000000000000002 R9: ffffea00169e8e1c

R10: ffff88064ea23b60 R11: 0000000000000000 R12: ffff88080c336d48

R13: 000000000102005a R14: 000000000003c6f2 R15: 00000000000000d0

ORIG_RAX: ffffffffffffffff CS: 0010 SS: 0018

#10 [ffff88064ea23bc0] grab_cache_page_write_begin at ffffffff811819c2

#11 [ffff88064ea23c00] xfs_vm_write_begin at ffffffffa04061b4 [xfs]

#12 [ffff88064ea23c48] generic_file_buffered_write at ffffffff81181bbe

#13 [ffff88064ea23d10] xfs_file_buffered_aio_write at ffffffffa0413cdb [xfs]

#14 [ffff88064ea23dc0] xfs_file_aio_write at ffffffffa0413fbd [xfs]

#15 [ffff88064ea23e18] do_sync_write at ffffffff811fe18d

#16 [ffff88064ea23ef0] vfs_write at ffffffff811fe9fd

#17 [ffff88064ea23f30] sys_pwrite64 at ffffffff811ff6d2

#18 [ffff88064ea23f80] system_call_fastpath at ffffffff81697809

RIP: 00007ff42f9c2d63 RSP: 00007fefeb9dda18 RFLAGS: 00000246

RAX: 0000000000000012 RBX: ffffffff81697809 RCX: 0000000000239400

RDX: 0000000000239400 RSI: 00007fefeb9df200 RDI: 000000000000000c

RBP: 00007fefeb9dd140 R8: 000000003c656c00 R9: 00007fefeb9dd598

R10: 000000003c656c00 R11: 0000000000000293 R12: 00007fefeb9df200

R13: 0000000000239400 R14: 000000000000000c R15: 00007fefeb9df200

ORIG_RAX: 0000000000000012 CS: 0033 SS: 002b



 Comments   
Comment by Axel Schwenke [ 2018-07-19 ]

This is not a MariaDB bug. The key is this message from syslog: unable to handle kernel paging request. It means that the Linux kernel could not map physical memory to an adress in the virtual memory space of some process. As a result that process had to be stopped (crashed).

There are many reasons why this could happen. Most simple one: the memory (and swap space) is full. It could also be a hardware problem like faulty memory or a bad power supply.

Check the memory consumption of the processes running on this machine and make sure that it doesn't exceed the 32G of memory that you seem to have. You might also want to run memtest to check if the hardware is good.

Generated at Thu Feb 08 08:31:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.