Database Connection Failures After Installation Ea4

Store Builder Questions
1

After reading all the good news about CS Cart V4.3.x supporting PHP 7 from 4.3.7 onwards we decided to upgrade Easy Apache 3 to Easy Apache 4 with Apache 2.4.

Having Easy Apache 4 allows me to run PHP 7 and previous PHP versions like 5.4, 5.5, 5.6.

Within Cpanel I have MultiPHP Manager which allows me to set PHP versions per Domain.

I have set our main store (V4.3.8) to inherit the PHP Version. I have set it to PHP 7 and there goes the database connection many times over.

What have I forgotten to do ?

2 
[Fri Aug 12 12:55:06.181847 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #6 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(443): Tygh\\ in /home/pasioonline/public_html/app/Tygh/Database/Connection.php on line 863: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.181396 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #5 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(548): Tygh\\Database\\Connection->checkTableFields(Array, 'sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180981 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #4 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(690): Tygh\\Database\\Connection->getTableFields('sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180744 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #3 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(660): Tygh\\Database\\Connection->getColumn('SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180515 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #2 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(327): call_user_func_array(Array, Array): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180226 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #0 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(458): Tygh\\Database\\Connection->error(false, 'SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.179906 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: PHP Fatal error:  Uncaught exception 'Tygh\\Exceptions\\DatabaseException' with message 'Got error 28 from storage engine (1030)
SHOW COLUMNS FROM cscart_sessions
' in /home/pasioonline/public_html/app/Tygh/Database/Connection.php:863: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.179315 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: PHP Warning:  session_start(): Cannot send session cache limiter - headers already sent (output started at /home/pasioonline/public_html/app/Tygh/Development.php:113) in /home/pasioonline/public_html/app/Tygh/Web/Session.php on line 334: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.178925 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: PHP Warning:  session_start(): Cannot send session cookie - headers already sent by (output started at /home/pasioonline/public_html/app/Tygh/Development.php:113) in /home/pasioonline/public_html/app/Tygh/Web/Session.php on line 334: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897698 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #6 /home/pasioonline/public_html/app/Tygh/ in /home/pasioonline/public_html/app/Tygh/Database/Connection.php on line 863: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897515 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #5 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(548): Tygh\\Database\\Connection->checkTableFields(Array, 'sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897289 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #4 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(690): Tygh\\Database\\Connection->getTableFields('sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897090 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #3 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(660): Tygh\\Database\\Connection->getColumn('SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.896897 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #2 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(327): call_user_func_array(Array, Array): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.896600 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #0 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(458): Tygh\\Database\\Connection->error(false, 'SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56

Above here you can see my error log files

3 
[Fri Aug 12 12:55:06.181847 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #6 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(443): Tygh\\ in /home/pasioonline/public_html/app/Tygh/Database/Connection.php on line 863: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.181396 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #5 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(548): Tygh\\Database\\Connection->checkTableFields(Array, 'sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180981 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #4 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(690): Tygh\\Database\\Connection->getTableFields('sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180744 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #3 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(660): Tygh\\Database\\Connection->getColumn('SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180515 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #2 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(327): call_user_func_array(Array, Array): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.180226 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: #0 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(458): Tygh\\Database\\Connection->error(false, 'SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.179906 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: PHP Fatal error:  Uncaught exception 'Tygh\\Exceptions\\DatabaseException' with message 'Got error 28 from storage engine (1030)
SHOW COLUMNS FROM cscart_sessions
' in /home/pasioonline/public_html/app/Tygh/Database/Connection.php:863: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.179315 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: PHP Warning:  session_start(): Cannot send session cache limiter - headers already sent (output started at /home/pasioonline/public_html/app/Tygh/Development.php:113) in /home/pasioonline/public_html/app/Tygh/Web/Session.php on line 334: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:55:06.178925 2016] [cgi:error] [pid 13614] [client 92.111.178.216:65086] AH01215: PHP Warning:  session_start(): Cannot send session cookie - headers already sent by (output started at /home/pasioonline/public_html/app/Tygh/Development.php:113) in /home/pasioonline/public_html/app/Tygh/Web/Session.php on line 334: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897698 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #6 /home/pasioonline/public_html/app/Tygh/ in /home/pasioonline/public_html/app/Tygh/Database/Connection.php on line 863: /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897515 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #5 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(548): Tygh\\Database\\Connection->checkTableFields(Array, 'sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897289 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #4 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(690): Tygh\\Database\\Connection->getTableFields('sessions'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.897090 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #3 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(660): Tygh\\Database\\Connection->getColumn('SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.896897 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #2 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(327): call_user_func_array(Array, Array): /usr/local/cpanel/cgi-sys/ea-php56
[Fri Aug 12 12:33:07.896600 2016] [cgi:error] [pid 14874] [client 163.172.12.218:55422] AH01215: #0 /home/pasioonline/public_html/app/Tygh/Database/Connection.php(458): Tygh\\Database\\Connection->error(false, 'SHOW COLUMNS FR...'): /usr/local/cpanel/cgi-sys/ea-php56

Above here you can see my error log files

It looks like your disk is full.

4

It looks like your disk is full.

Are you sure that is the cause ?

[attachment=11513:CurrentDiskUsage.jpg]

CurrentDiskUsage.jpg

5

Are you sure that is the cause ?

attachicon.gifCurrentDiskUsage.jpg

The Linux kernel reports the same error to applications whether a FS is full due to a lack of space or due to a lack of inodes. Run df -i to know how many inodes are left. Or MySQL tries to create temporary files bigger than total free space on /tmp partition. In this case you should optimize your SQL queries or increase size of /tmp.