MySQL 5.5 to 5.6
Hello,
I'm updating MySQL on my VPS
MySQL 5.5 ==> MySQL 5.5
Yesterday problem.
This morning I received an email (GMT + 1)
Problems were detected with cPanel-provided files which are RPM controlled.
If you did not make these changes intentionally, you can correct them by running:
> /usr/local/cpanel/scripts/check_cpanel_rpms --fix
The following RPMs are missing from your system:
MySQL55-client-5.5.42-2.cp1148
MySQL55-devel-5.5.42-2.cp1148
MySQL55-server-5.5.42-2.cp1148
MySQL55-shared-5.5.42-2.cp1148
MySQL55-test-5.5.42-2.cp1148
The following RPMs are unneeded on your system and should be uninstalled:
MySQL56-client-5.6.23-1.cp1148
MySQL56-devel-5.6.23-1.cp1148
MySQL56-server-5.6.23-1.cp1148
MySQL56-shared-5.6.23-1.cp1148
MySQL56-test-5.6.23-1.cp1148
So I launched the command: /usr/local/cpanel/scripts/check_cpanel_rpms --fix Now this is MySQL 5.5, which is installed And several site is not working. When I restart MySQL, I have this message: Log Messages 150510 12:26:10 [Note] /usr/sbin/mysqld: ready for connections. 150510 12:26:10 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/event.frm'
When I want to update MySQL, I have this message: tarting process with log file at /var/cpanel/logs/mysql_upgrade.20150510-123447/unattended_upgrade.log Beginning "MySQL 5.6" upgrade... Obtained version information from system. DBD::mysql::db do failed: Incorrect information in file: './mysql/tables_priv.frm'
my.cnf: [mysqld] innodb_file_per_table=1 # open_files_limit=22242 # max_allowed_packet=268435456 innodb_buffer_pool_size=134217728 max_allowed_packet=268435456 default-storage-engine=MyISAM [mysqld] local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 512M myisam_sort_buffer_size = 64M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 256M max_heap_table_size = 128M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 log-error external-locking=FALSE open_files_limit=50000 [mysqld_safe] [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M #### Per connection configuration #### sort_buffer_size = 1M join_buffer_size = 1M thread_stack = 192K
I need your help, it is urgent
So I launched the command: /usr/local/cpanel/scripts/check_cpanel_rpms --fix Now this is MySQL 5.5, which is installed And several site is not working. When I restart MySQL, I have this message: Log Messages 150510 12:26:10 [Note] /usr/sbin/mysqld: ready for connections. 150510 12:26:10 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/event.frm'
When I want to update MySQL, I have this message: tarting process with log file at /var/cpanel/logs/mysql_upgrade.20150510-123447/unattended_upgrade.log Beginning "MySQL 5.6" upgrade... Obtained version information from system. DBD::mysql::db do failed: Incorrect information in file: './mysql/tables_priv.frm'
my.cnf: [mysqld] innodb_file_per_table=1 # open_files_limit=22242 # max_allowed_packet=268435456 innodb_buffer_pool_size=134217728 max_allowed_packet=268435456 default-storage-engine=MyISAM [mysqld] local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 512M myisam_sort_buffer_size = 64M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 256M max_heap_table_size = 128M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 log-error external-locking=FALSE open_files_limit=50000 [mysqld_safe] [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M #### Per connection configuration #### sort_buffer_size = 1M join_buffer_size = 1M thread_stack = 192K
I need your help, it is urgent
-
Hello, Could you open a support ticket using the link in my signature so we can verify which RPMs are still installed and determine the best way to upgrade MySQL? You can post the ticket number here so we can update this thread with the outcome. Thank you. 0 -
Hello, My ticket number is 6488105 thank you 0 -
To update, it looks like InnoDB corruption is preventing MySQL from starting properly or updating. The following guide may help you repair the corruption: InnoDB Corruption Repair Guide Thank you. 0
Please sign in to leave a comment.
Comments
3 comments