uhlhosting

Aborted clientsDocumentation	        10	The number of connections that were aborted because the client died without closing the connection properly.
Aborted connectsDocumentation	        1	The number of failed attempts to connect to the MySQL server.
Created tmp disk tablesDocumentation	2.8 k	The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Handler read rndDocumentation	        186.5 k	The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler read rnd nextDocumentation	  10.7 M	The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. 

uhlhosting

root@panel [/]# bash engintron.sh install
**************************************
*        Installing Engintron        *
**************************************
--2016-02-09 17:20:58--  https://github.com/nuevvo/engintron/archive/master.zip
Resolving github.com (github.com)... 192.30.252.131
Connecting to github.com (github.com)|192.30.252.131|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://github.com/engintron/engintron/archive/master.zip [following]
--2016-02-09 17:20:58--  https://github.com/engintron/engintron/archive/master.zip

uhlhosting

[mysqld]
innodb_read_io_threads		= 2
innodb_write_io_threads		= 4
innodb_buffer_pool_size		= 1G
innodb_buffer_pool_load_abort =ON
#innodb_buffer_pool_load_at_startup =1
#innodb_buffer_pool_dump_at_shutdown =1
innodb_buffer_pool_instances	= 1
innodb_log_file_size 		= 256M
innodb_log_files_in_group	= 2

uhlhosting

root@panel [~]# pt-query-digest /var/log/mariadb/slow_query.log
/var/log/mariadb/slow_query.log:  17% 02:19 remain
/var/log/mariadb/slow_query.log:  36% 01:42 remain
/var/log/mariadb/slow_query.log:  55% 01:12 remain
/var/log/mariadb/slow_query.log:  74% 00:40 remain
/var/log/mariadb/slow_query.log:  92% 00:11 remain

# 162.4s user time, 1s system time, 93.74M rss, 291.91M vsz
# Current date: Fri Mar  4 12:17:24 2016
# Hostname: panel.uhlhosting.ch

uhlhosting

160114 18:00:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160114 18:00:03 [Note] /usr/sbin/mysqld (mysqld 10.0.23-MariaDB) starting as process 23065 ...
160114 18:00:03 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160114 18:00:03 [Note] InnoDB: The InnoDB memory heap is disabled
160114 18:00:03 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160114 18:00:03 [Note] InnoDB: Memory barrier is not used
160114 18:00:03 [Note] InnoDB: Compressed tables use zlib 1.2.7
160114 18:00:03 [Note] InnoDB: Using Linux native AIO
160114 18:00:03 [Note] InnoDB: Not using CPU crc32 instructions
160114 18:00:03 [Note] InnoDB: Initializing buffer pool, size = 128.0M

uhlhosting

mysqld]
default-storage-engine=MyISAM
default-tmp-storage-engine=MyISAM
innodb=OFF

innodb_fast_shutdown=0

innodb_force_recovery = 1

myisam-recover-options                  = FORCE,BACKUP

uhlhosting

root@panel [~]# find ./ -name *.ibd
./uhlhosting/mysql/back/mysql/mysql/gtid_slave_pos.ibd
./uhlhosting/mysql/back/mysql/mysql/innodb_index_stats.ibd
./uhlhosting/mysql/back/mysql/mysql/slave_worker_info.ibd
./uhlhosting/mysql/back/mysql/mysql/slave_master_info.ibd
./uhlhosting/mysql/back/mysql/mysql/innodb_table_stats.ibd
./uhlhosting/mysql/back/mysql/mysql/slave_relay_log_info.ibd
./uhlhosting/mysql/back/mysql/roundcube/contactgroups.ibd
./uhlhosting/mysql/back/mysql/roundcube/dictionary.ibd
./uhlhosting/mysql/back/mysql/roundcube/identities.ibd

uhlhosting

Please disregard Terrance's reply above. He replied to the wrong ticket by mistake. 

I am sorry to hear about the problems that you are having. I do see that Jesse was able to help and get MySQL back online for you. Your ticket was brought to my attention by one of our Level 1's on shift who has been monitoring the ticket at Jesse's request. 

Please note as both Jesse and Kaden stated repairing corruption is not something cPanel can do because we are not experts in database corruption repair and would not want to cause any more damage to your data. 

I see that you are still seeking some guidance on where to go from here in getting your sites back online and databases working. Since Jesse got MySQL/MariaDB reinstalled via our RPMs the database system itself is operational so this is good. 

The problem is that the current databases are likely still corrupted beyond repair and if the guide to repairing InnoDB issues by forcing InnoDB recovery did not work, there is not much else that can be done. Have you tr

uhlhosting

Could not restore account “highacid”: Failed to execute sql method do: (XID rwa3av) DBD::mysql::db do failed: Can't create table `whmxfer`.`queue_paneluhlhostinbacku20160306121853BsO` (errno: 165 "Table is read only") at /usr/local/cpanel/Cpanel/DBBackend.pm line 157.

Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x54d59b0), "do", "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 95

Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x54d59b0), "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1449

Whostmgr::Transfers::Session::_create_new_session(Whostmgr::Transfers::Session=HASH(0x54d59b0), "paneluhlhostinbacku20160306121853BsO") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1119

Whostmgr::Transfers::Session::_set_session_id(Whostmgr::Transfers::Session=HASH(0x54d59b0), "paneluhlhostinbac

uhlhosting

Could not restore account “highacid”: Failed to execute sql method do: (XID cu3jmn) DBD::mysql::db do failed: Can't create table `whmxfer`.`queue_paneluhlhostinbacku20160306123158jt3` (errno: 165 "Table is read only") at /usr/local/cpanel/Cpanel/DBBackend.pm line 157.

Cpanel::DBBackend::_retried_sql(Whostmgr::Transfers::Session=HASH(0x54d78e0), "do", "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Cpanel/DBBackend.pm line 95

Cpanel::DBBackend::_retried_do(Whostmgr::Transfers::Session=HASH(0x54d78e0), "\x{a}--\x{a}-- Table structure for table `queue_paneluhlhostinbacku20"...) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1449

Whostmgr::Transfers::Session::_create_new_session(Whostmgr::Transfers::Session=HASH(0x54d78e0), "paneluhlhostinbacku20160306123158jt3") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1119

Whostmgr::Transfers::Session::_set_session_id(Whostmgr::Transfers::Session=HASH(0x54d78e0), "paneluhlhostinbac