debian init script times out at server start when innodb_blocking_buffer_pool_restore=1

Bug #1072844 reported by Ignacio Nin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
New
Medium
Ignacio Nin

Bug Description

The debian init script times out after a fixed interval of 15 seconds, with a check based on mysql_ping. This approach can fail with buffer pools as small as 6GB when innodb_blocking_buffer_pool_restore=1:

Setting up percona-server-server-5.5 (5.5.28-rel29.1-334.precise) ...
 * Stopping MySQL (Percona Server) mysqld [ OK ]
 * Starting MySQL (Percona Server) database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing percona-server-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of percona-server-server:
 percona-server-server depends on percona-server-server-5.5; however:
  Package percona-server-server-5.5 is not configured yet.
dpkg: error processing percona-server-server (--configure):
 dependency problems - leaving unconfigured
Percona options sample:

# More Tuning
skip-name-resolve
back_log=500
tmpdir=/dev/shm
log_slow_admin_statements
long_query_time=0
innodb_buffer_pool_instances=4
innodb_io_capacity=200
innodb_old_blocks_time=1000
innodb_stats_on_metadata=0
expand_fast_index_creation=1
innodb_adaptive_flushing_method=keep_average
innodb_adaptive_hash_index_partitions=4
innodb_blocking_buffer_pool_restore=1
innodb_buffer_pool_restore_at_startup=60
innodb_corrupt_table_action=warn
innodb_ibuf_max_size=256M
innodb_kill_idle_transaction=200
innodb_lazy_drop_table=1
innodb_log_block_size=4K
innodb_fast_checksum=1
innodb_flush_neighbor_pages=cont
innodb_dict_size_limit=2048
innodb_merge_sort_block_size=64M
innodb_stats_auto_update=0
innodb_recovery_update_relay_log=1
innodb_show_verbose_locks=1
innodb_stats_update_need_lock=0
innodb_use_global_flush_log_at_trx_commit=0
innodb_use_sys_stats_table=1
query_cache_strip_comments=1
query_response_time_stats=1
query_response_time_range_base=2
log_slow_rate_limit=100
log_slow_rate_type=query
log_slow_sp_statements=1
log_slow_slave_statements=1
log_slow_verbosity="full"
slow_query_log_timestamp_always=1
slow_query_log_timestamp_precision=microsecond
slow_query_log_use_global_control=all
thread_statistics=1
userstat
innodb_import_table_from_xtrabackup=1
innodb_recovery_stats
innodb_purge_threads=2

Tags: pkg
Revision history for this message
Alexey Kopytov (akopytov) wrote :

Duplicate of bug #1072538?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.