Softwareaktualisierung - Voraussetzungen laden nicht. 5.2.16 ->5.2.17 - System-Log Fehler

Shopware 5 Installation/Einstieg
1

Hallo,

beim Versuch zu kontrollieren ob die nötige Voraussetzungen zum Update auf 5.2.17 erfüllt sind bricht immer nach mehrere Minuten der Vorgang ab und wir erhalten eine “communication failure”.

System Log-Fehler ergibt folgendes:

[2017-02-14 10:54:00] core.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'element_id' cannot be null in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:987 Stack trace: #0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): PDOStatement->execute() #1 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(100): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO s_c...', Array) #2 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(61): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->storeUniqueIdInDb('Aom2BiG7fsaTci7...') #3 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(453): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->getUniqueId() #4 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(266): Shopware_Controllers_Backend_SwagUpdate->getUnique() #5 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_SwagUpdate->popupAction() #6 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('popupAction') #7 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Kernel.php(179): Enlight_Controller_Front->dispatch() #9 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true) #10 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #11 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #12 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #13 /is/htdocs/wp1061229_47VO1MQRUV/www/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'INSERT INTO s_core_config_values (element_id, shop_id, value) VALUES ( (SELECT id FROM s_core_config_elements WHERE name LIKE 'trackingUniqueId' LIMIT 1), 1, ? )' with params ["s:32:\"Aom2BiG7fsaTci7rEcoKQ4O5jQeznw2w\";"]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'element_id' cannot be null in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119 Stack trace: #0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(996): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'INSERT INTO s_c...', Array) #1 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(100): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO s_c...', Array) #2 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Bundle/PluginInstallerBundle/Service/UniqueIdGenerator/UniqueIdGenerator.php(61): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->storeUniqueIdInDb('Aom2BiG7fsaTci7...') #3 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(453): Shopware\Bundle\PluginInstallerBundle\Service\UniqueIdGenerator\UniqueIdGenerator->getUniqueId() #4 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Plugins/Default/Backend/SwagUpdate/Controllers/Backend/SwagUpdate.php(266): Shopware_Controllers_Backend_SwagUpdate->getUnique() #5 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_SwagUpdate->popupAction() #6 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('popupAction') #7 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #8 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Kernel.php(179): Enlight_Controller_Front->dispatch() #9 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true) #10 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #11 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #12 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #13 /is/htdocs/wp1061229_47VO1MQRUV/www/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #14 {main} [] {"uid":"66eda27"}

Wenn uns jemanden hierzu Tipps, Information geben würde woran das liegen könnte, wäre das super.

Vielen Dank im Voraus

Grüße Mark

2

Hallo,

hier scheint ein Element in der Datenbank zu fehlen, dieses könntest du über das folgende Query in der Datenbank anlegen:

INSERT INTO `s_core_config_elements` (`id`, `form_id`, `name`, `value`, `label`, `description`, `type`, `required`, `position`, `scope`, `options`) VALUES ('966', '269', 'trackingUniqueId', 's:0:"";', 'Unique identifier', NULL, 'text', '0', '0', '0', 0x613a313a7b733a363a2268696464656e223b623a313b7d);

Viele Grüße aus Schöppingen
Janine

3

Hallo Janine,

vielen Dank, werde ich gleich nachher probieren. Warum diese?

0x613a313a7b733a363a2268696464656e223b623a313b7d

Weißt du eigentlich wie es mal vorkommen kann, dass scheinbar manchmal neue Tabellen nicht während eines ansonsten erfolgreichen Updates in der DB integriert werden?

Viele Grüße

Mark

4

Query erfolgreich angelegt erstmal in einer Version die wir zum Testen haben - alles super. Im Live Version ausgeführt und bekommen statt „communication failure“ einer 503 und folgende Fehler Meldung:

PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165\nStack trace:\n#0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement-]execute(Array)\n#1 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/DBALConfigReader.php(85): Doctrine\\DBAL\\Statement-]execute(Array)\n#2 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/CachedConfigReader.php(66): Shopware\\Components\\Plugin\\DBALConfigReader-]getByPluginName('SwagPaymentPayp...', NULL)\n#3 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/Namespace.php(182): Shopware\\Components\\Plugin\\CachedConfigReader-]getByPluginName('SwagPaymentPayp...', NULL)\n#4 /is/htdocs/wp1061229_47VO1MQRUV/www/engine/Shopware/Components/Plugin/Bootstrap.php(253): Shopware_Components_Plugin_Namespace-]getConfig('SwagPaymentPayp...')\n#5 /is/htdocs/wp1061229_4 in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php:330\nStack trace:\n#0 /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php(330): PDOStatement-]execute()\n#1 [internal function]: Symfony\\Component\\HttpFoundation\\Session\\Storage\\Handler\\PdoSessionHandler-]write('fcnhpckmr5dgh7a...', 'ShopwareBackend...')\n#2 [internal function]: session_write_close()\n#3 {main}\n thrown in /is/htdocs/wp1061229_47VO1MQRUV/www/vendor/symfony/http-foundation/Session/Storage/Handler/PdoSessionHandler.php on line 330

Irgendwelche Ideen was das jetzt bedeutet und behoben werden könnte?

Vielen Dank im Voraus

Mark

5

Sieht so aus, als ob der MySQL-Server nicht stabil läuft:

2006 MySQL server has gone away

Das solltest Du mal prüfen (ggf. auch anhand der MySQL-Logs, sofern Du darauf Zugriff hast).

Timme Hosting - schnelles nginx-Hosting

www.timmehosting.de

1 „Gefällt mir“