Mysql2::Error: The total number of locks exceeds the lock table size
A problem has occurred with the database dump or backup placing.
Running: db:migrate
rake aborted!
An error has occurred, all later migrations canceled:
Mysql2::Error: The total number of locks exceeds the lock table size: UPDATE `vm_resource_hourly_stats` SET `resource_class` = 'Billing::Resource::DataStoreGroup' WHERE `vm_resource_hourly_stats`.`resource_class` = 'Resource::DataStoreGroup'/onapp/interface/db/migrate/20150330153252_rename_class_names_in_base_resource_related_tables.rb:106:in `rename'
Issue with incorrect database configuration
In my.cnf must be set the next value:
innodb_buffer_pool_size=8G
innodb_log_file_size=512M
max_allowed_packet = 512M
table_cache = 2048
max_heap_table_size=53687091200
tmp_table_size=53687091200
query_cache_size = 512M
query_cache_limit = 8M
innodb_file_per_table=1
#innodb_data_file_path = ibdata1:100M:autoextend:max:2048M
innodb_data_file_path = ibdata1:100M:autoextend
innodb_lock_wait_timeout = 180
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
Change my.cnf parameters, restart mysql server
/etc/init.d/mysqld restart
Restart upgrade script
/onapp/onapp-cp-install/onapp-cp-install.sh
Comments
0 comments
Please sign in to leave a comment.