Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16775

mysql restart with crash dump

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.2.15
    • N/A
    • N/A
    • None
    • 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

      Attachments

        Activity

          People

            axel Axel Schwenke
            kyoung-yeon ssauravy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.