URL: https://linuxfr.org/forums/linux-debian-ubuntu/posts/mariadb-galera-cluster-mysql-is-gone-away-got-an-error-reading-communication-packets Title: MariaDB/Galera cluster - Mysql is gone away | Got an error reading communication packets Authors: voxdemonix Date: 2018年03月05日T14:41:41+01:00 License: CC By-SA Tags: cluster, mariadb, mysql, bug, galera et firefox Score: 1 Depuis hier j'essaye de régler un problème récalcitrant qui revient jour après jours et qui s’aggrave. Avec Nextcloud ce problème apparaît de temps en temps (tout les jours), mais là depuis une heure il n'est plus possible de faire fonctionner ZoneMinder plus de trente seconde avant qu'il crash (alors qu'il fonctionnait tranquillement depuis des mois). voila le type d'erreur dans _service mysql status_ : ``` févr. 25 17:55:23 0rionBDDServerOne mysqld[2497]: 2018年02月25日 17:55:23 139928900781824 [Warning] Aborted connection 170242 to db: 'nextcloud' user: 'nextcloud' host: '10.8.10.69' (Got an error reading communication packets) févr. 25 17:58:56 0rionBDDServerOne mysqld[2497]: 2018年02月25日 17:58:56 139928895104768 [Warning] Aborted connection 170665 to db: 'nextcloud' user: 'nextcloud' host: '10.8.10.69' (Got an error reading communication packets) mars 01 10:43:05 0rionBDDServerTwo mysqld[2795]: 2018年03月01日 10:43:05 140374565336832 [Warning] Aborted connection 416000 to db: 'nextcloud' user: 'nextcloud' host: '127.0.0.1' (Got an error reading communication packets) ``` Ici le client et le serveur sont sur la même machine (donc 127.0.0.1), mais si je renvoie les requêtes sur un autre nœud j'ai exactement la même erreur lors du lancement de zoneminder. C'est encore un retour de _service mysql status_ ``` mar 05 13:34:39 Memory1 mysqld[1907]: 2018年03月05日 13:34:39 139956546344704 [Warning] Aborted connection 1745 to db: 'ZoneMinder' user: 'zm_bbd_user' host: '127.0.0.1' (Got an error reading communication packets) mar 05 13:34:39 Memory1 mysqld[1907]: 2018年03月05日 13:34:39 139956543121152 [Warning] Aborted connection 1745 to db: 'ZoneMinder' user: 'zm_bbd_user' host: '127.0.0.1' (Got an error reading communication packets) mar 05 13:34:39 Memory1 mysqld[1907]: 2018年03月05日 13:34:39 139956143269632 [Warning] Aborted connection 1745 to db: 'ZoneMinder' user: 'zm_bbd_user' host: '127.0.0.1' (Got an error reading communication packets) mar 05 13:34:39 Memory1 mysqld[1907]: 2018年03月05日 13:34:39 139956546344704 [Warning] Aborted connection 1745 to db: 'ZoneMinder' user: 'zm_bbd_user' host: '127.0.0.1' (Got an error reading communication packets) mar 05 13:34:39 Memory1 mysqld[1907]: 2018年03月05日 13:34:39 139956142663424 [Warning] Aborted connection 1745 to db: 'ZoneMinder' user: 'zm_bbd_user' host: '127.0.0.1' (Got an error reading communication packets) mar 05 13:34:39 Memory1 mysqld[1907]: 2018年03月05日 13:34:39 139956546344704 [Warning] Aborted connection 1745 to db: 'ZoneMinder' user: 'zm_bbd_user' host: '127.0.0.1' (Got an error reading communication packets) ``` Nextcloud lui affiche ce genre d'erreur ( _/nextcloud/data/nextcloud.log_ ) : ``` [Sat Mar 03 14:24:07.094379 2018] [:error] [pid 16088] [client 10.8.42.1:45210] {"reqId":"1VqokvAET3Kq1TXhbGEi","level":3,"time":"2018-03-03T13:24:07+00:00","remoteAddr":"10.8.42.1","user":"myUser","app":"PHP","method":"POST","url":"\\/index.php\\/avatar\\/cropped","message":"unlink(\\/media\\/Nextcloud2018\\/appdata_oc7ux9zy7hky\\/avatar\\/myUser\\/avatar.32.png): Permission denied at \\/var\\/www\\/html\\/services\\/nextcloud2018\\/lib\\/private\\/Files\\/Storage\\/Local.php#225","userAgent":"Mozilla\\/4.2 (X11; Ubuntu; Linux x86_64; rv:42.0) Gecko\\/20420101 Firefox\\/42.666","version":"13.0.0.14"} [Sat Mar 03 14:26:05.938124 2018] [:error] [pid 16088] [client 10.8.42.1:45210] {"reqId":"1VqokvAET3Kq1TXhbGEi","level":3,"time":"2018-03-03T13:26:05+00:00","remoteAddr":"10.8.42.1","user":"myUser","app":"PHP","method":"POST","url":"\\/index.php\\/avatar\\/cropped","message":"PDO::commit(): MySQL server has gone away at \\/var\\/www\\/html\\/services\\/nextcloud2018\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php#1235","userAgent":"Mozilla\\/4.2 (X11; Ubuntu; Linux x86_64; rv:42.0) Gecko\\/20420101 Firefox\\/42.666","version":"13.0.0.14"} [Sat Mar 03 14:26:05.939454 2018] [:error] [pid 16088] [client 10.8.42.1:45210] {"reqId":"1VqokvAET3Kq1TXhbGEi","level":3,"time":"2018-03-03T13:26:05+00:00","remoteAddr":"10.8.42.1","user":"myUser","app":"PHP","method":"POST","url":"\\/index.php\\/avatar\\/cropped","message":"PDO::commit(): Error reading result set's header at \\/var\\/www\\/html\\/services\\/nextcloud2018\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php#1235","userAgent":"Mozilla\\/4.2 (X11; Ubuntu; Linux x86_64; rv:42.0) Gecko\\/20420101 Firefox\\/42.666","version":"13.0.0.14"} [Sat Mar 03 14:26:05.950780 2018] [:error] [pid 16088] [client 10.8.42.1:45210] {"reqId":"1VqokvAET3Kq1TXhbGEi","level":3,"time":"2018-03-03T13:26:05+00:00","remoteAddr":"10.8.42.1","user":"myUser","app":"core","method":"POST","url":"\\/index.php\\/avatar\\/cropped","message":"Exception: {\\"Exception\\":\\"Doctrine\\\\\\\\DBAL\\\\\\\\Exception\\\\\\\\DriverException\\",\\"Message\\":\\"An exception occurred while executing 'UPDATE `oc_filecache` SET `size`=? WHERE (`size` ? OR `size` IS NULL) AND `fileid` = ? ' with params [-1, -1, \\\\\\"63\\\\\\"]:\\\\n\\\\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away\\",\\"Code\\":0,\\"Trace\\":\\"#0 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(128): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n#1 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Connection.php(855): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOMySql\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'UPDATE `oc_file...', Array)\\\\n#2 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/DB\\\\\\/Connection.php(195): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->executeQuery('UPDATE `oc_file...', Array, Array, NULL)\\\\n#3 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Cache\\\\\\/Cache.php(320): OC\\\\\\\\DB\\\\\\\\Connection->executeQuery('UPDATE `oc_file...', Array)\\\\n#4 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Cache\\\\\\/Scanner.php(414): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Cache->update('63', Array)\\\\n#5 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Cache\\\\\\/Scanner.php(337): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Scanner->scanChildren('appdata_oc7ux9z...', false, 3, '63', true)\\\\n#6 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/View.php(1327): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Scanner->scan('appdata_oc7ux9z...', false)\\\\n#7 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/View.php(1371): OC\\\\\\\\Files\\\\\\\\View->getCacheEntry(Object(OCA\\\\\\\\Files_Trashbin\\\\\\\\Storage), 'appdata_oc7ux9z...', '\\\\\\/appdata_oc7ux9...')\\\\n#8 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Node\\\\\\/Root.php(198): OC\\\\\\\\Files\\\\\\\\View->getFileInfo('\\\\\\/appdata_oc7ux9...')\\\\n#9 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Node\\\\\\/Folder.php(133): OC\\\\\\\\Files\\\\\\\\Node\\\\\\\\Root->get('\\\\\\/appdata_oc7ux9...')\\\\n#10 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/AppData\\\\\\/AppData.php(89): OC\\\\\\\\Files\\\\\\\\Node\\\\\\\\Folder->get('preview')\\\\n#11 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/AppData\\\\\\/AppData.php(105): OC\\\\\\\\Files\\\\\\\\AppData\\\\\\\\AppData->getAppDataFolder()\\\\n#12 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Preview\\\\\\/Watcher.php(97): OC\\\\\\\\Files\\\\\\\\AppData\\\\\\\\AppData->getFolder(506888)\\\\n#13 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Preview\\\\\\/WatcherConnector.php(68): OC\\\\\\\\Preview\\\\\\\\Watcher->postDelete(Object(OC\\\\\\\\Files\\\\\\\\Node\\\\\\\\NonExistingFile))\\\\n#14 [internal function]: OC\\\\\\\\Preview\\\\\\\\WatcherConnector->OC\\\\\\\\Preview\\\\\\\\{closure}(*** sensitive parameters replaced ***)\\\\n#15 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Hooks\\\\\\/EmitterTrait.php(99): call_user_func_array(Object(Closure), Array)\\\\n#16 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Hooks\\\\\\/PublicEmitter.php(36): OC\\\\\\\\Hooks\\\\\\\\BasicEmitter->emit('\\\\\\\\\\\\\\\\OC\\\\\\\\\\\\\\\\Files', 'postDelete', Array)\\\\n#17 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Node\\\\\\/Root.php(136): OC\\\\\\\\Hooks\\\\\\\\PublicEmitter->emit('\\\\\\\\\\\\\\\\OC\\\\\\\\\\\\\\\\Files', 'postDelete', Array)\\\\n#18 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/Node\\\\\\/File.php(118): OC\\\\\\\\Files\\\\\\\\Node\\\\\\\\Root->emit('\\\\\\\\\\\\\\\\OC\\\\\\\\\\\\\\\\Files', 'postDelete', Array)\\\\n#19 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Files\\\\\\/SimpleFS\\\\\\/SimpleFile.php(104): OC\\\\\\\\Files\\\\\\\\Node\\\\\\\\File->delete()\\\\n#20 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Avatar.php(163): OC\\\\\\\\Files\\\\\\\\SimpleFS\\\\\\\\SimpleFile->delete()\\\\n#21 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Avatar.php(138): OC\\\\\\\\Avatar->remove()\\\\n#22 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/core\\\\\\/Controller\\\\\\/AvatarController.php(329): OC\\\\\\\\Avatar->set('\\\\\\\\x89PNG\\\\\\\\r\\\\\\\\n\\\\\\\\x1A\\\\\\\\n\\\\\\\\x00\\\\\\\\x00\\\\\\\\x00\\\\\\\\rIHD...')\\\\n#23 [internal function]: OC\\\\\\\\Core\\\\\\\\Controller\\\\\\\\AvatarController->postCroppedAvatar(Array)\\\\n#24 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/AppFramework\\\\\\/Http\\\\\\/Dispatcher.php(161): call_user_func_array(Array, Array)\\\\n#25 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/AppFramework\\\\\\/Http\\\\\\/Dispatcher.php(91): OC\\\\\\\\AppFramework\\\\\\\\Http\\\\\\\\Dispatcher->executeController(Object(OC\\\\\\\\Core\\\\\\\\Controller\\\\\\\\AvatarController), 'postCroppedAvat...')\\\\n#26 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/AppFramework\\\\\\/App.php(115): OC\\\\\\\\AppFramework\\\\\\\\Http\\\\\\\\Dispatcher->dispatch(Object(OC\\\\\\\\Core\\\\\\\\Controller\\\\\\\\AvatarController), 'postCroppedAvat...')\\\\n#27 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/AppFramework\\\\\\/Routing\\\\\\/RouteActionHandler.php(47): OC\\\\\\\\AppFramework\\\\\\\\App::main('OC\\\\\\\\\\\\\\\\Core\\\\\\\\\\\\\\\\Control...', 'postCroppedAvat...', Object(OC\\\\\\\\AppFramework\\\\\\\\DependencyInjection\\\\\\\\DIContainer), Array)\\\\n#28 [internal function]: OC\\\\\\\\AppFramework\\\\\\\\Routing\\\\\\\\RouteActionHandler->__invoke(Array)\\\\n#29 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/private\\\\\\/Route\\\\\\/Router.php(297): call_user_func(Object(OC\\\\\\\\AppFramework\\\\\\\\Routing\\\\\\\\RouteActionHandler), Array)\\\\n#30 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/lib\\\\\\/base.php(998): OC\\\\\\\\Route\\\\\\\\Router->match('\\\\\\/avatar\\\\\\/cropped')\\\\n#31 \\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/index.php(37): OC::handleRequest()\\\\n#32 {main}\\",\\"File\\":\\"\\\\\\/var\\\\\\/www\\\\\\/html\\\\\\/services\\\\\\/nextcloud2018\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\",\\"Line\\":115}","userAgent":"Mozilla\\/5.0 (X11; Ubuntu; Linux x86_64; rv:58 [Sat Mar 03 14:26:05.959028 2018] [:error] [pid 16088] [client 10.8.42.1:45210] {"reqId":"1VqokvAET3Kq1TXhbGEi","level":3,"time":"2018-03-03T13:26:05+00:00","remoteAddr":"10.8.42.1","user":"myUser","app":"PHP","method":"POST","url":"\\/index.php\\/avatar\\/cropped","message":"fopen(\\/media\\/Nextcloud2018\\/\\/nextcloud.log): failed to open stream: Permission denied at \\/var\\/www\\/html\\/services\\/nextcloud2018\\/lib\\/private\\/Log\\/File.php#135","userAgent":"Mozilla\\/4.2 (X11; Ubuntu; Linux x86_64; rv:42.0) Gecko\\/20420101 Firefox\\/42.666","version":"13.0.0.14"} ``` La commande "top" lancée sur les membres du cluster indiquent qu'ils glandent sévère, le temps de réponse est de 1ms (d'après HaProxy). J'ai testé les solutions indiquées ici mais rien n'y fait : - https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/ - https://dba.stackexchange.com/questions/40899/mysql-error-reading-communication-packets SVP de l'aide 😿 😿 😿

AltStyle によって変換されたページ (->オリジナル) /