DevHeads.net

mysql V 8.0.12 and mysqdump

Hello list,
i run into an unexpected problem with mysqldump:

mysqldump --version
mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)

when i try it results in:
mysqldump: Error: 'Lost connection to MySQL server during query' when trying to
dump tablespaces
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL
server has gone away (2006)

I seems it get stuck in this query:

explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE,
ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE
_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IS NOT NULL
AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP
_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND
TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATIO
N_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('kpc'))) GROUP BY LOGFILE_GROUP_NAME,
FILE_NAME, ENGINE, TOTAL_EXTENTS, INITIAL_SIZE ORDER BY
LOGFILE_GROUP_NAME;
+----+-------------+-------------+------------+--------+---------------------+---------------------+---------+--------------------------
----+-------+----------+---------------------------------------------------------------+
| id | select_type | table | partitions | type | possible_keys |
key | key_len | ref
| rows | filtered | Extra
|
+----+-------------+-------------+------------+--------+---------------------+---------------------+---------+--------------------------
----+-------+----------+---------------------------------------------------------------+
| 1 | SIMPLE | cat | NULL | index | PRIMARY |
name | 194 | NULL
| 1 | 100.00 | Using index; Using temporary; Using filesort; Start
temporary |
| 1 | SIMPLE | sch | NULL | eq_ref | PRIMARY,catalog_id |
catalog_id | 202 | mysql.cat.id,const
| 1 | 100.00 | Using index
|
| 1 | SIMPLE | tbl | NULL | ref | schema_id |
schema_id | 8 | mysql.sch.id
| 78 | 100.00 | Using where
|
| 1 | SIMPLE | part | NULL | ref | table_id,table_id_2 |
table_id | 8 | mysql.tbl.id
| 597 | 10.00 | Using where
|
| 1 | SIMPLE | part_ts | NULL | eq_ref | PRIMARY |
PRIMARY | 8 | mysql.part.tablespace_id
| 1 | 100.00 | NULL
|
| 1 | SIMPLE | ts | NULL | ALL | PRIMARY |
NULL | NULL | NULL
| 12605 | 100.00 | Using join buffer (Block Nested Loop)
|
| 1 | SIMPLE | tsf | NULL | ref | tablespace_id |
tablespace_id | 8 | mysql.ts.id
| 1 | 100.00 | Using where
|
| 1 | SIMPLE | sub_part | NULL | ref | parent_partition_id |
parent_partition_id | 9 | mysql.part.id
| 13152 | 100.00 | NULL
|
| 1 | SIMPLE | sub_part_ts | NULL | eq_ref | PRIMARY |
PRIMARY | 8 | mysql.sub_part.tablespace
_id | 1 | 100.00 | Using where
|
| 1 | SIMPLE | ts | NULL | eq_ref | PRIMARY,name |
name | 779 | func
| 1 | 100.00 | Using where
|
| 1 | SIMPLE | tsf | NULL | ref | tablespace_id |
tablespace_id | 8 | mysql.ts.id
| 1 | 100.00 | Using where; End temporary
|
+----+-------------+-------------+------------+--------+---------------------+---------------------+---------+--------------------------
----+-------+----------+---------------------------------------------------------------+

The probelm seems to happen only when i dump the whole database, single tables
are ok.

re,
wh

Comments

Re: mysql V 8.0.12 and mysqdump

By hsv at 02/09/2019 - 04:01

2019/02/08 10:32 ... Walter Harms:
I regulary hav this problem with the command-line client (mysql.exe) and
when I asked R H gave this answer (and with the command-line client it
is much less imporant):

query

Am 06.01.2014 15:36, schrieb ... at tbbs dot net:
what about look in the servers logfiles
most likely "max_allowed_packet" laughable low