mysql error on large content block posts

Permalink
when attempting tp save a content block with a lot of text (14K characters) I get this error

case '1095': case '1142': case '1143': case '1227': case '1370': case '2002': case '2005': return new Exception\ConnectionException($message, $exception); case '1048': case '1121': case '1138': case '1171': case '1252': case '1263': case '1566': return new Exception\NotNullConstraintViolationException($message, $exception); } return new Exception\DriverException($message, $exception); } /** * {@inheritdoc} */ public function createDatabasePlatformForVersion($version) { if ( ! preg_match('/^(?P\d+)(?:\.(?P\d+)(?:\.(?P\d+))?)?/', $version, $versionParts)) { throw DBALException::invalidPlatformVersionSpecified( $version, '..' ); } if (false !== stripos($version, 'mariadb')) { return $this->getDatabasePlatform(); } $majorVersion = $versionParts['major']; $minorVersion = isset($versionParts['minor']) ? $versionParts['minor'] : 0;


​Which is not a very useful error message :/

I edited concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php​

​and added a line to print the actual error code, which was ​

​Error: 2006 (CR_SERVER_GONE_ERROR)
Message: MySQL server has gone away​

​This was fixed by adding
wait_timeout=30
interactive_timeout=30
max_allowed_packet = 128M

​​t​o my.cnf


ntisithoj
View Replies: