Whereas my setup can easily display the field values using the normal image formatter, and also in a regular view, it crashes when using formatter_view. My configuration has no problems displaying nodes with 10 images but there is one node with 97 images in one field and it won't render with field_formatter_view.
The view actually renders fine (but very slow) if I remove the image field and just load a view of image:delta text fields. I think this proves it's a resource constraint issue. I know this can be fixed by tweaking settings like MySQL max packet size etc. but I still wanted to report here because I think it's strange I've never ran into this issue before and I'd prefer to optimize the module where possible before settling for increased server resources.
Full Warning and Error with call stack:
Warning: Error while sending QUERY packet. PID=39474 in Drupal\Core\Database\Statement->execute() (line 59 of /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Statement.php) #0 /webserver-www/buildr/1516392533/core/includes/bootstrap.inc(566): _drupal_error_handler_real(2, 'Error while sen...', '/Users/jjroelof...', 59, Array) #1 [internal function]: _drupal_error_handler(2, 'Error while sen...', '/Users/jjroelof...', 59, Array) #2 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Statement.php(59): PDOStatement->execute(Array) #3 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Connection.php(625): Drupal\Core\Database\Statement->execute(Array, Array) #4 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87): Drupal\Core\Database\Connection->query('SELECT 1 FROM {...', Array, Array) #5 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(216): Drupal\Core\Database\Driver\mysql\Connection->query('SELECT 1 FROM {...', Array, Array) #6 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php(634): Drupal\Core\Database\Driver\mysql\Connection->queryRange('SELECT 1 FROM {...', 0, 1) #7 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Cache/DatabaseBackend.php(403): Drupal\Core\Database\Driver\mysql\Schema->tableExists('cache_data') #8 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Cache/DatabaseBackend.php(196): Drupal\Core\Cache\DatabaseBackend->ensureBinExists() #9 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Cache/DatabaseBackend.php(180): Drupal\Core\Cache\DatabaseBackend->setMultiple(Array) #10 /webserver-www/buildr/1516392533/core/modules/views/src/Plugin/views/cache/CachePluginBase.php(113): Drupal\Core\Cache\DatabaseBackend->set('image_field_gal...', Array, -1, Array) #11 /webserver-www/buildr/1516392533/core/modules/views/src/ViewExecutable.php(1429): Drupal\views\Plugin\views\cache\CachePluginBase->cacheSet('results') #12 /webserver-www/buildr/1516392533/core/modules/views/src/ViewExecutable.php(1452): Drupal\views\ViewExecutable->execute(NULL) #13 /webserver-www/buildr/1516392533/core/modules/views/src/Plugin/views/display/DisplayPluginBase.php(2404): Drupal\views\ViewExecutable->render() #14 /webserver-www/buildr/1516392533/core/modules/views/src/ViewExecutable.php(1660): Drupal\views\Plugin\views\display\DisplayPluginBase->preview() #15 /webserver-www/buildr/1516392533/core/modules/views/src/Element/View.php(63): Drupal\views\ViewExecutable->preview('block_1', Array) #16 [internal function]: Drupal\views\Element\View::preRenderViewElement(Array) #17 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(378): call_user_func(Array, Array) #18 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(195): Drupal\Core\Render\Renderer->doRender(Array, false) #19 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Template/TwigExtension.php(490): Drupal\Core\Render\Renderer->render(Array) #20 /webserver-www/buildr/1516392533/sites/default/files/php/twig/5a6250be1e903_field.html.twig_qQxeceI4kAiybGRmSJJcHtK5O/P6SLYMZaicdS-370eLzs3v-wvZVBiAJquhSl-RzlILc.php(71): Drupal\Core\Template\TwigExtension->escapeFilter(Object(Drupal\Core\Template\TwigEnvironment), Array, 'html', NULL, true) #21 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(432): __TwigTemplate_06ee10becf8a4856df7e385e5f97227cc4393da7a141e80e200a4c5d87d88c08->doDisplay(Array, Array) #22 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(403): Twig_Template->displayWithErrorHandling(Array, Array) #23 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(411): Twig_Template->display(Array) #24 /webserver-www/buildr/1516392533/core/themes/engines/twig/twig.engine(64): Twig_Template->render(Array) #25 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Theme/ThemeManager.php(384): twig_render_template('profiles/cms/th...', Array) #26 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(437): Drupal\Core\Theme\ThemeManager->render('field', Array) #27 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(450): Drupal\Core\Render\Renderer->doRender(Array) #28 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(450): Drupal\Core\Render\Renderer->doRender(Array) #29 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(195): Drupal\Core\Render\Renderer->doRender(Array, false) #30 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Template/TwigExtension.php(490): Drupal\Core\Render\Renderer->render(Array) #31 /webserver-www/buildr/1516392533/sites/default/files/php/twig/5a6250be1e903_node.html.twig_P_UkLP952aCJ3u3yCCGJOjDxO/_dPn0oU-M17PE_ESgE40e_ti1At96gl1b5ymsfqmWIA.php(104): Drupal\Core\Template\TwigExtension->escapeFilter(Object(Drupal\Core\Template\TwigEnvironment), Array, 'html', NULL, true) #32 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(215): __TwigTemplate_0497d184e515c6fbeb9d3cd2f57b04f0f7707ed20566d6ddf569d3596367bbcd->block_content(Array, Array) #33 /webserver-www/buildr/1516392533/sites/default/files/php/twig/5a6250be1e903_node.html.twig_P_UkLP952aCJ3u3yCCGJOjDxO/_dPn0oU-M17PE_ESgE40e_ti1At96gl1b5ymsfqmWIA.php(86): Twig_Template->displayBlock('content', Array, Array) #34 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(432): __TwigTemplate_0497d184e515c6fbeb9d3cd2f57b04f0f7707ed20566d6ddf569d3596367bbcd->doDisplay(Array, Array) #35 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(403): Twig_Template->displayWithErrorHandling(Array, Array) #36 /webserver-www/buildr/1516392533/vendor/twig/twig/lib/Twig/Template.php(411): Twig_Template->display(Array) #37 /webserver-www/buildr/1516392533/core/themes/engines/twig/twig.engine(64): Twig_Template->render(Array) #38 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Theme/ThemeManager.php(384): twig_render_template('profiles/cms/th...', Array) #39 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(437): Drupal\Core\Theme\ThemeManager->render('node', Array) #40 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(195): Drupal\Core\Render\Renderer->doRender(Array, false) #41 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(226): Drupal\Core\Render\Renderer->render(Array, false) #42 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/Renderer.php(576): Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() #43 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(227): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure)) #44 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(117): Drupal\Core\Render\MainContent\HtmlRenderer->prepare(Array, Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\CurrentRouteMatch)) #45 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/EventSubscriber/MainContentViewSubscriber.php(90): Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\CurrentRouteMatch)) #46 /webserver-www/buildr/1516392533/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(108): Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object(Symfony\Component\HttpKernel\Event\GetResponseForControllerResultEvent), 'kernel.view', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) #47 /webserver-www/buildr/1516392533/vendor/symfony/http-kernel/HttpKernel.php(158): Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.view', Object(Symfony\Component\HttpKernel\Event\GetResponseForControllerResultEvent)) #48 /webserver-www/buildr/1516392533/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #49 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/StackMiddleware/Session.php(57): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #50 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(47): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #51 /webserver-www/buildr/1516392533/core/modules/page_cache/src/StackMiddleware/PageCache.php(99): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #52 /webserver-www/buildr/1516392533/core/modules/page_cache/src/StackMiddleware/PageCache.php(78): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, true) #53 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(47): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #54 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(50): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #55 /webserver-www/buildr/1516392533/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #56 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/DrupalKernel.php(657): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #57 /webserver-www/buildr/1516392533/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #58 {main}.
..
..
..
..
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: CREATE TABLE {cache_config} ( `cid` VARCHAR(255) BINARY CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` LONGBLOB NULL DEFAULT NULL COMMENT 'A collection of data to cache.', `expire` INT NOT NULL DEFAULT 0 COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` DECIMAL(14, 3) NOT NULL DEFAULT 0 COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` SMALLINT NOT NULL DEFAULT 0 COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` LONGTEXT NULL DEFAULT NULL COMMENT 'Space-separated list of cache tags for this entry.', `checksum` VARCHAR(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.', PRIMARY KEY (`cid`), INDEX `expire` (`expire`), INDEX `created` (`created`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'Storage for the cache API.'; Array ( ) in Drupal\Core\Config\CachedStorage->readMultiple() (line 105 of /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Config/CachedStorage.php) #0 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Connection.php(650): Drupal\Core\Database\Connection->handleQueryException(Object(PDOException), 'CREATE TABLE {c...', Array, Array) #1 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87): Drupal\Core\Database\Connection->query('CREATE TABLE {c...', Array, Array) #2 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Database/Schema.php(598): Drupal\Core\Database\Driver\mysql\Connection->query('CREATE TABLE {c...') #3 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Cache/DatabaseBackend.php(405): Drupal\Core\Database\Schema->createTable('cache_config', Array) #4 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Cache/DatabaseBackend.php(196): Drupal\Core\Cache\DatabaseBackend->ensureBinExists() #5 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Config/CachedStorage.php(105): Drupal\Core\Cache\DatabaseBackend->setMultiple(Array) #6 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Config/ConfigFactory.php(165): Drupal\Core\Config\CachedStorage->readMultiple(Array) #7 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Config/ConfigFactory.php(104): Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array, true) #8 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/Config/ConfigFactory.php(89): Drupal\Core\Config\ConfigFactory->doGet('automated_cron....') #9 /webserver-www/buildr/1516392533/core/modules/automated_cron/src/EventSubscriber/AutomatedCron.php(50): Drupal\Core\Config\ConfigFactory->get('automated_cron....') #10 /webserver-www/buildr/1516392533/core/lib/Drupal/Component/DependencyInjection/Container.php(270): Drupal\automated_cron\EventSubscriber\AutomatedCron->__construct(Object(Drupal\Core\ProxyClass\Cron), Object(Drupal\Core\Config\ConfigFactory), Object(Drupal\Core\State\State)) #11 /webserver-www/buildr/1516392533/core/lib/Drupal/Component/DependencyInjection/Container.php(171): Drupal\Component\DependencyInjection\Container->createService(Array, 'automated_cron....') #12 /webserver-www/buildr/1516392533/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(105): Drupal\Component\DependencyInjection\Container->get('automated_cron....') #13 /webserver-www/buildr/1516392533/vendor/symfony/http-kernel/HttpKernel.php(88): Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.terminat...', Object(Symfony\Component\HttpKernel\Event\PostResponseEvent)) #14 /webserver-www/buildr/1516392533/vendor/stack/builder/src/Stack/StackedHttpKernel.php(32): Symfony\Component\HttpKernel\HttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\LocalRedirectResponse)) #15 /webserver-www/buildr/1516392533/core/lib/Drupal/Core/DrupalKernel.php(635): Stack\StackedHttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\LocalRedirectResponse)) #16 /webserver-www/buildr/1516392533/index.php(22): Drupal\Core\DrupalKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\LocalRedirectResponse)) #17 {main}.
Comments
Comment #2
jurriaanroelofs commentedComment #3
jurriaanroelofs commentedComment #4
pol