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
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
to my.cnf
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
to my.cnf
