mysqldump --single-transaction --flush-logs --create-options -B --default-character-set=utf8 --routines --max_allowed_packet=104857600 -u mysqlbackup --socket=/var/run/mysqld/mysqld.sock --databases "fertigungsinfos"
Above command fails with error:
mysqldump: Couldn't execute 'FLUSH TABLES WITH READ LOCK': Lost connection to MySQL server during query (2013)
mysqlderr.log
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: cert index usage at exit 0
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: cert trx map usage at exit 29
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: deps set usage at exit 0
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: avg deps dist 16.2174
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: avg cert interval 15.2174
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: cert index size 28
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139746083424000 [Note] WSREP: Service thread queue flushed.
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.206349, misses: 50, in use: 0, in pool: 50
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 5703264)
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] WSREP: Flushing memory map to disk...
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745489295104 [Note] InnoDB: FTS optimize thread exiting.
Jul 31 08:39:51 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:51 139745556387584 [Note] InnoDB: Starting shutdown...
Jul 31 08:39:52 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:52 139745556387584 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Jul 31 08:39:53 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:53 139745556387584 [Note] InnoDB: Shutdown completed; log sequence number 36577024040
Jul 31 08:39:53 rbg-bahn-galera2-lan mysqld[10754]: 2019-07-31 8:39:53 139745556387584 [Note] /usr/sbin/mysqld: Shutdown complete
