Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Perl Error #280

Closed
jerotire opened this issue Dec 5, 2016 · 3 comments
Closed

Perl Error #280

jerotire opened this issue Dec 5, 2016 · 3 comments

Comments

@jerotire
Copy link

jerotire commented Dec 5, 2016

I am unable to use this perl script in my environment; I believe it is a script error:

Environment:

CentOS Linux release 7.2.1511 (Core)
Linux DBSERVER 3.10.0-327.36.3.el7.x86_64 #1 SMP Mon Oct 24 16:09:20 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

Perl 5.16 with perldoc

MySQL version 10.1.19-MariaDB

/etc/yum.repos.d/MariaDB.repo

# MariaDB 10.1 CentOS repository list - created 2016-11-28 01:53 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Acquisition:

wget http://mysqltuner.pl/ -O mysqltuner.pl
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv

Commands & Output:

[root@DBSERVER] [MySQLTuner] # ls -lsha
total 804K
   0 drwxr-xr-x. 2 root root   78 Dec  5 06:05 .
4.0K dr-xr-x---. 6 root root 4.0K Dec  5 06:05 ..
4.0K -rw-r--r--. 1 root root 3.9K Dec  5 06:05 basic_passwords.txt
204K -rw-r--r--. 1 root root 204K Dec  5 06:05 mysqltuner.pl
592K -rw-r--r--. 1 root root 589K Dec  5 06:05 vulnerabilities.csv


[root@DBSERVER] [MySQLTuner] # md5sum *
e7edeeeca2607b1502207eb2cd84a618  basic_passwords.txt
c14b2e7a530e5474410b8bb2d1230841  mysqltuner.pl
baebf6d93382c65e42f06237110936ba  vulnerabilities.csv


[root@DBSERVER] [MySQLTuner] # perl -v

This is perl 5, version 16, subversion 3 (v5.16.3) built for x86_64-linux-thread-multi
(with 29 registered patches, see perl -V for more detail)

Copyright 1987-2012, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.


