Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3.2
-
None
-
Ubuntu 16.04 + PHP 7.0
Description
The goal of this query it's to detect if we have one table with an engine not correctly installed, example TokuDB, mysql started without without transparent_hugepage = never
If all working fine this query return 0 lignes.
in mysql this query working fine, but with connector php7.0-mysql
ERROR 2006 (HY000): MySQL server has gone away |
example with PHP code
public function checkAllEngines() |
{
|
|
return true; |
|
$this->view = false; |
$db = $this->di['db']->sql(DB_DEFAULT); |
|
$sql = "select distinct a.engine from information_schema.tables a |
LEFT JOIN information_schema.engines b ON a.engine = b.engine
|
where a.table_schema = database() and b.engine is null;"; |
|
|
$res = $db->sql_query($sql); |
|
while ($ob = $db->sql_fetch_object($res)) { |
|
if ($ob->cpt !== "1") { |
return false; |
}
|
}
|
|
|
return true; |
}
|