[root@DBSERVER] [MySQLTuner] # perl mysqltuner.pl
 >>  MySQLTuner 1.7.0 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 10.1.19-MariaDB
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
Use of uninitialized value $num in string eq at mysqltuner.pl line 323, <STDIN>
        line 2 (#1)
    (W uninitialized) An undefined value was used as if it were already
    defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
    To suppress this warning assign a defined value to your variables.

    To help you figure out what was undefined, perl will try to tell you
    the name of the variable (if any) that was undefined.  In some cases
    it cannot do this, so it also tells you what operation you used the
    undefined value in.  Note, however, that perl optimizes your program
    anid the operation displayed in the warning may not necessarily appear
    literally in your program.  For example, "that $foo" is usually
    optimized into "that " . $foo, and the warning will refer to the
    concatenation (.) operator, even though there is no . in
    your program.

Use of uninitialized value $num in numeric ge (>=) at mysqltuner.pl line 325,
        <STDIN> line 2 (#1)
Use of uninitialized value $num in numeric ge (>=) at mysqltuner.pl line 328,
        <STDIN> line 2 (#1)
Use of uninitialized value $num in numeric ge (>=) at mysqltuner.pl line 331,
        <STDIN> line 2 (#1)
Use of uninitialized value $num in concatenation (.) or string at mysqltuner.pl
        line 335, <STDIN> line 2 (#1)
[--] Log file: (B)
[!!] Log file  doesn't exist
Use of uninitialized value in numeric gt (>) at mysqltuner.pl line 1114,
        <STDIN> line 2 (#1)
[!!] Log file  is empty
Use of uninitialized value in numeric lt (<) at mysqltuner.pl line 1120,
        <STDIN> line 2 (#1)
[OK] Log file  is smaller than 32 Mb

Can't open  for read: No such file or directory at mysqltuner.pl line 1095,
        <STDIN> line 2 (#2)
    (S inplace) The implicit opening of a file through use of the <>
    filehandle, either implicitly under the -n or -p command-line
    switches, or explicitly, failed for the indicated reason.  Usually
    this is because you don't have read permission for a file which
    you named on the command line.

    (F) You tried to call perl with the -e switch, but /dev/null (or
    your operating system's equivalent) could not be opened.

Uncaught exception from user code:
        Can't open  for read: No such file or directory at mysqltuner.pl line 1095, <STDIN> line 2.
        main::get_file_contents('') called at mysqltuner.pl line 1128
        main::log_file_recommandations() called at mysqltuner.pl line 5872
[root@DBSERVER] [MySQLTuner] #

SHOW VARIABLES

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	NORMAL	
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	80	
basedir	/usr/	
big_tables	OFF	
binlog_annotate_row_events	OFF	
binlog_cache_size	32768	
binlog_checksum	NONE	
binlog_commit_wait_count	0	
binlog_commit_wait_usec	100000	
binlog_direct_non_transactional_updates	OFF	
binlog_format	STATEMENT	
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	latin1	
character_set_filesystem	binary	
character_set_results	utf8mb4	
character_set_server	latin1	
character_set_system	utf8	
character_sets_dir	/usr/share/mysql/charsets/	
collation_connection	utf8mb4_unicode_ci	
collation_database	latin1_swedish_ci	
collation_server	latin1_swedish_ci	
completion_type	NO_CHAIN	
concurrent_insert	AUTO	
connect_timeout	10	
datadir	/var/lib/mysql/	
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_master_connection		
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		
error_count	0	
event_scheduler	OFF	
expensive_subquery_limit	100	
expire_logs_days	0	
explicit_defaults_for_timestamp	OFF	
external_user		
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	a.log	
group_concat_max_len	1024	
gtid_binlog_pos		
gtid_binlog_state		
gtid_current_pos		
gtid_domain_id	0	
gtid_ignore_duplicates	OFF	
gtid_seq_no	0	
gtid_slave_pos		
gtid_strict_mode	OFF	
have_compress	YES	
have_crypt	YES	
have_dynamic_loading	YES	
have_geometry	YES	
have_openssl	YES	
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	279	
hostname	******
identity	0	
ignore_builtin_innodb	OFF	
ignore_db_dirs		
in_transaction	0	
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	1	
innodb_adaptive_max_sleep_delay	150000	
innodb_additional_mem_pool_size	8388608	
innodb_api_bk_commit_interval	5	
innodb_api_disable_rowlock	OFF	
innodb_api_enable_binlog	OFF	
innodb_api_enable_mdl	OFF	
innodb_api_trx_level	0	
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_dump_at_shutdown	OFF	
innodb_buffer_pool_dump_now	OFF	
innodb_buffer_pool_dump_pct	100	
innodb_buffer_pool_filename	ib_buffer_pool	
innodb_buffer_pool_instances	8	
innodb_buffer_pool_load_abort	OFF	
innodb_buffer_pool_load_at_startup	OFF	
innodb_buffer_pool_load_now	OFF	
innodb_buffer_pool_populate	OFF	
innodb_buffer_pool_size	134217728	
innodb_change_buffer_max_size	25	
innodb_change_buffering	all	
innodb_checksum_algorithm	INNODB	
innodb_checksums	ON	
innodb_cleaner_lsn_age_factor	HIGH_CHECKPOINT	
innodb_cmp_per_index_enabled	OFF	
innodb_commit_concurrency	0	
innodb_compression_algorithm	none	
innodb_compression_failure_threshold_pct	5	
innodb_compression_level	6	
innodb_compression_pad_pct_max	50	
innodb_concurrency_tickets	5000	
innodb_corrupt_table_action	assert	
innodb_data_file_path	ibdata1:12M:autoextend	
innodb_data_home_dir		
innodb_default_encryption_key_id	1	
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	ON	
innodb_empty_free_list_algorithm	BACKOFF	
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	Antelope	
innodb_file_format_check	ON	
innodb_file_format_max	Antelope	
innodb_file_per_table	ON	
innodb_flush_log_at_timeout	1	
innodb_flush_log_at_trx_commit	1	
innodb_flush_method		
innodb_flush_neighbors	1	
innodb_flushing_avg_loops	30	
innodb_force_load_corrupted	OFF	
innodb_force_primary_key	OFF	
innodb_force_recovery	0	
innodb_foreground_preflush	EXPONENTIAL_BACKOFF	
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	200	
innodb_io_capacity_max	2000	
innodb_kill_idle_transaction	0	
innodb_large_prefix	OFF	
innodb_lock_schedule_algorithm	fcfs	
innodb_lock_wait_timeout	50	
innodb_locking_fake_changes	ON	
innodb_locks_unsafe_for_binlog	OFF	
innodb_log_arch_dir	./	
innodb_log_arch_expire_sec	0	
innodb_log_archive	OFF	
innodb_log_block_size	512	
innodb_log_buffer_size	16777216	
innodb_log_checksum_algorithm	INNODB	
innodb_log_compressed_pages	OFF	
innodb_log_file_size	50331648	
innodb_log_files_in_group	2	
innodb_log_group_home_dir	./	
innodb_lru_scan_depth	1024	
innodb_max_bitmap_file_size	104857600	
innodb_max_changed_pages	1000000	
innodb_max_dirty_pages_pct	75.000000	
innodb_max_dirty_pages_pct_lwm	0.001000	
innodb_max_purge_lag	0	
innodb_max_purge_lag_delay	0	
innodb_mirrored_log_groups	1	
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	2000	
innodb_optimize_fulltext_only	OFF	
innodb_page_size	16384	
innodb_prefix_index_cluster_optimization	OFF	
innodb_print_all_deadlocks	OFF	
innodb_purge_batch_size	300	
innodb_purge_threads	1	
innodb_random_read_ahead	OFF	
innodb_read_ahead_threshold	56	
innodb_read_io_threads	4	
innodb_read_only	OFF	
innodb_replication_delay	0	
innodb_rollback_on_timeout	OFF	
innodb_rollback_segments	128	
innodb_sched_priority_cleaner	19	
innodb_scrub_log	OFF	
innodb_scrub_log_speed	256	
innodb_show_locks_held	10	
innodb_show_verbose_locks	0	
innodb_simulate_comp_failures	0	
innodb_sort_buffer_size	1048576	
innodb_spin_wait_delay	6	
innodb_stats_auto_recalc	ON	
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	OFF	
innodb_support_xa	ON	
innodb_sync_array_size	1	
innodb_sync_spin_loops	30	
innodb_table_locks	ON	
innodb_thread_concurrency	0	
innodb_thread_sleep_delay	10000	
innodb_tmpdir		
innodb_track_changed_pages	OFF	
innodb_undo_directory	.	
innodb_undo_logs	128	
innodb_undo_tablespaces	0	
innodb_use_atomic_writes	OFF	
innodb_use_fallocate	OFF	
innodb_use_global_flush_log_at_trx_commit	ON	
innodb_use_mtflush	OFF	
innodb_use_native_aio	ON	
innodb_use_stacktrace	OFF	
innodb_use_sys_malloc	ON	
innodb_use_trim	OFF	
innodb_version	5.6.32-79.0	
innodb_write_io_threads	4	
insert_id	0	
interactive_timeout	28800	
join_buffer_size	262144	
join_buffer_space_limit	2097152	
join_cache_level	2	
keep_files_on_create	OFF	
key_buffer_size	134217728	
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	
last_gtid		
last_insert_id	0	
lc_messages	en_US	
lc_messages_dir		
lc_time_names	en_US	
license	GPL	
local_infile	ON	
lock_wait_timeout	31536000	
locked_in_memory	OFF	
log_bin	OFF	
log_bin_basename		
log_bin_index		
log_bin_trust_function_creators	OFF	
log_error		
log_output	FILE	
log_queries_not_using_indexes	OFF	
log_slave_updates	OFF	
log_slow_admin_statements	OFF	
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	OFF	
log_slow_verbosity		
log_tc_size	24576	
log_warnings	1	
long_query_time	10.000000	
low_priority_updates	OFF	
lower_case_file_system	OFF	
lower_case_table_names	0	
master_verify_checksum	OFF	
max_allowed_packet	4194304	
max_binlog_cache_size	18446744073709547520	
max_binlog_size	1073741824	
max_binlog_stmt_cache_size	18446744073709547520	
max_connect_errors	100	
max_connections	151	
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	4194304	
max_prepared_stmt_count	16382	
max_relay_log_size	1073741824	
max_seeks_for_key	4294967295	
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	DEFAULT	
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	16364	
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=off	
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	178	
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	/var/lib/mysql/a.pid	
plugin_dir	/usr/lib64/mysql/plugin/	
plugin_maturity	unknown	
port	3306	
preload_buffer_size	32768	
profiling	OFF	
profiling_history_size	15	
progress_report_time	5	
protocol_version	10	
proxy_user		
pseudo_slave_mode	OFF	
pseudo_thread_id	171	
query_alloc_block_size	16384	
query_cache_limit	1048576	
query_cache_min_res_unit	4096	
query_cache_size	1048576	
query_cache_strip_comments	OFF	
query_cache_type	OFF	
query_cache_wlock_invalidate	OFF	
query_prealloc_size	24576	
rand_seed1	576010907	
rand_seed2	741115504	
range_alloc_block_size	4096	
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	OFF	
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		
report_password		
report_port	3306	
report_user		
rowid_merge_buff_size	8388608	
secure_auth	ON	
secure_file_priv		
server_id	0	
skip_external_locking	ON	
skip_name_resolve	OFF	
skip_networking	OFF	
skip_parallel_replication	OFF	
skip_replication	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	3600	
slave_parallel_max_queued	131072	
slave_parallel_mode	conservative	
slave_parallel_threads	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	OFF	
slow_query_log_file	a-slow.log	
socket	/var/lib/mysql/mysql.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	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		
storage_engine	InnoDB	
stored_program_cache	256	
strict_password_validation	ON	
sync_binlog	0	
sync_frm	ON	
sync_master_info	10000	
sync_relay_log	10000	
sync_relay_log_info	10000	
system_time_zone	UTC	
table_definition_cache	400	
table_open_cache	2000	
thread_cache_size	0	
thread_concurrency	10	
thread_handling	one-thread-per-connection	
thread_pool_idle_timeout	60	
thread_pool_max_threads	1000	
thread_pool_oversubscribe	3	
thread_pool_size	4	
thread_pool_stall_limit	500	
thread_stack	295936	
time_format	%H:%i:%s	
time_zone	SYSTEM	
timed_mutexes	OFF	
timestamp	1480919461.693245	
tmp_table_size	16777216	
tmpdir	/tmp	
transaction_alloc_block_size	8192	
transaction_prealloc_size	4096	
tx_isolation	REPEATABLE-READ	
tx_read_only	OFF	
unique_checks	ON	
updatable_views_with_limit	YES	
use_stat_tables	NEVER	
userstat	OFF	
version	10.1.19-MariaDB	
version_comment	MariaDB Server	
version_compile_machine	x86_64	
version_compile_os	Linux	
version_malloc_library	system jemalloc	
version_ssl_library	OpenSSL 1.0.1e-fips 11 Feb 2013	
wait_timeout	28800	
warning_count	0	
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	/var/lib/mysql/	
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	*******	
wsrep_notify_cmd		
wsrep_on	OFF	
wsrep_patch_version	wsrep_25.16	
wsrep_provider	none	
wsrep_provider_options		
wsrep_recover	OFF	
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	

SHOW GLOBAL STATUS


Aborted_clients	0	
Aborted_connects	7	
Access_denied_errors	7	
Acl_column_grants	0	
Acl_database_grants	2	
Acl_function_grants	0	
Acl_procedure_grants	0	
Acl_proxy_users	2	
Acl_role_grants	0	
Acl_roles	0	
Acl_table_grants	0	
Acl_users	7	
Aria_pagecache_blocks_not_flushed	0	
Aria_pagecache_blocks_unused	15706	
Aria_pagecache_blocks_used	2	
Aria_pagecache_read_requests	140	
Aria_pagecache_reads	75	
Aria_pagecache_write_requests	22	
Aria_pagecache_writes	0	
Aria_transaction_log_syncs	0	
Binlog_commits	0	
Binlog_group_commits	0	
Binlog_group_commit_trigger_count	0	
Binlog_group_commit_trigger_lock_wait	0	
Binlog_group_commit_trigger_timeout	0	
Binlog_snapshot_file		
Binlog_snapshot_position	0	
Binlog_bytes_written	0	
Binlog_cache_disk_use	0	
Binlog_cache_use	0	
Binlog_stmt_cache_disk_use	0	
Binlog_stmt_cache_use	0	
Busy_time	0.000000	
Bytes_received	454018	
Bytes_sent	982403	
Com_admin_commands	5	
Com_alter_db	0	
Com_alter_db_upgrade	0	
Com_alter_event	0	
Com_alter_function	0	
Com_alter_procedure	0	
Com_alter_server	0	
Com_alter_table	70	
Com_alter_tablespace	0	
Com_analyze	0	
Com_assign_to_keycache	0	
Com_begin	0	
Com_binlog	0	
Com_call_procedure	0	
Com_change_db	53	
Com_change_master	0	
Com_check	0	
Com_checksum	0	
Com_commit	0	
Com_compound_sql	0	
Com_create_db	5	
Com_create_event	0	
Com_create_function	0	
Com_create_index	0	
Com_create_procedure	0	
Com_create_role	0	
Com_create_server	0	
Com_create_table	35	
Com_create_temporary_table	0	
Com_create_trigger	14	
Com_create_udf	0	
Com_create_user	0	
Com_create_view	0	
Com_dealloc_sql	0	
Com_delete	52	
Com_delete_multi	0	
Com_do	0	
Com_drop_db	2	
Com_drop_event	0	
Com_drop_function	0	
Com_drop_index	0	
Com_drop_procedure	0	
Com_drop_role	0	
Com_drop_server	0	
Com_drop_table	35	
Com_drop_temporary_table	0	
Com_drop_trigger	7	
Com_drop_user	0	
Com_drop_view	0	
Com_empty_query	0	
Com_execute_sql	0	
Com_flush	2	
Com_get_diagnostics	0	
Com_grant	0	
Com_grant_role	0	
Com_ha_close	0	
Com_ha_open	0	
Com_ha_read	0	
Com_help	0	
Com_insert	24	
Com_insert_select	0	
Com_install_plugin	0	
Com_kill	0	
Com_load	0	
Com_lock_tables	35	
Com_optimize	0	
Com_preload_keys	0	
Com_prepare_sql	0	
Com_purge	0	
Com_purge_before_date	0	
Com_release_savepoint	0	
Com_rename_table	30	
Com_rename_user	0	
Com_repair	0	
Com_replace	0	
Com_replace_select	0	
Com_reset	0	
Com_resignal	0	
Com_revoke	0	
Com_revoke_all	0	
Com_revoke_role	0	
Com_rollback	0	
Com_rollback_to_savepoint	0	
Com_savepoint	0	
Com_select	1766	
Com_set_option	425	
Com_show_authors	0	
Com_show_binlog_events	0	
Com_show_binlogs	3	
Com_show_charsets	0	
Com_show_collations	0	
Com_show_contributors	0	
Com_show_create_db	0	
Com_show_create_event	0	
Com_show_create_func	0	
Com_show_create_proc	0	
Com_show_create_table	2	
Com_show_create_trigger	0	
Com_show_databases	2	
Com_show_engine_logs	0	
Com_show_engine_mutex	0	
Com_show_engine_status	0	
Com_show_errors	0	
Com_show_events	0	
Com_show_explain	0	
Com_show_fields	31	
Com_show_function_status	2	
Com_show_generic	0	
Com_show_grants	4	
Com_show_keys	2	
Com_show_master_status	12	
Com_show_open_tables	0	
Com_show_plugins	0	
Com_show_privileges	0	
Com_show_procedure_status	2	
Com_show_processlist	0	
Com_show_profile	0	
Com_show_profiles	0	
Com_show_relaylog_events	0	
Com_show_slave_hosts	5	
Com_show_slave_status	17	
Com_show_status	17	
Com_show_storage_engines	5	
Com_show_table_status	0	
Com_show_tables	72	
Com_show_triggers	0	
Com_show_variables	38	
Com_show_warnings	0	
Com_shutdown	0	
Com_signal	0	
Com_start_all_slaves	0	
Com_start_slave	0	
Com_stmt_close	0	
Com_stmt_execute	0	
Com_stmt_fetch	0	
Com_stmt_prepare	0	
Com_stmt_reprepare	0	
Com_stmt_reset	0	
Com_stmt_send_long_data	0	
Com_stop_all_slaves	0	
Com_stop_slave	0	
Com_truncate	0	
Com_uninstall_plugin	0	
Com_unlock_tables	35	
Com_update	218	
Com_update_multi	0	
Com_xa_commit	0	
Com_xa_end	0	
Com_xa_prepare	0	
Com_xa_recover	0	
Com_xa_rollback	0	
Com_xa_start	0	
Compression	OFF	
Connection_errors_accept	0	
Connection_errors_internal	0	
Connection_errors_max_connections	0	
Connection_errors_peer_address	0	
Connection_errors_select	0	
Connection_errors_tcpwrap	0	
Connections	184	
Cpu_time	0.000000	
Created_tmp_disk_tables	75	
Created_tmp_files	6	
Created_tmp_tables	513	
Delayed_errors	0	
Delayed_insert_threads	0	
Delayed_writes	0	
Delete_scan	8	
Empty_queries	689	
Executed_events	0	
Executed_triggers	0	
Feature_delay_key_write	0	
Feature_dynamic_columns	0	
Feature_fulltext	0	
Feature_gis	0	
Feature_locale	60	
Feature_subquery	90	
Feature_timezone	3	
Feature_trigger	24	
Feature_xml	0	
Flush_commands	1	
Handler_commit	1614	
Handler_delete	0	
Handler_discover	0	
Handler_external_lock	0	
Handler_icp_attempts	0	
Handler_icp_match	0	
Handler_mrr_init	0	
Handler_mrr_key_refills	0	
Handler_mrr_rowid_refills	0	
Handler_prepare	0	
Handler_read_first	243	
Handler_read_key	1218	
Handler_read_last	0	
Handler_read_next	1677	
Handler_read_prev	0	
Handler_read_retry	0	
Handler_read_rnd	332	
Handler_read_rnd_deleted	19	
Handler_read_rnd_next	34302	
Handler_rollback	0	
Handler_savepoint	0	
Handler_savepoint_rollback	0	
Handler_tmp_update	0	
Handler_tmp_write	34433	
Handler_update	0	
Handler_write	351	
Innodb_available_undo_logs	128	
Innodb_background_log_sync	20980	
Innodb_buffer_pool_bytes_data	11321344	
Innodb_buffer_pool_bytes_dirty	0	
Innodb_buffer_pool_dump_status	Dumping buffer pool(s) not yet started	
Innodb_buffer_pool_load_status	Loading buffer pool(s) not yet started	
Innodb_buffer_pool_pages_data	691	
Innodb_buffer_pool_pages_dirty	0	
Innodb_buffer_pool_pages_flushed	381	
Innodb_buffer_pool_pages_free	7499	
Innodb_buffer_pool_pages_lru_flushed	0	
Innodb_buffer_pool_pages_made_not_young	0	
Innodb_buffer_pool_pages_made_young	0	
Innodb_buffer_pool_pages_misc	1	
Innodb_buffer_pool_pages_old	259	
Innodb_buffer_pool_pages_total	8191	
Innodb_buffer_pool_read_ahead	0	
Innodb_buffer_pool_read_ahead_evicted	0	
Innodb_buffer_pool_read_ahead_rnd	0	
Innodb_buffer_pool_read_requests	30561	
Innodb_buffer_pool_reads	524	
Innodb_buffer_pool_wait_free	0	
Innodb_buffer_pool_write_requests	4103	
Innodb_checkpoint_age	0	
Innodb_checkpoint_max_age	80826164	
Innodb_data_fsyncs	288	
Innodb_data_pending_fsyncs	0	
Innodb_data_pending_reads	0	
Innodb_data_pending_writes	0	
Innodb_data_read	9114112	
Innodb_data_reads	591	
Innodb_data_writes	626	
Innodb_data_written	12874752	
Innodb_dblwr_pages_written	381	
Innodb_dblwr_writes	10	
Innodb_deadlocks	0	
Innodb_have_atomic_builtins	ON	
Innodb_history_list_length	1101	
Innodb_ibuf_discarded_delete_marks	0	
Innodb_ibuf_discarded_deletes	0	
Innodb_ibuf_discarded_inserts	0	
Innodb_ibuf_free_list	0	
Innodb_ibuf_merged_delete_marks	0	
Innodb_ibuf_merged_deletes	0	
Innodb_ibuf_merged_inserts	0	
Innodb_ibuf_merges	0	
Innodb_ibuf_segment_size	2	
Innodb_ibuf_size	1	
Innodb_log_waits	0	
Innodb_log_write_requests	775	
Innodb_log_writes	95	
Innodb_lsn_current	4517345	
Innodb_lsn_flushed	4517345	
Innodb_lsn_last_checkpoint	4517345	
Innodb_master_thread_active_loops	7	
Innodb_master_thread_idle_loops	20973	
Innodb_max_trx_id	20277	
Innodb_mem_adaptive_hash	2233952	
Innodb_mem_dictionary	1221898	
Innodb_mem_total	140771328	
Innodb_mutex_os_waits	10	
Innodb_mutex_spin_rounds	394	
Innodb_mutex_spin_waits	78	
Innodb_oldest_view_low_limit_trx_id	0	
Innodb_os_log_fsyncs	105	
Innodb_os_log_pending_fsyncs	0	
Innodb_os_log_pending_writes	0	
Innodb_os_log_written	385024	
Innodb_page_size	16384	
Innodb_pages_created	168	
Innodb_pages_read	523	
Innodb_pages0_read	29	
Innodb_pages_written	381	
Innodb_purge_trx_id	19934	
Innodb_purge_undo_no	0	
Innodb_read_views_memory	88	
Innodb_row_lock_current_waits	0	
Innodb_row_lock_time	0	
Innodb_row_lock_time_avg	0	
Innodb_row_lock_time_max	0	
Innodb_row_lock_waits	0	
Innodb_rows_deleted	0	
Innodb_rows_inserted	351	
Innodb_rows_read	1720	
Innodb_rows_updated	0	
Innodb_system_rows_deleted	0	
Innodb_system_rows_inserted	0	
Innodb_system_rows_read	0	
Innodb_system_rows_updated	0	
Innodb_s_lock_os_waits	40	
Innodb_s_lock_spin_rounds	1279	
Innodb_s_lock_spin_waits	40	
Innodb_truncated_status_writes	0	
Innodb_x_lock_os_waits	0	
Innodb_x_lock_spin_rounds	0	
Innodb_x_lock_spin_waits	0	
Innodb_page_compression_saved	0	
Innodb_page_compression_trim_sect512	0	
Innodb_page_compression_trim_sect1024	0	
Innodb_page_compression_trim_sect2048	0	
Innodb_page_compression_trim_sect4096	0	
Innodb_page_compression_trim_sect8192	0	
Innodb_page_compression_trim_sect16384	0	
Innodb_page_compression_trim_sect32768	0	
Innodb_num_index_pages_written	113	
Innodb_num_non_index_pages_written	386	
Innodb_num_pages_page_compressed	0	
Innodb_num_page_compressed_trim_op	0	
Innodb_num_page_compressed_trim_op_saved	0	
Innodb_num_pages_page_decompressed	0	
Innodb_num_pages_page_compression_error	0	
Innodb_num_pages_encrypted	0	
Innodb_num_pages_decrypted	0	
Innodb_have_lz4	OFF	
Innodb_have_lzo	OFF	
Innodb_have_lzma	ON	
Innodb_have_bzip2	OFF	
Innodb_have_snappy	OFF	
Innodb_defragment_compression_failures	0	
Innodb_defragment_failures	0	
Innodb_defragment_count	0	
Innodb_onlineddl_rowlog_rows	0	
Innodb_onlineddl_rowlog_pct_used	0	
Innodb_onlineddl_pct_progress	0	
Innodb_secondary_index_triggered_cluster_reads	0	
Innodb_secondary_index_triggered_cluster_reads_avoided	0	
Innodb_encryption_rotation_pages_read_from_cache	0	
Innodb_encryption_rotation_pages_read_from_disk	0	
Innodb_encryption_rotation_pages_modified	0	
Innodb_encryption_rotation_pages_flushed	0	
Innodb_encryption_rotation_estimated_iops	0	
Innodb_scrub_background_page_reorganizations	0	
Innodb_scrub_background_page_splits	0	
Innodb_scrub_background_page_split_failures_underflow	0	
Innodb_scrub_background_page_split_failures_out_of_filespace	0	
Innodb_scrub_background_page_split_failures_missing_index	0	
Innodb_scrub_background_page_split_failures_unknown	0	
Key_blocks_not_flushed	0	
Key_blocks_unused	107162	
Key_blocks_used	1	
Key_blocks_warm	0	
Key_read_requests	4	
Key_reads	1	
Key_write_requests	0	
Key_writes	0	
Last_query_cost	0.000000	
Master_gtid_wait_count	0	
Master_gtid_wait_time	0	
Master_gtid_wait_timeouts	0	
Max_statement_time_exceeded	0	
Max_used_connections	6	
Memory_used	275107552	
Not_flushed_delayed_rows	0	
Open_files	25	
Open_streams	0	
Open_table_definitions	67	
Open_tables	60	
Opened_files	655	
Opened_plugin_libraries	0	
Opened_table_definitions	185	
Opened_tables	150	
Opened_views	0	
Performance_schema_accounts_lost	0	
Performance_schema_cond_classes_lost	0	
Performance_schema_cond_instances_lost	0	
Performance_schema_digest_lost	0	
Performance_schema_file_classes_lost	0	
Performance_schema_file_handles_lost	0	
Performance_schema_file_instances_lost	0	
Performance_schema_hosts_lost	0	
Performance_schema_locker_lost	0	
Performance_schema_mutex_classes_lost	0	
Performance_schema_mutex_instances_lost	0	
Performance_schema_rwlock_classes_lost	0	
Performance_schema_rwlock_instances_lost	0	
Performance_schema_session_connect_attrs_lost	0	
Performance_schema_socket_classes_lost	0	
Performance_schema_socket_instances_lost	0	
Performance_schema_stage_classes_lost	0	
Performance_schema_statement_classes_lost	0	
Performance_schema_table_handles_lost	0	
Performance_schema_table_instances_lost	0	
Performance_schema_thread_classes_lost	0	
Performance_schema_thread_instances_lost	0	
Performance_schema_users_lost	0	
Prepared_stmt_count	0	
Qcache_free_blocks	1	
Qcache_free_memory	1031336	
Qcache_hits	0	
Qcache_inserts	0	
Qcache_lowmem_prunes	0	
Qcache_not_cached	0	
Qcache_queries_in_cache	0	
Qcache_total_blocks	1	
Queries	3200	
Questions	3200	
Rows_read	1779	
Rows_sent	17876	
Rows_tmp_read	33995	
Rpl_status	AUTH_MASTER	
Select_full_join	9	
Select_full_range_join	0	
Select_range	0	
Select_range_check	0	
Select_scan	616	
Slave_connections	0	
Slave_heartbeat_period	0.000	
Slave_open_temp_tables	0	
Slave_received_heartbeats	0	
Slave_retried_transactions	0	
Slave_running	OFF	
Slave_skipped_errors	0	
Slaves_connected	0	
Slaves_running	0	
Slow_launch_threads	0	
Slow_queries	0	
Sort_merge_passes	0	
Sort_priority_queue_sorts	0	
Sort_range	0	
Sort_rows	332	
Sort_scan	55	
Ssl_accept_renegotiates	0	
Ssl_accepts	0	
Ssl_callback_cache_hits	0	
Ssl_cipher		
Ssl_cipher_list		
Ssl_client_connects	0	
Ssl_connect_renegotiates	0	
Ssl_ctx_verify_depth	0	
Ssl_ctx_verify_mode	0	
Ssl_default_timeout	0	
Ssl_finished_accepts	0	
Ssl_finished_connects	0	
Ssl_server_not_after		
Ssl_server_not_before		
Ssl_session_cache_hits	0	
Ssl_session_cache_misses	0	
Ssl_session_cache_mode	NONE	
Ssl_session_cache_overflows	0	
Ssl_session_cache_size	0	
Ssl_session_cache_timeouts	0	
Ssl_sessions_reused	0	
Ssl_used_session_cache_entries	0	
Ssl_verify_depth	0	
Ssl_verify_mode	0	
Ssl_version		
Subquery_cache_hit	0	
Subquery_cache_miss	0	
Syncs	104	
Table_locks_immediate	1675	
Table_locks_waited	0	
Tc_log_max_pages_used	0	
Tc_log_page_size	4096	
Tc_log_page_waits	0	
Threadpool_idle_threads	0	
Threadpool_threads	0	
Threads_cached	0	
Threads_connected	2	
Threads_created	182	
Threads_running	1	
Update_scan	98	
Uptime	20996	
Uptime_since_flush_status	20996	
wsrep_cluster_conf_id	18446744073709551615	
wsrep_cluster_size	0	
wsrep_cluster_state_uuid		
wsrep_cluster_status	Disconnected	
wsrep_connected	OFF	
wsrep_local_bf_aborts	0	
wsrep_local_index	18446744073709551615	
wsrep_provider_name		
wsrep_provider_vendor		
wsrep_provider_version		
wsrep_ready	OFF	
wsrep_thread_count	0	
jmrenouard added a commit that referenced this issue Dec 5, 2016
@jmrenouard
Copy link
Collaborator

Hi @jerotire

Thanks for your feedback.

This issue is raised when error log file is missing or empty.

@jerotire
Copy link
Author

jerotire commented Dec 5, 2016

Commit 2861883 appears to have solved the issue.
Thanks for the quick response!

@jmrenouard
Copy link
Collaborator

@Jeotire
Nice to get your feedback

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants